skip to content
New Literacy Technology Consultants

Financial Projections Template

/ 1 min read

Revenue Projections

YearRevenue from SalesRevenue from SubscriptionsTotal Revenue
Year 1$X$Y$Z
Year 2$X+10%$Y+20%$Z+15%
Year 3$X+20%$Y+30%$Z+25%

Income Statement (Profit & Loss)

YearRevenueCOGS (Cost of Goods Sold)Gross ProfitOperating ExpensesNet Profit
Year 1$Z$X$Y$A$B
Year 2$Z+10%$X+5%$Y+10%$A+5%$B+10%
Year 3$Z+20%$X+5%$Y+15%$A+5%$B+20%

Cash Flow Statement

YearCash InflowsCash OutflowsNet Cash FlowEnding Cash Balance
Year 1$X$Y$Z$W
Year 2$X+10%$Y+15%$Z+5%$W+5%
Year 3$X+20%$Y+10%$Z+10%$W+15%

Break-even Analysis

  • Break-even point: $XYZ (Revenue = Costs)
  • Assumptions:
    • Fixed Costs: $ABC (e.g., salaries, rent, utilities)
    • Variable Costs: $DEF (e.g., marketing spend, cost of sales)
    • Average Revenue per Customer: $GHI

Unit Economics (CAC and LTV)

MetricValue
Customer Acquisition Cost (CAC)$X
Lifetime Value (LTV)$Y
LTV/CAC RatioZ:1

Scenario Analysis

ScenarioAssumptionsYear 1Year 2Year 3
Base10% customer growth, stable costs$X$Y$Z
Optimistic20% customer growth, reduced churn$A$B$C
Pessimistic5% customer growth, higher costs$D$E$F

Headcount Plan

YearNumber of EmployeesSalaries and BenefitsOther Expenses
Year 1X$Y$Z
Year 2X+5$Y+10%$Z+5%
Year 3X+10$Y+15%$Z+10%

Financial Graphs and Charts

  • Revenue vs. Expenses (line chart)
  • Break-even point (graph)
  • Cash Flow trajectory (bar chart)