Loan Grace Period Spreadsheet - Excel
W
Description
Loan Grace Period Spreadsheet document sample
Document Sample


ONLY THE GREEN CELLS SHALL BE FILLED
PLEASE USE THE AREA AT THE END OF THIS SHEET FOR ADDITIONAL EXPLANATIONS OR DETAILS, IF NECESSARY
Name of Project
Country
GEN. ASSUMPTIONS
Factor Com. Prod. 1 TO BE FILLED ONLY WITH 0 (TO EXCLUDE THE
ERs 1 COMPONENT) OR WITH 1 (TO INCLUDE THE
Loan 1 COMPONENT)
Expected annual distribution of dividends 0%
Expected return on equity 0%
INVESTMENTS
Project start-up Jan-06 Jan-07 Jan-08 Jan-09 Jan-10
1 Initial Investments (including taxes if any): $
Land purchase $ $0 $0 $0 $0 $0
Machinery / Equipments $ $0 $0 $0 $0 $0
Buildings $ $0 $0 $0 $0 $0
Furniture & Fittings $ $0 $0 $0 $0 $0
Other $ $0 $0 $0 $0 $0
Depreciation Rate 0%
2 Financing:
Loan(s) Amount $ $0 $0 $0 $0 $0
Tenor 0 years
Grace Period 1 years
Interest rate 12.00%
3 Equity: $
Source 1 $ $0 $0 $0 $0 $0
Source 2 $ $0 $0 $0 $0 $0
Others $ $0 $0 $0 $0 $0
Sources & Uses Control OK
O & M COSTS
Project start-up Jan-06 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15
1 Operating costs (including taxes if any): $
Raw Material $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Power and Fuel $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Labor $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Repairs and Maintenance $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Selling Expenses $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Administration $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Working Capital $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
2 Insurance: 0.0% of investments
3 Certifications: $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
4 Income Tax: 0.00%
5 Carbon costs: $
Baseline Study, Monitoring Plan $40,000
Validation $20,000
Due diligence by WB / CF Unit $120,000
Annual Verification $20,000
REVENUES
Start-up Jan-06 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15
1 Net Revenues
Net Revenues - 1st Product
Production (Unit) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Sales Price $ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Revenues - 2nd Product
Production (Unit) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Sales Price $ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Revenues - Other Product
Production (Unit) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Sales Price $ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Revenues - Carbon Credits
Carbon generation (tCO2e) 0 0 0 0 0 0 0 0 0 0
Carbon price $0.00 /tCO2e TO BE NEGOTIATED
2 Extraordinary Net Revenues $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
PLEASE USE THE AREA BELOW FOR ADDITIONAL INFO, IF NECESSARY
Jan-16
$0
$0
$0
$0
$0
$0
$0
$0
Jan-16
0.00
$0.00
0.00
$0.00
0.00
$0.00
0
$0
NO INPUT REQUIRED IN THIS SPREADSHEET
INVESTMENTS AND EXPENSES
Unit Jan-06 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16
1 Investments: $ $0 $0 $0 $0 $0
Land purchase $ $0 $0 $0 $0 $0
Machinery / Equipments $ $0 $0 $0 $0 $0
Buildings $ $0 $0 $0 $0 $0
Furniture & Fittings $ $0 $0 $0 $0 $0
Other $ $0 $0 $0 $0 $0
2 Depreciation: 0% per year $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Jan-06 0% per year $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Jan-07 0% per year $0 $0 $0 $0 $0 $0 $0 $0 $0
Jan-08 0% per year $0 $0 $0 $0 $0 $0 $0 $0
Jan-09 0% per year $0 $0 $0 $0 $0 $0 $0
Jan-10 0% per year $0 $0 $0 $0 $0 $0
3 Operating costs: $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Raw Material $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Power and Fuel $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Labor $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Repairs and Maintenance $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Selling Expenses $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Administration $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Working Capital $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
4 Insurance: 0% of investments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
5 Certifications: $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
6 Financing: CPLTD $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Amount $ $0 $0 $0 $0 $0
Tenor 0 years
Grace Period 1 years
Interest rate 12.00%
Jan-06 CPLTD $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Jan-07 CPLTD $0 $0 $0 $0 $0 $0 $0 $0 $0
Interest $0 $0 $0 $0 $0 $0 $0 $0 $0
Jan-08 CPLTD $0 $0 $0 $0 $0 $0 $0 $0
Interest $0 $0 $0 $0 $0 $0 $0 $0
Jan-09 CPLTD $0 $0 $0 $0 $0 $0 $0
Interest $0 $0 $0 $0 $0 $0 $0
Jan-10 CPLTD $0 $0 $0 $0 $0 $0
Interest $0 $0 $0 $0 $0 $0
7 Income Tax: 0.00%
8 Carbon costs: $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Baseline Study, Monitoring Plan $40,000.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Validation $20,000.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Due diligence by BioCarbon Fund $120,000.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Annual Verification $20,000.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
REVENUES
Unit Jan-06 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16
1 Net Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - 1st Product $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
production (Unit) 0 0 0 0 0 0 0 0 0 0 0
Sales price $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - 2nd Product $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
production (Unit) 0 0 0 0 0 0 0 0 0 0 0
Sales price $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - Other Product $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Production (Unit) 0 0 0 0 0 0 0 0 0 0 0
Price $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - Carbon Credits $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Carbon generation (tCO2e) 0 0 0 0 0 0 0 0 0 0 0
Carbon price $0.00 /tCO2e
2 Extraordinary Net Revenues $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
NO INPUT REQUIRED IN THIS SPREADSHEET
Project Cashflow
Unit Jan-06 Jan-07 Jan-08 Jan-09 Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16
Net Revenues - 1st Product $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
production (Unit) 0 0 0 0 0 0 0 0 0 0 0
Sales price $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - 2nd Product $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
production (Unit) 0 0 0 0 0 0 0 0 0 0 0
Sales price $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - Other Product $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Production (Unit) 0 0 0 0 0 0 0 0 0 0 0
Price $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Revenues - Carbon Credits $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
ERs Production (tCO2e) 0 0 0 0 0 0 0 0 0 0 0
ER Price 0.0 US$/ton
Total Net Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Total Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Operating Costs
Raw Material $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Power and Fuel $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Labor $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Repairs and Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Selling Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Administration $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Working Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Insurance: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Certifications: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Costs BS/MP ERs $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Costs Valid. ERs $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Due Dilig PCF ERs $120,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Annual Verif. ERs $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Margin / (EBITDA) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) D/D/A machinery 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Interest expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Operational Result (EBT) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(+) Extraord. Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Profit before tax $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Income tax 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net profit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(+) D/D/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(-) Investments $0 $0 $0 $0 $0
Land purchase $0 $0 $0 $0 $0
Machinery / Equipments $0 $0 $0 $0 $0
Buildings $0 $0 $0 $0 $0
Furniture & Fittings $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0
(+) Loan $0 $0 $0 $0 $0
(-) CPLTD $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Free Cash Flow $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Asset Cash Flow $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Financial Indicators Rate
Total Debt 12.00% $0
Total Equity 0.00% $0
WACC (asset) #DIV/0!
IRR Project #NUM!
Asset #NUM!
NPV Discount Rate
10.00% $0
15.00% $0
18.00% $0
WACC (asset) #DIV/0!
Long Term Debt / Equity Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Gross Operational Cash Flow - Didivends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Debt Service $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Debt Service Coverage Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Get documents about "