Loan Grace Period Spreadsheet - Excel

W
Description

Loan Grace Period Spreadsheet document sample

Shared by: cqh93112
-
Stats
views:
32
posted:
5/18/2011
language:
English
pages:
4
Document Sample
scope of work template
							                                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!

						
Related docs
Other docs by cqh93112
Loan Profitability
Views: 0  |  Downloads: 0
Loan Mod Spreadsheet
Views: 2  |  Downloads: 0
Loan Market Direct
Views: 2  |  Downloads: 0
Loan Estate
Views: 2  |  Downloads: 0
Loan Payments Form
Views: 3  |  Downloads: 0
Loan Officers and Real Estate Agents
Views: 1  |  Downloads: 0