Saturday, August 18, 2018

I will build a financial model with monthly and annual projections

I will build a financial model with monthly and annual projections












About:

Using three years audited financial statements and other business assumptions, i will build a robust financial model in Ms Excel that has 5 (or more) years projections. The model will have the following sheets:
  • Cover Page
  • Input Section-General assumptions, constants and timing assumptions
  • Projection Assumptions- Will provide a basis for projecting each line item.
  • Historical financial statements-3 years audited accounts and any other information that might be needed.
  • Monthly Projections-Projection will be done for each line item.
  • Annual projections- The summations of Monthly projections will give annual projections-
  • Charts-This provides a visual display of items such as revenue growth, Margins, Comparison of Revenue Vs Opex among others.
  • Business Valuation- Using DCF approach
  • Supporting Schedules such as Plant, Property & Equipment (PPE), Tax, Working Capital, Equity and Debt Schedule

The model will be flexible, well structured, accurate and Transparent. In case you need some samples, i will be willing to shared with you.

I intend to provide quality and timely work that meets clients expectations.

Thank you in anticipation.

 

Reviews


:

:

:

:

:


No comments:

Post a Comment