Renovation_Budget_Estimator_2008

Document Sample
Renovation_Budget_Estimator_2008 Powered By Docstoc
					      Affordable Housing Development
                           Calculator

Before you begin
Please take the time to read through this introduction before you begin working through your own
project. Understanding the background, development and proper applications of this tool including its
limitations will help you to develop a useful and reliable sense of the likely costs and even the viability

Components of the tool: Working through the tabs
This calculator tool has been built using a Microsoft Excel spreadsheet document. Within this document
are several ‘tabs’ or worksheets that interact to process the information you enter for your specific
project. There are several calculations generated that will help you understand your project better. The



Budget
The Budget tab is the main calculator used to estimate the viability of your project. Your first task will
be to enter the number of units you wish to develop. As with all the worksheets (“tabs”), you must enter
information into the darker shaded “cells” (each box is called a “cell’). When you select (click on) a cell
that requires that you enter a variable, specific instructions will appear to advise you how to fill the cell.
In the lighter blue cells, estimates are automatically generated. Comments providing extra information
(such as what estimates a calculation is based on) will appear as you move the cursor over any cell with
a red triangle in the upper right corner.



Renovation Costs Calculator
If your project will include the purchase of an existing building it will most likely need to be renovated
or retrofitted for your purposes. The extent of these changes can vary dramatically from project to
project and can be the hardest series of costs to estimate. It can also be disastrous if the costs associated
with renovation turn out to be far beyond your organization’s ability to afford.
This page offers an opportunity to come to understand what changes may be needed for your project and
to come to a more accurate understanding of what they may cost. The Calculator is organized where
each row in the spreadsheet represents a possible required renovation. These items are firstly divided
into 15 main headings such as “Electrical”, “Structural” or “Interior Finishes”. Under each heading
there are various specific elements that may be required in column B. When you pass your cursor over
Column C, you will uncover a brief explanation of what these items mean, situations where they may
need to be addressed, and specific instructions on what information you will need to collect and enter
The bottom of the calculator contains the Subtotal row which sums all the items in the individual rows,
a GST Calculation which applies the GST to the total. PST is usually not charged extra to renovation
works as renovators and contractors are considered “itinerant sellers” which means that they come to
your house and make changes to the “real property”. In this situation, PST does not apply as the “good”

The final estimate of renovation costs is then automatically pulled into the Budget Tab.


Calculation Page
This page contains the formulas and price components broken down for the various items listed in the
Renovation Cost Calculator. Figures entered into the calculator are factored into the formulas laid out
on this page. Please note that although the costs outlined here have been thoroughly researched and the
calculator projects inflation into the next few years, these figures are estimates based on information
specific to Peterborough Ontario over the course of 2007. You may chose to review the costs in this



Percentage Page
This page contains a chart outlining the general proportional values of labour vs. material expressed as
percentages of various trades and renovation work. From these proportions, a "Labour Factor" was
drawn. For many of the items in the Renovation Cost Calculator, material costs were researched and
the Labour Factor was applied in order to arrive at the estimated overall cost. This sheet will stay
relevant over time but may be adjusted if you are applying this calculator in a region with a significantly




Five Year Pro Forma
Is automatically generated from the completion of the Budget worksheet.



Soft Costs
The Soft Costs tab provides specific estimates or rate data to the Budget. You don’t need to work on
this Tab, unless you want more information on a particular estimate.data – or you want to input your
region’s data/rates. Much of the data is relevant to any project while some is Peterborough-specific
(vacancies, rents, municipal fees & taxes). If you are using this calculator outside of Peterborough, you
Mortgage Calculator
Is provided here as an additional useful tool (particularly if you want to explore the cost implications of
longer amortization or making lump sum payments on your mortgage).



Aknowledgements
The final worksheet lists the various agencies, groups and individuals who assisted us to create this tool
with their knowledge and expertise, as well as a short list of useful on line resources worth checking
out.
                                                 Capital and Operating
                                                 Budget Template
         Cells shaded this colour require information be inputted (or verified)
         Cells shaded this colour have formulas that automatically calculate

Number and Types of Units in Proposed Development
Enter the number of units of each type
Affordable Units                                 Level 2 Affordability             Market Units                  Vacancy
# of units       Unit size         80%ofAve       # of units   Unit size           # of units Unit size Ave Rent
                 bachelor            $454                      bachelor      $595             bachelor    $568
               1 bedroom             $567                     1 bedroom      $759            1 bedroom    $709     2.0%
               2 bedroom             $658                     2 bedroom      $866            2 bedroom    $822     3.1%
               3 bedroom             $800                     3 bedroom     $1,031           3 bedroom $1,000      5.2%
               4 bedroom             $942                     4 bedroom                      4 bedroom $1,178      5.2%
               5 bedroom            $1,085                    5 bedroom                      5 bedroom $1,356      5.2%
            Total AHP units            0         Total Level 2 units           0   Total Market Units       0
             TOTAL UNITS               0
Initial Purchase Capital Budget
Hard Costs
Property Purchase
Reno/Construction Costs                     $0
               Total Hard Costs             $0

Soft Costs
Legal fees                              $1,075
Appraisals
Design/Engineering                          $0
Env Assm't Phase 1                          $0
Env Assm't Phase 2                          $0
Rezoning fees                               $0
Minor variance                              $0
Severance                                   $0
Site Plan                                   $0
Development Charges                         $0
Building Permit                           $150 (renovations)               *New* Construction Bldg Permit
Appliances (fridge&stove)                   $0                             new area          permit cost
Soft Cost Contingency                      $32          3%                          ft2                0
                 Total Soft Costs       $1,257                                      m2                 0

                 TOTAL COSTS            $1,257 (Expenses during construction are included below)
Income and Expense Calculations
Project Rent Revenues
Gross Rental Revenue                     $0
Vacancy Allowance                        $0
Parking Income
Laundry Income
Effective Gross Income                   $0
Project Operating Expenses
Property tax                             $0
Heat                                     $0
Electricity                              $0
Water/sewer                              $0
Garbage/snow removal                     $0
Insurance                                $0
Maintenance/Repairs                      $0
Wages                                    $0
Management Fees                          $0         4%
Miscellaneous (i.e.: ads)
Replacement Reserve                   $0.00         4%
Total Operating Expenses                 $0
NET OPERATING INCOME                     $0

Project Financing
Cash/Committed Donations
AHP                                      $0      yes
Development charges waived               $0
Property Tax reductions                  $0
PAHF                                     $0
CMHC                                     $0       no
Other grants/fundraising                 $0 Details:
Other grants/fundraising                       Details:
Other grants/fundraising                       Details:
Other grants/fundraising                       Details:
Total Equity Available                   $0

Net Loan Amount                      $1,257

Calculating Mortgage Insurance
Application fee                          $0
% Premium on total loan              5.50%
Premium Amount                          $69
Expenses during construction             $0               0    Calculate
Gross Loan Amount                    $1,326

Mortgage amortization(yrs)               25
Mortgage Interest Rate                  6%
Annual Debt Service                 $102.55                   98.99014361

AVAILABLE CASH FLOW                 -$102.55
                                                                                      Current
                                                              Equity        Target    DCR
Debt Coverage Ratios                                          Required      DCR       Value % Prem
Current DCR = Market NOI/(P+I) =                   -
Maximum Loan Available at 1.0 DCR                 #REF!       $      1.00      1.10      -      1.25%
Maximum Loan Available at 1.2 DCR                 #REF!       $ 40,000.00      1.20      -      1.25%
#NAME?
                                                    Renovation Cost Ca

Instructions: Visit each item listed below. Hold your mouse arrow over the "Details and Hints" cell for
have completed these steps for each item the formulas in the spreadsheet will calculate a total project es
compensate for an assumed 10% inflation in the building industry.


     Categories                    Items                   Details        Quantity
Municipal Services
                      Upgrade Waste                 Details and Hints
                      Upgrade Water Supply          Details and Hints
External Services
                      Upgrade Waste                 Details and Hints
                      Upgrade Water Supply          Details and Hints
Driveway/parking
                      Culvert Charge                Details and Hints
                      Culvert Install               Details and Hints
                      Curb Cutting                  Details and Hints
                      Bed Development               Details and Hints
                      Paving                        Details and Hints
                      Concrete                      Details and Hints
Drainage/ Site Remediation
                      Clean Fill                    Details and Hints
                      Machine Operator              Details and Hints
Fencing
                      Repair                        Details and Hints
                      Build new                     Details and Hints
Trash Removal
                      Trash removal                 Details and Hints
Demolition of Exterior Structure
                      Demolition                    Details and Hints
Exterior
                      Roofing                       Details and Hints
                      Soffit and Fascia             Details and Hints
                      Eaves troughs                 Details and Hints
                      Siding                        Details and Hints
                      Painting                      Details and Hints
                      Brick Repair                  Details and Hints
                      Replacement Windows           Details and Hints
                      Replacement Doors             Details and Hints
                      Entranceway(s)                Details and Hints
                     Wheelchair Ramp(s)                    Details and Hints
                     Retaining walls                       Details and Hints
                     Walkway Repair (small job)            Details and Hints
                     Walkway Repair (big job)              Details and Hints
Structure
                     Partition wall-load bearing           Details and Hints
                     Partition wall-non load bearing       Details and Hints
                     Fire wall                             Details and Hints
                     Floor reinforcement                   Details and Hints
                     Roof reinforcement for finished
                     attic                                 Details and Hints
                     Framing to finish basement walls      Details and Hints
                     Cut and install doorway in interior
                     wall                                  Details and Hints
                     Cut new opening and install
                     window                                Details and Hints
                     Foundation Repair-rubble              Details and Hints
                     Foundation Repair-block               Details and Hints
                     Foundation Repair- cracks in
                     poured concrete                       Details and Hints
                     Foundation Repair- large failures
                     in poured concrete                    Details and Hints
                     Finish Basement Floor                 Details and Hints
Plumbing
                     Rough in for fixture                  Details and Hints
                     Install Kitchen Sink                  Details and Hints
                     Install Dishwasher                    Details and Hints
                     Install vanity basin                  Details and Hints
                     Install Toilet                        Details and Hints
                     Install standard 5 foot tub           Details and Hints
                     Install tub surround                  Details and Hints
                     Install shower stall                  Details and Hints
                     Install new purchased hot water
                     tank                                  Details and Hints
                     Lease hot water tank                  Details and Hints
                     Install exterior Hose bib             Details and Hints
                     Install washing machine hook-up       Details and Hints
                     Replace faucet set                    Details and Hints
HVAC
                     Replace gas furnace                   Details and Hints
                     New furnace with central air-
                     conditioning                          Details and Hints
                     Install new duct work                 Details and Hints
                     Fire dampers                          Details and Hints
                     Grills                                Details and Hints
                     Chimney replacement                   Details and Hints
                     Replace gas Boiler                    Details and Hints
Heat sealing and insulation
                     Seal existing window                  Details and Hints
                     Seal existing doorway                 Details and Hints
                     Blown-in cellulose in walls           Details and Hints
                    Blown-in cellulose in attic           Details and Hints
                    Blown-in Fibreglass in attic          Details and Hints
                    Sprayed eurethane foam                Details and Hints
                    Fibreglass batt insulation 2x6        Details and Hints
                    Vapour barrier                        Details and Hints
                    Range hood                            Details and Hints
                    Washroom vent fan new                 Details and Hints
                    Washroom vent fan replacement         Details and Hints
Electrical
                    Upgrade service to 100 amps and
                    replace panel                         Details and Hints
                    Upgrade service to 200 amps and
                    replace panel                         Details and Hints
                    Split service (add one meter and
                    panel)                                Details and Hints
                    Replace breaker panel                 Details and Hints
                    Add 120v circuit                      Details and Hints
                    Install exterior outlet               Details and Hints
                    Install interior outlet               Details and Hints
                    Add 240v circuit                      Details and Hints
                    rough in for new light fixture        Details and Hints
                    install light fixture                 Details and Hints

                    Trimming out                          Details and Hints
