Financial modelling template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ACDEFGHIJKLMNOPQRSTUVWX
1
Summary Projected Profit & Loss, Cashflow and Balance Sheets
2
3
4
Projected Profit & Loss Statements
5
Year 1 Year 2 Year 3 Year 4 Year 5
6
7
Total Sales - - - - -
8
Gross Profit - - - - -
9
10
Fixed Expenses - - - - -
11
Net Profit Before Tax - - - - -
12
Net Profit After Tax - - - - -
13
14
15
Projected Cashflow Statements
16
Year 1 Year 2 Year 3 Year 4 Year 5
17
18
Total Cash Receipts - - - - -
19
Total Cash Payments - - - - -
20
Net Cashflow - - - - -
21
Bank Balance (s) - - - - -
22
Bank Balance (e) - - - - -
23
24
25
Projected Balance Sheets (at end of year)
26
Year 1 Year 2 Year 3 Year 4 Year 5
27
Total Current Assets - - - - -
28
Total Operating Assets - - -
29
Total Assets - - - - -
30
31
Total Current Liabilities - - - - -
32
Total Non Current Liabilities - - -
33
Total Liabilities - - - - -
34
35
Net Assets - - - - -
36
37
Paid Up Capital - - - - -
38
Retained Earnings - - - - -
39
- - - - -
40
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
103
104
105
Loading...
 
 
 
Summary
BS
Cashflow
Profit And Loss
Assumptions