Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have attached a file with real estate mortgage problems. Real Estate and Society Spring 2017 1. You have borrowed $550,000 for Bank of America.
I have attached a file with real estate mortgage problems.
Real Estate and Society Spring 2017 1. You have borrowed $550,000 for Bank of America. The loan is a traditional fixed mortgage loan at 3.75% for 30 years. Please use EXCEL to prepare a monthly amortization schedule. 2. What is the outstanding balance on this loan at the end of 5 years. a. According to the amortization schedule b. What entries would you make on a financial calculator to find the answer and is it the same? 3. You have now learned that the bank will charge you 1.5 points on the loan. What is the effective interest rate on this loan? 4. What is the effective rate with the points if the loan is paid off at the end of five years? 5. You have been provided the following information: a. Total property acquisition price $1,056,000 b. Property consists of eight office suites, 3 on the first floor, 5 on the second floor c. Contract rents: 2 suites at $1,800 per month, 1 at $3,600 per month, and 5 at $1,560 per month. d. It is anticipated that rents will increase annually at the rate of 3% per year e. It is anticipated that vacancy and collection loss will be 10% per year f. Operating expenses are 40% of effective gross income g. Capital expenditures are 5% of effective gross income h. Anticipated holding period is 5 years i. Expected selling price is based on a cap rate of 8.75% j. It is anticipated that selling expenses will be 4% of the sales price k. The first mortgage is $792,000 l. The mortgage interest rate is 6.5% m. The loan term is 30 years n. Total upfront financing costs are 3% - Calculate Loan to Value and Debt Service Coverage Use EXCEL to set up a discounted cash flow analysis o Include calculation of Operating Income o Include after Debt Service Cash Flow 6. What is the purpose of pre-payment penalties? SPREADSHEET FOR ANALYZING MORTGAGE LOANS You need to specify only the numbers shown in red. The machine will do the rest. L $550,000 Mortgage loan Y 30 Years (can be up to 30 years in this program) M 360 Months (calculated by program) RATE 3.75% Annual borrowing rate (A.P.R.) i 0.31% Monthly borrowing rate (calculated by program) PMT $2,547.14 Monthly mortgage payment (calculated by pgm.) AMORTIZATION TABLE FOR A MORTGAGE LOAN (SCROLL DOWN) Disregard any row row past the number of months for this deal DEBT STILL OWED INTEREST DUE PAYMENT DUE REPAYMENT OF DEBT AT BEGINNING OF AT THE END OF AT THE END OF WITH THIS PERIOD'S THE PERIOD THE PERIOD THE PERIOD PAYMENT (1) (2) (3) = i x (2) (4) (5) = (4) - (3) 1 2 3 $550,000.00 $549,171.61 $548,340.64 $1,718.75 $1,716.16 $1,713.56 $2,547.14 $2,547.14 $2,547.14 $828.39 $830.97 $833.57 4 5 $547,507.07 $546,670.89 $1,710.96 $1,708.35 $2,547.14 $2,547.14 $836.18 $838.79 MONTH 6 7 8 9 $545,832.10 $544,990.69 $544,146.65 $543,299.98 $1,705.73 $1,703.10 $1,700.46 $1,697.81 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $841.41 $844.04 $846.68 $849.32 10 11 $542,450.65 $541,598.67 $1,695.16 $1,692.50 $2,547.14 $2,547.14 $851.98 $854.64 12 13 14 $540,744.03 $539,886.72 $539,026.73 $1,689.83 $1,687.15 $1,684.46 $2,547.14 $2,547.14 $2,547.14 $857.31 $859.99 $862.68 15 16 $538,164.06 $537,298.68 $1,681.76 $1,679.06 $2,547.14 $2,547.14 $865.37 $868.08 17 18 19 $536,430.61 $535,559.82 $534,686.31 $1,676.35 $1,673.62 $1,670.89 $2,547.14 $2,547.14 $2,547.14 $870.79 $873.51 $876.24 20 21 $533,810.06 $532,931.08 $1,668.16 $1,665.41 $2,547.14 $2,547.14 $878.98 $881.73 22 23 24 $532,049.36 $531,164.88 $530,277.63 $1,662.65 $1,659.89 $1,657.12 $2,547.14 $2,547.14 $2,547.14 $884.48 $887.25 $890.02 25 26 $529,387.61 $528,494.81 $1,654.34 $1,651.55 $2,547.14 $2,547.14 $892.80 $895.59 27 28 29 $527,599.22 $526,700.84 $525,799.64 $1,648.75 $1,645.94 $1,643.12 $2,547.14 $2,547.14 $2,547.14 $898.39 $901.20 $904.01 30 31 32 33 $524,895.63 $523,988.79 $523,079.12 $522,166.61 $1,640.30 $1,637.46 $1,634.62 $1,631.77 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $906.84 $909.67 $912.51 $915.37 34 35 36 37 $521,251.24 $520,333.02 $519,411.92 $518,487.95 $1,628.91 $1,626.04 $1,623.16 $1,620.27 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $918.23 $921.10 $923.97 $926.86 38 39 $517,561.09 $516,631.33 $1,617.38 $1,614.47 $2,547.14 $2,547.14 $929.76 $932.66 40 41 42 $515,698.67 $514,763.09 $513,824.59 $1,611.56 $1,608.63 $1,605.70 $2,547.14 $2,547.14 $2,547.14 $935.58 $938.50 $941.43 43 44 $512,883.15 $511,938.78 $1,602.76 $1,599.81 $2,547.14 $2,547.14 $944.38 $947.33 45 46 47 $510,991.45 $510,041.16 $509,087.91 $1,596.85 $1,593.88 $1,590.90 $2,547.14 $2,547.14 $2,547.14 $950.29 $953.26 $956.24 48 49 $508,131.67 $507,172.45 $1,587.91 $1,584.91 $2,547.14 $2,547.14 $959.22 $962.22 50 51 52 $506,210.23 $505,245.00 $504,276.75 $1,581.91 $1,578.89 $1,575.86 $2,547.14 $2,547.14 $2,547.14 $965.23 $968.25 $971.27 53 54 $503,305.48 $502,331.17 $1,572.83 $1,569.78 $2,547.14 $2,547.14 $974.31 $977.35 55 56 57 $501,353.82 $500,373.42 $499,389.95 $1,566.73 $1,563.67 $1,560.59 $2,547.14 $2,547.14 $2,547.14 $980.41 $983.47 $986.54 58 59 60 61 $498,403.41 $497,413.78 $496,421.06 $495,425.24 $1,557.51 $1,554.42 $1,551.32 $1,548.20 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $989.63 $992.72 $995.82 $998.93 62 63 64 65 $494,426.31 $493,424.26 $492,419.07 $491,410.75 $1,545.08 $1,541.95 $1,538.81 $1,535.66 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,002.05 $1,005.18 $1,008.33 $1,011.48 66 67 $490,399.27 $489,384.63 $1,532.50 $1,529.33 $2,547.14 $2,547.14 $1,014.64 $1,017.81 68 69 70 $488,366.82 $487,345.83 $486,321.65 $1,526.15 $1,522.96 $1,519.76 $2,547.14 $2,547.14 $2,547.14 $1,020.99 $1,024.18 $1,027.38 71 72 $485,294.27 $484,263.68 $1,516.54 $1,513.32 $2,547.14 $2,547.14 $1,030.59 $1,033.81 73 74 75 $483,229.87 $482,192.83 $481,152.55 $1,510.09 $1,506.85 $1,503.60 $2,547.14 $2,547.14 $2,547.14 $1,037.04 $1,040.28 $1,043.53 76 77 $480,109.01 $479,062.22 $1,500.34 $1,497.07 $2,547.14 $2,547.14 $1,046.80 $1,050.07 78 79 80 $478,012.15 $476,958.80 $475,902.16 $1,493.79 $1,490.50 $1,487.19 $2,547.14 $2,547.14 $2,547.14 $1,053.35 $1,056.64 $1,059.94 81 82 $474,842.22 $473,778.97 $1,483.88 $1,480.56 $2,547.14 $2,547.14 $1,063.25 $1,066.58 83 84 85 $472,712.39 $471,642.48 $470,569.23 $1,477.23 $1,473.88 $1,470.53 $2,547.14 $2,547.14 $2,547.14 $1,069.91 $1,073.25 $1,076.61 86 87 88 89 $469,492.62 $468,412.65 $467,329.30 $466,242.57 $1,467.16 $1,463.79 $1,460.40 $1,457.01 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,079.97 $1,083.35 $1,086.73 $1,090.13 90 91 92 93 $465,152.44 $464,058.91 $462,961.96 $461,861.58 $1,453.60 $1,450.18 $1,446.76 $1,443.32 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,093.53 $1,096.95 $1,100.38 $1,103.82 94 95 $460,757.76 $459,650.49 $1,439.87 $1,436.41 $2,547.14 $2,547.14 $1,107.27 $1,110.73 96 97 98 $458,539.77 $457,425.57 $456,307.89 $1,432.94 $1,429.45 $1,425.96 $2,547.14 $2,547.14 $2,547.14 $1,114.20 $1,117.68 $1,121.17 99 100 $455,186.71 $454,062.03 $1,422.46 $1,418.94 $2,547.14 $2,547.14 $1,124.68 $1,128.19 101 102 103 $452,933.84 $451,802.13 $450,666.87 $1,415.42 $1,411.88 $1,408.33 $2,547.14 $2,547.14 $2,547.14 $1,131.72 $1,135.25 $1,138.80 104 105 $449,528.07 $448,385.71 $1,404.78 $1,401.21 $2,547.14 $2,547.14 $1,142.36 $1,145.93 106 107 108 $447,239.78 $446,090.27 $444,937.16 $1,397.62 $1,394.03 $1,390.43 $2,547.14 $2,547.14 $2,547.14 $1,149.51 $1,153.10 $1,156.71 109 110 $443,780.46 $442,620.13 $1,386.81 $1,383.19 $2,547.14 $2,547.14 $1,160.32 $1,163.95 111 112 113 $441,456.19 $440,288.60 $439,117.37 $1,379.55 $1,375.90 $1,372.24 $2,547.14 $2,547.14 $2,547.14 $1,167.59 $1,171.23 $1,174.89 114 115 116 117 $437,942.47 $436,763.91 $435,581.66 $434,395.72 $1,368.57 $1,364.89 $1,361.19 $1,357.49 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,178.57 $1,182.25 $1,185.94 $1,189.65 118 119 120 121 $433,206.07 $432,012.70 $430,815.60 $429,614.77 $1,353.77 $1,350.04 $1,346.30 $1,342.55 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,193.37 $1,197.10 $1,200.84 $1,204.59 122 123 $428,410.18 $427,201.82 $1,338.78 $1,335.01 $2,547.14 $2,547.14 $1,208.35 $1,212.13 124 125 126 $425,989.69 $424,773.78 $423,554.06 $1,331.22 $1,327.42 $1,323.61 $2,547.14 $2,547.14 $2,547.14 $1,215.92 $1,219.72 $1,223.53 127 128 $422,330.53 $421,103.18 $1,319.78 $1,315.95 $2,547.14 $2,547.14 $1,227.35 $1,231.19 129 130 131 $419,871.99 $418,636.95 $417,398.06 $1,312.10 $1,308.24 $1,304.37 $2,547.14 $2,547.14 $2,547.14 $1,235.04 $1,238.90 $1,242.77 132 133 $416,155.29 $414,908.64 $1,300.49 $1,296.59 $2,547.14 $2,547.14 $1,246.65 $1,250.55 134 135 136 $413,658.09 $412,403.64 $411,145.26 $1,292.68 $1,288.76 $1,284.83 $2,547.14 $2,547.14 $2,547.14 $1,254.45 $1,258.37 $1,262.31 137 138 $409,882.96 $408,616.71 $1,280.88 $1,276.93 $2,547.14 $2,547.14 $1,266.25 $1,270.21 139 140 141 $407,346.50 $406,072.32 $404,794.16 $1,272.96 $1,268.98 $1,264.98 $2,547.14 $2,547.14 $2,547.14 $1,274.18 $1,278.16 $1,282.15 142 143 144 145 $403,512.01 $402,225.84 $400,935.66 $399,641.45 $1,260.98 $1,256.96 $1,252.92 $1,248.88 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,286.16 $1,290.18 $1,294.21 $1,298.26 146 147 148 149 $398,343.20 $397,040.88 $395,734.50 $394,424.04 $1,244.82 $1,240.75 $1,236.67 $1,232.58 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,302.31 $1,306.38 $1,310.47 $1,314.56 150 151 $393,109.47 $391,790.81 $1,228.47 $1,224.35 $2,547.14 $2,547.14 $1,318.67 $1,322.79 152 153 154 $390,468.02 $389,141.09 $387,810.02 $1,220.21 $1,216.07 $1,211.91 $2,547.14 $2,547.14 $2,547.14 $1,326.92 $1,331.07 $1,335.23 155 156 $386,474.79 $385,135.39 $1,207.73 $1,203.55 $2,547.14 $2,547.14 $1,339.40 $1,343.59 157 158 159 $383,791.80 $382,444.02 $381,092.02 $1,199.35 $1,195.14 $1,190.91 $2,547.14 $2,547.14 $2,547.14 $1,347.79 $1,352.00 $1,356.22 160 161 $379,735.80 $378,375.34 $1,186.67 $1,182.42 $2,547.14 $2,547.14 $1,360.46 $1,364.71 162 163 164 $377,010.62 $375,641.64 $374,268.39 $1,178.16 $1,173.88 $1,169.59 $2,547.14 $2,547.14 $2,547.14 $1,368.98 $1,373.26 $1,377.55 165 166 $372,890.84 $371,508.99 $1,165.28 $1,160.97 $2,547.14 $2,547.14 $1,381.85 $1,386.17 167 168 169 $370,122.82 $368,732.32 $367,337.47 $1,156.63 $1,152.29 $1,147.93 $2,547.14 $2,547.14 $2,547.14 $1,390.50 $1,394.85 $1,399.21 170 171 172 173 $365,938.26 $364,534.69 $363,126.72 $361,714.36 $1,143.56 $1,139.17 $1,134.77 $1,130.36 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,403.58 $1,407.96 $1,412.36 $1,416.78 174 175 176 177 $360,297.58 $358,876.37 $357,450.73 $356,020.62 $1,125.93 $1,121.49 $1,117.03 $1,112.56 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,421.21 $1,425.65 $1,430.10 $1,434.57 178 179 $354,586.05 $353,147.00 $1,108.08 $1,103.58 $2,547.14 $2,547.14 $1,439.05 $1,443.55 180 181 182 $351,703.45 $350,255.38 $348,802.80 $1,099.07 $1,094.55 $1,090.01 $2,547.14 $2,547.14 $2,547.14 $1,448.06 $1,452.59 $1,457.13 183 184 $347,345.67 $345,883.99 $1,085.46 $1,080.89 $2,547.14 $2,547.14 $1,461.68 $1,466.25 185 186 187 $344,417.74 $342,946.91 $341,471.48 $1,076.31 $1,071.71 $1,067.10 $2,547.14 $2,547.14 $2,547.14 $1,470.83 $1,475.43 $1,480.04 188 189 $339,991.45 $338,506.78 $1,062.47 $1,057.83 $2,547.14 $2,547.14 $1,484.66 $1,489.30 190 191 192 $337,017.48 $335,523.52 $334,024.90 $1,053.18 $1,048.51 $1,043.83 $2,547.14 $2,547.14 $2,547.14 $1,493.96 $1,498.62 $1,503.31 193 194 $332,521.59 $331,013.59 $1,039.13 $1,034.42 $2,547.14 $2,547.14 $1,508.01 $1,512.72 195 196 197 $329,500.87 $327,983.42 $326,461.23 $1,029.69 $1,024.95 $1,020.19 $2,547.14 $2,547.14 $2,547.14 $1,517.45 $1,522.19 $1,526.94 198 199 200 201 $324,934.29 $323,402.57 $321,866.07 $320,324.77 $1,015.42 $1,010.63 $1,005.83 $1,001.01 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,531.72 $1,536.50 $1,541.30 $1,546.12 202 203 204 205 $318,778.65 $317,227.69 $315,671.89 $314,111.23 $996.18 $991.34 $986.47 $981.60 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,550.95 $1,555.80 $1,560.66 $1,565.54 206 207 $312,545.70 $310,975.27 $976.71 $971.80 $2,547.14 $2,547.14 $1,570.43 $1,575.34 208 209 210 $309,399.93 $307,819.67 $306,234.47 $966.87 $961.94 $956.98 $2,547.14 $2,547.14 $2,547.14 $1,580.26 $1,585.20 $1,590.15 211 212 $304,644.31 $303,049.19 $952.01 $947.03 $2,547.14 $2,547.14 $1,595.12 $1,600.11 213 214 215 $301,449.08 $299,843.98 $298,233.85 $942.03 $937.01 $931.98 $2,547.14 $2,547.14 $2,547.14 $1,605.11 $1,610.12 $1,615.15 216 217 $296,618.70 $294,998.50 $926.93 $921.87 $2,547.14 $2,547.14 $1,620.20 $1,625.27 218 219 220 $293,373.23 $291,742.89 $290,107.45 $916.79 $911.70 $906.59 $2,547.14 $2,547.14 $2,547.14 $1,630.34 $1,635.44 $1,640.55 221 222 $288,466.90 $286,821.22 $901.46 $896.32 $2,547.14 $2,547.14 $1,645.68 $1,650.82 223 224 225 $285,170.40 $283,514.42 $281,853.27 $891.16 $885.98 $880.79 $2,547.14 $2,547.14 $2,547.14 $1,655.98 $1,661.15 $1,666.34 226 227 228 229 $280,186.93 $278,515.37 $276,838.60 $275,156.58 $875.58 $870.36 $865.12 $859.86 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,671.55 $1,676.78 $1,682.02 $1,687.27 230 231 232 233 $273,469.31 $271,776.77 $270,078.93 $268,375.80 $854.59 $849.30 $844.00 $838.67 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,692.54 $1,697.83 $1,703.14 $1,708.46 234 235 $266,667.33 $264,953.53 $833.34 $827.98 $2,547.14 $2,547.14 $1,713.80 $1,719.16 236 237 238 $263,234.38 $261,509.85 $259,779.93 $822.61 $817.22 $811.81 $2,547.14 $2,547.14 $2,547.14 $1,724.53 $1,729.92 $1,735.32 239 $258,044.61 $806.39 $2,547.14 $1,740.75 240 $256,303.86 $800.95 $2,547.14 $1,746.19 241 $254,557.68 $795.49 $2,547.14 $1,751.64 242 243 $252,806.03 $251,048.92 $790.02 $784.53 $2,547.14 $2,547.14 $1,757.12 $1,762.61 244 245 246 $249,286.31 $247,518.19 $245,744.55 $779.02 $773.49 $767.95 $2,547.14 $2,547.14 $2,547.14 $1,768.12 $1,773.64 $1,779.18 247 248 $243,965.37 $242,180.62 $762.39 $756.81 $2,547.14 $2,547.14 $1,784.74 $1,790.32 249 250 251 $240,390.30 $238,594.39 $236,792.86 $751.22 $745.61 $739.98 $2,547.14 $2,547.14 $2,547.14 $1,795.92 $1,801.53 $1,807.16 252 253 254 255 256 $234,985.70 $233,172.89 $231,354.42 $229,530.27 $227,700.42 $734.33 $728.67 $722.98 $717.28 $711.56 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,812.81 $1,818.47 $1,824.15 $1,829.85 $1,835.57 257 258 259 260 $225,864.84 $224,023.54 $222,176.47 $220,323.64 $705.83 $700.07 $694.30 $688.51 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,841.31 $1,847.06 $1,852.83 $1,858.62 261 262 $218,465.02 $216,600.58 $682.70 $676.88 $2,547.14 $2,547.14 $1,864.43 $1,870.26 263 264 265 $214,730.32 $212,854.22 $210,972.25 $671.03 $665.17 $659.29 $2,547.14 $2,547.14 $2,547.14 $1,876.10 $1,881.97 $1,887.85 266 267 $209,084.41 $207,190.66 $653.39 $647.47 $2,547.14 $2,547.14 $1,893.75 $1,899.66 268 269 270 $205,290.99 $203,385.39 $201,473.84 $641.53 $635.58 $629.61 $2,547.14 $2,547.14 $2,547.14 $1,905.60 $1,911.56 $1,917.53 271 272 $199,556.31 $197,632.78 $623.61 $617.60 $2,547.14 $2,547.14 $1,923.52 $1,929.53 273 274 275 $195,703.25 $193,767.69 $191,826.08 $611.57 $605.52 $599.46 $2,547.14 $2,547.14 $2,547.14 $1,935.56 $1,941.61 $1,947.68 276 277 $189,878.40 $187,924.63 $593.37 $587.26 $2,547.14 $2,547.14 $1,953.77 $1,959.87 278 279 280 $185,964.76 $183,998.76 $182,026.62 $581.14 $575.00 $568.83 $2,547.14 $2,547.14 $2,547.14 $1,966.00 $1,972.14 $1,978.30 281 282 283 284 $180,048.32 $178,063.84 $176,073.15 $174,076.24 $562.65 $556.45 $550.23 $543.99 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,984.48 $1,990.69 $1,996.91 $2,003.15 285 286 287 288 $172,073.10 $170,063.69 $168,048.00 $166,026.02 $537.73 $531.45 $525.15 $518.83 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,009.41 $2,015.69 $2,021.99 $2,028.30 289 290 $163,997.71 $161,963.07 $512.49 $506.13 $2,547.14 $2,547.14 $2,034.64 $2,041.00 291 292 293 $159,922.07 $157,874.69 $155,820.91 $499.76 $493.36 $486.94 $2,547.14 $2,547.14 $2,547.14 $2,047.38 $2,053.78 $2,060.20 294 295 $153,760.72 $151,694.08 $480.50 $474.04 $2,547.14 $2,547.14 $2,066.63 $2,073.09 296 297 298 $149,620.99 $147,541.42 $145,455.35 $467.57 $461.07 $454.55 $2,547.14 $2,547.14 $2,547.14 $2,079.57 $2,086.07 $2,092.59 299 300 $143,362.76 $141,263.64 $448.01 $441.45 $2,547.14 $2,547.14 $2,099.13 $2,105.69 301 302 303 $139,157.95 $137,045.68 $134,926.81 $434.87 $428.27 $421.65 $2,547.14 $2,547.14 $2,547.14 $2,112.27 $2,118.87 $2,125.49 304 305 $132,801.33 $130,669.19 $415.00 $408.34 $2,547.14 $2,547.14 $2,132.13 $2,138.79 306 307 308 $128,530.40 $126,384.92 $124,232.74 $401.66 $394.95 $388.23 $2,547.14 $2,547.14 $2,547.14 $2,145.48 $2,152.18 $2,158.91 309 310 311 312 $122,073.83 $119,908.17 $117,735.75 $115,556.54 $381.48 $374.71 $367.92 $361.11 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,165.66 $2,172.42 $2,179.21 $2,186.02 313 314 315 316 $113,370.52 $111,177.67 $108,977.96 $106,771.38 $354.28 $347.43 $340.56 $333.66 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,192.85 $2,199.71 $2,206.58 $2,213.48 317 318 $104,557.91 $102,337.51 $326.74 $319.80 $2,547.14 $2,547.14 $2,220.39 $2,227.33 319 320 321 $100,110.18 $97,875.89 $95,634.62 $312.84 $305.86 $298.86 $2,547.14 $2,547.14 $2,547.14 $2,234.29 $2,241.27 $2,248.28 322 323 $93,386.34 $91,131.04 $291.83 $284.78 $2,547.14 $2,547.14 $2,255.30 $2,262.35 324 325 326 $88,868.69 $86,599.26 $84,322.75 $277.71 $270.62 $263.51 $2,547.14 $2,547.14 $2,547.14 $2,269.42 $2,276.51 $2,283.63 327 328 $82,039.12 $79,748.36 $256.37 $249.21 $2,547.14 $2,547.14 $2,290.76 $2,297.92 329 330 331 $77,450.44 $75,145.34 $72,833.03 $242.03 $234.83 $227.60 $2,547.14 $2,547.14 $2,547.14 $2,305.10 $2,312.31 $2,319.53 332 333 $70,513.50 $68,186.71 $220.35 $213.08 $2,547.14 $2,547.14 $2,326.78 $2,334.05 334 335 336 $65,852.66 $63,511.32 $61,162.65 $205.79 $198.47 $191.13 $2,547.14 $2,547.14 $2,547.14 $2,341.35 $2,348.66 $2,356.00 337 338 339 340 $58,806.65 $56,443.29 $54,072.54 $51,694.38 $183.77 $176.39 $168.98 $161.54 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,363.36 $2,370.75 $2,378.16 $2,385.59 341 342 343 344 $49,308.79 $46,915.74 $44,515.22 $42,107.19 $154.09 $146.61 $139.11 $131.58 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,393.05 $2,400.52 $2,408.03 $2,415.55 345 346 $39,691.64 $37,268.54 $124.04 $116.46 $2,547.14 $2,547.14 $2,423.10 $2,430.67 347 348 349 $34,837.87 $32,399.60 $29,953.71 $108.87 $101.25 $93.61 $2,547.14 $2,547.14 $2,547.14 $2,438.27 $2,445.89 $2,453.53 350 351 $27,500.18 $25,038.99 $85.94 $78.25 $2,547.14 $2,547.14 $2,461.20 $2,468.89 352 353 354 $22,570.10 $20,093.49 $17,609.15 $70.53 $62.79 $55.03 $2,547.14 $2,547.14 $2,547.14 $2,476.60 $2,484.34 $2,492.11 355 356 $15,117.04 $12,617.15 $47.24 $39.43 $2,547.14 $2,547.14 $2,499.89 $2,507.71 357 358 359 $10,109.44 $7,593.90 $5,070.49 $31.59 $23.73 $15.85 $2,547.14 $2,547.14 $2,547.14 $2,515.54 $2,523.40 $2,531.29 360 $2,539.20 $7.94 $2,547.14 $2,539.20 LOANS the rest. CROLL DOWN) his deal DEBT STILL OWNED AT THE END OF THE PERIOD (6) = (2) - (5) $549,171.61 $548,340.64 $547,507.07 $546,670.89 $545,832.10 $544,990.69 $544,146.65 $543,299.98 $542,450.65 $541,598.67 $540,744.03 $539,886.72 $539,026.73 $538,164.06 $537,298.68 $536,430.61 $535,559.82 $534,686.31 $533,810.06 $532,931.08 $532,049.36 $531,164.88 $530,277.63 $529,387.61 $528,494.81 $527,599.22 $526,700.84 $525,799.64 $524,895.63 $523,988.79 $523,079.12 $522,166.61 $521,251.24 $520,333.02 $519,411.92 $518,487.95 $517,561.09 $516,631.33 $515,698.67 $514,763.09 $513,824.59 $512,883.15 $511,938.78 $510,991.45 $510,041.16 $509,087.91 $508,131.67 $507,172.45 $506,210.23 $505,245.00 $504,276.75 $503,305.48 $502,331.17 $501,353.82 $500,373.42 $499,389.95 $498,403.41 $497,413.78 $496,421.06 $495,425.24 $494,426.31 $493,424.26 $492,419.07 $491,410.75 $490,399.27 $489,384.63 $488,366.82 $487,345.83 $486,321.65 $485,294.27 $484,263.68 $483,229.87 $482,192.83 $481,152.55 $480,109.01 $479,062.22 $478,012.15 $476,958.80 $475,902.16 $474,842.22 $473,778.97 $472,712.39 $471,642.48 $470,569.23 $469,492.62 $468,412.65 $467,329.30 $466,242.57 $465,152.44 $464,058.91 $462,961.96 $461,861.58 $460,757.76 $459,650.49 $458,539.77 $457,425.57 $456,307.89 $455,186.71 $454,062.03 $452,933.84 $451,802.13 $450,666.87 $449,528.07 $448,385.71 $447,239.78 $446,090.27 $444,937.16 $443,780.46 $442,620.13 $441,456.19 $440,288.60 $439,117.37 $437,942.47 $436,763.91 $435,581.66 $434,395.72 $433,206.07 $432,012.70 $430,815.60 $429,614.77 $428,410.18 $427,201.82 $425,989.69 $424,773.78 $423,554.06 $422,330.53 $421,103.18 $419,871.99 $418,636.95 $417,398.06 $416,155.29 $414,908.64 $413,658.09 $412,403.64 $411,145.26 $409,882.96 $408,616.71 $407,346.50 $406,072.32 $404,794.16 $403,512.01 $402,225.84 $400,935.66 $399,641.45 $398,343.20 $397,040.88 $395,734.50 $394,424.04 $393,109.47 $391,790.81 $390,468.02 $389,141.09 $387,810.02 $386,474.79 $385,135.39 $383,791.80 $382,444.02 $381,092.02 $379,735.80 $378,375.34 $377,010.62 $375,641.64 $374,268.39 $372,890.84 $371,508.99 $370,122.82 $368,732.32 $367,337.47 $365,938.26 $364,534.69 $363,126.72 $361,714.36 $360,297.58 $358,876.37 $357,450.73 $356,020.62 $354,586.05 $353,147.00 $351,703.45 $350,255.38 $348,802.80 $347,345.67 $345,883.99 $344,417.74 $342,946.91 $341,471.48 $339,991.45 $338,506.78 $337,017.48 $335,523.52 $334,024.90 $332,521.59 $331,013.59 $329,500.87 $327,983.42 $326,461.23 $324,934.29 $323,402.57 $321,866.07 $320,324.77 $318,778.65 $317,227.69 $315,671.89 $314,111.23 $312,545.70 $310,975.27 $309,399.93 $307,819.67 $306,234.47 $304,644.31 $303,049.19 $301,449.08 $299,843.98 $298,233.85 $296,618.70 $294,998.50 $293,373.23 $291,742.89 $290,107.45 $288,466.90 $286,821.22 $285,170.40 $283,514.42 $281,853.27 $280,186.93 $278,515.37 $276,838.60 $275,156.58 $273,469.31 $271,776.77 $270,078.93 $268,375.80 $266,667.33 $264,953.53 $263,234.38 $261,509.85 $259,779.93 $258,044.61 $256,303.86 $254,557.68 $252,806.03 $251,048.92 $249,286.31 $247,518.19 $245,744.55 $243,965.37 $242,180.62 $240,390.30 $238,594.39 $236,792.86 $234,985.70 $233,172.89 $231,354.42 $229,530.27 $227,700.42 $225,864.84 $224,023.54 $222,176.47 $220,323.64 $218,465.02 $216,600.58 $214,730.32 $212,854.22 $210,972.25 $209,084.41 $207,190.66 $205,290.99 $203,385.39 $201,473.84 $199,556.31 $197,632.78 $195,703.25 $193,767.69 $191,826.08 $189,878.40 $187,924.63 $185,964.76 $183,998.76 $182,026.62 $180,048.32 $178,063.84 $176,073.15 $174,076.24 $172,073.10 $170,063.69 $168,048.00 $166,026.02 $163,997.71 $161,963.07 $159,922.07 $157,874.69 $155,820.91 $153,760.72 $151,694.08 $149,620.99 $147,541.42 $145,455.35 $143,362.76 $141,263.64 $139,157.95 $137,045.68 $134,926.81 $132,801.33 $130,669.19 $128,530.40 $126,384.92 $124,232.74 $122,073.83 $119,908.17 $117,735.75 $115,556.54 $113,370.52 $111,177.67 $108,977.96 $106,771.38 $104,557.91 $102,337.51 $100,110.18 $97,875.89 $95,634.62 $93,386.34 $91,131.04 $88,868.69 $86,599.26 $84,322.75 $82,039.12 $79,748.36 $77,450.44 $75,145.34 $72,833.03 $70,513.50 $68,186.71 $65,852.66 $63,511.32 $61,162.65 $58,806.65 $56,443.29 $54,072.54 $51,694.38 $49,308.79 $46,915.74 $44,515.22 $42,107.19 $39,691.64 $37,268.54 $34,837.87 $32,399.60 $29,953.71 $27,500.18 $25,038.99 $22,570.10 $20,093.49 $17,609.15 $15,117.04 $12,617.15 $10,109.44 $7,593.90 $5,070.49 $2,539.20 $0.00 Potential gross income (PGI) 2*1,800*12 1*3,600*12 5*1560*12 Total PGI Vacancy 10% of PGI Effective gross income Operating expense 40% of EGI Capital expenditure 5% of EGI Net operating income Debt service After Debt service Cash flow Discount rate (1+r)^-n Discounted after debt service cash flow Year 1 Year 2 7,200 7416 7,200 7416 93,600 96408 108,000 111240 10800 11124 97,200 100116 38880 40046.4 4860 5005.8 53,460 55063.8 60,649 60,649 -7,189 -5,585 0.939 0.8817 -6750.471 -4924.4708 Year 3 7638.48 7638.48 99300.24 114577.2 11457.72 103119.48 41247.792 5155.974 56715.714 60,649 -3,933 0.8278 -3255.9742 Year 4 7867.6344 7867.6344 102279.247 118014.516 11801.4516 106213.064 42485.2258 5310.65322 58417.1854 60,649 -2,232 0.7773 -1734.78947 Year 5 8103.663432 8103.663432 105347.624616 121554.95148 12155.495148 109399.456332 43759.7825328 5469.9728166 60169.7009826 60,649 -479 0.7299 -349.8403528 Loan Amortization Table www.excel-skills.com Loan Principle Amount Annual Interest Rate Loan Period (in months) Original Repayment Amount Repayment Number 550,000.00 3.75% 360.00 2,547.14 Opening Balance Loan Repayment Interest Charged Capital Repaid Closing Balance % Capital Outstanding Interest Rate 1 550,000.00 4,624.70 4,354.17 270.53 549,729.47 100.0% 9.50% 2 549,729.47 4,624.70 4,352.02 272.67 549,456.80 99.9% 9.50% 3 549,456.80 4,624.70 4,349.87 274.83 549,181.96 99.9% 9.50% 4 549,181.96 4,624.70 4,347.69 277.01 548,904.96 99.8% 9.50% 5 548,904.96 4,624.70 4,345.50 279.20 548,625.76 99.8% 9.50% 6 548,625.76 4,624.70 4,343.29 281.41 548,344.34 99.7% 9.50% 7 548,344.34 4,624.70 4,341.06 283.64 548,060.71 99.6% 9.50% 8 548,060.71 4,624.70 4,338.81 285.88 547,774.82 99.6% 9.50% 9 547,774.82 4,624.70 4,336.55 288.15 547,486.67 99.5% 9.50% 10 547,486.67 4,624.70 4,334.27 290.43 547,196.25 99.5% 9.50% 11 547,196.25 4,624.70 4,331.97 292.73 546,903.52 99.4% 9.50% 12 546,903.52 5,025.70 4,785.41 240.29 546,663.23 99.4% 10.50% 13 546,663.23 5,025.70 4,783.30 242.39 546,420.83 99.3% 10.50% 14 546,420.83 5,025.70 4,781.18 244.51 546,176.32 99.3% 10.50% 15 546,176.32 5,025.70 4,779.04 246.65 545,929.66 99.3% 10.50% 16 545,929.66 5,025.70 4,776.88 248.81 545,680.85 99.2% 10.50% 17 545,680.85 5,025.70 4,774.71 250.99 545,429.86 99.2% 10.50% 18 545,429.86 5,025.70 4,772.51 253.19 545,176.67 99.1% 10.50% 19 545,176.67 5,025.70 4,770.30 255.40 544,921.27 99.1% 10.50% 20 544,921.27 5,025.70 4,768.06 257.64 544,663.64 99.0% 10.50% 21 544,663.64 5,025.70 4,765.81 259.89 544,403.75 99.0% 10.50% 22 544,403.75 5,025.70 4,763.53 262.16 544,141.58 98.9% 10.50% 23 544,141.58 5,025.70 4,761.24 264.46 543,877.12 98.9% 10.50% 24 543,877.12 5,025.70 4,758.92 266.77 543,610.35 98.8% 10.50% 25 543,610.35 5,025.70 4,756.59 269.11 543,341.25 98.8% 10.50% 26 543,341.25 5,025.70 4,754.24 271.46 543,069.78 98.7% 10.50% 27 543,069.78 5,025.70 4,751.86 273.84 542,795.95 98.7% 10.50% 28 542,795.95 5,025.70 4,749.46 276.23 542,519.72 98.6% 10.50% 29 542,519.72 5,025.70 4,747.05 278.65 542,241.07 98.6% 10.50% 30 542,241.07 5,025.70 4,744.61 281.09 541,959.98 98.5% 10.50% 31 541,959.98 5,025.70 4,742.15 283.55 541,676.43 98.5% 10.50% 32 541,676.43 5,025.70 4,739.67 286.03 541,390.40 98.4% 10.50% 33 541,390.40 5,025.70 4,737.17 288.53 541,101.87 98.4% 10.50% 34 541,101.87 5,025.70 4,734.64 291.06 540,810.82 98.3% 10.50% 35 540,810.82 5,025.70 4,732.09 293.60 540,517.21 98.3% 10.50% 36 540,517.21 5,025.70 4,729.53 296.17 540,221.04 98.2% 10.50% 37 540,221.04 5,025.70 4,726.93 298.76 539,922.28 98.2% 10.50% 38 539,922.28 5,025.70 4,724.32 301.38 539,620.90 98.1% 10.50% 39 539,620.90 5,025.70 4,721.68 304.01 539,316.89 98.1% 10.50% 40 539,316.89 5,025.70 4,719.02 306.67 539,010.21 98.0% 10.50% 41 539,010.21 5,025.70 4,716.34 309.36 538,700.85 97.9% 10.50% 42 538,700.85 5,025.70 4,713.63 312.06 538,388.79 97.9% 10.50% 43 538,388.79 5,025.70 4,710.90 314.80 538,073.99 97.8% 10.50% 44 538,073.99 5,025.70 4,708.15 317.55 537,756.45 97.8% 10.50% 45 537,756.45 5,025.70 4,705.37 320.33 537,436.12 97.7% 10.50% 46 537,436.12 5,025.70 4,702.57 323.13 537,112.99 97.7% 10.50% 47 537,112.99 5,025.70 4,699.74 325.96 536,787.03 97.6% 10.50% 48 536,787.03 5,025.70 4,696.89 328.81 536,458.22 97.5% 10.50% 49 536,458.22 5,025.70 4,694.01 331.69 536,126.53 97.5% 10.50% 50 536,126.53 5,025.70 4,691.11 334.59 535,791.94 97.4% 10.50% 51 535,791.94 5,025.70 4,688.18 337.52 535,454.42 97.4% 10.50% 52 535,454.42 5,025.70 4,685.23 340.47 535,113.95 97.3% 10.50% 53 535,113.95 5,025.70 4,682.25 343.45 534,770.50 97.2% 10.50% 54 534,770.50 5,025.70 4,679.24 346.46 534,424.05 97.2% 10.50% 55 534,424.05 5,025.70 4,676.21 349.49 534,074.56 97.1% 10.50% 56 534,074.56 5,025.70 4,673.15 352.54 533,722.01 97.0% 10.50% 57 533,722.01 5,025.70 4,670.07 355.63 533,366.38 97.0% 10.50% 58 533,366.38 5,025.70 4,666.96 358.74 533,007.64 96.9% 10.50% 59 533,007.64 5,025.70 4,663.82 361.88 532,645.76 96.8% 10.50% 60 532,645.76 5,025.70 4,660.65 365.05 532,280.72 96.8% 10.50% 61 532,280.72 5,025.70 4,657.46 368.24 531,912.47 96.7% 10.50% 62 531,912.47 5,025.70 4,654.23 371.46 531,541.01 96.6% 10.50% Page 1 of 8 Loan Amortization Table www.excel-skills.com Loan Principle Amount Annual Interest Rate Loan Period (in months) Original Repayment Amount Repayment Number 550,000.00 3.75% 360.00 2,547.14 Opening Balance Loan Repayment Interest Charged Capital Repaid Closing Balance % Capital Outstanding Interest Rate 63 531,541.01 5,025.70 4,650.98 374.71 531,166.30 96.6% 10.50% 64 531,166.30 5,025.70 4,647.71 377.99 530,788.31 96.5% 10.50% 65 530,788.31 5,025.70 4,644.40 381.30 530,407.01 96.4% 10.50% 66 530,407.01 5,025.70 4,641.06 384.64 530,022.37 96.4% 10.50% 67 530,022.37 5,025.70 4,637.70 388.00 529,634.37 96.3% 10.50% 68 529,634.37 5,025.70 4,634.30 391.40 529,242.97 96.2% 10.50% 69 529,242.97 5,025.70 4,630.88 394.82 528,848.15 96.2% 10.50% 70 528,848.15 5,025.70 4,627.42 398.28 528,449.88 96.1% 10.50% 71 528,449.88 5,025.70 4,623.94 401.76 528,048.12 96.0% 10.50% 72 528,048.12 5,025.70 4,620.42 405.28 527,642.84 95.9% 10.50% 73 527,642.84 5,025.70 4,616.87 408.82 527,234.02 95.9% 10.50% 74 527,234.02 5,025.70 4,613.30 412.40 526,821.62 95.8% 10.50% 75 526,821.62 5,025.70 4,609.69 416.01 526,405.61 95.7% 10.50% 76 526,405.61 5,025.70 4,606.05 419.65 525,985.96 95.6% 10.50% 77 525,985.96 5,025.70 4,602.38 423.32 525,562.64 95.6% 10.50% 78 525,562.64 5,025.70 4,598.67 427.02 525,135.62 95.5% 10.50% 79 525,135.62 5,025.70 4,594.94 430.76 524,704.86 95.4% 10.50% 80 524,704.86 5,025.70 4,591.17 434.53 524,270.33 95.3% 10.50% 81 524,270.33 5,025.70 4,587.37 438.33 523,832.00 95.2% 10.50% 82 523,832.00 5,025.70 4,583.53 442.17 523,389.83 95.2% 10.50% 83 523,389.83 5,025.70 4,579.66 446.04 522,943.79 95.1% 10.50% 84 522,943.79 5,025.70 4,575.76 449.94 522,493.85 95.0% 10.50% 85 522,493.85 5,025.70 4,571.82 453.88 522,039.98 94.9% 10.50% 86 522,039.98 5,025.70 4,567.85 457.85 521,582.13 94.8% 10.50% 87 521,582.13 5,025.70 4,563.84 461.85 521,120.28 94.7% 10.50% 88 521,120.28 5,025.70 4,559.80 465.89 520,654.38 94.7% 10.50% 89 520,654.38 5,025.70 4,555.73 469.97 520,184.41 94.6% 10.50% 90 520,184.41 5,025.70 4,551.61 474.08 519,710.33 94.5% 10.50% 91 519,710.33 5,025.70 4,547.47 478.23 519,232.10 94.4% 10.50% 92 519,232.10 5,025.70 4,543.28 482.42 518,749.68 94.3% 10.50% 93 518,749.68 5,025.70 4,539.06 486.64 518,263.04 94.2% 10.50% 94 518,263.04 5,025.70 4,534.80 490.90 517,772.15 94.1% 10.50% 95 517,772.15 5,025.70 4,530.51 495.19 517,276.96 94.1% 10.50% 96 517,276.96 5,025.70 4,526.17 499.52 516,777.43 94.0% 10.50% 97 516,777.43 5,025.70 4,521.80 503.89 516,273.54 93.9% 10.50% 98 516,273.54 5,025.70 4,517.39 508.30 515,765.23 93.8% 10.50% 99 515,765.23 5,025.70 4,512.95 512.75 515,252.48 93.7% 10.50% 100 515,252.48 5,025.70 4,508.46 517.24 514,735.24 93.6% 10.50% 101 514,735.24 5,025.70 4,503.93 521.76 514,213.48 93.5% 10.50% 102 514,213.48 5,025.70 4,499.37 526.33 513,687.15 93.4% 10.50% 103 513,687.15 5,025.70 4,494.76 530.93 513,156.22 93.3% 10.50% 104 513,156.22 5,025.70 4,490.12 535.58 512,620.64 93.2% 10.50% 105 512,620.64 5,025.70 4,485.43 540.27 512,080.37 93.1% 10.50% 106 512,080.37 5,025.70 4,480.70 544.99 511,535.38 93.0% 10.50% 107 511,535.38 5,025.70 4,475.93 549.76 510,985.61 92.9% 10.50% 108 510,985.61 5,025.70 4,471.12 554.57 510,431.04 92.8% 10.50% 109 510,431.04 5,025.70 4,466.27 559.43 509,871.61 92.7% 10.50% 110 509,871.61 5,025.70 4,461.38 564.32 509,307.29 92.6% 10.50% 111 509,307.29 5,025.70 4,456.44 569.26 508,738.04 92.5% 10.50% 112 508,738.04 5,025.70 4,451.46 574.24 508,163.80 92.4% 10.50% 113 508,163.80 5,025.70 4,446.43 579.26 507,584.53 92.3% 10.50% 114 507,584.53 5,025.70 4,441.36 584.33 507,000.20 92.2% 10.50% 115 507,000.20 5,025.70 4,436.25 589.45 506,410.75 92.1% 10.50% 116 506,410.75 5,025.70 4,431.09 594.60 505,816.15 92.0% 10.50% 117 505,816.15 5,025.70 4,425.89 599.81 505,216.35 91.9% 10.50% 118 505,216.35 5,025.70 4,420.64 605.05 504,611.29 91.7% 10.50% 119 504,611.29 5,025.70 4,415.35 610.35 504,000.94 91.6% 10.50% 120 504,000.94 5,025.70 4,410.01 615.69 503,385.25 91.5% 10.50% 121 503,385.25 5,025.70 4,404.62 621.08 502,764.18 91.4% 10.50% 122 502,764.18 5,025.70 4,399.19 626.51 502,137.67 91.3% 10.50% 123 502,137.67 5,025.70 4,393.70 631.99 501,505.68 91.2% 10.50% 124 501,505.68 5,025.70 4,388.17 637.52 500,868.15 91.1% 10.50% Page 2 of 8 Loan Amortization Table www.excel-skills.com Loan Principle Amount Annual Interest Rate Loan Period (in months) Original Repayment Amount Repayment Number 550,000.00 3.75% 360.00 2,547.14 Opening Balance Loan Repayment Interest Charged Capital Repaid Closing Balance % Capital Outstanding Interest Rate 125 500,868.15 5,025.70 4,382.60 643.10 500,225.05 91.0% 10.50% 126 500,225.05 5,025.70 4,376.97 648.73 499,576.32 90.8% 10.50% 127 499,576.32 5,025.70 4,371.29 654.40 498,921.92 90.7% 10.50% 128 498,921.92 5,025.70 4,365.57 660.13 498,261.79 90.6% 10.50% 129 498,261.79 5,025.70 4,359.79 665.91 497,595.88 90.5% 10.50% 130 497,595.88 5,025.70 4,353.96 671.73 496,924.15 90.3% 10.50% 131 496,924.15 5,025.70 4,348.09 677.61 496,246.54 90.2% 10.50% 132 496,246.54 5,025.70 4,342.16 683.54 495,563.00 90.1% 10.50% 133 495,563.00 5,025.70 4,336.18 689.52 494,873.48 90.0% 10.50% 134 494,873.48 5,025.70 4,330.14 695.55 494,177.92 89.9% 10.50% 135 494,177.92 5,025.70 4,324.06 701.64 493,476.28 89.7% 10.50% 136 493,476.28 5,025.70 4,317.92 707.78 492,768.50 89.6% 10.50% 137 492,768.50 5,025.70 4,311.72 713.97 492,054.53 89.5% 10.50% 138 492,054.53 5,025.70 4,305.48 720.22 491,334.31 89.3% 10.50% 139 491,334.31 5,025.70 4,299.18 726.52 490,607.79 89.2% 10.50% 140 490,607.79 5,025.70 4,292.82 732.88 489,874.91 89.1% 10.50% 141 489,874.91 5,025.70 4,286.41 739.29 489,135.62 88.9% 10.50% 142 489,135.62 5,025.70 4,279.94 745.76 488,389.86 88.8% 10.50% 143 488,389.86 5,025.70 4,273.41 752.29 487,637.57 88.7% 10.50% 144 487,637.57 5,025.70 4,266.83 758.87 486,878.70 88.5% 10.50% 145 486,878.70 5,025.70 4,260.19 765.51 486,113.20 88.4% 10.50% 146 486,113.20 5,025.70 4,253.49 772.21 485,340.99 88.2% 10.50% 147 485,340.99 5,025.70 4,246.73 778.96 484,562.03 88.1% 10.50% 148 484,562.03 5,025.70 4,239.92 785.78 483,776.25 88.0% 10.50% 149 483,776.25 5,025.70 4,233.04 792.65 482,983.59 87.8% 10.50% 150 482,983.59 5,025.70 4,226.11 799.59 482,184.00 87.7% 10.50% 151 482,184.00 5,025.70 4,219.11 806.59 481,377.41 87.5% 10.50% 152 481,377.41 5,025.70 4,212.05 813.64 480,563.77 87.4% 10.50% 153 480,563.77 5,025.70 4,204.93 820.76 479,743.00 87.2% 10.50% 154 479,743.00 5,025.70 4,197.75 827.95 478,915.06 87.1% 10.50% 155 478,915.06 5,025.70 4,190.51 835.19 478,079.87 86.9% 10.50% 156 478,079.87 5,025.70 4,183.20 842.50 477,237.37 86.8% 10.50% 157 477,237.37 5,025.70 4,175.83 849.87 476,387.50 86.6% 10.50% 158 476,387.50 5,025.70 4,168.39 857.31 475,530.19 86.5% 10.50% 159 475,530.19 5,025.70 4,160.89 864.81 474,665.39 86.3% 10.50% 160 474,665.39 5,025.70 4,153.32 872.38 473,793.01 86.1% 10.50% 161 473,793.01 5,025.70 4,145.69 880.01 472,913.00 86.0% 10.50% 162 472,913.00 5,025.70 4,137.99 887.71 472,025.29 85.8% 10.50% 163 472,025.29 5,025.70 4,130.22 895.48 471,129.82 85.7% 10.50% 164 471,129.82 5,025.70 4,122.39 903.31 470,226.51 85.5% 10.50% 165 470,226.51 5,025.70 4,114.48 911.22 469,315.29 85.3% 10.50% 166 469,315.29 5,025.70 4,106.51 919.19 468,396.10 85.2% 10.50% 167 468,396.10 5,025.70 4,098.47 927.23 467,468.87 85.0% 10.50% 168 467,468.87 5,025.70 4,090.35 935.34 466,533.53 84.8% 10.50% 169 466,533.53 5,025.70 4,082.17 943.53 465,590.00 84.7% 10.50% 170 465,590.00 5,025.70 4,073.91 951.78 464,638.21 84.5% 10.50% 171 464,638.21 5,025.70 4,065.58 960.11 463,678.10 84.3% 10.50% 172 463,678.10 5,025.70 4,057.18 968.51 462,709.59 84.1% 10.50% 173 462,709.59 5,025.70 4,048.71 976.99 461,732.60 84.0% 10.50% 174 461,732.60 5,025.70 4,040.16 985.54 460,747.06 83.8% 10.50% 175 460,747.06 5,025.70 4,031.54 994.16 459,752.90 83.6% 10.50% 176 459,752.90 5,025.70 4,022.84 1,002.86 458,750.04 83.4% 10.50% 177 458,750.04 5,025.70 4,014.06 1,011.63 457,738.41 83.2% 10.50% 178 457,738.41 5,025.70 4,005.21 1,020.49 456,717.92 83.0% 10.50% 179 456,717.92 5,025.70 3,996.28 1,029.42 455,688.51 82.9% 10.50% 180 455,688.51 5,025.70 3,987.27 1,038.42 454,650.08 82.7% 10.50% 181 454,650.08 5,025.70 3,978.19 1,047.51 453,602.58 82.5% 10.50% 182 453,602.58 5,025.70 3,969.02 1,056.67 452,545.90 82.3% 10.50% 183 452,545.90 5,025.70 3,959.78 1,065.92 451,479.98 82.1% 10.50% 184 451,479.98 5,025.70 3,950.45 1,075.25 450,404.73 81.9% 10.50% 185 450,404.73 5,025.70 3,941.04 1,084.66 449,320.08 81.7% 10.50% 186 449,320.08 5,025.70 3,931.55 1,094.15 448,225.93 81.5% 10.50% Page 3 of 8 Loan Amortization Table www.excel-skills.com Loan Principle Amount Annual Interest Rate Loan Period (in months) Original Repayment Amount Repayment Number 550,000.00 3.75% 360.00 2,547.14 Opening Balance Loan Repayment Interest Charged Capital Repaid Closing Balance % Capital Outstanding Interest Rate 187 448,225.93 5,025.70 3,921.98 1,103.72 447,122.21 81.3% 10.50% 188 447,122.21 5,025.70 3,912.32 1,113.38 446,008.83 81.1% 10.50% 189 446,008.83 5,025.70 3,902.58 1,123.12 444,885.71 80.9% 10.50% 190 444,885.71 5,025.70 3,892.75 1,132.95 443,752.77 80.7% 10.50% 191 443,752.77 5,025.70 3,882.84 1,142.86 442,609.91 80.5% 10.50% 192 442,609.91 5,025.70 3,872.84 1,152.86 441,457.04 80.3% 10.50% 193 441,457.04 5,025.70 3,862.75 1,162.95 440,294.10 80.1% 10.50% 194 440,294.10 5,025.70 3,852.57 1,173.12 439,120.97 79.8% 10.50% 195 439,120.97 5,025.70 3,842.31 1,183.39 437,937.58 79.6% 10.50% 196 437,937.58 5,025.70 3,831.95 1,193.74 436,743.84 79.4% 10.50% 197 436,743.84 5,025.70 3,821.51 1,204.19 435,539.65 79.2% 10.50% 198 435,539.65 5,025.70 3,810.97 1,214.73 434,324.93 79.0% 10.50% 199 434,324.93 5,025.70 3,800.34 1,225.35 433,099.57 78.7% 10.50% 200 433,099.57 5,025.70 3,789.62 1,236.08 431,863.50 78.5% 10.50% 201 431,863.50 5,025.70 3,778.81 1,246.89 430,616.61 78.3% 10.50% 202 430,616.61 5,025.70 3,767.90 1,257.80 429,358.80 78.1% 10.50% 203 429,358.80 5,025.70 3,756.89 1,268.81 428,090.00 77.8% 10.50% 204 428,090.00 5,025.70 3,745.79 1,279.91 426,810.09 77.6% 10.50% 205 426,810.09 5,025.70 3,734.59 1,291.11 425,518.98 77.4% 10.50% 206 425,518.98 5,025.70 3,723.29 1,302.41 424,216.57 77.1% 10.50% 207 424,216.57 5,025.70 3,711.90 1,313.80 422,902.77 76.9% 10.50% 208 422,902.77 5,025.70 3,700.40 1,325.30 421,577.47 76.7% 10.50% 209 421,577.47 5,025.70 3,688.80 1,336.89 420,240.58 76.4% 10.50% 210 420,240.58 5,025.70 3,677.11 1,348.59 418,891.99 76.2% 10.50% 211 418,891.99 5,025.70 3,665.30 1,360.39 417,531.59 75.9% 10.50% 212 417,531.59 5,025.70 3,653.40 1,372.30 416,159.30 75.7% 10.50% 213 416,159.30 5,025.70 3,641.39 1,384.30 414,774.99 75.4% 10.50% 214 414,774.99 5,025.70 3,629.28 1,396.42 413,378.58 75.2% 10.50% 215 413,378.58 5,025.70 3,617.06 1,408.63 411,969.94 74.9% 10.50% 216 411,969.94 5,025.70 3,604.74 1,420.96 410,548.98 74.6% 10.50% 217 410,548.98 5,025.70 3,592.30 1,433.39 409,115.59 74.4% 10.50% 218 409,115.59 5,025.70 3,579.76 1,445.94 407,669.65 74.1% 10.50% 219 407,669.65 5,025.70 3,567.11 1,458.59 406,211.07 73.9% 10.50% 220 406,211.07 5,025.70 3,554.35 1,471.35 404,739.72 73.6% 10.50% 221 404,739.72 5,025.70 3,541.47 1,484.22 403,255.49 73.3% 10.50% 222 403,255.49 5,025.70 3,528.49 1,497.21 401,758.28 73.0% 10.50% 223 401,758.28 5,025.70 3,515.38 1,510.31 400,247.97 72.8% 10.50% 224 400,247.97 5,025.70 3,502.17 1,523.53 398,724.44 72.5% 10.50% 225 398,724.44 5,025.70 3,488.84 1,536.86 397,187.58 72.2% 10.50% 226 397,187.58 5,025.70 3,475.39 1,550.31 395,637.28 71.9% 10.50% 227 395,637.28 5,025.70 3,461.83 1,563.87 394,073.41 71.6% 10.50% 228 394,073.41 5,025.70 3,448.14 1,577.55 392,495.85 71.4% 10.50% 229 392,495.85 5,025.70 3,434.34 1,591.36 390,904.49 71.1% 10.50% 230 390,904.49 5,025.70 3,420.41 1,605.28 389,299.21 70.8% 10.50% 231 389,299.21 5,025.70 3,406.37 1,619.33 387,679.88 70.5% 10.50% 232 387,679.88 5,025.70 3,392.20 1,633.50 386,046.38 70.2% 10.50% 233 386,046.38 5,025.70 3,377.91 1,647.79 384,398.59 69.9% 10.50% 234 384,398.59 5,025.70 3,363.49 1,662.21 382,736.38 69.6% 10.50% 235 382,736.38 5,025.70 3,348.94 1,676.75 381,059.63 69.3% 10.50% 236 381,059.63 5,025.70 3,334.27 1,691.43 379,368.20 69.0% 10.50% 237 379,368.20 5,025.70 3,319.47 1,706.23 377,661.98 68.7% 10.50% 238 377,661.98 5,025.70 3,304.54 1,721.15 375,940.82 68.4% 10.50% 239 375,940.82 5,025.70 3,289.48 1,736.21 374,204.61 68.0% 10.50% 240 374,204.61 5,025.70 3,274.29 1,751.41 372,453.20 67.7% 10.50% 241 372,453.20 5,025.70 3,258.97 1,766.73 370,686.47 67.4% 10.50% 242 370,686.47 5,025.70 3,243.51 1,782.19 368,904.28 67.1% 10.50% 243 368,904.28 5,025.70 3,227.91 1,797.78 367,106.49 66.7% 10.50% 244 367,106.49 5,025.70 3,212.18 1,813.52 365,292.98 66.4% 10.50% 245 365,292.98 5,025.70 3,196.31 1,829.38 363,463.59 66.1% 10.50% 246 363,463.59 5,025.70 3,180.31 1,845.39 361,618.20 65.7% 10.50% 247 361,618.20 5,025.70 3,164.16 1,861.54 359,756.67 65.4% 10.50% 248 359,756.67 5,025.70 3,147.87 1,877.83 357,878.84 65.1% 10.50% Page 4 of 8 Loan Amortization Table www.excel-skills.com Loan Principle Amount Annual Interest Rate Loan Period (in months) Original Repayment Amount Repayment Number 550,000.00 3.75% 360.00 2,547.14 Opening Balance Loan Repayment Interest Charged Capital Repaid Closing Balance % Capital Outstanding Interest Rate 249 357,878.84 5,025.70 3,131.44 1,894.26 355,984.58 64.7% 10.50% 250 355,984.58 5,025.70 3,114.87 1,910.83 354,073.75 64.4% 10.50% 251 354,073.75 5,025.70 3,098.15 1,927.55 352,146.20 64.0% 10.50% 252 352,146.20 5,025.70 3,081.28 1,944.42 350,201.78 63.7% 10.50% 253 350,201.78 5,025.70 3,064.27 1,961.43 348,240.35 63.3% 10.50% 254 348,240.35 5,025.70 3,047.10 1,978.59 346,261.75 63.0% 10.50% 255 346,261.75 5,025.70 3,029.79 1,995.91 344,265.85 62.6% 10.50% 256 344,265.85 5,025.70 3,012.33 2,013.37 342,252.48 62.2% 10.50% 257 342,252.48 5,025.70 2,994.71 2,030.99 340,221.49 61.9% 10.50% 258 340,221.49 5,025.70 2,976.94 2,048.76 338,172.73 61.5% 10.50% 259 338,172.73 5,025.70 2,959.01 2,066.69 336,106.04 61.1% 10.50% 260 336,106.04 5,025.70 2,940.93 2,084.77 334,021.28 60.7% 10.50% 261 334,021.28 5,025.70 2,922.69 2,103.01 331,918.26 60.3% 10.50% 262 331,918.26 5,025.70 2,904.28 2,121.41 329,796.85 60.0% 10.50% 263 329,796.85 5,025.70 2,885.72 2,139.97 327,656.88 59.6% 10.50% 264 327,656.88 5,025.70 2,867.00 2,158.70 325,498.18 59.2% 10.50% 265 325,498.18 5,025.70 2,848.11 2,177.59 323,320.59 58.8% 10.50% 266 323,320.59 5,025.70 2,829.06 2,196.64 321,123.95 58.4% 10.50% 267 321,123.95 5,025.70 2,809.83 2,215.86 318,908.09 58.0% 10.50% 268 318,908.09 5,025.70 2,790.45 2,235.25 316,672.83 57.6% 10.50% 269 316,672.83 5,025.70 2,770.89 2,254.81 314,418.02 57.2% 10.50% 270 314,418.02 5,025.70 2,751.16 2,274.54 312,143.48 56.8% 10.50% 271 312,143.48 5,025.70 2,731.26 2,294.44 309,849.04 56.3% 10.50% 272 309,849.04 5,025.70 2,711.18 2,314.52 307,534.52 55.9% 10.50% 273 307,534.52 5,025.70 2,690.93 2,334.77 305,199.75 55.5% 10.50% 274 305,199.75 5,025.70 2,670.50 2,355.20 302,844.56 55.1% 10.50% 275 302,844.56 5,025.70 2,649.89 2,375.81 300,468.75 54.6% 10.50% 276 300,468.75 5,025.70 2,629.10 2,396.60 298,072.15 54.2% 10.50% 277 298,072.15 5,025.70 2,608.13 2,417.57 295,654.59 53.8% 10.50% 278 295,654.59 5,025.70 2,586.98 2,438.72 293,215.87 53.3% 10.50% 279 293,215.87 5,025.70 2,565.64 2,460.06 290,755.81 52.9% 10.50% 280 290,755.81 5,025.70 2,544.11 2,481.58 288,274.23 52.4% 10.50% 281 288,274.23 5,025.70 2,522.40 2,503.30 285,770.93 52.0% 10.50% 282 285,770.93 5,025.70 2,500.50 2,525.20 283,245.73 51.5% 10.50% 283 283,245.73 5,025.70 2,478.40 2,547.30 280,698.43 51.0% 10.50% 284 280,698.43 5,025.70 2,456.11 2,569.59 278,128.84 50.6% 10.50% 285 278,128.84 5,025.70 2,433.63 2,592.07 275,536.77 50.1% 10.50% 286 275,536.77 5,025.70 2,410.95 2,614.75 272,922.02 49.6% 10.50% 287 272,922.02 5,025.70 2,388.07 2,637.63 270,284.39 49.1% 10.50% 288 270,284.39 5,025.70 2,364.99 2,660.71 267,623.68 48.7% 10.50% 289 267,623.68 5,025.70 2,341.71 2,683.99 264,939.69 48.2% 10.50% 290 264,939.69 5,025.70 2,318.22 2,707.47 262,232.22 47.7% 10.50% 291 262,232.22 5,025.70 2,294.53 2,731.17 259,501.05 47.2% 10.50% 292 259,501.05 5,025.70 2,270.63 2,755.06 256,745.99 46.7% 10.50% 293 256,745.99 5,025.70 2,246.53 2,779.17 253,966.82 46.2% 10.50% 294 253,966.82 5,025.70 2,222.21 2,803.49 251,163.33 45.7% 10.50% 295 251,163.33 5,025.70 2,197.68 2,828.02 248,335.32 45.2% 10.50% 296 248,335.32 5,025.70 2,172.93 2,852.76 245,482.55 44.6% 10.50% 297 245,482.55 5,025.70 2,147.97 2,877.72 242,604.83 44.1% 10.50% 298 242,604.83 5,025.70 2,122.79 2,902.90 239,701.92 43.6% 10.50% 299 239,701.92 5,025.70 2,097.39 2,928.31 236,773.62 43.0% 10.50% 300 236,773.62 5,025.70 2,071.77 2,953.93 233,819.69 42.5% 10.50% 301 233,819.69 5,025.70 2,045.92 2,979.77 230,839.92 42.0% 10.50% 302 230,839.92 5,025.70 2,019.85 3,005.85 227,834.07 41.4% 10.50% 303 227,834.07 5,025.70 1,993.55 3,032.15 224,801.92 40.9% 10.50% 304 224,801.92 5,025.70 1,967.02 3,058.68 221,743.24 40.3% 10.50% 305 221,743.24 5,025.70 1,940.25 3,085.44 218,657.79 39.8% 10.50% 306 218,657.79 5,025.70 1,913.26 3,112.44 215,545.35 39.2% 10.50% 307 215,545.35 5,025.70 1,886.02 3,139.68 212,405.68 38.6% 10.50% 308 212,405.68 5,025.70 1,858.55 3,167.15 209,238.53 38.0% 10.50% 309 209,238.53 5,025.70 1,830.84 3,194.86 206,043.67 37.5% 10.50% 310 206,043.67 5,025.70 1,802.88 3,222.82 202,820.86 36.9% 10.50% Page 5 of 8 Loan Amortization Table www.excel-skills.com Loan Principle Amount Annual Interest Rate Loan Period (in months) Original Repayment Amount Repayment Number 550,000.00 3.75% 360.00 2,547.14 Opening Balance Loan Repayment Interest Charged Capital Repaid Closing Balance % Capital Outstanding Interest Rate 311 202,820.86 5,025.70 1,774.68 3,251.01 199,569.84 36.3% 10.50% 312 199,569.84 5,025.70 1,746.24 3,279.46 196,290.38 35.7% 10.50% 313 196,290.38 5,025.70 1,717.54 3,308.16 192,982.22 35.1% 10.50% 314 192,982.22 5,025.70 1,688.59 3,337.10 189,645.12 34.5% 10.50% 315 189,645.12 5,025.70 1,659.39 3,366.30 186,278.82 33.9% 10.50% 316 186,278.82 5,025.70 1,629.94 3,395.76 182,883.06 33.3% 10.50% 317 182,883.06 5,025.70 1,600.23 3,425.47 179,457.59 32.6% 10.50% 318 179,457.59 5,025.70 1,570.25 3,455.44 176,002.15 32.0% 10.50% 319 176,002.15 5,025.70 1,540.02 3,485.68 172,516.47 31.4% 10.50% 320 172,516.47 5,025.70 1,509.52 3,516.18 169,000.29 30.7% 10.50% 321 169,000.29 5,025.70 1,478.75 3,546.94 165,453.35 30.1% 10.50% 322 165,453.35 5,025.70 1,447.72 3,577.98 161,875.37 29.4% 10.50% 323 161,875.37 5,025.70 1,416.41 3,609.29 158,266.08 28.8% 10.50% 324 158,266.08 5,025.70 1,384.83 3,640.87 154,625.21 28.1% 10.50% 325 154,625.21 5,025.70 1,352.97 3,672.73 150,952.48 27.4% 10.50% 326 150,952.48 5,025.70 1,320.83 3,704.86 147,247.62 26.8% 10.50% 327 147,247.62 5,025.70 1,288.42 3,737.28 143,510.34 26.1% 10.50% 328 143,510.34 5,025.70 1,255.72 3,769.98 139,740.36 25.4% 10.50% 329 139,740.36 5,025.70 1,222.73 3,802.97 135,937.39 24.7% 10.50% 330 135,937.39 5,025.70 1,189.45 3,836.24 132,101.14 24.0% 10.50% 331 132,101.14 5,025.70 1,155.89 3,869.81 128,231.33 23.3% 10.50% 332 128,231.33 5,025.70 1,122.02 3,903.67 124,327.66 22.6% 10.50% 333 124,327.66 5,025.70 1,087.87 3,937.83 120,389.83 21.9% 10.50% 334 120,389.83 5,025.70 1,053.41 3,972.29 116,417.54 21.2% 10.50% 335 116,417.54 5,025.70 1,018.65 4,007.04 112,410.50 20.4% 10.50% 336 112,410.50 5,025.70 983.59 4,042.11 108,368.39 19.7% 10.50% 337 108,368.39 5,025.70 948.22 4,077.47 104,290.92 19.0% 10.50% 338 104,290.92 5,025.70 912.55 4,113.15 100,177.77 18.2% 10.50% 339 100,177.77 5,025.70 876.56 4,149.14 96,028.63 17.5% 10.50% 340 96,028.63 5,025.70 840.25 4,185.45 91,843.18 16.7% 10.50% 341 91,843.18 5,025.70 803.63 4,222.07 87,621.11 15.9% 10.50% 342 87,621.11 5,025.70 766.68 4,259.01 83,362.10 15.2% 10.50% 343 83,362.10 5,025.70 729.42 4,296.28 79,065.82 14.4% 10.50% 344 79,065.82 5,025.70 691.83 4,333.87 74,731.95 13.6% 10.50% 345 74,731.95 5,025.70 653.90 4,371.79 70,360.16 12.8% 10.50% 346 70,360.16 5,025.70 615.65 4,410.05 65,950.11 12.0% 10.50% 347 65,950.11 5,025.70 577.06 4,448.63 61,501.48 11.2% 10.50% 348 61,501.48 5,025.70 538.14 4,487.56 57,013.92 10.4% 10.50% 349 57,013.92 5,025.70 498.87 4,526.83 52,487.09 9.5% 10.50% 350 52,487.09 5,025.70 459.26 4,566.44 47,920.66 8.7% 10.50% 351 47,920.66 5,025.70 419.31 4,606.39 43,314.27 7.9% 10.50% 352 43,314.27 5,025.70 379.00 4,646.70 38,667.57 7.0% 10.50% 353 38,667.57 5,025.70 338.34 4,687.36 33,980.21 6.2% 10.50% 354 33,980.21 5,025.70 297.33 4,728.37 29,251.84 5.3% 10.50% 355 29,251.84 5,025.70 255.95 4,769.74 24,482.10 4.5% 10.50% 356 24,482.10 5,025.70 214.22 4,811.48 19,670.62 3.6% 10.50% 357 19,670.62 5,025.70 172.12 4,853.58 14,817.04 2.7% 10.50% 358 14,817.04 5,025.70 129.65 4,896.05 9,920.99 1.8% 10.50% 359 9,920.99 5,025.70 86.81 4,938.89 4,982.10 0.9% 10.50% 360 4,982.10 5,025.70 43.59 4,982.10 0.0% 10.50% 1,804,839.98 1,254,839.98 550,000.00 Page 6 of 8 - Potential gross income (PGI) 2*1,800*12 1*3,600*12 5*1560*12 Total PGI Vacancy 10% of PGI Effective gross income Operating expense 40% of EGI Capital expenditure 5% of EGI Net operating income Debt service After Debt service Cash flow Discount rate (1+r)^-n Year 1 Year 2 Year 3 Year 4 7,200 7416 7638.48 7867.6344 7,200 7416 7638.48 7867.6344 93,600 96408 99300.24 102279.2472 108,000 111240 114577.2 118014.516 10800 11124 11457.72 11801.4516 97,200 100116 103119.48 106213.0644 38880 40046.4 41247.792 42485.22576 4860 5005.8 5155.974 5310.65322 53,460 55063.8 56715.714 58417.18542 60,649 60,649 60,649 60,649 -7,189 -5,585 -3,933 -2,232 0.939 0.8817 0.8278 0.7773 Discounted after debt service cash flow -6750.471 -4924.47084 -3255.974151 -1734.789473 Year 5 8103.663432 8103.663432 105347.6246 121554.9515 12155.49515 109399.4563 43759.78253 5469.972817 60169.70098 60,649 -479 0.7299 -349.8403528 SPREADSHEET FOR ANALYZING MORTGAGE LOANS You need to specify only the numbers shown in red. The machine will do the rest. L $550,000 Mortgage loan Y 30 Years (can be up to 30 years in this program) M 360 Months (calculated by program) RATE 3.75% Annual borrowing rate (A.P.R.) i 0.31% Monthly borrowing rate (calculated by program) PMT $2,547.14 Monthly mortgage payment (calculated by pgm.) AMORTIZATION TABLE FOR A MORTGAGE LOAN (SCROLL DOWN) Disregard any row row past the number of months for this deal DEBT STILL OWED INTEREST DUE PAYMENT DUE REPAYMENT OF DEBT AT BEGINNING OF AT THE END OF AT THE END OF WITH THIS PERIOD'S THE PERIOD THE PERIOD THE PERIOD PAYMENT (1) (2) (3) = i x (2) (4) (5) = (4) - (3) 1 2 3 $550,000.00 $549,171.61 $548,340.64 $1,718.75 $1,716.16 $1,713.56 $2,547.14 $2,547.14 $2,547.14 $828.39 $830.97 $833.57 4 5 $547,507.07 $546,670.89 $1,710.96 $1,708.35 $2,547.14 $2,547.14 $836.18 $838.79 MONTH 6 7 8 9 $545,832.10 $544,990.69 $544,146.65 $543,299.98 $1,705.73 $1,703.10 $1,700.46 $1,697.81 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $841.41 $844.04 $846.68 $849.32 10 11 $542,450.65 $541,598.67 $1,695.16 $1,692.50 $2,547.14 $2,547.14 $851.98 $854.64 12 13 14 $540,744.03 $539,886.72 $539,026.73 $1,689.83 $1,687.15 $1,684.46 $2,547.14 $2,547.14 $2,547.14 $857.31 $859.99 $862.68 15 16 $538,164.06 $537,298.68 $1,681.76 $1,679.06 $2,547.14 $2,547.14 $865.37 $868.08 17 18 19 $536,430.61 $535,559.82 $534,686.31 $1,676.35 $1,673.62 $1,670.89 $2,547.14 $2,547.14 $2,547.14 $870.79 $873.51 $876.24 20 21 $533,810.06 $532,931.08 $1,668.16 $1,665.41 $2,547.14 $2,547.14 $878.98 $881.73 22 23 24 $532,049.36 $531,164.88 $530,277.63 $1,662.65 $1,659.89 $1,657.12 $2,547.14 $2,547.14 $2,547.14 $884.48 $887.25 $890.02 25 26 $529,387.61 $528,494.81 $1,654.34 $1,651.55 $2,547.14 $2,547.14 $892.80 $895.59 27 28 29 $527,599.22 $526,700.84 $525,799.64 $1,648.75 $1,645.94 $1,643.12 $2,547.14 $2,547.14 $2,547.14 $898.39 $901.20 $904.01 30 31 32 33 $524,895.63 $523,988.79 $523,079.12 $522,166.61 $1,640.30 $1,637.46 $1,634.62 $1,631.77 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $906.84 $909.67 $912.51 $915.37 34 35 36 37 $521,251.24 $520,333.02 $519,411.92 $518,487.95 $1,628.91 $1,626.04 $1,623.16 $1,620.27 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $918.23 $921.10 $923.97 $926.86 38 39 $517,561.09 $516,631.33 $1,617.38 $1,614.47 $2,547.14 $2,547.14 $929.76 $932.66 40 41 42 $515,698.67 $514,763.09 $513,824.59 $1,611.56 $1,608.63 $1,605.70 $2,547.14 $2,547.14 $2,547.14 $935.58 $938.50 $941.43 43 44 $512,883.15 $511,938.78 $1,602.76 $1,599.81 $2,547.14 $2,547.14 $944.38 $947.33 45 46 47 $510,991.45 $510,041.16 $509,087.91 $1,596.85 $1,593.88 $1,590.90 $2,547.14 $2,547.14 $2,547.14 $950.29 $953.26 $956.24 48 49 $508,131.67 $507,172.45 $1,587.91 $1,584.91 $2,547.14 $2,547.14 $959.22 $962.22 50 51 52 $506,210.23 $505,245.00 $504,276.75 $1,581.91 $1,578.89 $1,575.86 $2,547.14 $2,547.14 $2,547.14 $965.23 $968.25 $971.27 53 54 $503,305.48 $502,331.17 $1,572.83 $1,569.78 $2,547.14 $2,547.14 $974.31 $977.35 55 56 57 $501,353.82 $500,373.42 $499,389.95 $1,566.73 $1,563.67 $1,560.59 $2,547.14 $2,547.14 $2,547.14 $980.41 $983.47 $986.54 58 59 60 61 $498,403.41 $497,413.78 $496,421.06 $495,425.24 $1,557.51 $1,554.42 $1,551.32 $1,548.20 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $989.63 $992.72 $995.82 $998.93 62 63 64 65 $494,426.31 $493,424.26 $492,419.07 $491,410.75 $1,545.08 $1,541.95 $1,538.81 $1,535.66 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,002.05 $1,005.18 $1,008.33 $1,011.48 66 67 $490,399.27 $489,384.63 $1,532.50 $1,529.33 $2,547.14 $2,547.14 $1,014.64 $1,017.81 68 69 70 $488,366.82 $487,345.83 $486,321.65 $1,526.15 $1,522.96 $1,519.76 $2,547.14 $2,547.14 $2,547.14 $1,020.99 $1,024.18 $1,027.38 71 72 $485,294.27 $484,263.68 $1,516.54 $1,513.32 $2,547.14 $2,547.14 $1,030.59 $1,033.81 73 74 75 $483,229.87 $482,192.83 $481,152.55 $1,510.09 $1,506.85 $1,503.60 $2,547.14 $2,547.14 $2,547.14 $1,037.04 $1,040.28 $1,043.53 76 77 $480,109.01 $479,062.22 $1,500.34 $1,497.07 $2,547.14 $2,547.14 $1,046.80 $1,050.07 78 79 80 $478,012.15 $476,958.80 $475,902.16 $1,493.79 $1,490.50 $1,487.19 $2,547.14 $2,547.14 $2,547.14 $1,053.35 $1,056.64 $1,059.94 81 82 $474,842.22 $473,778.97 $1,483.88 $1,480.56 $2,547.14 $2,547.14 $1,063.25 $1,066.58 83 84 85 $472,712.39 $471,642.48 $470,569.23 $1,477.23 $1,473.88 $1,470.53 $2,547.14 $2,547.14 $2,547.14 $1,069.91 $1,073.25 $1,076.61 86 87 88 89 $469,492.62 $468,412.65 $467,329.30 $466,242.57 $1,467.16 $1,463.79 $1,460.40 $1,457.01 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,079.97 $1,083.35 $1,086.73 $1,090.13 90 91 92 93 $465,152.44 $464,058.91 $462,961.96 $461,861.58 $1,453.60 $1,450.18 $1,446.76 $1,443.32 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,093.53 $1,096.95 $1,100.38 $1,103.82 94 95 $460,757.76 $459,650.49 $1,439.87 $1,436.41 $2,547.14 $2,547.14 $1,107.27 $1,110.73 96 97 98 $458,539.77 $457,425.57 $456,307.89 $1,432.94 $1,429.45 $1,425.96 $2,547.14 $2,547.14 $2,547.14 $1,114.20 $1,117.68 $1,121.17 99 100 $455,186.71 $454,062.03 $1,422.46 $1,418.94 $2,547.14 $2,547.14 $1,124.68 $1,128.19 101 102 103 $452,933.84 $451,802.13 $450,666.87 $1,415.42 $1,411.88 $1,408.33 $2,547.14 $2,547.14 $2,547.14 $1,131.72 $1,135.25 $1,138.80 104 105 $449,528.07 $448,385.71 $1,404.78 $1,401.21 $2,547.14 $2,547.14 $1,142.36 $1,145.93 106 107 108 $447,239.78 $446,090.27 $444,937.16 $1,397.62 $1,394.03 $1,390.43 $2,547.14 $2,547.14 $2,547.14 $1,149.51 $1,153.10 $1,156.71 109 110 $443,780.46 $442,620.13 $1,386.81 $1,383.19 $2,547.14 $2,547.14 $1,160.32 $1,163.95 111 112 113 $441,456.19 $440,288.60 $439,117.37 $1,379.55 $1,375.90 $1,372.24 $2,547.14 $2,547.14 $2,547.14 $1,167.59 $1,171.23 $1,174.89 114 115 116 117 $437,942.47 $436,763.91 $435,581.66 $434,395.72 $1,368.57 $1,364.89 $1,361.19 $1,357.49 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,178.57 $1,182.25 $1,185.94 $1,189.65 118 119 120 121 $433,206.07 $432,012.70 $430,815.60 $429,614.77 $1,353.77 $1,350.04 $1,346.30 $1,342.55 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,193.37 $1,197.10 $1,200.84 $1,204.59 122 123 $428,410.18 $427,201.82 $1,338.78 $1,335.01 $2,547.14 $2,547.14 $1,208.35 $1,212.13 124 125 126 $425,989.69 $424,773.78 $423,554.06 $1,331.22 $1,327.42 $1,323.61 $2,547.14 $2,547.14 $2,547.14 $1,215.92 $1,219.72 $1,223.53 127 128 $422,330.53 $421,103.18 $1,319.78 $1,315.95 $2,547.14 $2,547.14 $1,227.35 $1,231.19 129 130 131 $419,871.99 $418,636.95 $417,398.06 $1,312.10 $1,308.24 $1,304.37 $2,547.14 $2,547.14 $2,547.14 $1,235.04 $1,238.90 $1,242.77 132 133 $416,155.29 $414,908.64 $1,300.49 $1,296.59 $2,547.14 $2,547.14 $1,246.65 $1,250.55 134 135 136 $413,658.09 $412,403.64 $411,145.26 $1,292.68 $1,288.76 $1,284.83 $2,547.14 $2,547.14 $2,547.14 $1,254.45 $1,258.37 $1,262.31 137 138 $409,882.96 $408,616.71 $1,280.88 $1,276.93 $2,547.14 $2,547.14 $1,266.25 $1,270.21 139 140 141 $407,346.50 $406,072.32 $404,794.16 $1,272.96 $1,268.98 $1,264.98 $2,547.14 $2,547.14 $2,547.14 $1,274.18 $1,278.16 $1,282.15 142 143 144 145 $403,512.01 $402,225.84 $400,935.66 $399,641.45 $1,260.98 $1,256.96 $1,252.92 $1,248.88 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,286.16 $1,290.18 $1,294.21 $1,298.26 146 147 148 149 $398,343.20 $397,040.88 $395,734.50 $394,424.04 $1,244.82 $1,240.75 $1,236.67 $1,232.58 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,302.31 $1,306.38 $1,310.47 $1,314.56 150 151 $393,109.47 $391,790.81 $1,228.47 $1,224.35 $2,547.14 $2,547.14 $1,318.67 $1,322.79 152 153 154 $390,468.02 $389,141.09 $387,810.02 $1,220.21 $1,216.07 $1,211.91 $2,547.14 $2,547.14 $2,547.14 $1,326.92 $1,331.07 $1,335.23 155 156 $386,474.79 $385,135.39 $1,207.73 $1,203.55 $2,547.14 $2,547.14 $1,339.40 $1,343.59 157 158 159 $383,791.80 $382,444.02 $381,092.02 $1,199.35 $1,195.14 $1,190.91 $2,547.14 $2,547.14 $2,547.14 $1,347.79 $1,352.00 $1,356.22 160 161 $379,735.80 $378,375.34 $1,186.67 $1,182.42 $2,547.14 $2,547.14 $1,360.46 $1,364.71 162 163 164 $377,010.62 $375,641.64 $374,268.39 $1,178.16 $1,173.88 $1,169.59 $2,547.14 $2,547.14 $2,547.14 $1,368.98 $1,373.26 $1,377.55 165 166 $372,890.84 $371,508.99 $1,165.28 $1,160.97 $2,547.14 $2,547.14 $1,381.85 $1,386.17 167 168 169 $370,122.82 $368,732.32 $367,337.47 $1,156.63 $1,152.29 $1,147.93 $2,547.14 $2,547.14 $2,547.14 $1,390.50 $1,394.85 $1,399.21 170 171 172 173 $365,938.26 $364,534.69 $363,126.72 $361,714.36 $1,143.56 $1,139.17 $1,134.77 $1,130.36 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,403.58 $1,407.96 $1,412.36 $1,416.78 174 175 176 177 $360,297.58 $358,876.37 $357,450.73 $356,020.62 $1,125.93 $1,121.49 $1,117.03 $1,112.56 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,421.21 $1,425.65 $1,430.10 $1,434.57 178 179 $354,586.05 $353,147.00 $1,108.08 $1,103.58 $2,547.14 $2,547.14 $1,439.05 $1,443.55 180 181 182 $351,703.45 $350,255.38 $348,802.80 $1,099.07 $1,094.55 $1,090.01 $2,547.14 $2,547.14 $2,547.14 $1,448.06 $1,452.59 $1,457.13 183 184 $347,345.67 $345,883.99 $1,085.46 $1,080.89 $2,547.14 $2,547.14 $1,461.68 $1,466.25 185 186 187 $344,417.74 $342,946.91 $341,471.48 $1,076.31 $1,071.71 $1,067.10 $2,547.14 $2,547.14 $2,547.14 $1,470.83 $1,475.43 $1,480.04 188 189 $339,991.45 $338,506.78 $1,062.47 $1,057.83 $2,547.14 $2,547.14 $1,484.66 $1,489.30 190 191 192 $337,017.48 $335,523.52 $334,024.90 $1,053.18 $1,048.51 $1,043.83 $2,547.14 $2,547.14 $2,547.14 $1,493.96 $1,498.62 $1,503.31 193 194 $332,521.59 $331,013.59 $1,039.13 $1,034.42 $2,547.14 $2,547.14 $1,508.01 $1,512.72 195 196 197 $329,500.87 $327,983.42 $326,461.23 $1,029.69 $1,024.95 $1,020.19 $2,547.14 $2,547.14 $2,547.14 $1,517.45 $1,522.19 $1,526.94 198 199 200 201 $324,934.29 $323,402.57 $321,866.07 $320,324.77 $1,015.42 $1,010.63 $1,005.83 $1,001.01 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,531.72 $1,536.50 $1,541.30 $1,546.12 202 203 204 205 $318,778.65 $317,227.69 $315,671.89 $314,111.23 $996.18 $991.34 $986.47 $981.60 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,550.95 $1,555.80 $1,560.66 $1,565.54 206 207 $312,545.70 $310,975.27 $976.71 $971.80 $2,547.14 $2,547.14 $1,570.43 $1,575.34 208 209 210 $309,399.93 $307,819.67 $306,234.47 $966.87 $961.94 $956.98 $2,547.14 $2,547.14 $2,547.14 $1,580.26 $1,585.20 $1,590.15 211 212 $304,644.31 $303,049.19 $952.01 $947.03 $2,547.14 $2,547.14 $1,595.12 $1,600.11 213 214 215 $301,449.08 $299,843.98 $298,233.85 $942.03 $937.01 $931.98 $2,547.14 $2,547.14 $2,547.14 $1,605.11 $1,610.12 $1,615.15 216 217 $296,618.70 $294,998.50 $926.93 $921.87 $2,547.14 $2,547.14 $1,620.20 $1,625.27 218 219 220 $293,373.23 $291,742.89 $290,107.45 $916.79 $911.70 $906.59 $2,547.14 $2,547.14 $2,547.14 $1,630.34 $1,635.44 $1,640.55 221 222 $288,466.90 $286,821.22 $901.46 $896.32 $2,547.14 $2,547.14 $1,645.68 $1,650.82 223 224 225 $285,170.40 $283,514.42 $281,853.27 $891.16 $885.98 $880.79 $2,547.14 $2,547.14 $2,547.14 $1,655.98 $1,661.15 $1,666.34 226 227 228 229 $280,186.93 $278,515.37 $276,838.60 $275,156.58 $875.58 $870.36 $865.12 $859.86 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,671.55 $1,676.78 $1,682.02 $1,687.27 230 231 232 233 $273,469.31 $271,776.77 $270,078.93 $268,375.80 $854.59 $849.30 $844.00 $838.67 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,692.54 $1,697.83 $1,703.14 $1,708.46 234 235 $266,667.33 $264,953.53 $833.34 $827.98 $2,547.14 $2,547.14 $1,713.80 $1,719.16 236 237 238 $263,234.38 $261,509.85 $259,779.93 $822.61 $817.22 $811.81 $2,547.14 $2,547.14 $2,547.14 $1,724.53 $1,729.92 $1,735.32 239 $258,044.61 $806.39 $2,547.14 $1,740.75 240 $256,303.86 $800.95 $2,547.14 $1,746.19 241 $254,557.68 $795.49 $2,547.14 $1,751.64 242 243 $252,806.03 $251,048.92 $790.02 $784.53 $2,547.14 $2,547.14 $1,757.12 $1,762.61 244 245 246 $249,286.31 $247,518.19 $245,744.55 $779.02 $773.49 $767.95 $2,547.14 $2,547.14 $2,547.14 $1,768.12 $1,773.64 $1,779.18 247 248 $243,965.37 $242,180.62 $762.39 $756.81 $2,547.14 $2,547.14 $1,784.74 $1,790.32 249 250 251 $240,390.30 $238,594.39 $236,792.86 $751.22 $745.61 $739.98 $2,547.14 $2,547.14 $2,547.14 $1,795.92 $1,801.53 $1,807.16 252 253 254 255 256 $234,985.70 $233,172.89 $231,354.42 $229,530.27 $227,700.42 $734.33 $728.67 $722.98 $717.28 $711.56 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,812.81 $1,818.47 $1,824.15 $1,829.85 $1,835.57 257 258 259 260 $225,864.84 $224,023.54 $222,176.47 $220,323.64 $705.83 $700.07 $694.30 $688.51 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,841.31 $1,847.06 $1,852.83 $1,858.62 261 262 $218,465.02 $216,600.58 $682.70 $676.88 $2,547.14 $2,547.14 $1,864.43 $1,870.26 263 264 265 $214,730.32 $212,854.22 $210,972.25 $671.03 $665.17 $659.29 $2,547.14 $2,547.14 $2,547.14 $1,876.10 $1,881.97 $1,887.85 266 267 $209,084.41 $207,190.66 $653.39 $647.47 $2,547.14 $2,547.14 $1,893.75 $1,899.66 268 269 270 $205,290.99 $203,385.39 $201,473.84 $641.53 $635.58 $629.61 $2,547.14 $2,547.14 $2,547.14 $1,905.60 $1,911.56 $1,917.53 271 272 $199,556.31 $197,632.78 $623.61 $617.60 $2,547.14 $2,547.14 $1,923.52 $1,929.53 273 274 275 $195,703.25 $193,767.69 $191,826.08 $611.57 $605.52 $599.46 $2,547.14 $2,547.14 $2,547.14 $1,935.56 $1,941.61 $1,947.68 276 277 $189,878.40 $187,924.63 $593.37 $587.26 $2,547.14 $2,547.14 $1,953.77 $1,959.87 278 279 280 $185,964.76 $183,998.76 $182,026.62 $581.14 $575.00 $568.83 $2,547.14 $2,547.14 $2,547.14 $1,966.00 $1,972.14 $1,978.30 281 282 283 284 $180,048.32 $178,063.84 $176,073.15 $174,076.24 $562.65 $556.45 $550.23 $543.99 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $1,984.48 $1,990.69 $1,996.91 $2,003.15 285 286 287 288 $172,073.10 $170,063.69 $168,048.00 $166,026.02 $537.73 $531.45 $525.15 $518.83 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,009.41 $2,015.69 $2,021.99 $2,028.30 289 290 $163,997.71 $161,963.07 $512.49 $506.13 $2,547.14 $2,547.14 $2,034.64 $2,041.00 291 292 293 $159,922.07 $157,874.69 $155,820.91 $499.76 $493.36 $486.94 $2,547.14 $2,547.14 $2,547.14 $2,047.38 $2,053.78 $2,060.20 294 295 $153,760.72 $151,694.08 $480.50 $474.04 $2,547.14 $2,547.14 $2,066.63 $2,073.09 296 297 298 $149,620.99 $147,541.42 $145,455.35 $467.57 $461.07 $454.55 $2,547.14 $2,547.14 $2,547.14 $2,079.57 $2,086.07 $2,092.59 299 300 $143,362.76 $141,263.64 $448.01 $441.45 $2,547.14 $2,547.14 $2,099.13 $2,105.69 301 302 303 $139,157.95 $137,045.68 $134,926.81 $434.87 $428.27 $421.65 $2,547.14 $2,547.14 $2,547.14 $2,112.27 $2,118.87 $2,125.49 304 305 $132,801.33 $130,669.19 $415.00 $408.34 $2,547.14 $2,547.14 $2,132.13 $2,138.79 306 307 308 $128,530.40 $126,384.92 $124,232.74 $401.66 $394.95 $388.23 $2,547.14 $2,547.14 $2,547.14 $2,145.48 $2,152.18 $2,158.91 309 310 311 312 $122,073.83 $119,908.17 $117,735.75 $115,556.54 $381.48 $374.71 $367.92 $361.11 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,165.66 $2,172.42 $2,179.21 $2,186.02 313 314 315 316 $113,370.52 $111,177.67 $108,977.96 $106,771.38 $354.28 $347.43 $340.56 $333.66 $2,547.14 $2,547.14 $2,547.14 $2,547.14 $2,192.85 $2,199.71 $2,206.58 $2,213.48 317 318 $104,557.91 $102,337.51 $326.74 $319.80 $2,547.14 $2,547.14 $2,220.39 $2,227.33 319 320 321 $100,110.18 $97,875.89 $95,634.62 $312.84 $305.86 $298.86 $2,547.14 $2,547.14 $2,547.14 $2,234.29 $2,241.27 $2,248.28 322 323 $93,386.34 $91,131.04 $291.83 $284.78 $2,547.14 $2,547.14 $2,255.30 $2,262.35 324 325 326 $88,868.69 $86,599.26 $84,322.75 $277.71 $270.62 $263.51 $2,547.14 $2,547.14 $2,547.14 $2,269.42 $2,276.51 $2,283.63 327 328 $82,039.12 $79,748.36 $256.37 $249.21 $2,547.14 $2,547.14 $2,290.76 $2,297.92 329 330 331 $77,450.44 $75,145.34 $72,833.03 $242.03 $234.83 $227.60 $2,547.14 $2,547.14 $2,547.14 $2,305.10 $2,312.31 $2,319.53 332 333 $70,513.50 $68,186.71 $220.35 $213.08 $2,547.14 $2,547.14 $2,326.78 $2,334.05 334 335 336 $65,852.66 $63,511.32 $61,162.65 $205.79 $198.47 $191.13 $2,547.14 $2,547.14 $2,547.14 $2Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started