Finance 3.0 - Social Network for Finance
Smart financial thinking
-
B.Balachandran Nair
- Male
- Trivandrum, kerala
- India
- Asst. Vice president
- Share
- Share on Twitter
- Share on Facebook
- Blog Posts
- Discussions (20)
- Events
- Groups (1)
- Charts
- Chart Portfolios
- Videos
B.Balachandran Nair's Discussions
The Best Financial Model in the World
Hello Toby I have been following this tread for some time since I was also curious in learning the best practices in finacial modeling. I was not trained in modeling. However going thoroguh the discu…
Tagged: objectives, goal, perfect, training, characteristics
Replied Jul 12
Budget and monthly variance analysis- Format
Dear all finance 30 friends Thanks for your comments on the format for Budget and variance analysis. I am happy that this one attracted many of the finance guys. This format is in use in my work pla…
Tagged: variance analysis, budgeting, excel
Replied Jun 29
int(),trunc(),floor(),rounddown() functions
Thanks Sacha for your valuable comments. This has added to the Bhasker 's explanantions. Your knowledge in details is wonderful. Regards Balachandran
Replied May 31
int(),trunc(),floor(),rounddown() functions
Thanks Bhaskar Patra This will help me and many others too. You have clearly laid down and differentiated the similar functions in excel. Thanks once again Regards Balachandran
Replied May 31
B.Balachandran Nair's Page
Gifts Received
B.Balachandran Nair has not received any gifts yet
Latest Activity
I note most people ask for a password to unprotect. I do not see a response.
Protected spreadsheets are useful only insofar as ideas. It becomes useless if wishing to customise for own use.
Can you advise on this forum if you are willing to unprotec…
Hello Toby
I have been following this tread for some time since I was also curious in learning the best practices in finacial modeling. I was not trained in modeling.
However going thoroguh the discussion, and seeing how it is getting developed, I t…
thank you very much for sharing the file. could you please send me the unprotected version of the file so that can be used for MIS reporting. my e-mail is gorsto@hotmail.com
Dear all finance 30 friends
Thanks for your comments on the format for Budget and variance analysis. I am happy that this one attracted many of the finance guys. This format is in use in my work place for the last two years. The sheet is protected…
Dear Bala,
Good morning 2u, and we hope this atamplate finds you well ,its very good work ,foregive me if I ask you for unprotected sheet for performance analysis and Budget & monthly variance sheet its highly appreciated your prompt action and rep…
Thanks Sacha for your valuable comments. This has added to the Bhasker 's explanantions. Your knowledge in details is wonderful.
Regards
Balachandran
Thanks Bhaskar Patra
This will help me and many others too. You have clearly laid down and differentiated the similar functions in excel.
Thanks once again
Regards
Balachandran
ROUNDDOWN() and FLOOR() are similar. The difference is Rounddown seeks an input signifying up to what decimal place you want to round off downwards. The decimal place cna be zero or even negative. Thus:
Rounddown(125.245,1) returns 125.4 and Rounddo…
"int()" = This function rounds a number down to the nearest whole number.
categoty = Mathematical
Example:
Number......Formula .... Result
1.5>>>>> =INT() >>>>>1
2.4>>>>> =INT()>>>>> 2
10.89>>> =INT() >>>>>10
-2.47575 >=INT() >>>>> -3
"floor()" = T…
Dear all
Can any body give "when" and "how" these excel functions shall be used. These functions on its normal usgage give the same result. But I am sure excel will have some thing in mind which is not apparent.
Please site some example to show ho…
Dear Ahamed
May be I did not understand your question properly. But the solutions given by either Sacha, Bhasker or me are working. If you have any stock answer with you please give.
Regards
Balachandran
Has any received the passward? If so kinly post it so that everyone can see. Thanks
use text to column (in data menu) useing . as critera.
Sum the result col.
OK
Profile Information
- Profession:
- Chartered Accountant
- Current Role:
- Asst. Vice president
- Past Experience:
- 21 years
- Education:
- C A
- Current Location:
- Trivandrum
- Interested In:
- career opportunities, job enquires, expertise requests, getting back in touch
- My LinkedIn
Comment Wall (7 comments)
- At 1:49pm on June 11, 2010,
K.Ssreekumar said…
- Dear Sri.Balachandran,
Nice to see your templates on budgeting and standard costing.I am interested in being touch with you.
Sincere regards,
K.Sreekumar
Sr.Budget Controller
Jubail United Petrochemical Company
(A Sabic Affiliate)
KSA
- At 9:01pm on May 18, 2010,
Jeremy Matthias said…
- Hi,
I would very much like to use your template. Could you please send me the password?
My email address is jeremy@theterraces.com.au
Great work!
- At 4:34am on May 15, 2010,
Dickson Kasamale said… - Impressive template. Thank you.
- At 5:10am on May 4, 2010,
Zaheer Ahmed said…
- "Budget and monthly variance analysis- Format", its a commendable model
would appreciate if you can send the unprotected version on my e-mail
Zaheer_ahmed_w@yahoo.com
thanks
- At 12:38am on February 3, 2010,
Talib said… - Great work, appreciate could you send me password to unprotect the workshop (talib_ali@hotmail.com). Talib
- At 4:49am on February 2, 2010,
Pavel Petkov said… - Budget and monthly variance analysis - is a Great Model :). Could you send me protection password or unprotect version at ppetkof@yahoo.com
many thanks
- At 11:54pm on February 1, 2010,
Muhammad Asif Hafeez said…
- Great work, can you share the password with me (asifkhari@gmail.com) regards, Asif
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0.
