Difference between revisions of "SPIS Toolbox - Finance - Annex"
***** (***** | *****) m (→Annex) |
***** (***** | *****) m (→Annex) |
||
| Line 1: | Line 1: | ||
{{SPIS Banner}}<br/> | {{SPIS Banner}}<br/> | ||
| + | |||
| Line 8: | Line 9: | ||
'''<span style="color:#879637">Annex – Collection of Formulae (Finances)</span>'''<br/> | '''<span style="color:#879637">Annex – Collection of Formulae (Finances)</span>'''<br/> | ||
| − | '''<span style="color:#879637">Average Cash Flow</span>''''''<span style="color:#879637"> | + | '''<span style="color:#879637">Average Cash Flow</span>''''''<span style="color:#879637"></span>''<span style="color:#879637"></span> |
| + | |||
{| style="width: 800px" cellspacing="1" cellpadding="1" border="0" | {| style="width: 800px" cellspacing="1" cellpadding="1" border="0" | ||
|- | |- | ||
| style="background-color: rgb(153, 153, 102)" | | | style="background-color: rgb(153, 153, 102)" | | ||
| − | ''*Definition: The “cash flow” is the incoming and outgoing cash of a business. Expenses (costs) are considered as negative cash flows and revenues as positive ones.'' | + | <span style="color:#879637">''*Definition: The “cash flow” is the incoming and outgoing cash of a business. Expenses (costs) are considered as negative cash flows and revenues as positive ones.''</span> |
| + | |||
|} | |} | ||
| − | '''''Formula:'''''<i>(Revenue-R –Operating Expenses-C) = Cf. = Cash flow</i> | + | <span style="color:#879637">'''''Formula:'''''<i>(Revenue-R –Operating Expenses-C) = Cf. = Cash flow</i></span> |
| + | |||
| + | <span style="color:#879637">'''<span style="color:#879637">Payback Period* (PP)</span>'''</span><br/> | ||
| − | |||
{| style="width: 800px" cellspacing="1" cellpadding="1" border="0" | {| style="width: 800px" cellspacing="1" cellpadding="1" border="0" | ||
|- | |- | ||
| style="background-color: rgb(153, 153, 102)" | | | style="background-color: rgb(153, 153, 102)" | | ||
| − | ''*Definition: The payback period is the length of time required to recover the cost of an investment.'' | + | <span style="color:#879637">''*Definition: The payback period is the length of time required to recover the cost of an investment.''</span> |
| + | |||
|} | |} | ||
| − | '''Formula''': I/(R-C) = PP = Payback Period | + | <span style="color:#879637">'''Formula''': I/(R-C) = PP = Payback Period</span> |
| − | I=Initial investment (CAPEX) | + | <span style="color:#879637">I=Initial investment (CAPEX)</span> |
| − | C=Average annual operating expenses (OPEX), excluding depreciation | + | <span style="color:#879637">C=Average annual operating expenses (OPEX), excluding depreciation</span> |
| − | R=Average annual revenue | + | <span style="color:#879637">R=Average annual revenue</span> |
| − | (R-C) = Cf. = Cash flow | + | <span style="color:#879637">(R-C) = Cf. = Cash flow</span> |
| − | '''<span style="color:#879637">Net Present Value* (NPV)</span>'''<br/> | + | <span style="color:#879637">'''<span style="color:#879637">Net Present Value* (NPV)</span>'''</span><br/> |
{| style="width: 800px" cellspacing="1" cellpadding="1" border="0" | {| style="width: 800px" cellspacing="1" cellpadding="1" border="0" | ||
|- | |- | ||
| style="background-color: rgb(153, 153, 102)" | | | style="background-color: rgb(153, 153, 102)" | | ||
| − | ''*Definition: The “Net Present Value” or NPV determines the present worth of an investment by discounting the cash inflows and cash outflows generated by this investment over its life span. For the determination of the NPV you need to define the expected life span of the investment as well as a discount factor, which might be near to the interest rate on deposits. You could also use the NPV for comparison of alternative investment options.'' | + | <span style="color:#879637">''*Definition: The “Net Present Value” or NPV determines the present worth of an investment by discounting the cash inflows and cash outflows generated by this investment over its life span. For the determination of the NPV you need to define the expected life span of the investment as well as a discount factor, which might be near to the interest rate on deposits. You could also use the NPV for comparison of alternative investment options.''</span> |
| + | |||
|} | |} | ||
| − | '''''Formula:''''' | + | <span style="color:#879637">'''''Formula:''''' [[File:Formul1.jpg|thumb|left|180px|Formula]]</span> |
| − | [[File:Formul1.jpg|thumb|left|Formula]] | + | <div> |
| + | r= Discount factor =: 6% (current deposit rate in Chile 4-5%) | ||
| + | |||
| + | S= Salvage Value = €0 | ||
| + | |||
| + | I= Initial investment cost = €10,500 | ||
| + | |||
| + | t= years counting from base year | ||
| + | |||
| + | n= lifetime of project (panels) = 15years | ||
| + | </div> | ||
| + | <br/> | ||
Revision as of 18:27, 2 June 2017
Introduction
The Toolbox on Solar Powered Irrigation Systems (SPIS) is designed to enable advisors, service providers and practitioners in the field of solar irrigation to provide broad hands-on guidance to end-users, policy-makers and financiers. Risks related to system efficiency, financial viability and the unsustainable use of water resources can thus be minimized. The Toolbox comprises informative modules supplemented with user-friendly software tools (calculations sheets, checklists, guidelines). read more
Modules and tools touch upon:
- assessing the water requirements,
- comparing the financial viability,
- determining farm profitability and payback of investment in SPIS,
- sustainably design and maintain a SPIS,
- highlight critical workmanship quality aspects,
- and many more.
Annex
Annex – Collection of Formulae (Finances)
Average Cash Flow'
|
*Definition: The “cash flow” is the incoming and outgoing cash of a business. Expenses (costs) are considered as negative cash flows and revenues as positive ones. |
Formula:(Revenue-R –Operating Expenses-C) = Cf. = Cash flow
Payback Period* (PP)
|
*Definition: The payback period is the length of time required to recover the cost of an investment. |
Formula: I/(R-C) = PP = Payback Period
I=Initial investment (CAPEX)
C=Average annual operating expenses (OPEX), excluding depreciation
R=Average annual revenue
(R-C) = Cf. = Cash flow
Net Present Value* (NPV)
|
*Definition: The “Net Present Value” or NPV determines the present worth of an investment by discounting the cash inflows and cash outflows generated by this investment over its life span. For the determination of the NPV you need to define the expected life span of the investment as well as a discount factor, which might be near to the interest rate on deposits. You could also use the NPV for comparison of alternative investment options. |
r= Discount factor =: 6% (current deposit rate in Chile 4-5%)
S= Salvage Value = €0
I= Initial investment cost = €10,500
t= years counting from base year
n= lifetime of project (panels) = 15years
