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

 
р.
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LEGEND
2
3
- Editable boxes for input information
4
(81,00)- Negative value
5
(81,00)
- Critical negative value
6
7
8
LISTS OF THE MODEL
9
10
Types of the lists
11
- Info
12
- Key information for user
13
- Lists for input information
14
- Lists with internal calculations
15
- Lists with totals
16
17
Navigation
18
Info- Helpful information
19
Resume
- Key information for user
20
Macro
- Information on macroeconomical parametres and the data related to the whole model
21
Sales
- Information on products/services, revenue calculation
22
Variable costs
- Information on cost of production
23
Fixed costs
- Information on fixed costs
24
Salary
- Information on salary costs
25
Investment
- Information on capital investments, property tax calculation
26
Finance
- Information on project financing
27
Calc- Internal calculations
28
Report
- Main reports (Balance, Profit & Loss Account and Cashflow Statement)
29
InvRatios- Investment ratio
30
SensAnalysis- Sensitivity analysis
31
32
33
ИСПОЛЬЗУЕМЫЕ ИМЕНА
34
35
FixedCosts
='Fixed costs'!$45:$45
Fixed cost (VAT exclusive)
36
fum=Macro!$E$6
Project currency
37
fumh=Macro!$G$6
Project currency in thousands
38
IncomeTaxRate=Macro!$13:$13
Income tax rate
39
InfMaterials=Macro!$39:$39
Material inflation
40
InfSalary=Macro!$40:$40
Salary inflation
41
InfSales=Macro!$38:$38
Revenue inflation
42
kb=Macro!$30:$30
Monthly rate for budget effectiveness calculation
43
PropertyTaxRate=Macro!$14:$14
Property tax rate
44
SalaryTax=Macro!$15:$15
Premium rate
45
VATRate=Macro!$16:$16VAT rate
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
Loading...
Main menu