Simplicity is a Virtue – BASE Rule
On a cup of green tea with a friend I grabbed the golden rule of accounting. It is simple (You can easily miss if it came your way!) and can be applied to almost all the accounts (Depreciation, Gross Block, Cash, Equity, Debt) – You name it, and you have to use it!
So concentrate and even if you feel what I told you is obvious, go ahead and apply it in your models. It would help!
What is the BASE Rule?
BASE rule is an acronym:
Is that not simple (and very obvious)?
And yeah before I forget, this year’s ending balance is next year’s opening balance
I think this is also obvious that if I had a cash of USD 100 Mio with me on 31st of Dec 2010, then my opening balance on 1st of Jan 2011 would also be USD 100 Mio.
BASE rule can help you summarize any Account
I always say, Cash is the king of business. The BASE rule can be used in any account, but I will illustrate its usage in Cash Account. Please note that cash is a balance sheet item and sits in the current account section of the balance sheet.
Let’s say you start your business on 30th Dec, 2009 with USD 100 Mio. During the year, you entered into the following transactions (Assume all are cash transactions for simplicity sake).
So the transactions in FY 10 can be summarized as:
Similarly Let’s say in FY 11 you had a cash inflow of USD 250 Mio and an outflow of USD 220 Mio. The cash positions can be modelled in Excel as:
Beginning + Additions – Subtractions = Closing Balance
The beginning balance of FY 12 is same as closing balance of FY 11 and so on…
Where else can this function be useful in Finance?
As I figured out in my modelling career, the rule is the golden rule in accounting. And exactly the same rule can be applied to the following:
· Beginning (Old Retained Earnings) + Add (Profit after tax) – Subtract (Dividends) = Ending (New Retained Earnings)
· Beginning (Old Debt Balance) + Add (Additional Debt Raised) – Subtract (Debt Repaid) = Ending (New Debt Balance)
· Beginning (Old Cumulative Depreciation) + Add (Depreciation during the Year) – Subtract (Depreciation because of assets sold) = Ending (New Cumulative Depreciation)
I can’t even remember the times I have used this concept!
Are you also using Acronyms in Financial Modelling?
Acronyms are cool! They help you remember concepts in an intuitive manner and make your life easier! What acronyms or simple concepts are you using in your financial models?
Templates to download
I have created a template for you, where the subheadings are given and you have use the functions to get the right values for you! You can download the same from here. You can go through the case and fill in the yellow boxes. I also recommend that you try to create this structure on your own (so that you get a hang of what information is to be recorded).
Also you can download this filled template and check, if the information you recorded, matches mine or not!
Join our Financial Modeling Classes
We are glad to inform that our new financial modeling & project finance modeling online class is ready for your consideration.
Chandoo.org has partnered with Pristine to launch a Financial Modeling Course. For details click here.
For any queries regarding the cash impact or financial modeling, feel free to put the comments in the blog or write an email to firstname.lastname@example.org
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« 10 Excel Keyboard Shortcuts I can’t live without!
|MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student »