Difference between revisions of "SPIS Toolbox - Loan Assessment: Determine Financing Volume and Profitability"
***** (***** | *****) |
***** (***** | *****) m Tag: 2017 source edit |
||
(29 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{Spis Invest}} | |
− | = Loan Assessment: Determine Financing Volume and Profitability = | + | {| cellpadding="1" |
+ | |- | ||
+ | | {{Back to SPIS Toolbox 2}} | ||
+ | | | ||
+ | | {{Back to Finance}} | ||
+ | | | ||
+ | | {{Next Chapter}}[[SPIS Toolbox - Loan Assessment: Assess Credit Risk and Collateral|►Go to the Next Chapter]]'''</span></span> | ||
+ | |} | ||
+ | |||
+ | === '''<span style="color:#879637;">5. Loan Assessment: Determine Financing Volume and Profitability</span>''' === | ||
− | While the previous process steps focused on the policy makers, the next steps focus on the loan officers who assess single loan applications for | + | While the previous process steps focused on the policy makers, the next steps focus on the loan officers who assess single loan applications for financing SPIS. |
− | Loan officers generally prefer to use the tools provided by their institution, but it is useful to use the tools ''' | + | Loan officers generally prefer to use the tools provided by their institution, but it is useful to use the tools '''[[:file:INVEST Farm Analysis Tool version 3.0.xlsm|INVEST – Farm Analysis Tool]]''' and '''[[:File:INVEST Payback Tool version 3.0.xlsm|INVEST – Payback Tool]]''' as they are specifically designed for SPIS and can provide a first estimation of viability. In fact these tools can be provided to borrowers/loan applicants to verify their own assumptions. |
− | {| style="width: | + | {| style="width:100%;" cellspacing="1" cellpadding="1" border="0" |
|- | |- | ||
− | | style="background-color: rgb( | + | | style="background-color: rgb(225, 229, 205)" | |
'''Note''': Transaction costs for loan review can be high, especially if the technology has limited scope for standardization. Using specific tools, and encouraging loan applicants to use the same, can minimize unnecessary effort. | '''Note''': Transaction costs for loan review can be high, especially if the technology has limited scope for standardization. Using specific tools, and encouraging loan applicants to use the same, can minimize unnecessary effort. | ||
|} | |} | ||
− | == Outcome / Product == | + | ==== '''<span style="color:#879637;">Outcome/Product</span>''' ==== |
*Profitability analysis of investment (and alternatives); | *Profitability analysis of investment (and alternatives); | ||
Line 20: | Line 29: | ||
*Financial projections on investment costs (CAPEX) (and alternatives); | *Financial projections on investment costs (CAPEX) (and alternatives); | ||
− | == People / | + | ==== '''<span style="color:#879637;">People/Stakeholders</span>''' ==== |
*Loan officers financing or planning to finance SPIS; | *Loan officers financing or planning to finance SPIS; | ||
*Producer(s) / potential borrower(s); | *Producer(s) / potential borrower(s); | ||
− | *Management of financial service providers(operational level); | + | *Management of financial service providers (operational level); |
*Agricultural extension services and promotion agencies (e.g. for subsidies); | *Agricultural extension services and promotion agencies (e.g. for subsidies); | ||
*Providers of service, technology and inputs; | *Providers of service, technology and inputs; | ||
*Research and training institutes. | *Research and training institutes. | ||
− | == Data Requirements == | + | ==== '''<span style="color:#879637;">Data Requirements</span>''' ==== |
'''Research, collect, analyze, cross-check''' | '''Research, collect, analyze, cross-check''' | ||
*prices for components to be financed; | *prices for components to be financed; | ||
− | *cropping pattern and crop prices (fluctuation,trends); | + | *cropping pattern and crop prices (fluctuation,trends etc.); |
− | *prices for O&M costs and inputs ( | + | *prices for O&M costs and inputs (including other options); |
*sales revenues | *sales revenues | ||
− | *purpose and sums provided as subsidies or | + | *purpose and sums provided as subsidies and/or through sponsors; |
*macro-economic variables (inflation, interest rates, etc.); | *macro-economic variables (inflation, interest rates, etc.); | ||
− | *tax policies (corporate income tax, VAT dynamics, etc.). | + | *tax policies (corporate income tax, GST/VAT dynamics, etc.). |
'''Compute, prepare''' | '''Compute, prepare''' | ||
Line 50: | Line 59: | ||
*Payback Period (PP), Net Present Value (NPV) and Internal Rate of Return (IRR) of SPIS investment. | *Payback Period (PP), Net Present Value (NPV) and Internal Rate of Return (IRR) of SPIS investment. | ||
− | == Important Issues == | + | ==== '''<span style="color:#879637;">Important Issues</span>''' ==== |
− | *Compare PV with alternative pumping solutions and consider varying profitability of different SPIS (crops, size). | + | *Compare PV with alternative pumping solutions with the same scenarios and consider varying profitability of different SPIS systems (crops, size). |
− | + | *Loan should be assessed by informed, trained and capable loan staff. | |
− | + | {{SPIS Reference}} | |
− | + | {| cellpadding="1" | |
− | + | |- | |
− | [[ | + | | {{Back to SPIS Toolbox 2}} |
− | + | | | |
+ | | {{Back to Finance}} | ||
+ | | | ||
+ | | {{Next Chapter}}[[SPIS Toolbox - Loan Assessment: Assess Credit Risk and Collateral|►Go to the Next Chapter]]'''</span></span> | ||
+ | |} |
Latest revision as of 06:41, 9 December 2021
![SPIS Invest.svg](/images/thumb/a/ae/SPIS_Invest.svg/1200px-SPIS_Invest.svg.png)
►Back to the Start Page | ►Back to the Module Page | ►Go to the Next Chapter |
5. Loan Assessment: Determine Financing Volume and Profitability
While the previous process steps focused on the policy makers, the next steps focus on the loan officers who assess single loan applications for financing SPIS.
Loan officers generally prefer to use the tools provided by their institution, but it is useful to use the tools INVEST – Farm Analysis Tool and INVEST – Payback Tool as they are specifically designed for SPIS and can provide a first estimation of viability. In fact these tools can be provided to borrowers/loan applicants to verify their own assumptions.
Note: Transaction costs for loan review can be high, especially if the technology has limited scope for standardization. Using specific tools, and encouraging loan applicants to use the same, can minimize unnecessary effort. |
Outcome/Product
- Profitability analysis of investment (and alternatives);
- Cash flow analysis;
- Financial projections on investment costs (CAPEX) (and alternatives);
People/Stakeholders
- Loan officers financing or planning to finance SPIS;
- Producer(s) / potential borrower(s);
- Management of financial service providers (operational level);
- Agricultural extension services and promotion agencies (e.g. for subsidies);
- Providers of service, technology and inputs;
- Research and training institutes.
Data Requirements
Research, collect, analyze, cross-check
- prices for components to be financed;
- cropping pattern and crop prices (fluctuation,trends etc.);
- prices for O&M costs and inputs (including other options);
- sales revenues
- purpose and sums provided as subsidies and/or through sponsors;
- macro-economic variables (inflation, interest rates, etc.);
- tax policies (corporate income tax, GST/VAT dynamics, etc.).
Compute, prepare
- water unit cost;
- annual revenue and operating expenses (OPEX) --> Annual gross margin of production (current and future);
- CAPEX (capital expenditure); i.e. total/annual sum for financing investment in SPIS (and alternative system);
- cash flow projections (current, future, alternative energy source);
- life cycle cost of SPIS investment;
- Payback Period (PP), Net Present Value (NPV) and Internal Rate of Return (IRR) of SPIS investment.
Important Issues
- Compare PV with alternative pumping solutions with the same scenarios and consider varying profitability of different SPIS systems (crops, size).
- Loan should be assessed by informed, trained and capable loan staff.
►Back to the Start Page | ►Back to the Module Page | ►Go to the Next Chapter |