I will build a robust and dynamic three statement financial model

Three statement financial model build

The key outputs are expected to be as follows 

• Integrated Income statement, balance sheet and cash flow following appropriate accounting standards
• Choice of timeline periodicity (monthly, quarterly, annual) with up to 96 periods and 8 summary periods
• Summary output dashboard with up to 10 KPI and 3 charts

Specification 

• Inputs will be clearly identified and shown separately from calculations and outputs to allow sensitivities to be run easily
• Ability to update for actuals
• Working capital to cashflows independently to income statement recognition
• Full scope of build to be determined in first session, client to provide management accounts

Ways of working

• First session to be scoping of requirements running through the business model and existing management accounts or management information
• Skeleton input / output template drafted based on scope and sent for approval
• Following approval, full model build begins in ernest
• Second session includes a live demo and draft handover for client testing
• Following approval, model is fully reviewed and prepared for final handover