05.Attachment B2 - Life Cycle Cost Analysis_EN.xlsx

	B	C	D
1
2
3
4
5
6
7		SME GRANT PROGRAM - Life Cycle Cost Analysis
8
9	Moldova Energy Security Activity (MESA) project funded by USAID and implemented by Tetra Tech ES, Inc
10
11	The life cycle cost analysis determines the economic feasibility of an energy efficiency project.
12	In order to be eligible for the SME Grant Program, applicants shall complete the Life Cycle Cost analysis which calculates:
13	the net present value (NPV), the savings-to-investment ratio (SIR), and internal rate of return (IRR) of the proposed
14	project according to the estimated investment and annual savings.
15
16	This is an automatic calculation excel containing four different sheets.
17
18		Input Data Dashboard: Applicants shall include their values in the gray cells
19
20		LCC: Determines the Life Cycle Cost Analysis of the proposed project
21		and calculates financial parameters to assess the project eligibility
22
23		LCC+Subsidy: Determines the Life Cycle Cost Analysis of the proposed project considering
24		the SME Grant Subsidy requested by the applicant and calculates financial parameters accordingly
25
26		Summary: Summarizes the financial parameters to be included in the Proposal Template file
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