| Assumptions: |
| Mortgage Amount | | | | | | | 150,000.00 |
| Current Real Rate plus other risk premia | | | | | | | 4% |
| Inflation index (year 1-10) | | | | | | | 3% |
| Inflation index (year 11-18) | | | | | | | 4% |
| Inflation index (year 19-25) | | | | | | | 2% |
| Amortization term | | | | | | | 25 |
| Year | Principle Balance | Annual PMT | Interest | Interest PMT | Amortization | FV | Ending Balance | Index |
| 0 |
| 1 | 150,000.00 | 9,601.79 | 4% | 6,000.00 | 3,601.79 | 146,398.21 | 150,790.15 | 3% |
| 2 | 150,790.15 | 9,889.85 | 4% | 6,031.61 | 3,858.24 | 146,931.91 | 151,339.87 | 3% |
| 3 | 151,339.87 | 10,186.54 | 4% | 6,053.59 | 4,132.95 | 147,206.92 | 151,623.13 | 3% |
| 4 | 151,623.13 | 10,492.14 | 4% | 6,064.93 | 4,427.21 | 147,195.91 | 151,611.79 | 3% |
| 5 | 151,611.79 | 10,806.90 | 4% | 6,064.47 | 4,742.43 | 146,869.35 | 151,275.44 | 3% |
| 6 | 151,275.44 | 11,131.11 | 4% | 6,051.02 | 5,080.09 | 146,195.34 | 150,581.20 | 3% |
| 7 | 150,581.20 | 11,465.04 | 4% | 6,023.25 | 5,441.80 | 145,139.41 | 149,493.59 | 3% |
| 8 | 149,493.59 | 11,809.00 | 4% | 5,979.74 | 5,829.25 | 143,664.34 | 147,974.27 | 3% |
| 9 | 147,974.27 | 12,163.27 | 4% | 5,918.97 | 6,244.30 | 141,729.97 | 145,981.87 | 3% |
| 10 | 145,981.87 | 12,528.16 | 4% | 5,839.27 | 6,688.89 | 139,292.98 | 143,471.77 | 3% |
| 11 | 143,471.77 | 12,904.01 | 4% | 5,738.87 | 7,165.14 | 136,306.63 | 141,758.90 | 4% |
| 12 | 141,758.90 | 13,420.17 | 4% | 5,670.36 | 7,749.81 | 134,009.08 | 139,369.45 | 4% |
| 13 | 139,369.45 | 13,956.98 | 4% | 5,574.78 | 8,382.20 | 130,987.25 | 136,226.74 | 4% |
| 14 | 136,226.74 | 14,515.25 | 4% | 5,449.07 | 9,066.19 | 127,160.55 | 132,246.97 | 4% |
| 15 | 132,246.97 | 15,095.87 | 4% | 5,289.88 | 9,805.99 | 122,440.99 | 127,338.63 | 4% |
| 16 | 127,338.63 | 15,699.70 | 4% | 5,093.55 | 10,606.15 | 116,732.47 | 121,401.77 | 4% |
| 17 | 121,401.77 | 16,327.69 | 4% | 4,856.07 | 11,471.62 | 109,930.16 | 114,327.36 | 4% |
| 18 | 114,327.36 | 16,980.80 | 4% | 4,573.09 | 12,407.70 | 101,919.66 | 105,996.45 | 4% |
| 19 | 105,996.45 | 17,660.03 | 4% | 4,239.86 | 13,420.17 | 92,576.28 | 94,427.80 | 2% |
| 20 | 94,427.80 | 18,013.23 | 4% | 3,777.11 | 14,236.12 | 80,191.69 | 81,795.52 | 2% |
| 21 | 81,795.52 | 18,373.49 | 4% | 3,271.82 | 15,101.67 | 66,693.85 | 68,027.73 | 2% |
| 22 | 68,027.73 | 18,740.96 | 4% | 2,721.11 | 16,019.85 | 52,007.88 | 53,048.03 | 2% |
| 23 | 53,048.03 | 19,115.78 | 4% | 2,121.92 | 16,993.86 | 36,054.17 | 36,775.26 | 2% |
| 24 | 36,775.26 | 19,498.10 | 4% | 1,471.01 | 18,027.09 | 18,748.17 | 19,123.13 | 2% |
| 25 | 19,123.13 | 19,888.06 | 4% | 764.93 | 19,123.13 | 0.00 | 0.00 | 2% |
Gatillo1
example_plam.xls
