This financial model is about creating a representation of your business/start-ups’ financial situation. It can be used across all industries for capital budgeting, estimating costs associated with running a particular business and projecting profits.
It has a “Summary” part where you have to type in information about your business and the rest will be automatically calculated. Other parts of the model include the;
Investor summary – which shows a summary of your investment and earnings, NPV and IRR
Income statement – shows the company’s revenues and expenses during a particular period. It indicates how the revenues are transformed into the net income or net profit
Cash flow statement – which shows how changes in balance sheet accounts and income affect cash and cash equivalents, and breaks the analysis down to operating, investing, and financing activities.
Balance sheet – which reports a company’s assets, liabilities and shareholders’ equity at a specific point in time, and provides a basis for computing rates of return and evaluating its capital structure.
Loan amortization – which shows calculations of how you will pay back a business loan on scheduled periodic payments that are applied to both principal and interest.