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!

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

EduPristine is a member of Adtalem Global Education (NYSE: ATGE), a global education provider headquartered in the United States. Adtalem is a 3 billion dollars (20,000 crores) company that has about 9 institutions and companies with more than 16,000 employees spread across 145 locations. Adtalem takes pride in training 142,000 degree-seeking students all over the world.The organization's purpose is to empower students to achieve their goals, find success and make inspiring contributions to our global community. EduPristine is one of India's leading training providers in Analytics, Accounting, Finance, Healthcare, and Marketing. Founded in 2008, EduPristine has a strong online platform and network of classrooms across India and caters to self-paced learning and online learning, in addition to classroom learning

Comments

Interested in this topic?

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

* Mandatory Field

Post ID = 11536