347 647 9001+1 714 797 8196Request a Call
Call Me

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 the Author

Prasad Ajinkya is the Chief Technology Officer at Pristine. Prior to joining Pristine, he has worked in leadership roles in the education sector, the retail sector and the e-commerce sector.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 11536