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