Interior finishes
                    Plaster repair                        Details and Hints
                    New drywall                           Details and Hints
                    Fire barrier drywall                  Details and Hints
                    Interior door -- non fire rated       Details and Hints
                    interior door -- fire rated           Details and Hints
                    Trim                                  Details and Hints
                    Painting                              Details and Hints

                    Sand and finish existing wood floor   Details and Hints
                    Underlay                              Details and Hints
                    Carpet                                Details and Hints
                    Vinyl sheet flooring                  Details and Hints
                    Hardwood                              Details and Hints
                    Ceramic Tile                          Details and Hints
Kitchen             Cabinets                              Details and Hints
                    Counter top                           Details and Hints

Subtotal
5% GST
Overrun/contingency 15%
Total
ion Cost Calculator

he "Details and Hints" cell for each item and follow the hints for entering your project specific information. When you
will calculate a total project estimate for the year this tool was designed as well as for the following 4 years to


                           Estimated Cost     Estimated Cost     Estimated Cost      Estimated Cost
                Unit            2007               2008               2009                2010

          linear feet           $0.00              $0.00               $0.00              $0.00
          linear feet           $0.00              $0.00               $0.00              $0.00

          linear feet           $0.00              $0.00               $0.00              $0.00
          linear feet           $0.00              $0.00               $0.00              $0.00

          one fee               $0.00              $0.00               $0.00              $0.00
          single                $0.00              $0.00               $0.00              $0.00
          linear feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00

          cubic yards           $0.00              $0.00               $0.00              $0.00
          hours                 $0.00              $0.00               $0.00              $0.00

          linear feet           $0.00              $0.00               $0.00              $0.00
          linear feet           $0.00              $0.00               $0.00              $0.00

          1/2 ton trucks        $0.00              $0.00               $0.00              $0.00

          1/2 ton trucks        $0.00              $0.00               $0.00              $0.00

          square feet           $0.00              $0.00               $0.00              $0.00
          linear feet           $0.00              $0.00               $0.00              $0.00
          linear feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00
          square feet           $0.00              $0.00               $0.00              $0.00
          single                $0.00              $0.00               $0.00              $0.00
          single                $0.00              $0.00               $0.00              $0.00
Inches to grade   $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00

linear feet       $0.00   $0.00   $0.00   $0.00
linear feet       $0.00   $0.00   $0.00   $0.00
linear feet       $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00

square feet       $0.00   $0.00   $0.00   $0.00
linear feet       $0.00   $0.00   $0.00   $0.00

single            $0.00   $0.00   $0.00   $0.00

square feet       $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00

linear feet       $0.00   $0.00   $0.00   $0.00

square feet       $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00

single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00

single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00

single            $0.00   $0.00   $0.00   $0.00

single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
grills            $0.00   $0.00   $0.00   $0.00
grills            $0.00   $0.00   $0.00   $0.00
linear feet       $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00

single            $0.00   $0.00   $0.00   $0.00
single            $0.00   $0.00   $0.00   $0.00
square feet       $0.00   $0.00   $0.00   $0.00
square feet    $0.00   $0.00   $0.00   $0.00
square feet    $0.00   $0.00   $0.00   $0.00
square feet    $0.00   $0.00   $0.00   $0.00
square feet    $0.00   $0.00   $0.00   $0.00
square feet    $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00


single         $0.00   $0.00   $0.00   $0.00

single         $0.00   $0.00   $0.00   $0.00

single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
switches and
receptacles    $0.00   $0.00   $0.00   $0.00

square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
single         $0.00   $0.00   $0.00   $0.00
linear foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00

square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
square foot    $0.00   $0.00   $0.00   $0.00
linear foot    $0.00   $0.00   $0.00   $0.00
linear foot    $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
ific information. When you
following 4 years to


            Estimated Cost
                 2011

                 $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
                                                      Calculation Page

