questions both need to be answered

project 3 data

projects 4 data

more information!!

4. Using your spread sheet determine how many payments you would need to make in order for your balance to be $0. How many fewer payments would this be compared to the number of payments in project 3. 5. Compare your answers in project 3 and project 4 for question 4. How much do you save by paying $500 more each month? (if you didn't complete Project #3 you will need to calculate the need information from the previous project to be able to compare) 1 Amortization Chart: 4702 Pelham St, Dearborn Heights, MI, 48125 APR 3% 0.00280583 + Month Applied to Applied to Remaining monthly 2 (Payment) Payment interest Principal Balance rate: 3 0 96,000 initial loan 4 1 680.04 269.36 410.68 95,589.32 5 2 680.04 268.21 411.83 95,177.49 6 3 680.04 267.05 412.99 94,764.50 7 4 680.04 265.89 414.15 94,350.35 B 5 680.04 264.73 415 31 93,935.04 9 6 680.04 263.57 416,47 93,518.57 10 7 680.04 262.40 417.64 93,100.93 11 680.04 261.23 418.81 92,682.11 12 9 680.04 260.05 419.99 92,262.12 13 10 680.04 258.87 421.17 91,840.96 14 11 680.04 257.69 422.35 91.418.61 15 12 680.04 25651 423.53 90,995.07 16 13 680.04 25532 424.72 90,570.35 17 14 680.04 254.13 425.91 90,144,43 18 15 680.04 252.93 427 11 89,717.32 19 16 680.04 251.73 428.31 89,289.02 20 17 680.04 250.53 429.51 88,859.51 21 18 680.04 249,32 430.72 88,428.79 22 19 680.04 248.12 431 92 87,996.87 23 20 680.04 246.90 433.14 87,563.73 24 21 680 04 245.69 434,35 87,129.38 25 22 680.04 24447 435.57 86,693.81 25 23 680.04 243.25 436.79 86,257.02 27 24 680.04 242.02 438.02 85,819.00 25 680.04 240.79 439.25 85,379.76 26 680.04 239,56 440.48 84,939.28 30 27 68004 233.33 44171 84,497 56 31 28 610.04 237,09 442 95 84,054,61 20 610,04 235.84 444.20 83,610.41 30 30 630.04 234.60 445.44 83,164,97 31 680.04 23335 446.69 82,718.28 32 680 04 232.00 32,270 33 36 33 680.04 230 4 449 20 81 821.13 680.04 22958 450,46 31,370.66 Sheet1 447.95 Open recovered workbooks? Your recent changes were saved. Do you want to continue working whe B191 x fx B D E F G H 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 228.31 227.05 225.77 224.50 223.22 221.94 220.65 219.37 218.07 216.78 215.48 214.17 212.87 211.56 210.24 208.92 207.60 206.27 204.95 203.61 202.28 200.94 199.59 198.24 196.89 195.54 194.18 192.81 191.45 190.07 188.70 187.32 185.94 184.55 183.16 181.77 180.37 178.97 177.56 451.73 452.99 454.27 455.54 456.82 458.10 459.39 460.67 461.97 463.26 464.56 465.87 467.17 468.48 469.80 471.12 472.44 473.77 475.09 476.43 477.76 479.10 480.45 481.80 483.15 484.50 485.86 487.23 488.59 489.97 491.34 492.72 494.10 495.49 496.88 498.27 499.67 501.07 502.48 57 80,918.94 80,465.94 80,011.68 79,556.14 79,099.32 78,641.22 78,181.83 77,721.16 77,259.19 76,795.92 76,331.36 75,865.49 75,398.32 74,929.84 74,460.04 73,988.92 73,516.48 73,042.71 72,567.62 72,091.19 71,613.43 71,134.32 70,653.87 70,172.08 69,688.93 69,204.42 68,718.56 68,231.33 67,742.74 67,252.77 66,761.43 66,268.72 65,774.61 65,279.13 64,782.25 64,283.98 63,784.31 63,283.24 62,780.76 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 8 9 ST 9 82 52 84 95 86 87 22 29 90 91 92 74 75 76 7 78 79 80 81 82 83 84 85 86 87 88 89 90 94 5 96 97 99 99 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.00 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.0-4 680.04 680.04 60.04 60.04 680.04 680.04 680.00 680.04 680.00 91 92 93 94 95 96 97 98 99 100 101 102 100 106 105 106 197 1TB 109 110 111 112 176.15 174.74 173.32 171.90 170.47 169.04 167.61 166.17 164.73 163.28 161.83 160.38 158.92 157.46 155.99 154.52 153.05 151.57 150.09 148.60 147.11 145.61 144.11 142.61 14110 139.59 138.07 136.55 135.03 133.50 13197 130.43 128.89 127.34 125.79 124.23 122.67 121.11 119.54 503.89 505.30 506.72 508.14 509.57 511.00 512.43 513.87 515.31 516.76 51821 519.66 521.12 522.58 524.05 525.52 526.9 528.47 529.95 531.44 532.93 534.43 535.93 537.43 538.94 540.45 541.97 543.49 545.01 546:54 548.07 549.61 551-15 552.70 554.25 555.81 557.37 556.93 560.50 62.276.87 61.771.57 61.264.85 60.756.71 60.247.14 59,736.15 59.223.72 58.709.85 58.194.54 57.677.78 57,159.58 56,639.92 56.118.80 55.596.22 55.072.17 54,546.65 54.019.66 53,491.19 52,961.24 52.429.80 51,896.87 51.362.44 50,826.52 50.289.09 49,750.15 49.209.70 48.667.74 48.124.25 47.579.24 47,032.70 46.484.63 45,935.01 45.383.86 44.831.16 44.276.91 43.721.10 43.163.74 42.6504.81 42,044.31 100 101 102 103 104 105 106 107) | 10B 109 1110 [11] 112 1113 111 114 A B F G H 113 114 115 116 117 118 119 120 121 122 123 124 125 126 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 117.97 116.39 114.81 113.22 111.63 110.04 108.44 106.84 105,23 103.62 102.00 100.38 98.75 97.12 95.48 93.84 92.20 90.55 88.89 87.24 85.57 83.90 82.23 80.55 78.87 77.19 75.49 73.80 72.10 70.39 68.68 66.97 65.25 63.52 61.79 60.06 58.32 56.57 54.82 D 562.07 563,65 565.23 566.82 568.41 570.00 571.60 573.20 574,81 576.42 578.04 579.66 581.29 582.92 584.56 586.20 587.84 589.49 591.15 592.80 594.47 596.14 597.81 599.49 601.17 602.85 604.55 606.24 607.94 609.65 611.36 613.07 614.79 616.52 618.25 619.98 621.72 623.47 625.22 E 41,482.24 40,918.59 40,353.36 39,786.54 39,218.14 38,648.14 38,076,54 37,503.34 36,928.52 36,352.10 35,774.06 35,194.39 34,613.10 34,030.18 33,445.62 32,859.43 32,271,58 31,682.09 31,090.95 30,498.14 29,903.68 29,307.54 28,709.73 28,110.25 27,509.08 26,906.23 26,301.68 25,695.44 25,087.50 24,477.85 23,866.49 23,253.41 22,638.62 22,022.10 21,403.85 20,783.87 20,162.14 19,538.67 18,913.46 148 149 150 151 152 153 155 156 157 1158 (159 160 161 1162 163 1164 1165 1166 167 168 169 170 171 112 1173 174 175 1176 177 178 1179 126 181 182 183 184 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 678.71 122405.87 53.07 51.31 49.54 47.78 46.00 44.22 42.44 40.65 38.86 37.06 35.25 33.44 31.63 29.81 27.99 26.16 24.32 22.48 20.64 18.79 16.93 15.07 13.20 11.33 9.46 7.58 5.69 3.80 1.90 26405.87 626.97 628.73 630.50 632.26 634.04 635.82 637.60 639.39 641.18 642.98 644.79 646.60 648.41 650.23 652.05 53.8 655.72 657.56 659.40 661.25 663.11 664.97 666.84 668.71 670.58 672.46 674.35 676.24 576.81 18.286.48 17.657.75 17.027.26 16.394.99 15.760.95 15.125.14 14.487.54 13,848.15 13.206.96 12.563.98 11.919.19 11.272.59 10.624.18 9973.95 9321.90 8,668.01 8,012.29 7354.73 6.695.33 6.034.08 5.370.97 4.706.00 4,039.16 3.370.45 2,699.87 2.027.41 1.353.06 676.81 0.00 0 1 5 6 7 2 2 3 8 9 5 3 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 $269.36 $266.80 $264.24 $261.67 $259.10 $256.51 $253.92 $251.32 $248.72 $246.10 $243.48 $240.85 $238.22 $235.58 $232.93 $230.27 $227.60 $224.93 $222.25 $219.57 $216.87 $214.17 $211.46 $208.74 $206.01 $203.28 $200.54 $197.79 $195.04 $192.27 $189.50 $186.72 $183.94 $181.14 $910.68 $913.24 $915.80 $918.37 $920.94 $923.53 $924-12 $926.72 $931.32 $933.94 $936.56 $939.19 $941.82 $944.46 $947.11 $949.77 $952.44 $955.11 $957.79 $960.47 $963.17 $965.87 $968.58 $971.30 $974.03 $976.76 $979.50 $982.25 $985.00 $987.77 $990.54 $993.32 $996.10 $998.90 96,000 initial loan 95,089 94,176 93,260 92,342 91,421 90,497 89,571 88,643 87,711 86,777 85,841 84,902 83,960 83,015 82,068 81,118 80,166 79,211 78,253 77,293 76,329 75,364 74,395 73,424 72,450 71,473 70,493 69,511 68,526 67,538 66,548 65,555 64,558 63,560 2 2 3 3 5 5 3 e 27 28 29 1 2 3 1 30 31 32 33 34 7 Chat ne ya F G H att 38 39 40 41 35 36 37 38 sing 42 eces 43 44 ayme 45 Dreat 46 nswe 47 48 wev 49 umbi 50 1. 51 52 53 2. 54 55 56 3. 57 58 59 4. 60 61 62 5. 63 64 65 Date 66 67 68 69 70 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 B 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 D $178.34 $1,001.70 $175.53 $1,004.51 $172.71 $1,007.33 $169.88 $1,010.16 $167.05 $1,012.99 $164.21 $1,015.83 $161.36 $1,05458 $158.50 $1,021.54 $155.63 $1,024.41 $152.76 $1,027.28 $149.87 $1,030.17 $146.98 $1,033.06 $144.08 $1,035.96 $141.18 $1,038.86 $138.26 $1,041.78 $135.34 $1,044.70 $132.41 $1,047.63 $129.47 $1,050.57 $126.52 $1,053.52 $123.57 $1,056.47 $120.60 $1,059.44 $117.63 $1,062.41 $114.65 $1,065.39 $111.66 $1,068.38 $108.66 $1,071.38 $105.65 $1,074.39 $102.64 $1,077.40 $99.62 $1,080.42 $96.59 $1,083.45 $93.55 $1,086.49 $90.50 $1,089.54 $87.44 $1,092.60 $84.37 $1,095.67 $81.30 $1,098.74 $78.22 $1,101.82 E 62,558 61,553 60,546 59,536 58,523 57,507 56,488 55,467 54,442 53,415 52,385 51,352 50,316 49,277 48,235 47,191 46,143 45,092 44,039 42,982 41,923 40,861 39,795 38,727 37,655 36,581 35,504 34,423 33,340 32,253 31,164 30,071 28,975 27,877 26,775 ing WO 71 72 RA A Sheet1 + 0 A B C D G H 73 74 75 76 77 RRRR 25 78 me 79 180 ea 81 WE 82 vev 83 84 mbi 85 1. 186 87 88 2. 89 90 91 92. 193 4. 194 95 96 5. 197 198 71 . 73 74 75 76 77 78 79 80 81 82, 83 84 85 86 87 88 89 190 91 92 193 1180.04 $75.13 $1,104.91 1180.04 $72.03 $1,108.01. 1180.04 $68.92. $1,111.12 1180.04 $65.80 $1,114.24 1180.04 $62,67 $1,117.37 1180.04 $59.54 $1,124.50 1180.04 $56.39 $1,121.65 1180,04 $53.24 $1,126,800 1180.04 $50.08 $1,129.961 1180.04 $46.91 $1,133.13 1180.04 $43.73 $1,136.31 1180.04 S40.54 $1,139.50 1180.04 $37.34 $1,142,700 1180.04 $34.14 $1,145.90) 1180.04 $30.92 $1,149.12 1180.04 $27.70 $1,152.34 1180.04 $24.46 $1,155.58 1180.04 $21.22 S1,158.822 1180.04 $17.97 51,162.07 1180.04 $14.71 $1,165.33 1180.04 $11.44 $1,168.60) 1180.04 $8.16 $1,171.88 1180.04 54.87 $1,175.17 563.04 $1.58 $561.46 109126.72 $13,127.11 25,670 24,562 23,451 22,337 21,219) 20,099 18,975 17,848 16,718) 15,585) 14,449 13,309 12,167 11,021 9,872 8,719 7,5641 6,405 5,243 4,077 2,909 1,737 562 3. The home that I choose is 4702 Pelhamst, Dearborn Height, MI, 48125. The asking Price is $120,000 and the initial principal $ 96,000 Price = 120.000 initial Principal of 80%-0.8 Borrowed -08 120.000) = $96,000 Monthly payment Amount borrowed xr (Hrst ((1+rt 1) APR - 3,367 -0.03367 lo 680,034 680.09 (96.000 (003347) 1+ 2036 190 718 1 600.04 +500 = 1180.04 = $1180.04 0.03367 186 12 4. Using your spread sheet determine how many payments you would need to make in order for your balance to be $0. How many fewer payments would this be compared to the number of payments in project 3. 5. Compare your answers in project 3 and project 4 for question 4. How much do you save by paying $500 more each month? (if you didn't complete Project #3 you will need to calculate the need information from the previous project to be able to compare) 1 Amortization Chart: 4702 Pelham St, Dearborn Heights, MI, 48125 APR 3% 0.00280583 + Month Applied to Applied to Remaining monthly 2 (Payment) Payment interest Principal Balance rate: 3 0 96,000 initial loan 4 1 680.04 269.36 410.68 95,589.32 5 2 680.04 268.21 411.83 95,177.49 6 3 680.04 267.05 412.99 94,764.50 7 4 680.04 265.89 414.15 94,350.35 B 5 680.04 264.73 415 31 93,935.04 9 6 680.04 263.57 416,47 93,518.57 10 7 680.04 262.40 417.64 93,100.93 11 680.04 261.23 418.81 92,682.11 12 9 680.04 260.05 419.99 92,262.12 13 10 680.04 258.87 421.17 91,840.96 14 11 680.04 257.69 422.35 91.418.61 15 12 680.04 25651 423.53 90,995.07 16 13 680.04 25532 424.72 90,570.35 17 14 680.04 254.13 425.91 90,144,43 18 15 680.04 252.93 427 11 89,717.32 19 16 680.04 251.73 428.31 89,289.02 20 17 680.04 250.53 429.51 88,859.51 21 18 680.04 249,32 430.72 88,428.79 22 19 680.04 248.12 431 92 87,996.87 23 20 680.04 246.90 433.14 87,563.73 24 21 680 04 245.69 434,35 87,129.38 25 22 680.04 24447 435.57 86,693.81 25 23 680.04 243.25 436.79 86,257.02 27 24 680.04 242.02 438.02 85,819.00 25 680.04 240.79 439.25 85,379.76 26 680.04 239,56 440.48 84,939.28 30 27 68004 233.33 44171 84,497 56 31 28 610.04 237,09 442 95 84,054,61 20 610,04 235.84 444.20 83,610.41 30 30 630.04 234.60 445.44 83,164,97 31 680.04 23335 446.69 82,718.28 32 680 04 232.00 32,270 33 36 33 680.04 230 4 449 20 81 821.13 680.04 22958 450,46 31,370.66 Sheet1 447.95 Open recovered workbooks? Your recent changes were saved. Do you want to continue working whe B191 x fx B D E F G H 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 228.31 227.05 225.77 224.50 223.22 221.94 220.65 219.37 218.07 216.78 215.48 214.17 212.87 211.56 210.24 208.92 207.60 206.27 204.95 203.61 202.28 200.94 199.59 198.24 196.89 195.54 194.18 192.81 191.45 190.07 188.70 187.32 185.94 184.55 183.16 181.77 180.37 178.97 177.56 451.73 452.99 454.27 455.54 456.82 458.10 459.39 460.67 461.97 463.26 464.56 465.87 467.17 468.48 469.80 471.12 472.44 473.77 475.09 476.43 477.76 479.10 480.45 481.80 483.15 484.50 485.86 487.23 488.59 489.97 491.34 492.72 494.10 495.49 496.88 498.27 499.67 501.07 502.48 57 80,918.94 80,465.94 80,011.68 79,556.14 79,099.32 78,641.22 78,181.83 77,721.16 77,259.19 76,795.92 76,331.36 75,865.49 75,398.32 74,929.84 74,460.04 73,988.92 73,516.48 73,042.71 72,567.62 72,091.19 71,613.43 71,134.32 70,653.87 70,172.08 69,688.93 69,204.42 68,718.56 68,231.33 67,742.74 67,252.77 66,761.43 66,268.72 65,774.61 65,279.13 64,782.25 64,283.98 63,784.31 63,283.24 62,780.76 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 8 9 ST 9 82 52 84 95 86 87 22 29 90 91 92 74 75 76 7 78 79 80 81 82 83 84 85 86 87 88 89 90 94 5 96 97 99 99 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.00 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.0-4 680.04 680.04 60.04 60.04 680.04 680.04 680.00 680.04 680.00 91 92 93 94 95 96 97 98 99 100 101 102 100 106 105 106 197 1TB 109 110 111 112 176.15 174.74 173.32 171.90 170.47 169.04 167.61 166.17 164.73 163.28 161.83 160.38 158.92 157.46 155.99 154.52 153.05 151.57 150.09 148.60 147.11 145.61 144.11 142.61 14110 139.59 138.07 136.55 135.03 133.50 13197 130.43 128.89 127.34 125.79 124.23 122.67 121.11 119.54 503.89 505.30 506.72 508.14 509.57 511.00 512.43 513.87 515.31 516.76 51821 519.66 521.12 522.58 524.05 525.52 526.9 528.47 529.95 531.44 532.93 534.43 535.93 537.43 538.94 540.45 541.97 543.49 545.01 546:54 548.07 549.61 551-15 552.70 554.25 555.81 557.37 556.93 560.50 62.276.87 61.771.57 61.264.85 60.756.71 60.247.14 59,736.15 59.223.72 58.709.85 58.194.54 57.677.78 57,159.58 56,639.92 56.118.80 55.596.22 55.072.17 54,546.65 54.019.66 53,491.19 52,961.24 52.429.80 51,896.87 51.362.44 50,826.52 50.289.09 49,750.15 49.209.70 48.667.74 48.124.25 47.579.24 47,032.70 46.484.63 45,935.01 45.383.86 44.831.16 44.276.91 43.721.10 43.163.74 42.6504.81 42,044.31 100 101 102 103 104 105 106 107) | 10B 109 1110 [11] 112 1113 111 114 A B F G H 113 114 115 116 117 118 119 120 121 122 123 124 125 126 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 117.97 116.39 114.81 113.22 111.63 110.04 108.44 106.84 105,23 103.62 102.00 100.38 98.75 97.12 95.48 93.84 92.20 90.55 88.89 87.24 85.57 83.90 82.23 80.55 78.87 77.19 75.49 73.80 72.10 70.39 68.68 66.97 65.25 63.52 61.79 60.06 58.32 56.57 54.82 D 562.07 563,65 565.23 566.82 568.41 570.00 571.60 573.20 574,81 576.42 578.04 579.66 581.29 582.92 584.56 586.20 587.84 589.49 591.15 592.80 594.47 596.14 597.81 599.49 601.17 602.85 604.55 606.24 607.94 609.65 611.36 613.07 614.79 616.52 618.25 619.98 621.72 623.47 625.22 E 41,482.24 40,918.59 40,353.36 39,786.54 39,218.14 38,648.14 38,076,54 37,503.34 36,928.52 36,352.10 35,774.06 35,194.39 34,613.10 34,030.18 33,445.62 32,859.43 32,271,58 31,682.09 31,090.95 30,498.14 29,903.68 29,307.54 28,709.73 28,110.25 27,509.08 26,906.23 26,301.68 25,695.44 25,087.50 24,477.85 23,866.49 23,253.41 22,638.62 22,022.10 21,403.85 20,783.87 20,162.14 19,538.67 18,913.46 148 149 150 151 152 153 155 156 157 1158 (159 160 161 1162 163 1164 1165 1166 167 168 169 170 171 112 1173 174 175 1176 177 178 1179 126 181 182 183 184 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 680.04 678.71 122405.87 53.07 51.31 49.54 47.78 46.00 44.22 42.44 40.65 38.86 37.06 35.25 33.44 31.63 29.81 27.99 26.16 24.32 22.48 20.64 18.79 16.93 15.07 13.20 11.33 9.46 7.58 5.69 3.80 1.90 26405.87 626.97 628.73 630.50 632.26 634.04 635.82 637.60 639.39 641.18 642.98 644.79 646.60 648.41 650.23 652.05 53.8 655.72 657.56 659.40 661.25 663.11 664.97 666.84 668.71 670.58 672.46 674.35 676.24 576.81 18.286.48 17.657.75 17.027.26 16.394.99 15.760.95 15.125.14 14.487.54 13,848.15 13.206.96 12.563.98 11.919.19 11.272.59 10.624.18 9973.95 9321.90 8,668.01 8,012.29 7354.73 6.695.33 6.034.08 5.370.97 4.706.00 4,039.16 3.370.45 2,699.87 2.027.41 1.353.06 676.81 0.00 0 1 5 6 7 2 2 3 8 9 5 3 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 $269.36 $266.80 $264.24 $261.67 $259.10 $256.51 $253.92 $251.32 $248.72 $246.10 $243.48 $240.85 $238.22 $235.58 $232.93 $230.27 $227.60 $224.93 $222.25 $219.57 $216.87 $214.17 $211.46 $208.74 $206.01 $203.28 $200.54 $197.79 $195.04 $192.27 $189.50 $186.72 $183.94 $181.14 $910.68 $913.24 $915.80 $918.37 $920.94 $923.53 $924-12 $926.72 $931.32 $933.94 $936.56 $939.19 $941.82 $944.46 $947.11 $949.77 $952.44 $955.11 $957.79 $960.47 $963.17 $965.87 $968.58 $971.30 $974.03 $976.76 $979.50 $982.25 $985.00 $987.77 $990.54 $993.32 $996.10 $998.90 96,000 initial loan 95,089 94,176 93,260 92,342 91,421 90,497 89,571 88,643 87,711 86,777 85,841 84,902 83,960 83,015 82,068 81,118 80,166 79,211 78,253 77,293 76,329 75,364 74,395 73,424 72,450 71,473 70,493 69,511 68,526 67,538 66,548 65,555 64,558 63,560 2 2 3 3 5 5 3 e 27 28 29 1 2 3 1 30 31 32 33 34 7 Chat ne ya F G H att 38 39 40 41 35 36 37 38 sing 42 eces 43 44 ayme 45 Dreat 46 nswe 47 48 wev 49 umbi 50 1. 51 52 53 2. 54 55 56 3. 57 58 59 4. 60 61 62 5. 63 64 65 Date 66 67 68 69 70 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 B 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 1180.04 D $178.34 $1,001.70 $175.53 $1,004.51 $172.71 $1,007.33 $169.88 $1,010.16 $167.05 $1,012.99 $164.21 $1,015.83 $161.36 $1,05458 $158.50 $1,021.54 $155.63 $1,024.41 $152.76 $1,027.28 $149.87 $1,030.17 $146.98 $1,033.06 $144.08 $1,035.96 $141.18 $1,038.86 $138.26 $1,041.78 $135.34 $1,044.70 $132.41 $1,047.63 $129.47 $1,050.57 $126.52 $1,053.52 $123.57 $1,056.47 $120.60 $1,059.44 $117.63 $1,062.41 $114.65 $1,065.39 $111.66 $1,068.38 $108.66 $1,071.38 $105.65 $1,074.39 $102.64 $1,077.40 $99.62 $1,080.42 $96.59 $1,083.45 $93.55 $1,086.49 $90.50 $1,089.54 $87.44 $1,092.60 $84.37 $1,095.67 $81.30 $1,098.74 $78.22 $1,101.82 E 62,558 61,553 60,546 59,536 58,523 57,507 56,488 55,467 54,442 53,415 52,385 51,352 50,316 49,277 48,235 47,191 46,143 45,092 44,039 42,982 41,923 40,861 39,795 38,727 37,655 36,581 35,504 34,423 33,340 32,253 31,164 30,071 28,975 27,877 26,775 ing WO 71 72 RA A Sheet1 + 0 A B C D G H 73 74 75 76 77 RRRR 25 78 me 79 180 ea 81 WE 82 vev 83 84 mbi 85 1. 186 87 88 2. 89 90 91 92. 193 4. 194 95 96 5. 197 198 71 . 73 74 75 76 77 78 79 80 81 82, 83 84 85 86 87 88 89 190 91 92 193 1180.04 $75.13 $1,104.91 1180.04 $72.03 $1,108.01. 1180.04 $68.92. $1,111.12 1180.04 $65.80 $1,114.24 1180.04 $62,67 $1,117.37 1180.04 $59.54 $1,124.50 1180.04 $56.39 $1,121.65 1180,04 $53.24 $1,126,800 1180.04 $50.08 $1,129.961 1180.04 $46.91 $1,133.13 1180.04 $43.73 $1,136.31 1180.04 S40.54 $1,139.50 1180.04 $37.34 $1,142,700 1180.04 $34.14 $1,145.90) 1180.04 $30.92 $1,149.12 1180.04 $27.70 $1,152.34 1180.04 $24.46 $1,155.58 1180.04 $21.22 S1,158.822 1180.04 $17.97 51,162.07 1180.04 $14.71 $1,165.33 1180.04 $11.44 $1,168.60) 1180.04 $8.16 $1,171.88 1180.04 54.87 $1,175.17 563.04 $1.58 $561.46 109126.72 $13,127.11 25,670 24,562 23,451 22,337 21,219) 20,099 18,975 17,848 16,718) 15,585) 14,449 13,309 12,167 11,021 9,872 8,719 7,5641 6,405 5,243 4,077 2,909 1,737 562 3. The home that I choose is 4702 Pelhamst, Dearborn Height, MI, 48125. The asking Price is $120,000 and the initial principal $ 96,000 Price = 120.000 initial Principal of 80%-0.8 Borrowed -08 120.000) = $96,000 Monthly payment Amount borrowed xr (Hrst ((1+rt 1) APR - 3,367 -0.03367 lo 680,034 680.09 (96.000 (003347) 1+ 2036 190 718 1 600.04 +500 = 1180.04 = $1180.04 0.03367 186 12