course bg
EduPristine>Blog>Financial Modeling Round-up

Financial Modeling Round-up

January 27, 2012

We have finally completed our financial model on the Chocolate business, and here are the steps. I am concluding this Financial Modeling series in one summary post.

  1. The first thing you do in creating your Financial Model, is to create an Income Statement (also known as a Profit and Loss statement)
  2. You will need to move on to the Interest Schedule and the Debt Schedule in order to complete your P&L
  3. With your P&L in place, you move on to the Balance Sheet
  4. You can then create the Cash Flow Statement as well. Once this is done, you loop it back to finish your Balance Sheet
  5. Then to test your Financial Model and also to check how your numbers are doing as compared to the industry, you put together the Financial Ratios
  6. The next step is to break down your Return on Equity using the DuPont Analysis
  7. Lastly, to check how long your business model can sustain without any further infusion of funds, you check the Sustainable Growth Rate (SGR)

Well, it was interesting to discuss how to create this sweet model for a Chocolate manufacturing business. I sure had fun creating and discussing this model with you! You can download the complete model here.

At this point, I would also like to point out that the complexity of a model also depends on how many factors you are willing to consider, how many plans are you willing to drill-down to and most importantly how realistic are you about the business.

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 11536