Financial Model
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Financial Model as PDF for free.
More details
- Words: 3,963
- Pages: 8
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. ERs Loan
Expected annual distribution of dividends
0%
Expected return on equity
0%
1 1 1
TO BE FILLED ONLY WITH 0 (TO EXCLUDE THE COMPONENT) OR WITH 1 (TO INCLUDE THE COMPONENT)
INVESTMENTS 1 Initial Investments (including taxes if any): Land purchase Machinery / Equipments Buildings / Fences / Site preparation Fertilization, Pesticides Soil prep., Seedling, Planting Other Depreciation Rate
Project start-up
Jan-06
Jan-07
Jan-08
Jan-09
Jan-10
$ $ $ $ $ $ $
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
Jan-08
Jan-09
Jan-10
0%
2 Financing: Loan(s) Amount Tenor Grace Period Interest rate
$ 0 years 0 years 0.00%
3 Equity:
$ $ $ $
Source 1 Source 2 Others Sources & Uses Control
OK
O & M COSTS Project start-up 1 Operating costs (including taxes if any): Thinnings / prunning Clearing / replanting Fuel / Transport services Repairs and Maintenance Harvesting Administration Others
Jan-06
$ $ $ $ $ $ $ $
2 Insurance:
Jan-07
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0.0% of investments
3 Forest certifications:
$
4 Income Tax:
0.00%
5 Carbon costs: Baseline Study, Monitoring Plan Validation Due diligence by WB / CF Unit Annual Verification
$ $40,000 $20,000 $120,000 $20,000
REVENUES 1
2
Start-up
Jan-06
Jan-07
Jan-08
Jan-09
Jan-10
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
Net Revenues - 1st Product Production Net Sales Price
(Unit) $
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
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 Net Sales Price
(Unit) $
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
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 Net Sales Price
(Unit) $
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
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 Carbon price
(tCO2e) $0.00 /tCO2e
0
0 TO BE NEGOTIATED
0
0
0
0
0
0
0
0
$
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net Revenues
Extraordinary Net Revenues
PLEASE USE THE AREA BELOW FOR ADDITIONAL INFO, IF NECESSARY
Jan-16
Jan-17
Jan-18
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-16
Jan-17
Jan-18
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
NO INPUT REQUIRED IN THIS SPREADSHEET Name of Project Country
0 0
INVESTMENTS AND EXPENSES Unit 1 Investments: Land purchase Machinery / Equipments Buildings / Fences / Site preparation Fertilization, Pesticides Soil prep., Seedling, Planting Other 2 Depreciation: Jan-06 Jan-07 Jan-08 Jan-09 Jan-10
Amount Tenor Grace Period Interest rate Jan-06 Jan-07 Jan-08 Jan-09 Jan-10
Jan-08
Jan-09
Jan-10
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
Jan-16
Jan-17
Jan-18
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
0% per year 0% per year 0% per year 0% per year 0% per year 0% per year
$0 $0
$0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$ $ $ $ $ $ $ $
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
0% of investments
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
CPLTD Interest $ 0 years 0 years 0.00% CPLTD Interest CPLTD Interest CPLTD Interest CPLTD Interest CPLTD Interest
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
5 Certifications: 6 Financing:
Jan-07 $0 $0 $0 $0 $0 $0 $0
3 Operating costs: Thinnings / prunning Clearing / replanting Fuel / Transport services Repairs and Maintenance Harvesting Administration Others 4 Insurance:
Jan-06
$ $ $ $ $ $ $
7 Income Tax:
0.00%
8 Carbon costs: Baseline Study, Monitoring Plan Validation Due diligence by BioCarbon Fund Annual Verification
$ $40,000.00 $20,000.00 $120,000.00 $20,000.00
$0 $0 $0 $0 $0
REVENUES Unit 1
Net Revenues
Jan-06
Jan-07
Jan-08
Jan-09
Jan-10
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
Jan-16
Jan-17
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-18 $0
Net Revenues - 1st Product production Sales price
$ (Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - 2nd Product production Sales price
$ (Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Other Product Production Price
$ (Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Carbon Credits Carbon generation Carbon price
$ (tCO2e) $0.00 /tCO2e
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
2
Extraordinary Net Revenues
$
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-34 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
NO INPUT REQUIRED IN THIS SPREADSHEET Name of Project Country
0 0
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
Jan-17
Jan-18
Jan-19
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - 1st Product production Sales price
(Unit) $
$0 0 $0
Net Revenues - 2nd Product production Sales price
(Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Other Product Production Price
(Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Carbon Credits ERs Production ER Price
(tCO2e) 0.0 US$/ton
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
Total Net Revenues
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
(-) Total Costs (-) Operating Costs Thinnings / prunning Clearing / replanting Fuel / Transport services Repairs and Maintenance Harvesting Administration Others
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $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
$0
$0
$0
(+) Extraord. Income
$0
$0
$0
$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
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net profit
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
(-) Dividends (+) D/D/A (-) Investments Land purchase Machinery / Equipments Buildings / Fences / Site preparation Fertilization, Pesticides Soil prep., Seedling, Planting Other (+) Loan (-) CPLTD
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$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
$0
$0
$0
Asset Cash Flow
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
(-) Insurance: (-) Certifications: (-) Costs BS/MP ERs (-) Costs Valid. ERs (-) Due Dilig PCF ERs (-) Annual Verif. ERs
$40,000 $20,000 $120,000 $20,000
Margin / (EBITDA) (-) D/D/A machinery (-) Interest expenses
0%
(-) Income tax
0.00%
Financial Indicators Total Debt Total Equity WACC (asset)
Rate 0.00% 0.00% 0.00%
$0 $0
IRR
Project Asset
Err:523 Err:523
NPV
Discount Rate 10.00% 15.00% 18.00% WACC (asset)
$0 $0 $0 $0
Long Term Debt / Equity Ratio Gross Operational Cash Flow - Didivends Debt Service Debt Service Coverage Ratio
0.00
0.00 $0 $0
0.0
0.00 $0 $0
0.0
0.00 $0 $0
0.0
0.00 $0 $0
0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
Name of Project Country
GEN. ASSUMPTIONS Factor
Com. Prod. ERs Loan
Expected annual distribution of dividends
0%
Expected return on equity
0%
1 1 1
TO BE FILLED ONLY WITH 0 (TO EXCLUDE THE COMPONENT) OR WITH 1 (TO INCLUDE THE COMPONENT)
INVESTMENTS 1 Initial Investments (including taxes if any): Land purchase Machinery / Equipments Buildings / Fences / Site preparation Fertilization, Pesticides Soil prep., Seedling, Planting Other Depreciation Rate
Project start-up
Jan-06
Jan-07
Jan-08
Jan-09
Jan-10
$ $ $ $ $ $ $
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
Jan-08
Jan-09
Jan-10
0%
2 Financing: Loan(s) Amount Tenor Grace Period Interest rate
$ 0 years 0 years 0.00%
3 Equity:
$ $ $ $
Source 1 Source 2 Others Sources & Uses Control
OK
O & M COSTS Project start-up 1 Operating costs (including taxes if any): Thinnings / prunning Clearing / replanting Fuel / Transport services Repairs and Maintenance Harvesting Administration Others
Jan-06
$ $ $ $ $ $ $ $
2 Insurance:
Jan-07
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0.0% of investments
3 Forest certifications:
$
4 Income Tax:
0.00%
5 Carbon costs: Baseline Study, Monitoring Plan Validation Due diligence by WB / CF Unit Annual Verification
$ $40,000 $20,000 $120,000 $20,000
REVENUES 1
2
Start-up
Jan-06
Jan-07
Jan-08
Jan-09
Jan-10
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
Net Revenues - 1st Product Production Net Sales Price
(Unit) $
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
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 Net Sales Price
(Unit) $
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
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 Net Sales Price
(Unit) $
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
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 Carbon price
(tCO2e) $0.00 /tCO2e
0
0 TO BE NEGOTIATED
0
0
0
0
0
0
0
0
$
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net Revenues
Extraordinary Net Revenues
PLEASE USE THE AREA BELOW FOR ADDITIONAL INFO, IF NECESSARY
Jan-16
Jan-17
Jan-18
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-16
Jan-17
Jan-18
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0.00 $0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
NO INPUT REQUIRED IN THIS SPREADSHEET Name of Project Country
0 0
INVESTMENTS AND EXPENSES Unit 1 Investments: Land purchase Machinery / Equipments Buildings / Fences / Site preparation Fertilization, Pesticides Soil prep., Seedling, Planting Other 2 Depreciation: Jan-06 Jan-07 Jan-08 Jan-09 Jan-10
Amount Tenor Grace Period Interest rate Jan-06 Jan-07 Jan-08 Jan-09 Jan-10
Jan-08
Jan-09
Jan-10
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
Jan-16
Jan-17
Jan-18
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
0% per year 0% per year 0% per year 0% per year 0% per year 0% per year
$0 $0
$0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$ $ $ $ $ $ $ $
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
0% of investments
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
CPLTD Interest $ 0 years 0 years 0.00% CPLTD Interest CPLTD Interest CPLTD Interest CPLTD Interest CPLTD Interest
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
5 Certifications: 6 Financing:
Jan-07 $0 $0 $0 $0 $0 $0 $0
3 Operating costs: Thinnings / prunning Clearing / replanting Fuel / Transport services Repairs and Maintenance Harvesting Administration Others 4 Insurance:
Jan-06
$ $ $ $ $ $ $
7 Income Tax:
0.00%
8 Carbon costs: Baseline Study, Monitoring Plan Validation Due diligence by BioCarbon Fund Annual Verification
$ $40,000.00 $20,000.00 $120,000.00 $20,000.00
$0 $0 $0 $0 $0
REVENUES Unit 1
Net Revenues
Jan-06
Jan-07
Jan-08
Jan-09
Jan-10
Jan-11
Jan-12
Jan-13
Jan-14
Jan-15
Jan-16
Jan-17
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-18 $0
Net Revenues - 1st Product production Sales price
$ (Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - 2nd Product production Sales price
$ (Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Other Product Production Price
$ (Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Carbon Credits Carbon generation Carbon price
$ (tCO2e) $0.00 /tCO2e
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
2
Extraordinary Net Revenues
$
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
Jan-19
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan-34 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
NO INPUT REQUIRED IN THIS SPREADSHEET Name of Project Country
0 0
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
Jan-17
Jan-18
Jan-19
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - 1st Product production Sales price
(Unit) $
$0 0 $0
Net Revenues - 2nd Product production Sales price
(Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Other Product Production Price
(Unit) $
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
Net Revenues - Carbon Credits ERs Production ER Price
(tCO2e) 0.0 US$/ton
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
Total Net Revenues
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
(-) Total Costs (-) Operating Costs Thinnings / prunning Clearing / replanting Fuel / Transport services Repairs and Maintenance Harvesting Administration Others
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $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
$0
$0
$0
(+) Extraord. Income
$0
$0
$0
$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
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net profit
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
(-) Dividends (+) D/D/A (-) Investments Land purchase Machinery / Equipments Buildings / Fences / Site preparation Fertilization, Pesticides Soil prep., Seedling, Planting Other (+) Loan (-) CPLTD
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$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
$0
$0
$0
Asset Cash Flow
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
(-) Insurance: (-) Certifications: (-) Costs BS/MP ERs (-) Costs Valid. ERs (-) Due Dilig PCF ERs (-) Annual Verif. ERs
$40,000 $20,000 $120,000 $20,000
Margin / (EBITDA) (-) D/D/A machinery (-) Interest expenses
0%
(-) Income tax
0.00%
Financial Indicators Total Debt Total Equity WACC (asset)
Rate 0.00% 0.00% 0.00%
$0 $0
IRR
Project Asset
Err:523 Err:523
NPV
Discount Rate 10.00% 15.00% 18.00% WACC (asset)
$0 $0 $0 $0
Long Term Debt / Equity Ratio Gross Operational Cash Flow - Didivends Debt Service Debt Service Coverage Ratio
0.00
0.00 $0 $0
0.0
0.00 $0 $0
0.0
0.00 $0 $0
0.0
0.00 $0 $0
0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
Jan-20
Jan-21
Jan-22
Jan-23
Jan-24
Jan-25
Jan-26
Jan-27
Jan-28
Jan-29
Jan-30
Jan-31
Jan-32
Jan-33
Jan-34
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0 $0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0 0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
$0 $0 0.0
Related Documents
Financial Model
November 2019 12
Financial Model
November 2019 13
Financial Model Xyz
October 2019 20
Ind Financial Model
July 2020 2
