ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Project title
Bakery
3
4
Financial Model for a small bakery startup selling chocolate coffee, expresso and cookies
5
The owners equity comprises
300,000Rs
6
The project is expecting the following metrics after five year:
7
NPV57,382Rs
8
IRR27.0%%
9
The initial capex includes the following items
10
Bakery machinery and peripherals320,000Rs
11
12
13
Table of contents
14
Summary
Executive summary
15
Macro
Dates, inflation, tax rates
16
Assumptions
All project assumptions
17
Reports
Income statement, cash flow statement, balance sheet
18
Charts
Charts and diagrams
19
Scenarios
Data for scenarios and sensitivity tables
20
Key input Data
Key initial paraqmeters for the project
21
22
Color coding
Author and contacts
23
Input cells9,999
Jerry Mavely
24
Calculated cells9,999
jerrymavely@gmail.com
25
26
*on google sheets Iterative Calculations to be on.
27
28
29
30
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