February 26, 2013
A DCF model is an elaborate method of valuing a company or its equity. At the end of the exercise, when we look back to see all the sheets that we have incorporated, we realize that assumption sheet has far more number of rows populated than any other sheet in the model. So precisely, a financial model contains more assumption than data.
Imagine a situation where you donâ€™t have luxury of time to build a detailed DCF model. But you still have been asked to value a company using DCF. Company is not willing to part with the data or their business plans. Even if they are, you don’t have time to look into them and analyse to support your assumptions. You have been asked to produce a DCF model in next half an hour when you have heard the name of the company for the first time at that very moment.
A DCF model can still be developed within the stipulated time frame and with bare minimum information from the company. You need to have just three things to start with:
You can sail through a difficult time and come up with a defendable DCF model. We illustrate this on the basis of small case –
Raj was smart but a silent guy. Shilpa was mediocre but a chirpy girl.
He was dark while she was fair.
He came out as a closed person in numerous group discussions while she appeared to be an open person.
While he used to be serious in his thoughts, she used to be funny.
He was good in Marketing, while she had an edge in finance.
While he accepted, she dominated.
Wow, how complementary to each other.
The two got together and started a venture on Shilpaâ€™s suggestions. Shilpa has a thought through business plan which they attempted to execute. While Raj brought customers for the company, Shilpa used to handle finances. He thought he knew everything about her while she knew everything about the business.
But that was two years ago. Today, Shilpa was clueless about the volatile nature of the industry their company was operating in while Ravi was clueless about Shilpa.
They were trying to figure out the cash requirement by the business and the funding plans over the next few years.
Exhibit 1: Last Year’s Audited Financial Statements (Abridged Version)
The problem that they are facing is how to prepare the projected financial statements in the absence of knowledge about funding requirements. They have a very vague idea about the business over next 5 years:
Exhibit 2: Select Items from the Business Plan
They want to maintain a minimum cash level of Rs. 12 Lakhs in the business and borrow at the existing interest rate of 12% if required. Please make an attempt to help them out based on limited information.
This situation can be developed into a financial model step by step as displayed below: Ensure iterations are turned on as per steps below:
Now proceed to model, iterative calculations will be taken care of.
Weâ€™ll soon be coming up with an amazing Quiz on building Financial Model. So STAY TUNED and strengthen your understanding of Financial Modeling.
Why donâ€™t you try a free sample of our Financial Modeling course learn to create a robust model with Excel.