|
|
|
|
|
|
|
|
| ΣXi |
|
|
|
|
|
|
|
|
|
| ΣYi | ||||
Let: | X = |
|
|
|
|
|
| Y = | ||||||||||||||||
| n |
|
|
|
|
|
|
| n | |||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||||
SX2 | = Σ (X |
|
|
|
| )2 |
|
| SX2 |
|
|
|
|
|
|
| ||||||||
i |
| − X |
|
| = Σ (Y − Y )2 | |||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| i |
|
|
| |
|
|
| SXY = Σ (Xi |
|
|
|
|
|
|
|
|
|
|
|
|
| ||||||||
|
|
| − X | ) (Yi | − Y ) |
|
|
| ||||||||||||||||
Then: |
|
|
|
|
|
| M = | SXY |
|
|
|
|
|
|
|
|
| |||||||
|
|
|
|
|
| SX2 |
|
|
|
|
|
|
|
| ||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |||||
|
|
| B = b for LIN and LOG models, and | |||||||||||||||||||||
|
|
| B = eb for EXP and PWR models, | |||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
where b = Y |
| − M X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||||
|
|
|
|
|
|
|
| CORR = |
|
|
|
| SXY |
|
|
|
| |||||||
|
|
|
|
|
|
|
|
|
| SX 2 ⋅ SY 2 |
|
|
| |||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equations Used in Chapter 14
Canadian Mortgages
PV | = − PMT | 1 | − (1 | + r)−N | − FV (1 + r)−N | |||||
|
|
| r |
| ||||||
|
|
|
| |
|
|
| | ||
| |
| CI%YR 16 |
| |
| ||||
where: r = | 1 | + |
|
|
|
| | − | 1 |
|
200 |
|
| ||||||||
| |
|
| |
| |
| |||
| |
|
|
|
|
|
|
| |
|
N = total number of monthly payments
CI%YR = annual interest rate (as a percent)
PV = loan amount
PMT = monthly payment
FV = balloon payment
252 B: More About Calculations
File name :