Upgrade Waste
(25' extension)        materials      $      400.00   total            4480
                       labour         $    2,880.00   per foot         179.2
                       excavator      $    1,200.00
Upgrade Water Supply
(25' extension)        materials      $      600.00   total            4680
                       labour         $    2,880.00   per foot         187.2
                       excavator      $    1,200.00

Upgrade Waste
(25' extension)        materials      $      400.00   total            3040
                       labour         $    1,440.00   per foot         121.6
                       excavator      $    1,200.00
Upgrade Water Supply
                       materials      $    1,000.00   total            3640
                       labour         $    1,440.00   per foot         145.6
                       excavator      $    1,200.00
Culvert Charge                      50
Culvert Install        10 per lineal foot plus 4 hours machine plus 600 agregate
                       14 lf +1000                      $ 1,140.00
Curb Cutting                                            $    15.95
Bed Development                        Per 1000 sq feetper 1sq foot
                       Excavator        $      900.00 $       0.90
                       aggegate         $    1,200.00 $       1.20
                       Trucking         $      360.00 $       0.36
                                        $    2,460.00 $       2.46
Paving                                                  $     1.67
Concrete               materials                        $     7.86
                       labor factor                     $     2.80
                       total                            $    22.01
Clean Fill                          35
Machine Operator                  100
Repair (fencing)       materials        $        12.00
                       labour factor $            2.52
                       total            $        30.24
Build new (fencing)    materials        $        22.25
                       labour           $         2.52
                       total            $        56.07
Trash removal
                       labour         $       20.00
                       trucking       $       10.00
                       tipping        $       25.00   $    55.00
Demolition
                       labour         $       50.00
                          trucking        $        10.00
                          tipping         $        25.00    $    85.00
Roofing
                          materials       $      25.00
                          labour factor   $       1.83
                          total           $      45.75
                          tipping         $       5.50      $     2.44
Soffit and Facia                          $       9.50
Eavestroughs                              $       7.00
Siding                    materials       $       0.85
                          labour factor   $       1.65
                          total           $       1.40
Painting                  materials       $       0.33
                          labour factor           3.30
                          total          $        1.09
Brick Repair                            100 sq feet         1 sq foot
                          materials      $      250.00      $      2.50
                          Labour         $      765.00      $      7.65
                          total          $   1,015.00       $    10.15
Replacement Windows       total          $       43.38
Replacement Doors                        $   1,000.00
Entranceway with new
door                      materials       $        900.00
                          labour factor              2.52
                          total           $      2,268.00
Wheelchair Ramp(s)                        24'               1'
                          materials       $        759.74
                          labour factor              2.52
                          Total           $      1,914.54   $    79.77
Retaining walls                           $         30.00
Walkway Repair (small
job)                      materials                         $    11.22
                          labour factor                           2.80
                          total                             $    31.42
Walkway Repair (big
job)                      materials                         $     5.19
                          labour factor                     $     2.80
                          total                             $    14.53
Partition wall-load
bearing                                    12'              1'
                                           $
                          Material (12' x 8')     215.94    $    18.00    10 2x6x8   $    43.00
                          labour factor                           2.52     4 2x6x12 $     24.48
                          total                             $    45.35     6 4x8 dw $     71.94
                                                                                     $
                                                                             mud & msc    50.00
                                                                             total:  $   215.94
Partition wall-non load
bearing                                    12'              1'
                                           $
                          Material (12' x 8')     165.16    $    13.76    10 2x4x8   $    26.70
                          labour factor                           2.52     4 2x4x12 $     16.52
                          total                             $    34.68     6 4x8 dw $     71.94
                                                                                     $
                                                                             mud & msc    50.00
                                                                             Total   $   165.16
Firewall                                   12'              1'
                                           $
                          Material (12' x 8')     258.58    $    21.55    10 2x4x8     $ 26.70
                          labour factor                           2.52     4 2x4x12 $ 16.52
                          total                             $    54.30                   165.36
                                                                          12 4x8x5/8 fc$dw
                                                                                       $
                                                                               mud & msc 50.00
                                                                               Total   $ 258.58
Floor reinforcement                      100sq'             1sq'
                                         $
                          material (100sq')     123.90      $       1.24    10 2x10x10 $ 103.90
                          labour                                    2.52       misc    $ 20.00
                          total                             $       3.12       total   $ 123.90
Roof reinforcement for
finished attic                           100sq'             1sq'
                                         $
                          material (100sq')     70.01       $       0.70     6 2x8x10    $ 42.00
                          labour                                    2.52     3 2x4x8     $ 8.01
                          total                             $       1.76       misc      $ 20.00
                                                                               Total     $ 70.01
Framing to finish
basement walls                             12'              1'
                                           $
                          Material (12' x 8')     165.16    $      13.76    10 2x4x8      $ 26.70
                          labour factor                             2.52     4 2x4x12 $ 16.52
                          total                             $      34.68     6 4x8 dw $ 71.94
                                                                                          $
                                                                               mud & msc 50.00
                                                                            12 sill gasket$ 0.94
                                                                            96 tar paper $ 3.74
                                                                                          $
                                                                           120 vapour barrier 5.40
                                                                            96 insulation $ 53.76
                                                                               Total      $ 165.16
Cut and install doorway
in interior wall        materials                           $    200.00
                        labour                                     2.52
                        Total                               $    504.00
Cut new opening and
install window          materials                           $    43.38
                        labour factor                              1.50
Foundation Repair-      Total                               $    65.07
rubble                                100 sq feet           1 sq foot
                        materials      $      100.00        $      1.00
                        Labour         $   1,190.00         $    11.90
                        total          $   1,290.00         $    12.90

Foundation Repair-block                   100 sq feet       1 sq foot
                          materials       $        250.00   $       2.50
                          Labour          $        765.00   $       7.65
                          total           $      1,015.00   $      10.15
Foundation Repair-
cracks in poured
concrete                  materials                         $      10.00
                          labour                            $      40.00
                          total                             $      50.00
Foundation repair-large
failures in poured
concrete                materials                           $     13.10
                        labour factor                              2.80
                        total                               $     36.68
Finish Basement Floor Materials                             $      5.19
                        labour factor                              2.80
                        Total                               $     14.53
Rough in for fixture                                        $    350.00
Install Kitchen Sink                                        $    400.00
Install Dishwasher                                 $   650.00
Install vanity basin                               $   200.00
Install Toilet                                     $   200.00
Install standard 5 foot
tub                                                $ 850.00
Install tub surround                               $ 500.00
Install shower stall                               $ 1,000.00
Install new purchased
hot water tank                                     $   850.00
Lease hot water tank                               $   100.00

Install exterior Hose bib                          $   350.00
Install washing machine
hook-up                                            $ 350.00
Replace faucet set                                 $ 250.00
Replace gas furnace                                $ 3,250.00
New furnace with central
air-conditioning                                   $ 4,500.00
Install new duct work                              $ 2,500.00
Fire dampers                                       $     60.00
Grilles                                            $     12.00
Chimney replacement                30 foot         1foot
                                   $    2,500.00   $     83.33
Replace gas Boiler                                 $ 3,000.00
Seal existing window                               $     40.00
Seal existing doorway                              $     60.00
Blown-in cellulose in
walls                                              $     1.35
Blown-in cellulose in
attic                                              $     0.90
Blown-in Fibreglass in
attic                                              $     1.50
Sprayed eurethane
foam                                               $     3.50
Fibreglass batt
insulation 2x6                     insulation      $     0.57
                                   labour factor   $     1.67
                                   total           $     0.95
Vapour barrior                     plastic         $     0.05
                                   labour factor         1.67
                                   total           $     0.08
Range hood                         materials       $   200.00
                                   labour factor         2.50
                                   total           $   500.00
washroom vent fan new       500
Washroom vent fan
replacement                 375

Upgrade service to 100
amps and replace panel      775

Upgrade service to 200
amps and replace panel      1250
Split service (add one
meter and panel)            775
Replace breaker panel       500
Add 120v circuit               225
Install exterior outlet        225
Install interior outlet        185
Add 240v circuit               250
rough in for new light
fixture                        185
install light fixture          200
Trimming out                      7
Plaster repair                    4
New drywall                     2.5
Fire barrier drywall           2.75
Interior door -- non fire
rated                           200
interior door -- fire rated     350
Trim                          4.768
Painting                      0.715 $   0.09   2.5 coats x labour ratio x square foot coverage\
Sand and finish existing
wood floor                     1.75 $   0.29
Underlay                        1.5
Carpet                          2.5
Vinyl sheet flooring              4
Hardwood                          8
Ceramic Tile                    9.5
Cabinets                       150
Counter top                      20
tion Page

       Sources:

       Millage Masonry
       Mason           $55.00/hr
       Assistant       $30.00/hr


       Vern O'Brian Excavating
       Excavator                     100/hr
       Truck                         60/hr
       average truckload of aggegate        400

       Asphalt (Bell Paving)
       1.50 to 1.75 per square foot


       FCI Windows
       Window averages
       square footage Installed price   per foot   avg per foot
                     4 $     352.00      $ 88.00   $    43.38
                     6 $     374.00      $ 62.33
                     8 $     395.00      $ 49.38
                    10 $     453.00      $ 45.30
                    12 $     511.00      $ 42.58
                    14 $     568.00      $ 40.57
                    16 $     625.00      $ 39.06
                    18 $     683.00      $ 37.94
                    20 $     740.00      $ 37.00
                    22 $     798.00      $ 36.27



       Kingdon Tim-Br-Mart
       wheelchair ramp materials 24'
                    11 2x8x8            $ 110.88
                     3 2x8x10           $ 37.80
                     6 2x6x8            $ 44.94
                      2 2x6x10          $ 18.60




                    21 2x6x12           $ 234.36
                     2 4x4x8            $ 20.16
              2 deck screws            120




             15 joist hangers           45
              8 16x16 slabs             64
              8 deck blocks             64
                total            $ 759.74



 Kingdon Tim-Br-Mart
                spruce           pt
2x4x8           $         2.67    $ 4.99
2x4x10          $         3.30    $ 6.36
2x4x12          $         4.13    $ 7.63
2x6x8           $         4.30    $ 7.49
2x6x10          $         5.08    $ 9.30
2x6x12          $         6.10    $ 11.16
2x8x8                             $ 10.08

2x8x10            $       7.00   $   12.60
2x8x12            $       8.40   $   15.12
2x10x10           $      10.39   $   16.90
2x10x12           $      12.47   $   20.28
4x4x8                            $   10.08




Rehill Building Supplies
tar paper         $      16.99         430                     0.0395
vapour barrier    $      67.99        1500                     0.0453

sill gasket       $       6.29          80                     0.0786
20 yr shingles    $      16.99
4x8x1/2 drywall   $      11.99

4x8x5/8 drywall   $      13.78
2x4x16 ins        $      33.00          58                     0.5690
2x6x16 ins        $      26.89          49                     0.5488
2x10x24 ins       $      47.75          40                     1.1938



Dufferin Custom Concrete
concrete 5m+     $    185.00                 1mtr=1.308 yrds
concrete 1m      $    400.00                 1 yrd=.765 mtr

thickness         small job     big job
4" sq ft          $       11.22 $ 5.19
6" sq ft          $       17.00 $ 7.86
8" sq ft          $       22.44 $ 10.38
10" sq ft         $       28.32 $ 13.10
Alf Curtis Home Improvements
eavestrough       $     7.00
vented soffit <16 $     4.25
vented soffit <24 $     5.25
facia             $     4.25




Charlotte Paint and Paper
Paint            $      43.95

                $       0.11 sq foot
                                                             Peterborough-
                                                         Demographic and R

TABLE 1 Vacancy Rates & Rents
                               AHP rent
                                (CMHC                     CMHC        CMHC Level
   Unit size     Ave Rent       Level 3)    Vacancy       Level 1         2          Level 1: • Self-contained apartments: maj
     Bachelor      $568           $454        0.07         $635          $595        Level 2: • Self-contained apartments: maj
1 bedroom          $709           $567       2.0%          $795          $759        Level 3: AHP or generally at or below the
2 bedroom          $822           $658       3.1%          $925          $866        * A given rent percentile is the point in the
3 bedroom         $1,000          $800       5.2%          $144         $1,031       which that per cent of rents would fall. For
4 bedroom         $1,178          $942       5.2%                                    surveyed units would have rents that fall b
5 bedroom         $1,356         $1,085      5.2%                                    * Rents for 4 & 5 bedroom units have bee
(Source of Ave Rent: CMHC Market Analysis April-October 2007 : Table 28 Peterborough CMA Rental Apartment and Row Structures)
(Source Level 1 & 2: CMHC Advancing Affordable Houisng Solutions: Affordability Criteria , downloaded November 2007)

TABLE 2 Land Transfer Tax for the Province of Ontario
For Residential Properties
Purchase Price             Applicable Tax
0 to $55,000               .005 x Amount
$55,001 to $250,000        (.01 x Amount) minus $275
$250,001 to $400,000       (.015 x Amount) minus $1,525
Greater than $400,000      (.02 x Amount) minus $3,525

TABLE 3 Environmental Assessments
Phase 1               $2,000 *This table is for estimation purposes only.
Phase 2               $5,000 Estimates are averages from 3 environmental consultant firms in Peterborough

TABLE 4 Legal fees                                      Range         # used in estimates        *These fees are rough estima
legal fees                                              $650-$800              $725
disbursements, registering deed, title search, etc.     $300-$400              $350

TABLE 5 Design & Engineer's Stamp
Size of Devmt                 Qualifications Required
>660square m or 6460sq.ft Structural Engineer
>660square m or 6460sq.ft Professional with structural qualifications & Building Code Insurance Number (BCIN)
* There is only one structural engineer within 50 miles of Peterborough. This firm determines prices based on what the mar
how much exposure/liability a project has and the actual time needed to review the plans (thus an approximate cost cannot
In fact, it may be a challenge to find a structural engineer who will to review smaller developments, especially if it involves re

TABLE 6 Municipal Fees (2007)
                 Site plan
                   *fees
                                                                                    Planning
                 reduced if
                mandated by
                                                                                   area (City-
                rezoning or                            Severance                      Wide
                   minor    Zoning By-                 (creation of    City-wide   Developm      Total
   # of New       variance     Law     Minor              a new        uniform     ent Area) Development
     Units        decision  Amendment Variance         building lot)    charge       charge    Charges
       0            0             0           0              0             0           0          0
       1           $791          $963        $525          $845         $7,856        $865      $8,721
       2           $802          $990        $525          $965        $15,712       $1,730    $17,442
       3           $988         $1,018       $650         $1,085       $20,319       $2,595    $22,914
       4           $999         $1,045       $650         $1,205       $27,092       $3,460    $30,552
       5          $1,010        $1,073       $650         $1,325       $33,865       $4,325    $38,190
       6          $1,021        $1,100       $650         $1,445       $40,638       $5,190    $45,828
       7          $1,032        $1,128       $650         $1,565       $47,411       $6,055    $53,466
       8          $1,043        $1,155       $650         $1,685       $54,184       $6,920    $61,104
Base fee 1-2
units              $780          $885        $525         $725          $7,856        $865
Base fee >2
units              $955          $885        $650                       $6,773        $746
Per unit fee        $11           $28                     $120

TABLE 7 Municipal Taxes City of Peterborough 2007
Type of Property             Tax Rate
Residential                   1.479394%
Multi-Residential             2.748265%                                                        Calculating Lending Value
Commercial                    4.258548%                                                        Assumed cap rate =
Commercial Excess/            2.980984%                                                        Lending Value
                                                                                               Loan to Value Ratio
TABLE 8 CMHC Mortgage Insurance*
Calculating Loan to Value Ratio
"Lending Value" is the Net Operating Income (NOI) divided by the prevailing capitalization rate (these terms are clarified wit
Assumed cap rate =                 8.0%
Lending Value                       -
Loan to Value Ratio           #DIV/0!

                                  Min 5 units       1 to 4 Units 5+ units
Loan-to-Value Ratio        Level 1&2 Level 3                                   * This table is for estimation purposes onl
Up to and incl.    65%         1.20%          0%       1.25%         1.75%     debt coverage ratios, borrower history, etc
Up to and incl.    70%         1.40%          0%       1.25%         2.00%     Should advancing of funds only be require
Up to and incl.    75%         1.50%          0%       1.75%         2.25%
Up to and incl.    80%         2.40%          0%       2.50%         3.50%     AHP Projects (& others at level 3 afforda
Up to and incl.    85%         3.10%          0%       3.50%         4.50%     Other flexibilities include: No surcharge on
Up to and incl.    90%         3.40%          0%       4.75%      Not offered CMHC will consider giving AHP flexibilities
Up to and incl.    95%         3.80%          0%       6.50%      Not offered
                  100%
95.01%to100%(Purchase) Not offered Not offered         7.25%      Not offered Energy Efficiency - possible 10% reduction in
Surcharges:
 Extended Amortization: Add 0.20% for every 5 years of amortization beyond the 25 year mortgage amortization period (*wa

TABLE 9 Appraisals
Current Value of Single Family Dwelling                         $250 *This table is for estimation purposes only.
Prospective Value of Triplex                                    $500 Estimates are averages from 3 appraisors local to Peter
Current Value of Industrial Bldg (size: for 8 Units)          $1,500
Prospective Value of Industrial Bldg->8 Units                 $1,500
Current Value of building for 30 units (ie school)            $2,000
Prospective Value of building for 30 units (ie school)        $3,000

TABLE 10 Expense Benchmarks for Common Expenses*
     Item                     Cost/Unit/Yr # Used in estimates         *Canada Mortgage and Housing Corporation uses these
Insurance                      $100-$150      $300
Heating                        $600-$850      $850
Hydro                          $600-$750      $750
Water & Sewer                  $200-$400      $400
Maintenance & Repair           $500-$800      $650
Wages                          $250-$350      $300
Management Fees               4-6% of Effective Gross Income
Replacement Reserve           4% of Effective Gross Income

TABLE 11 Zoning Regulations in Brief

                                                                                    Max        Max building
               Min lot      Min lot                      Min building Min building building    coverage 2
               area/unit    width/unit   Min lot         set back      setback rear coverage   storey
               (sq. metres) (sq. metres) depth           side lot line lot line     1 storey   building
R1: max 1
unit                    370            12           30           1.2             7.6     45%           40%
R2: max 2
units                   278              9          30           1.2             7.6     45%             40
R3: max 8
units (or a
boarding
house)                  230              6          30           2.4               9     35%           35%
R4: max 16
units, Min 3
units (or                                              3 m or 1.5      9 m or 4.5
                                                       metres/store    metres/storey
boarding                                               y whichever     whichever is
house)                  185            24           30 is greater      greater           30%           30%
borough-Specific
hic and Rate Data


 lf-contained apartments: majority of rents in the project are below the 80th percentile*
 lf-contained apartments: majority of rents in the project are below the 65th percentile*
   or generally at or below the 50th percentile*
 t percentile is the point in the distribution (smallest to largest) of surveyed rents below
er cent of rents would fall. For example, if the 80th percentile rent is $700, then 80% of all
 ts would have rents that fall below $700. CMHC publishes the rent levels annually.
  & 5 bedroom units have been estimated based on smaller units for which market data is available
Apartment and Row Structures)
wnloaded November 2007)




Peterborough

These fees are rough estimates. If more legal issues are more complex, adjust accordingly.




nce Number (BCIN)
 rices based on what the market can bear, as well as
  an approximate cost cannot be estimated).
ents, especially if it involves restoration.
               Building
               Permit
                $9.18 per sq. m
                $0.0929 per sq. ft




Calculating Lending Value
 ssumed cap rate =          8.0%
 ending Value
 oan to Value Ratio       #REF!



 (these terms are clarified within the relevant cells below)




s for estimation purposes only. Credit history, mortgage amortization, mortgage term,
 e ratios, borrower history, etc will affect attainment and cost of mortgage insurance.
ncing of funds only be required upon completion of the project, the CMHC premium will be lower.

 s (& others at level 3 affordability) with a min of 5 units = all premiums waived.
 ties include: No surcharge on amortization>25 years, no surcharge for waiving rental achievement holdback
onsider giving AHP flexibilities to <5 unit developments on a case by case basis.

ency - possible 10% reduction in premium fees and no surcharge on amortization>25 years

gage amortization period (*waived under AHP)
purposes only.
m 3 appraisors local to Peterborough




using Corporation uses these estimates in their underwriting




                                        Max lot
                            Min Floor   coverage
                            area/unit   by parking
             Max # of       (sq.        &
             storeys        metres)     driveways


                        2          70        20%


                        2          70        20%




                        2 N/A                25%




                        3 N/A                25%
                            Percentage Page
Item Name                          percentage labour   Labour Factor
Excavation                                      100%
Foundation, Piers, Flatwork                      64%            2.80
Rough Hardware                                   64%            2.81
Masonry Frame                                    59%            2.44
Insulation                                       40%            1.67
Exterior Finish                                  39%            1.65
Exterior Trim                                    64%            2.81
Doors                                            45%            1.83
Windows                                          40%            1.67
Finish Hardware                                  45%            1.83
Roofing, Flashing, Fascia                        45%            1.83
Finish Carpentry                                 83%            5.96
Interior Wall Finish                             60%            2.52
Painting                                         70%            3.30
Wiring                                           65%            2.86
Lighting Fixtures                                24%            1.31
Flooring                                         58%            2.40
Carpeting                                        26%            1.35
Bath Accessories                                 38%            1.61
Shower & Tub Enclosure                           45%            1.83
Countertops                                      45%            1.83
Cabinets                                         24%            1.31
Built In Appliances                              12%            1.14
Plumbing Rough-in and Connection                 72%            3.54
Plumbing Fixtures                                24%            1.31
Heating and Cooling Systems                      60%            2.50
                                         5 Year Proforma
This section of the tool provides an indication of project operations given the loan amount.

Income Forecast Inflation Rate              3.00% Operating Expenses Inflation Rate                  3.00%

                                    YEAR 1             YEAR 2            YEAR 3            YEAR 4
INCOME
Rental Income                          $0                $0                 $0                  $0
Parking Income                         $0                $0                 $0                  $0
Laundry Income                         $0                $0                 $0                  $0
Vacancy Allowance                      $0                $0                 $0                  $0
Effective Gross Income                 $0                $0                 $0                  $0
OPERATING EXPENSES
Property tax                           $0                 $0                $0                   $0
Heat                                   $0                 $0                $0                   $0
Electricity                            $0                 $0                $0                   $0
Water/sewer                            $0                 $0                $0                   $0
Garbage/snow removal                   $0                 $0                $0                   $0
Insurance                              $0                 $0                $0                   $0
Maintenance/Repairs                    $0                 $0                $0                   $0
Wages                                  $0                 $0                $0                   $0
Management Fees                        $0                 $0                $0                   $0
Miscellaneous (i.e.: ads)              $0                 $0                $0                   $0
Replacement Reserve                    $0                 $0                $0                   $0
Total Operating Expenses               $0                 $0                $0                   $0
Net Operating Income                   $0                 $0                $0                   $0
Annual Debt Service                  #REF!              #REF!             #REF!                #REF!
Available Cash Flow                  -$103              -$106             -$109                -$112
ma

     YEAR 5
              m
       $0
       $0
       $0
       $0
       $0

       $0
       $0
       $0
       $0
       $0
       $0
       $0
       $0
       $0
       $0
       $0
       $0
       $0
     #REF!
     -$115
                                                  Mortgage Calculator
                                                      with Extra Payments
                                                       Enter values                       Instructions
Loan amount                                       $     130,000.00                        Must be between 1 and 30 years.
Annual interest rate                                        7.000%                        If your extra payments vary, enter them in the table below.
Loan period in years                                            25
Start date of loan                                         1/1/2008
Optional extra payments                           $         500.00



Scheduled monthly payment                         $         918.81
Scheduled number of payments                                   300
Actual number of payments                                      132
Total of early payments                           $      66,000.00
Total interest                                    $      56,515.14


                                       Beginning
   No.           Payment Date            Balance Scheduled Payment        Extra Payment       Total Payment             Principal             Interest       Ending Balance

     1                1/1/2008   $   130,000.00   $        918.81     $        500.00     $       1,418.81      $        660.48     $         758.33     $     129,339.52
     2                2/1/2008   $   129,339.52   $        918.81     $        500.00     $       1,418.81      $        664.33     $         754.48     $     128,675.19
     3                3/1/2008   $   128,675.19   $        918.81     $        500.00     $       1,418.81      $        668.21     $         750.61     $     128,006.98
     4                4/1/2008   $   128,006.98   $        918.81     $        500.00     $       1,418.81      $        672.11     $         746.71     $     127,334.87
     5                5/1/2008   $   127,334.87   $        918.81     $        500.00     $       1,418.81      $        676.03     $         742.79     $     126,658.85
     6                6/1/2008   $   126,658.85   $        918.81     $        500.00     $       1,418.81      $        679.97     $         738.84     $     125,978.88
     7                7/1/2008   $   125,978.88   $        918.81     $        500.00     $       1,418.81      $        683.94     $         734.88     $     125,294.94
     8                8/1/2008   $   125,294.94   $        918.81     $        500.00     $       1,418.81      $        687.93     $         730.89     $     124,607.02
     9                9/1/2008   $   124,607.02   $        918.81     $        500.00     $       1,418.81      $        691.94     $         726.87     $     123,915.08
    10               10/1/2008   $   123,915.08   $        918.81     $        500.00     $       1,418.81      $        695.98     $         722.84     $     123,219.10
    11               11/1/2008   $   123,219.10   $        918.81     $        500.00     $       1,418.81      $        700.03     $         718.78     $     122,519.07
    12               12/1/2008   $   122,519.07   $        918.81     $        500.00     $       1,418.81      $        704.12     $         714.69     $     121,814.95
    13                1/1/2009   $   121,814.95   $        918.81     $        500.00     $       1,418.81      $        708.23     $         710.59     $     121,106.72
    14                2/1/2009   $   121,106.72   $        918.81     $        500.00     $       1,418.81      $        712.36     $         706.46     $     120,394.37
    15                3/1/2009   $   120,394.37   $        918.81     $        500.00     $       1,418.81      $        716.51     $         702.30     $     119,677.85
    16                4/1/2009   $   119,677.85   $        918.81     $        500.00     $       1,418.81      $        720.69     $         698.12     $     118,957.16
    17                5/1/2009   $   118,957.16   $        918.81     $        500.00     $       1,418.81      $        724.90     $         693.92     $     118,232.27
    18                6/1/2009   $   118,232.27   $        918.81     $        500.00     $       1,418.81      $        729.12     $         689.69     $     117,503.14
    19                7/1/2009   $   117,503.14   $        918.81     $        500.00     $       1,418.81      $        733.38     $         685.43     $     116,769.76
    20                8/1/2009   $   116,769.76   $        918.81     $        500.00     $       1,418.81      $        737.66     $         681.16     $     116,032.11
    21                9/1/2009   $   116,032.11   $        918.81     $        500.00     $       1,418.81      $        741.96     $         676.85     $     115,290.15
    22               10/1/2009   $   115,290.15   $        918.81     $        500.00     $       1,418.81      $        746.29     $         672.53     $     114,543.86
    23               11/1/2009   $   114,543.86   $        918.81     $        500.00     $       1,418.81      $        750.64     $         668.17     $     113,793.22
    24               12/1/2009   $   113,793.22   $        918.81     $        500.00     $       1,418.81      $        755.02     $         663.79     $     113,038.20
    25                1/1/2010   $   113,038.20   $        918.81     $        500.00     $       1,418.81      $        759.42     $         659.39     $     112,278.78
    26                2/1/2010   $   112,278.78   $        918.81     $        500.00     $       1,418.81      $        763.85     $         654.96     $     111,514.93
    27                3/1/2010   $   111,514.93   $        918.81     $        500.00     $       1,418.81      $        768.31     $         650.50     $     110,746.62
    28                4/1/2010   $   110,746.62   $        918.81     $        500.00     $       1,418.81      $        772.79     $         646.02     $     109,973.82
    29                5/1/2010   $   109,973.82   $        918.81     $        500.00     $       1,418.81      $        777.30     $         641.51     $     109,196.53
    30                6/1/2010   $   109,196.53   $        918.81     $        500.00     $       1,418.81      $        781.83     $         636.98     $     108,414.69
    31                7/1/2010   $   108,414.69   $        918.81     $        500.00     $       1,418.81      $        786.39     $         632.42     $     107,628.30
    32                8/1/2010   $   107,628.30   $        918.81     $        500.00     $       1,418.81      $        790.98     $         627.83     $     106,837.32
    33                9/1/2010   $   106,837.32   $        918.81     $        500.00     $       1,418.81      $        795.60     $         623.22     $     106,041.72
    34               10/1/2010   $   106,041.72   $        918.81     $        500.00     $       1,418.81      $        800.24     $         618.58     $     105,241.49
    35               11/1/2010   $   105,241.49   $        918.81     $        500.00     $       1,418.81      $        804.90     $         613.91     $     104,436.58
    36               12/1/2010   $   104,436.58   $        918.81     $        500.00     $       1,418.81      $        809.60     $         609.21     $     103,626.98
    37                1/1/2011   $   103,626.98   $        918.81     $        500.00     $       1,418.81      $        814.32     $         604.49     $     102,812.66
    38                2/1/2011   $   102,812.66   $        918.81     $        500.00     $       1,418.81      $        819.07     $         599.74     $     101,993.59
    39                3/1/2011   $   101,993.59   $        918.81     $        500.00     $       1,418.81      $        823.85     $         594.96     $     101,169.74
    40                4/1/2011   $   101,169.74   $        918.81     $        500.00     $       1,418.81      $        828.66     $         590.16     $     100,341.08
    41                5/1/2011   $   100,341.08   $        918.81     $        500.00     $       1,418.81      $        833.49     $         585.32     $      99,507.59
    42                6/1/2011   $    99,507.59   $        918.81     $        500.00     $       1,418.81      $        838.35     $         580.46     $      98,669.24
                           Beginning
No.   Payment Date           Balance Scheduled Payment       Extra Payment       Total Payment        Principal        Interest       Ending Balance
 43      7/1/2011    $    98,669.24   $        918.81    $        500.00     $      1,418.81     $     843.24     $   575.57      $      97,826.00
 44      8/1/2011    $    97,826.00   $        918.81    $        500.00     $      1,418.81     $     848.16     $   570.65      $      96,977.84
 45      9/1/2011    $    96,977.84   $        918.81    $        500.00     $      1,418.81     $     853.11     $   565.70      $      96,124.73
 46     10/1/2011    $    96,124.73   $        918.81    $        500.00     $      1,418.81     $     858.09     $   560.73      $      95,266.64
 47     11/1/2011    $    95,266.64   $        918.81    $        500.00     $      1,418.81     $     863.09     $   555.72      $      94,403.55
 48     12/1/2011    $    94,403.55   $        918.81    $        500.00     $      1,418.81     $     868.13     $   550.69      $      93,535.42
 49      1/1/2012    $    93,535.42   $        918.81    $        500.00     $      1,418.81     $     873.19     $   545.62      $      92,662.23
 50      2/1/2012    $    92,662.23   $        918.81    $        500.00     $      1,418.81     $     878.28     $   540.53      $      91,783.95
 51      3/1/2012    $    91,783.95   $        918.81    $        500.00     $      1,418.81     $     883.41     $   535.41      $      90,900.55
 52      4/1/2012    $    90,900.55   $        918.81    $        500.00     $      1,418.81     $     888.56     $   530.25      $      90,011.99
 53      5/1/2012    $    90,011.99   $        918.81    $        500.00     $      1,418.81     $     893.74     $   525.07      $      89,118.24
 54      6/1/2012    $    89,118.24   $        918.81    $        500.00     $      1,418.81     $     898.96     $   519.86      $      88,219.29
 55      7/1/2012    $    88,219.29   $        918.81    $        500.00     $      1,418.81     $     904.20     $   514.61      $      87,315.09
 56      8/1/2012    $    87,315.09   $        918.81    $        500.00     $      1,418.81     $     909.47     $   509.34      $      86,405.61
 57      9/1/2012    $    86,405.61   $        918.81    $        500.00     $      1,418.81     $     914.78     $   504.03      $      85,490.83
 58     10/1/2012    $    85,490.83   $        918.81    $        500.00     $      1,418.81     $     920.12     $   498.70      $      84,570.71
 59     11/1/2012    $    84,570.71   $        918.81    $        500.00     $      1,418.81     $     925.48     $   493.33      $      83,645.23
 60     12/1/2012    $    83,645.23   $        918.81    $        500.00     $      1,418.81     $     930.88     $   487.93      $      82,714.35
 61     1/1/2013     $   82,714.35    $       918.81     $       500.00      $     1,418.81      $     936.31     $   482.50      $     81,778.03
 62     2/1/2013     $   81,778.03    $       918.81     $       500.00      $     1,418.81      $     941.77     $   477.04      $     80,836.26
 63     3/1/2013     $   80,836.26    $       918.81     $       500.00      $     1,418.81      $     947.27     $   471.54      $     79,888.99
 64     4/1/2013     $   79,888.99    $       918.81     $       500.00      $     1,418.81      $     952.79     $   466.02      $     78,936.20
 65     5/1/2013     $   78,936.20    $       918.81     $       500.00      $     1,418.81      $     958.35     $   460.46      $     77,977.85
 66     6/1/2013     $   77,977.85    $       918.81     $       500.00      $     1,418.81      $     963.94     $   454.87      $     77,013.90
 67     7/1/2013     $   77,013.90    $       918.81     $       500.00      $     1,418.81      $     969.57     $   449.25      $     76,044.34
 68     8/1/2013     $   76,044.34    $       918.81     $       500.00      $     1,418.81      $     975.22     $   443.59      $     75,069.12
 69     9/1/2013     $   75,069.12    $       918.81     $       500.00      $     1,418.81      $     980.91     $   437.90      $     74,088.21
 70    10/1/2013     $   74,088.21    $       918.81     $       500.00      $     1,418.81      $     986.63     $   432.18      $     73,101.58
 71    11/1/2013     $   73,101.58    $       918.81     $       500.00      $     1,418.81      $     992.39     $   426.43      $     72,109.19
 72    12/1/2013     $   72,109.19    $       918.81     $       500.00      $     1,418.81      $     998.18     $   420.64      $     71,111.01
 73     1/1/2014     $   71,111.01    $       918.81     $       500.00      $     1,418.81      $   1,004.00     $   414.81      $     70,107.01
 74     2/1/2014     $   70,107.01    $       918.81     $       500.00      $     1,418.81      $   1,009.86     $   408.96      $     69,097.16
 75     3/1/2014     $   69,097.16    $       918.81     $       500.00      $     1,418.81      $   1,015.75     $   403.07      $     68,081.41
 76     4/1/2014     $   68,081.41    $       918.81     $       500.00      $     1,418.81      $   1,021.67     $   397.14      $     67,059.74
 77     5/1/2014     $   67,059.74    $       918.81     $       500.00      $     1,418.81      $   1,027.63     $   391.18      $     66,032.11
 78     6/1/2014     $   66,032.11    $       918.81     $       500.00      $     1,418.81      $   1,033.63     $   385.19      $     64,998.49
 79     7/1/2014     $   64,998.49    $       918.81     $       500.00      $     1,418.81      $   1,039.66     $   379.16      $     63,958.83
 80     8/1/2014     $   63,958.83    $       918.81     $       500.00      $     1,418.81      $   1,045.72     $   373.09      $     62,913.11
 81     9/1/2014     $   62,913.11    $       918.81     $       500.00      $     1,418.81      $   1,051.82     $   366.99      $     61,861.29
 82    10/1/2014     $   61,861.29    $       918.81     $       500.00      $     1,418.81      $   1,057.96     $   360.86      $     60,803.34
 83    11/1/2014     $   60,803.34    $       918.81     $       500.00      $     1,418.81      $   1,064.13     $   354.69      $     59,739.21
 84    12/1/2014     $   59,739.21    $       918.81     $       500.00      $     1,418.81      $   1,070.33     $   348.48      $     58,668.87
 85     1/1/2015     $   58,668.87    $       918.81     $       500.00      $     1,418.81      $   1,076.58     $   342.24      $     57,592.30
 86     2/1/2015     $   57,592.30    $       918.81     $       500.00      $     1,418.81      $   1,082.86     $   335.96      $     56,509.44
 87     3/1/2015     $   56,509.44    $       918.81     $       500.00      $     1,418.81      $   1,089.17     $   329.64      $     55,420.26
 88     4/1/2015     $   55,420.26    $       918.81     $       500.00      $     1,418.81      $   1,095.53     $   323.28      $     54,324.74
 89     5/1/2015     $   54,324.74    $       918.81     $       500.00      $     1,418.81      $   1,101.92     $   316.89      $     53,222.82
 90     6/1/2015     $   53,222.82    $       918.81     $       500.00      $     1,418.81      $   1,108.35     $   310.47      $     52,114.47
 91     7/1/2015     $   52,114.47    $       918.81     $       500.00      $     1,418.81      $   1,114.81     $   304.00      $     50,999.66
 92     8/1/2015     $   50,999.66    $       918.81     $       500.00      $     1,418.81      $   1,121.31     $   297.50      $     49,878.34
 93     9/1/2015     $   49,878.34    $       918.81     $       500.00      $     1,418.81      $   1,127.86     $   290.96      $     48,750.49
 94    10/1/2015     $   48,750.49    $       918.81     $       500.00      $     1,418.81      $   1,134.44     $   284.38      $     47,616.05
 95    11/1/2015     $   47,616.05    $       918.81     $       500.00      $     1,418.81      $   1,141.05     $   277.76      $     46,475.00
 96    12/1/2015     $   46,475.00    $       918.81     $       500.00      $     1,418.81      $   1,147.71     $   271.10      $     45,327.29
 97     1/1/2016     $   45,327.29    $       918.81     $       500.00      $     1,418.81      $   1,154.40     $   264.41      $     44,172.89
 98     2/1/2016     $   44,172.89    $       918.81     $       500.00      $     1,418.81      $   1,161.14     $   257.68      $     43,011.75
 99     3/1/2016     $   43,011.75    $       918.81     $       500.00      $     1,418.81      $   1,167.91     $   250.90      $     41,843.84
100     4/1/2016     $   41,843.84    $       918.81     $       500.00      $     1,418.81      $   1,174.72     $   244.09      $     40,669.11
101     5/1/2016     $   40,669.11    $       918.81     $       500.00      $     1,418.81      $   1,181.58     $   237.24      $     39,487.54
102     6/1/2016     $   39,487.54    $       918.81     $       500.00      $     1,418.81      $   1,188.47     $   230.34      $     38,299.07
103     7/1/2016     $   38,299.07    $       918.81     $       500.00      $     1,418.81      $   1,195.40     $   223.41      $     37,103.67
104     8/1/2016     $   37,103.67    $       918.81     $       500.00      $     1,418.81      $   1,202.37     $   216.44      $     35,901.29
105     9/1/2016     $   35,901.29    $       918.81     $       500.00      $     1,418.81      $   1,209.39     $   209.42      $     34,691.90
106    10/1/2016     $   34,691.90    $       918.81     $       500.00      $     1,418.81      $   1,216.44     $   202.37      $     33,475.46
107    11/1/2016     $   33,475.46    $       918.81     $       500.00      $     1,418.81      $   1,223.54     $   195.27      $     32,251.92
                           Beginning
No.   Payment Date           Balance Scheduled Payment       Extra Payment       Total Payment        Principal         Interest       Ending Balance
108    12/1/2016     $    32,251.92    $      918.81     $       500.00      $     1,418.81      $   1,230.68     $    188.14      $     31,021.24
109     1/1/2017     $    31,021.24    $      918.81     $       500.00      $     1,418.81      $   1,237.86     $    180.96      $     29,783.39
110     2/1/2017     $    29,783.39    $      918.81     $       500.00      $     1,418.81      $   1,245.08     $    173.74      $     28,538.31
111     3/1/2017     $    28,538.31    $      918.81     $       500.00      $     1,418.81      $   1,252.34     $    166.47      $     27,285.97
112     4/1/2017     $    27,285.97    $      918.81     $       500.00      $     1,418.81      $   1,259.64     $    159.17      $     26,026.33
113     5/1/2017     $    26,026.33    $      918.81     $       500.00      $     1,418.81      $   1,266.99     $    151.82      $     24,759.33
114     6/1/2017     $    24,759.33    $      918.81     $       500.00      $     1,418.81      $   1,274.38     $    144.43      $     23,484.95
115     7/1/2017     $    23,484.95    $      918.81     $       500.00      $     1,418.81      $   1,281.82     $    137.00      $     22,203.13
116     8/1/2017     $    22,203.13    $      918.81     $       500.00      $     1,418.81      $   1,289.29     $    129.52      $     20,913.84
117     9/1/2017     $    20,913.84    $      918.81     $       500.00      $     1,418.81      $   1,296.82     $    122.00      $     19,617.02
118    10/1/2017     $    19,617.02    $      918.81     $       500.00      $     1,418.81      $   1,304.38     $    114.43      $     18,312.64
119    11/1/2017     $    18,312.64    $      918.81     $       500.00      $     1,418.81      $   1,311.99     $    106.82      $     17,000.65
120    12/1/2017     $    17,000.65    $      918.81     $       500.00      $     1,418.81      $   1,319.64     $     99.17      $     15,681.01
121     1/1/2018     $    15,681.01    $      918.81     $       500.00      $     1,418.81      $   1,327.34     $     91.47      $     14,353.67
122     2/1/2018     $    14,353.67    $      918.81     $       500.00      $     1,418.81      $   1,335.08     $     83.73      $     13,018.59
123     3/1/2018     $    13,018.59    $      918.81     $       500.00      $     1,418.81      $   1,342.87     $     75.94      $     11,675.72
124     4/1/2018     $    11,675.72    $      918.81     $       500.00      $     1,418.81      $   1,350.70     $     68.11      $     10,325.01
125     5/1/2018     $    10,325.01    $      918.81     $       500.00      $     1,418.81      $   1,358.58     $     60.23      $      8,966.43
126     6/1/2018     $     8,966.43    $      918.81     $       500.00      $     1,418.81      $   1,366.51     $     52.30      $      7,599.92
127     7/1/2018     $     7,599.92    $      918.81     $       500.00      $     1,418.81      $   1,374.48     $     44.33      $      6,225.44
128     8/1/2018     $     6,225.44    $      918.81     $       500.00      $     1,418.81      $   1,382.50     $     36.32      $      4,842.94
129     9/1/2018     $     4,842.94    $      918.81     $       500.00      $     1,418.81      $   1,390.56     $     28.25      $      3,452.38
130    10/1/2018     $     3,452.38    $      918.81     $       500.00      $     1,418.81      $   1,398.67     $     20.14      $      2,053.71
131    11/1/2018     $     2,053.71    $      918.81     $       500.00      $     1,418.81      $   1,406.83     $     11.98      $        646.87
132    12/1/2018     $       646.87    $      918.81     $       500.00      $     1,418.81      $   1,415.04     $      3.77      $       (768.17)
133     1/1/2019     $      (768.17)   $      918.81     $       500.00      $     1,418.81      $   1,423.29     $     (4.48)     $     (2,191.46)
134     2/1/2019     $    (2,191.46)   $      918.81     $       500.00      $     1,418.81      $   1,431.60     $    (12.78)     $     (3,623.06)
135     3/1/2019     $    (3,623.06)   $      918.81     $       500.00      $     1,418.81      $   1,439.95     $    (21.13)     $     (5,063.01)
136     4/1/2019     $    (5,063.01)   $      918.81     $       500.00      $     1,418.81      $   1,448.35     $    (29.53)     $     (6,511.35)
137     5/1/2019     $    (6,511.35)   $      918.81     $       500.00      $     1,418.81      $   1,456.80     $    (37.98)     $     (7,968.15)
138     6/1/2019     $    (7,968.15)   $      918.81     $       500.00      $     1,418.81      $   1,465.29     $    (46.48)     $     (9,433.44)
139     7/1/2019     $    (9,433.44)   $      918.81     $       500.00      $     1,418.81      $   1,473.84     $    (55.03)     $    (10,907.28)
140     8/1/2019     $   (10,907.28)   $      918.81     $       500.00      $     1,418.81      $   1,482.44     $    (63.63)     $    (12,389.72)
141     9/1/2019     $   (12,389.72)   $      918.81     $       500.00      $     1,418.81      $   1,491.09     $    (72.27)     $    (13,880.81)
142    10/1/2019     $   (13,880.81)   $      918.81     $       500.00      $     1,418.81      $   1,499.78     $    (80.97)     $    (15,380.59)
143    11/1/2019     $   (15,380.59)   $      918.81     $       500.00      $     1,418.81      $   1,508.53     $    (89.72)     $    (16,889.13)
144    12/1/2019     $   (16,889.13)   $      918.81     $       500.00      $     1,418.81      $   1,517.33     $    (98.52)     $    (18,406.46)
145     1/1/2020     $   (18,406.46)   $      918.81     $       500.00      $     1,418.81      $   1,526.18     $   (107.37)     $    (19,932.64)
146     2/1/2020     $   (19,932.64)   $      918.81     $       500.00      $     1,418.81      $   1,535.09     $   (116.27)     $    (21,467.73)
147     3/1/2020     $   (21,467.73)   $      918.81     $       500.00      $     1,418.81      $   1,544.04     $   (125.23)     $    (23,011.77)
148     4/1/2020     $   (23,011.77)   $      918.81     $       500.00      $     1,418.81      $   1,553.05     $   (134.24)     $    (24,564.82)
149     5/1/2020     $   (24,564.82)   $      918.81     $       500.00      $     1,418.81      $   1,562.11     $   (143.29)     $    (26,126.93)
150     6/1/2020     $   (26,126.93)   $      918.81     $       500.00      $     1,418.81      $   1,571.22     $   (152.41)     $    (27,698.15)
151     7/1/2020     $   (27,698.15)   $      918.81     $       500.00      $     1,418.81      $   1,580.39     $   (161.57)     $    (29,278.53)
152     8/1/2020     $   (29,278.53)   $      918.81     $       500.00      $     1,418.81      $   1,589.60     $   (170.79)     $    (30,868.14)
153     9/1/2020     $   (30,868.14)   $      918.81     $       500.00      $     1,418.81      $   1,598.88     $   (180.06)     $    (32,467.01)
154    10/1/2020     $   (32,467.01)   $      918.81     $       500.00      $     1,418.81      $   1,608.20     $   (189.39)     $    (34,075.22)
155    11/1/2020     $   (34,075.22)   $      918.81     $       500.00      $     1,418.81      $   1,617.59     $   (198.77)     $    (35,692.80)
156    12/1/2020     $   (35,692.80)   $      918.81     $       500.00      $     1,418.81      $   1,627.02     $   (208.21)     $    (37,319.82)
157     1/1/2021     $   (37,319.82)   $      918.81     $       500.00      $     1,418.81      $   1,636.51     $   (217.70)     $    (38,956.34)
158     2/1/2021     $   (38,956.34)   $      918.81     $       500.00      $     1,418.81      $   1,646.06     $   (227.25)     $    (40,602.39)
159     3/1/2021     $   (40,602.39)   $      918.81     $       500.00      $     1,418.81      $   1,655.66     $   (236.85)     $    (42,258.05)
160     4/1/2021     $   (42,258.05)   $      918.81     $       500.00      $     1,418.81      $   1,665.32     $   (246.51)     $    (43,923.37)
161     5/1/2021     $   (43,923.37)   $      918.81     $       500.00      $     1,418.81      $   1,675.03     $   (256.22)     $    (45,598.41)
162     6/1/2021     $   (45,598.41)   $      918.81     $       500.00      $     1,418.81      $   1,684.80     $   (265.99)     $    (47,283.21)
163     7/1/2021     $   (47,283.21)   $      918.81     $       500.00      $     1,418.81      $   1,694.63     $   (275.82)     $    (48,977.84)
164     8/1/2021     $   (48,977.84)   $      918.81     $       500.00      $     1,418.81      $   1,704.52     $   (285.70)     $    (50,682.36)
165     9/1/2021     $   (50,682.36)   $      918.81     $       500.00      $     1,418.81      $   1,714.46     $   (295.65)     $    (52,396.82)
166    10/1/2021     $   (52,396.82)   $      918.81     $       500.00      $     1,418.81      $   1,724.46     $   (305.65)     $    (54,121.28)
167    11/1/2021     $   (54,121.28)   $      918.81     $       500.00      $     1,418.81      $   1,734.52     $   (315.71)     $    (55,855.80)
168    12/1/2021     $   (55,855.80)   $      918.81     $       500.00      $     1,418.81      $   1,744.64     $   (325.83)     $    (57,600.44)
169     1/1/2022     $   (57,600.44)   $      918.81     $       500.00      $     1,418.81      $   1,754.82     $   (336.00)     $    (59,355.25)
170     2/1/2022     $   (59,355.25)   $      918.81     $       500.00      $     1,418.81      $   1,765.05     $   (346.24)     $    (61,120.30)
171     3/1/2022     $   (61,120.30)   $      918.81     $       500.00      $     1,418.81      $   1,775.35     $   (356.54)     $    (62,895.65)
172     4/1/2022     $   (62,895.65)   $      918.81     $       500.00      $     1,418.81      $   1,785.70     $   (366.89)     $    (64,681.36)
                          Beginning
No.   Payment Date          Balance Scheduled Payment       Extra Payment       Total Payment        Principal          Interest       Ending Balance
173     5/1/2022     $ (64,681.36)    $      918.81     $       500.00      $     1,418.81      $   1,796.12     $     (377.31)    $    (66,477.48)
174     6/1/2022     $ (66,477.48)    $      918.81     $       500.00      $     1,418.81      $   1,806.60     $     (387.79)    $    (68,284.08)
175     7/1/2022     $ (68,284.08)    $      918.81     $       500.00      $     1,418.81      $   1,817.14     $     (398.32)    $    (70,101.21)
176     8/1/2022     $ (70,101.21)    $      918.81     $       500.00      $     1,418.81      $   1,827.74     $     (408.92)    $    (71,928.95)
177     9/1/2022     $ (71,928.95)    $      918.81     $       500.00      $     1,418.81      $   1,838.40     $     (419.59)    $    (73,767.35)
178    10/1/2022     $ (73,767.35)    $      918.81     $       500.00      $     1,418.81      $   1,849.12     $     (430.31)    $    (75,616.47)
179    11/1/2022     $ (75,616.47)    $      918.81     $       500.00      $     1,418.81      $   1,859.91     $     (441.10)    $    (77,476.38)
180    12/1/2022     $ (77,476.38)    $      918.81     $       500.00      $     1,418.81      $   1,870.76     $     (451.95)    $    (79,347.14)
181     1/1/2023     $ (79,347.14)    $      918.81     $       500.00      $     1,418.81      $   1,881.67     $     (462.86)    $    (81,228.81)
182     2/1/2023     $ (81,228.81)    $      918.81     $       500.00      $     1,418.81      $   1,892.65     $     (473.83)    $    (83,121.46)
183     3/1/2023     $ (83,121.46)    $      918.81     $       500.00      $     1,418.81      $   1,903.69     $     (484.88)    $    (85,025.15)
184     4/1/2023     $ (85,025.15)    $      918.81     $       500.00      $     1,418.81      $   1,914.79     $     (495.98)    $    (86,939.94)
185     5/1/2023     $ (86,939.94)    $      918.81     $       500.00      $     1,418.81      $   1,925.96     $     (507.15)    $    (88,865.90)
186     6/1/2023     $ (88,865.90)    $      918.81     $       500.00      $     1,418.81      $   1,937.20     $     (518.38)    $    (90,803.10)
187     7/1/2023     $ (90,803.10)    $      918.81     $       500.00      $     1,418.81      $   1,948.50     $     (529.68)    $    (92,751.60)
188     8/1/2023     $ (92,751.60)    $      918.81     $       500.00      $     1,418.81      $   1,959.86     $     (541.05)    $    (94,711.46)
189     9/1/2023     $ (94,711.46)    $      918.81     $       500.00      $     1,418.81      $   1,971.30     $     (552.48)    $    (96,682.76)
190    10/1/2023     $ (96,682.76)    $      918.81     $       500.00      $     1,418.81      $   1,982.80     $     (563.98)    $    (98,665.55)
191    11/1/2023     $ (98,665.55)    $      918.81     $       500.00      $     1,418.81      $   1,994.36     $     (575.55)    $   (100,659.91)
192    12/1/2023     $ (100,659.91)   $      918.81     $       500.00      $     1,418.81      $   2,006.00     $     (587.18)    $   (102,665.91)
193     1/1/2024     $ (102,665.91)   $      918.81     $       500.00      $     1,418.81      $   2,017.70     $     (598.88)    $   (104,683.61)
194     2/1/2024     $ (104,683.61)   $      918.81     $       500.00      $     1,418.81      $   2,029.47     $     (610.65)    $   (106,713.07)
195     3/1/2024     $ (106,713.07)   $      918.81     $       500.00      $     1,418.81      $   2,041.31     $     (622.49)    $   (108,754.38)
196     4/1/2024     $ (108,754.38)   $      918.81     $       500.00      $     1,418.81      $   2,053.21     $     (634.40)    $   (110,807.59)
197     5/1/2024     $ (110,807.59)   $      918.81     $       500.00      $     1,418.81      $   2,065.19     $     (646.38)    $   (112,872.78)
198     6/1/2024     $ (112,872.78)   $      918.81     $       500.00      $     1,418.81      $   2,077.24     $     (658.42)    $   (114,950.02)
199     7/1/2024     $ (114,950.02)   $      918.81     $       500.00      $     1,418.81      $   2,089.35     $     (670.54)    $   (117,039.38)
200     8/1/2024     $ (117,039.38)   $      918.81     $       500.00      $     1,418.81      $   2,101.54     $     (682.73)    $   (119,140.92)
201     9/1/2024     $ (119,140.92)   $      918.81     $       500.00      $     1,418.81      $   2,113.80     $     (694.99)    $   (121,254.72)
202    10/1/2024     $ (121,254.72)   $      918.81     $       500.00      $     1,418.81      $   2,126.13     $     (707.32)    $   (123,380.85)
203    11/1/2024     $ (123,380.85)   $      918.81     $       500.00      $     1,418.81      $   2,138.53     $     (719.72)    $   (125,519.39)
204    12/1/2024     $ (125,519.39)   $      918.81     $       500.00      $     1,418.81      $   2,151.01     $     (732.20)    $   (127,670.40)
205     1/1/2025     $ (127,670.40)   $      918.81     $       500.00      $     1,418.81      $   2,163.56     $     (744.74)    $   (129,833.95)
206     2/1/2025     $ (129,833.95)   $      918.81     $       500.00      $     1,418.81      $   2,176.18     $     (757.36)    $   (132,010.13)
207     3/1/2025     $ (132,010.13)   $      918.81     $       500.00      $     1,418.81      $   2,188.87     $     (770.06)    $   (134,199.00)
208     4/1/2025     $ (134,199.00)   $      918.81     $       500.00      $     1,418.81      $   2,201.64     $     (782.83)    $   (136,400.64)
209     5/1/2025     $ (136,400.64)   $      918.81     $       500.00      $     1,418.81      $   2,214.48     $     (795.67)    $   (138,615.13)
210     6/1/2025     $ (138,615.13)   $      918.81     $       500.00      $     1,418.81      $   2,227.40     $     (808.59)    $   (140,842.53)
211     7/1/2025     $ (140,842.53)   $      918.81     $       500.00      $     1,418.81      $   2,240.39     $     (821.58)    $   (143,082.92)
212     8/1/2025     $ (143,082.92)   $      918.81     $       500.00      $     1,418.81      $   2,253.46     $     (834.65)    $   (145,336.39)
213     9/1/2025     $ (145,336.39)   $      918.81     $       500.00      $     1,418.81      $   2,266.61     $     (847.80)    $   (147,603.00)
214    10/1/2025     $ (147,603.00)   $      918.81     $       500.00      $     1,418.81      $   2,279.83     $     (861.02)    $   (149,882.83)
215    11/1/2025     $ (149,882.83)   $      918.81     $       500.00      $     1,418.81      $   2,293.13     $     (874.32)    $   (152,175.96)
216    12/1/2025     $ (152,175.96)   $      918.81     $       500.00      $     1,418.81      $   2,306.51     $     (887.69)    $   (154,482.46)
217     1/1/2026     $ (154,482.46)   $      918.81     $       500.00      $     1,418.81      $   2,319.96     $     (901.15)    $   (156,802.42)
218     2/1/2026     $ (156,802.42)   $      918.81     $       500.00      $     1,418.81      $   2,333.49     $     (914.68)    $   (159,135.92)
219     3/1/2026     $ (159,135.92)   $      918.81     $       500.00      $     1,418.81      $   2,347.11     $     (928.29)    $   (161,483.02)
220     4/1/2026     $ (161,483.02)   $      918.81     $       500.00      $     1,418.81      $   2,360.80     $     (941.98)    $   (163,843.82)
221     5/1/2026     $ (163,843.82)   $      918.81     $       500.00      $     1,418.81      $   2,374.57     $     (955.76)    $   (166,218.39)
222     6/1/2026     $ (166,218.39)   $      918.81     $       500.00      $     1,418.81      $   2,388.42     $     (969.61)    $   (168,606.81)
223     7/1/2026     $ (168,606.81)   $      918.81     $       500.00      $     1,418.81      $   2,402.35     $     (983.54)    $   (171,009.16)
224     8/1/2026     $ (171,009.16)   $      918.81     $       500.00      $     1,418.81      $   2,416.37     $     (997.55)    $   (173,425.53)
225     9/1/2026     $ (173,425.53)   $      918.81     $       500.00      $     1,418.81      $   2,430.46     $   (1,011.65)    $   (175,855.99)
226    10/1/2026     $ (175,855.99)   $      918.81     $       500.00      $     1,418.81      $   2,444.64     $   (1,025.83)    $   (178,300.63)
227    11/1/2026     $ (178,300.63)   $      918.81     $       500.00      $     1,418.81      $   2,458.90     $   (1,040.09)    $   (180,759.53)
228    12/1/2026     $ (180,759.53)   $      918.81     $       500.00      $     1,418.81      $   2,473.24     $   (1,054.43)    $   (183,232.77)
229     1/1/2027     $ (183,232.77)   $      918.81     $       500.00      $     1,418.81      $   2,487.67     $   (1,068.86)    $   (185,720.44)
230     2/1/2027     $ (185,720.44)   $      918.81     $       500.00      $     1,418.81      $   2,502.18     $   (1,083.37)    $   (188,222.62)
231     3/1/2027     $ (188,222.62)   $      918.81     $       500.00      $     1,418.81      $   2,516.78     $   (1,097.97)    $   (190,739.40)
232     4/1/2027     $ (190,739.40)   $      918.81     $       500.00      $     1,418.81      $   2,531.46     $   (1,112.65)    $   (193,270.86)
233     5/1/2027       (193,270.86)          918.81             500.00            1,418.81          2,546.23         (1,127.41)        (195,817.09)
234     6/1/2027       (195,817.09)          918.81             500.00            1,418.81          2,561.08         (1,142.27)        (198,378.17)
235     7/1/2027       (198,378.17)          918.81             500.00            1,418.81          2,576.02         (1,157.21)        (200,954.19)
236     8/1/2027       (200,954.19)          918.81             500.00            1,418.81          2,591.05         (1,172.23)        (203,545.23)
237     9/1/2027       (203,545.23)          918.81             500.00            1,418.81          2,606.16         (1,187.35)        (206,151.39)
                        Beginning
No.   Payment Date        Balance Scheduled Payment   Extra Payment   Total Payment    Principal      Interest   Ending Balance
238    10/1/2027     (206,151.39)          918.81         500.00        1,418.81      2,621.36     (1,202.55)    (208,772.76)
239    11/1/2027     (208,772.76)          918.81         500.00        1,418.81      2,636.65     (1,217.84)    (211,409.41)
240    12/1/2027     (211,409.41)          918.81         500.00        1,418.81      2,652.03     (1,233.22)    (214,061.44)
241     1/1/2028     (214,061.44)          918.81         500.00        1,418.81      2,667.50     (1,248.69)    (216,728.95)
242     2/1/2028     (216,728.95)          918.81         500.00        1,418.81      2,683.07     (1,264.25)    (219,412.01)
243     3/1/2028     (219,412.01)          918.81         500.00        1,418.81      2,698.72     (1,279.90)    (222,110.73)
244     4/1/2028     (222,110.73)          918.81         500.00        1,418.81      2,714.46     (1,295.65)    (224,825.19)
245     5/1/2028     (224,825.19)          918.81         500.00        1,418.81      2,730.29     (1,311.48)    (227,555.48)
246     6/1/2028     (227,555.48)          918.81         500.00        1,418.81      2,746.22     (1,327.41)    (230,301.70)
247     7/1/2028     (230,301.70)          918.81         500.00        1,418.81      2,762.24     (1,343.43)    (233,063.94)
248     8/1/2028     (233,063.94)          918.81         500.00        1,418.81      2,778.35     (1,359.54)    (235,842.29)
249     9/1/2028     (235,842.29)          918.81         500.00        1,418.81      2,794.56     (1,375.75)    (238,636.85)
250    10/1/2028     (238,636.85)          918.81         500.00        1,418.81      2,810.86     (1,392.05)    (241,447.72)
251    11/1/2028     (241,447.72)          918.81         500.00        1,418.81      2,827.26     (1,408.45)    (244,274.97)
252    12/1/2028     (244,274.97)          918.81         500.00        1,418.81      2,843.75     (1,424.94)    (247,118.72)
253     1/1/2029     (247,118.72)          918.81         500.00        1,418.81      2,860.34     (1,441.53)    (249,979.06)
254     2/1/2029     (249,979.06)          918.81         500.00        1,418.81      2,877.02     (1,458.21)    (252,856.09)
255     3/1/2029     (252,856.09)          918.81         500.00        1,418.81      2,893.81     (1,474.99)    (255,749.89)
256     4/1/2029     (255,749.89)          918.81         500.00        1,418.81      2,910.69     (1,491.87)    (258,660.58)
257     5/1/2029     (258,660.58)          918.81         500.00        1,418.81      2,927.67     (1,508.85)    (261,588.25)
258     6/1/2029     (261,588.25)          918.81         500.00        1,418.81      2,944.74     (1,525.93)    (264,532.99)
259     7/1/2029     (264,532.99)          918.81         500.00        1,418.81      2,961.92     (1,543.11)    (267,494.91)
260     8/1/2029     (267,494.91)          918.81         500.00        1,418.81      2,979.20     (1,560.39)    (270,474.11)
261     9/1/2029     (270,474.11)          918.81         500.00        1,418.81      2,996.58     (1,577.77)    (273,470.69)
262    10/1/2029     (273,470.69)          918.81         500.00        1,418.81      3,014.06     (1,595.25)    (276,484.75)
263    11/1/2029     (276,484.75)          918.81         500.00        1,418.81      3,031.64     (1,612.83)    (279,516.39)
264    12/1/2029     (279,516.39)          918.81         500.00        1,418.81      3,049.33     (1,630.51)    (282,565.72)
265     1/1/2030     (282,565.72)          918.81         500.00        1,418.81      3,067.11     (1,648.30)    (285,632.83)
266     2/1/2030     (285,632.83)          918.81         500.00        1,418.81      3,085.00     (1,666.19)    (288,717.83)
267     3/1/2030     (288,717.83)          918.81         500.00        1,418.81      3,103.00     (1,684.19)    (291,820.83)
268     4/1/2030     (291,820.83)          918.81         500.00        1,418.81      3,121.10     (1,702.29)    (294,941.94)
269     5/1/2030     (294,941.94)          918.81         500.00        1,418.81      3,139.31     (1,720.49)    (298,081.24)
270     6/1/2030     (298,081.24)          918.81         500.00        1,418.81      3,157.62     (1,738.81)    (301,238.86)
271     7/1/2030     (301,238.86)          918.81         500.00        1,418.81      3,176.04     (1,757.23)    (304,414.90)
272     8/1/2030     (304,414.90)          918.81         500.00        1,418.81      3,194.57     (1,775.75)    (307,609.47)
273     9/1/2030     (307,609.47)          918.81         500.00        1,418.81      3,213.20     (1,794.39)    (310,822.67)
274    10/1/2030     (310,822.67)          918.81         500.00        1,418.81      3,231.95     (1,813.13)    (314,054.62)
275    11/1/2030     (314,054.62)          918.81         500.00        1,418.81      3,250.80     (1,831.99)    (317,305.41)
276    12/1/2030     (317,305.41)          918.81         500.00        1,418.81      3,269.76     (1,850.95)    (320,575.18)
277     1/1/2031     (320,575.18)          918.81         500.00        1,418.81      3,288.83     (1,870.02)    (323,864.01)
278     2/1/2031     (323,864.01)          918.81         500.00        1,418.81      3,308.02     (1,889.21)    (327,172.03)
279     3/1/2031     (327,172.03)          918.81         500.00        1,418.81      3,327.32     (1,908.50)    (330,499.35)
280     4/1/2031     (330,499.35)          918.81         500.00        1,418.81      3,346.73     (1,927.91)    (333,846.07)
281     5/1/2031     (333,846.07)          918.81         500.00        1,418.81      3,366.25     (1,947.44)    (337,212.32)
282     6/1/2031     (337,212.32)          918.81         500.00        1,418.81      3,385.88     (1,967.07)    (340,598.21)
283     7/1/2031     (340,598.21)          918.81         500.00        1,418.81      3,405.64     (1,986.82)    (344,003.84)
284     8/1/2031     (344,003.84)          918.81         500.00        1,418.81      3,425.50     (2,006.69)    (347,429.34)
285     9/1/2031     (347,429.34)          918.81         500.00        1,418.81      3,445.48     (2,026.67)    (350,874.83)
286    10/1/2031     (350,874.83)          918.81         500.00        1,418.81      3,465.58     (2,046.77)    (354,340.41)
287    11/1/2031     (354,340.41)          918.81         500.00        1,418.81      3,485.80     (2,066.99)    (357,826.21)
288    12/1/2031     (357,826.21)          918.81         500.00        1,418.81      3,506.13     (2,087.32)    (361,332.34)
289     1/1/2032     (361,332.34)          918.81         500.00        1,418.81      3,526.58     (2,107.77)    (364,858.93)
290     2/1/2032     (364,858.93)          918.81         500.00        1,418.81      3,547.16     (2,128.34)    (368,406.08)
291     3/1/2032     (368,406.08)          918.81         500.00        1,418.81      3,567.85     (2,149.04)    (371,973.93)
292     4/1/2032     (371,973.93)          918.81         500.00        1,418.81      3,588.66     (2,169.85)    (375,562.59)
293     5/1/2032     (375,562.59)          918.81         500.00        1,418.81      3,609.59     (2,190.78)    (379,172.19)
294     6/1/2032     (379,172.19)          918.81         500.00        1,418.81      3,630.65     (2,211.84)    (382,802.84)
295     7/1/2032     (382,802.84)          918.81         500.00        1,418.81      3,651.83     (2,233.02)    (386,454.67)
296     8/1/2032     (386,454.67)          918.81         500.00        1,418.81      3,673.13     (2,254.32)    (390,127.80)
297     9/1/2032     (390,127.80)          918.81         500.00        1,418.81      3,694.56     (2,275.75)    (393,822.36)
298    10/1/2032     (393,822.36)          918.81         500.00        1,418.81      3,716.11     (2,297.30)    (397,538.47)
299    11/1/2032     (397,538.47)          918.81         500.00        1,418.81      3,737.79     (2,318.97)    (401,276.26)
300    12/1/2032     (401,276.26)          918.81         500.00        1,418.81      3,759.59     (2,340.78)    (405,035.85)
301     1/1/2033     (405,035.85)          918.81         500.00        1,418.81      3,781.52     (2,362.71)    (408,817.37)
302     2/1/2033     (408,817.37)          918.81         500.00        1,418.81      3,803.58     (2,384.77)    (412,620.95)
                         Beginning
 No.   Payment Date        Balance Scheduled Payment   Extra Payment   Total Payment    Principal      Interest   Ending Balance
 303     3/1/2033     (412,620.95)          918.81         500.00        1,418.81      3,825.77     (2,406.96)    (416,446.72)
 304     4/1/2033     (416,446.72)          918.81         500.00        1,418.81      3,848.09     (2,429.27)    (420,294.80)
 305     5/1/2033     (420,294.80)          918.81         500.00        1,418.81      3,870.53     (2,451.72)    (424,165.34)
 306     6/1/2033     (424,165.34)          918.81         500.00        1,418.81      3,893.11     (2,474.30)    (428,058.45)
 307     7/1/2033     (428,058.45)          918.81         500.00        1,418.81      3,915.82     (2,497.01)    (431,974.27)
 308     8/1/2033     (431,974.27)          918.81         500.00        1,418.81      3,938.66     (2,519.85)    (435,912.93)
 309     9/1/2033     (435,912.93)          918.81         500.00        1,418.81      3,961.64     (2,542.83)    (439,874.57)
 310    10/1/2033     (439,874.57)          918.81         500.00        1,418.81      3,984.75     (2,565.93)    (443,859.32)
 311    11/1/2033     (443,859.32)          918.81         500.00        1,418.81      4,007.99     (2,589.18)    (447,867.31)
 312    12/1/2033     (447,867.31)          918.81         500.00        1,418.81      4,031.37     (2,612.56)    (451,898.68)
 313     1/1/2034     (451,898.68)          918.81         500.00        1,418.81      4,054.89     (2,636.08)    (455,953.57)
 314     2/1/2034     (455,953.57)          918.81         500.00        1,418.81      4,078.54     (2,659.73)    (460,032.11)
 315     3/1/2034     (460,032.11)          918.81         500.00        1,418.81      4,102.33     (2,683.52)    (464,134.45)
 316     4/1/2034     (464,134.45)          918.81         500.00        1,418.81      4,126.26     (2,707.45)    (468,260.71)
 317     5/1/2034     (468,260.71)          918.81         500.00        1,418.81      4,150.33     (2,731.52)    (472,411.04)
 318     6/1/2034     (472,411.04)          918.81         500.00        1,418.81      4,174.54     (2,755.73)    (476,585.59)
 319     7/1/2034     (476,585.59)          918.81         500.00        1,418.81      4,198.90     (2,780.08)    (480,784.48)
 320     8/1/2034     (480,784.48)          918.81         500.00        1,418.81      4,223.39     (2,804.58)    (485,007.87)
 321     9/1/2034     (485,007.87)          918.81         500.00        1,418.81      4,248.03     (2,829.21)    (489,255.90)
 322    10/1/2034     (489,255.90)          918.81         500.00        1,418.81      4,272.81     (2,853.99)    (493,528.70)
 323    11/1/2034     (493,528.70)          918.81         500.00        1,418.81      4,297.73     (2,878.92)    (497,826.43)
 324    12/1/2034     (497,826.43)          918.81         500.00        1,418.81      4,322.80     (2,903.99)    (502,149.23)
 325     1/1/2035     (502,149.23)          918.81         500.00        1,418.81      4,348.02     (2,929.20)    (506,497.25)
 326     2/1/2035     (506,497.25)          918.81         500.00        1,418.81      4,373.38     (2,954.57)    (510,870.63)
 327     3/1/2035     (510,870.63)          918.81         500.00        1,418.81      4,398.89     (2,980.08)    (515,269.52)
 328     4/1/2035     (515,269.52)          918.81         500.00        1,418.81      4,424.55     (3,005.74)    (519,694.07)
 329     5/1/2035     (519,694.07)          918.81         500.00        1,418.81      4,450.36     (3,031.55)    (524,144.44)
 330     6/1/2035     (524,144.44)          918.81         500.00        1,418.81      4,476.32     (3,057.51)    (528,620.76)
 331     7/1/2035     (528,620.76)          918.81         500.00        1,418.81      4,502.43     (3,083.62)    (533,123.19)
 332     8/1/2035     (533,123.19)          918.81         500.00        1,418.81      4,528.70     (3,109.89)    (537,651.89)
 333     9/1/2035     (537,651.89)          918.81         500.00        1,418.81      4,555.12     (3,136.30)    (542,207.01)
 334    10/1/2035     (542,207.01)          918.81         500.00        1,418.81      4,581.69     (3,162.87)    (546,788.69)
 335    11/1/2035     (546,788.69)          918.81         500.00        1,418.81      4,608.41     (3,189.60)    (551,397.11)
 336    12/1/2035     (551,397.11)          918.81         500.00        1,418.81      4,635.30     (3,216.48)    (556,032.40)
 337     1/1/2036     (556,032.40)          918.81         500.00        1,418.81      4,662.34     (3,243.52)    (560,694.74)
 338     2/1/2036     (560,694.74)          918.81         500.00        1,418.81      4,689.53     (3,270.72)    (565,384.27)
 339     3/1/2036     (565,384.27)          918.81         500.00        1,418.81      4,716.89     (3,298.07)    (570,101.16)
 340     4/1/2036     (570,101.16)          918.81         500.00        1,418.81      4,744.40     (3,325.59)    (574,845.56)
 341     5/1/2036     (574,845.56)          918.81         500.00        1,418.81      4,772.08     (3,353.27)    (579,617.64)
 342     6/1/2036     (579,617.64)          918.81         500.00        1,418.81      4,799.92     (3,381.10)    (584,417.56)
 343     7/1/2036     (584,417.56)          918.81         500.00        1,418.81      4,827.92     (3,409.10)    (589,245.47)
 344     8/1/2036     (589,245.47)          918.81         500.00        1,418.81      4,856.08     (3,437.27)    (594,101.55)
 345     9/1/2036     (594,101.55)          918.81         500.00        1,418.81      4,884.41     (3,465.59)    (598,985.96)
 346    10/1/2036     (598,985.96)          918.81         500.00        1,418.81      4,912.90     (3,494.08)    (603,898.85)
 347    11/1/2036     (603,898.85)          918.81         500.00        1,418.81      4,941.56     (3,522.74)    (608,840.41)
 348    12/1/2036     (608,840.41)          918.81         500.00        1,418.81      4,970.38     (3,551.57)    (613,810.79)
 349     1/1/2037     (613,810.79)          918.81         500.00        1,418.81      4,999.38     (3,580.56)    (618,810.17)
 350     2/1/2037     (618,810.17)          918.81         500.00        1,418.81      5,028.54     (3,609.73)    (623,838.71)
 351     3/1/2037     (623,838.71)          918.81         500.00        1,418.81      5,057.87     (3,639.06)    (628,896.58)
 352     4/1/2037     (628,896.58)          918.81         500.00        1,418.81      5,087.38     (3,668.56)    (633,983.95)
 353     5/1/2037     (633,983.95)          918.81         500.00        1,418.81      5,117.05     (3,698.24)    (639,101.01)
 354     6/1/2037     (639,101.01)          918.81         500.00        1,418.81      5,146.90     (3,728.09)    (644,247.91)
 355     7/1/2037     (644,247.91)          918.81         500.00        1,418.81      5,176.93     (3,758.11)    (649,424.84)
 356     8/1/2037     (649,424.84)          918.81         500.00        1,418.81      5,207.12     (3,788.31)    (654,631.96)
 357     9/1/2037     (654,631.96)          918.81         500.00        1,418.81      5,237.50     (3,818.69)    (659,869.46)
 358    10/1/2037     (659,869.46)          918.81         500.00        1,418.81      5,268.05     (3,849.24)    (665,137.51)
 359    11/1/2037     (665,137.51)          918.81         500.00        1,418.81      5,298.78     (3,879.97)    (670,436.29)
####    12/1/2037     (670,436.29)          918.81         500.00        1,418.81      5,329.69     (3,910.88)    (675,765.98)
                                    Acknowledgements and

Kairos would like to take this opportunity to thank everyone who contributed to this project, in par
for their generous financial support and Kairos Expansion Committee for their guidance and enthus

Contributors of Information:
Ontario Non-Profit Housing Association
Canada Mortgage and Housing Corporation
City of Peterborough
County of Peterborough
Otonabee/South Monaghan Township
Statistics Canada
David Watson General Contracting
Derek Millage -- Millage Masonry
Vern O'Brien Excavating
Bell Paving
FCI Windows
Kingdon Tim-Br-Mart
Alf Curtis Home Improvement
Dufferin Custom Concrete
Charlotte Paint and Paper
Royden Moran Architect

Online Resources:
http://www.onpha.org/affordable_housing_initiatives/funding/default.asp?load=mortgage#worksheet
http://www.cmhc.ca/en/inpr/afhoce/tore/into/into_001.cfm
http://www.building-cost.net/CompMatrix.asp
http://www.ontariocontractors.com/costs.htm#9
http://www.hiringacontractor.com/En/default.asp
http://cgi.money.cnn.com/tools/renovation/renovation.html
http://www.renovationplanner.com/
nts and Resources

o this project, in particular the Ontario Trillium Foundation
guidance and enthusiasm.




           (ONPHA Hands On Project Financing Worksheet)
           (CMHC Affordable Housing Project Viability Assessment Tool)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:25
posted:5/18/2012
language:English
pages:40
fanzhongqing fanzhongqing http://
About