ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Financial Model Overview
2
3
Introduction
4
Venture NameCaila
5
Worksheets
6
IntroductionThis sheet
7
Next 24 Months
Projected cashflow for next 24 months
8
Base Year
Data entry sheet for first year estimates/actual data
9
Assumptions
Data entry sheet for assumptions relating to major line items
10
Income Statement
Pro forma Income Statement
11
Balance Sheet
Pro forma Balance Sheet
12
Cash Flow
Pro forma Cash Flow Statement
13
Income Statement Chart
Projected Income Statement Chart
14
Balance Sheet Char
Projected Balance Sheet Chart
15
Cash Flow Chart
Projected Cash Flow Chart
16
Cumulative Free
Free Cash Flow Chart
17
Impact
Impact Metrics calculated by year
18
Cash Flow Chart
19
20
Justification
21
• Estimate finance requirements, especially external, and plan accordingly
22
• Scenario analyses to determine the unit economics of products or services
23
24
Forecasting Methods
25
• Percent of Sales
26
• A method in which income statement and balance sheet figures to future sales
27
• The method is effective because the sale of an item directly influences several variable costs, current assets and liabilities
28
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102