Solution Manual for Engineering with Excel, 5th Edition

2.1 Paying Back Student Loans Loan Amortization Table Amount Borrowed: $ APR: Periodic Interest Rate: Term: Payments/Year: Payments: Payment Amount: Principal Payment Before Payment 1 $ 20,000.00 2 $ 19,877.96 3 $ 19,755.31 4 $ 19,632.04 5 $ 19,508.16 6 $ 19,383.66 7 $ 19,258.54 8 $ 19,132.79 9 $ 19,006.41 10 $ 18,879.41 11 $ 18,751.76 12 $ 18,623.48 13 $ 18,494.56 14 $ 18,364.99 15 $ 18,234.77 16 $ 18,103.90 17 $ 17,972.38 18 $ 17,840.20 19 $ 17,707.36 20 $ 17,573.86 21 $ 17,439.69 22 $ 17,304.85 23 $ 17,169.33 24 $ 17,033.13 25 $ 16,896.26 26 $ 16,758.70 27 $ 16,620.45 28 $ 16,481.51 29 $ 16,341.88 30 $ 16,201.55 31 $ 16,060.51 32 $ 15,918.78 33 $ 15,776.33 34 $ 15,633.17 35 $ 15,489.29 Interest Payment $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 100.00 99.39 98.78 98.16 97.54 96.92 96.29 95.66 95.03 94.40 93.76 93.12 92.47 91.82 91.17 90.52 89.86 89.20 88.54 87.87 87.20 86.52 85.85 85.17 84.48 83.79 83.10 82.41 81.71 81.01 80.30 79.59 78.88 78.17 77.45 20,000 6% 0.5% 10 years 12 120 $222.04 Paid on Principal $122.04 $122.65 $123.26 $123.88 $124.50 $125.12 $125.75 $126.38 $127.01 $127.64 $128.28 $128.92 $129.57 $130.22 $130.87 $131.52 $132.18 $132.84 $133.50 $134.17 $134.84 $135.52 $136.19 $136.88 $137.56 $138.25 $138.94 $139.63 $140.33 $141.03 $141.74 $142.45 $143.16 $143.88 $144.59 Principal After Payment $ 19,877.96 $ 19,755.31 $ 19,632.04 $ 19,508.16 $ 19,383.66 $ 19,258.54 $ 19,132.79 $ 19,006.41 $ 18,879.41 $ 18,751.76 $ 18,623.48 $ 18,494.56 $ 18,364.99 $ 18,234.77 $ 18,103.90 $ 17,972.38 $ 17,840.20 $ 17,707.36 $ 17,573.86 $ 17,439.69 $ 17,304.85 $ 17,169.33 $ 17,033.13 $ 16,896.26 $ 16,758.70 $ 16,620.45 $ 16,481.51 $ 16,341.88 $ 16,201.55 $ 16,060.51 $ 15,918.78 $ 15,776.33 $ 15,633.17 $ 15,489.29 $ 15,344.70 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 74 75 76 77 78 79 80 81 82 83 84 85 $ 15,344.70 $ 15,199.38 $ 15,053.34 $ 14,906.56 $ 14,759.06 $ 14,610.81 $ 14,461.82 $ 14,312.09 $ 14,161.61 $ 14,010.38 $ 13,858.39 $ 13,705.64 $ 13,552.13 $ 13,397.85 $ 13,242.79 $ 13,086.97 $ 12,930.36 $ 12,772.97 $ 12,614.80 $ 12,455.83 $ 12,296.07 $ 12,135.51 $ 11,974.14 $ 11,811.97 $ 11,648.99 $ 11,485.20 $ 11,320.58 $ 11,155.14 $ 10,988.88 $ 10,821.78 $ 10,653.85 $ 10,485.08 $ 10,315.46 $ 10,145.00 $ 9,973.68 $ 9,801.51 $ 9,628.48 $ 9,454.58 $ 9,279.81 $ 9,104.17 $ 8,927.65 $ 8,750.24 $ 8,571.95 $ 8,392.77 $ 8,212.70 $ 8,031.72 $ 7,849.84 $ 7,667.04 $ 7,483.34 $ 7,298.71 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 76.72 76.00 75.27 74.53 73.80 73.05 72.31 71.56 70.81 70.05 69.29 68.53 67.76 66.99 66.21 65.43 64.65 63.86 63.07 62.28 61.48 60.68 59.87 59.06 58.24 57.43 56.60 55.78 54.94 54.11 53.27 52.43 51.58 50.72 49.87 49.01 48.14 47.27 46.40 45.52 44.64 43.75 42.86 41.96 41.06 40.16 39.25 38.34 37.42 36.49 $145.32 $146.04 $146.77 $147.51 $148.25 $148.99 $149.73 $150.48 $151.23 $151.99 $152.75 $153.51 $154.28 $155.05 $155.83 $156.61 $157.39 $158.18 $158.97 $159.76 $160.56 $161.36 $162.17 $162.98 $163.80 $164.62 $165.44 $166.27 $167.10 $167.93 $168.77 $169.62 $170.46 $171.32 $172.17 $173.03 $173.90 $174.77 $175.64 $176.52 $177.40 $178.29 $179.18 $180.08 $180.98 $181.88 $182.79 $183.71 $184.62 $185.55 $ 15,199.38 $ 15,053.34 $ 14,906.56 $ 14,759.06 $ 14,610.81 $ 14,461.82 $ 14,312.09 $ 14,161.61 $ 14,010.38 $ 13,858.39 $ 13,705.64 $ 13,552.13 $ 13,397.85 $ 13,242.79 $ 13,086.97 $ 12,930.36 $ 12,772.97 $ 12,614.80 $ 12,455.83 $ 12,296.07 $ 12,135.51 $ 11,974.14 $ 11,811.97 $ 11,648.99 $ 11,485.20 $ 11,320.58 $ 11,155.14 $ 10,988.88 $ 10,821.78 $ 10,653.85 $ 10,485.08 $ 10,315.46 $ 10,145.00 $ 9,973.68 $ 9,801.51 $ 9,628.48 $ 9,454.58 $ 9,279.81 $ 9,104.17 $ 8,927.65 $ 8,750.24 $ 8,571.95 $ 8,392.77 $ 8,212.70 $ 8,031.72 $ 7,849.84 $ 7,667.04 $ 7,483.34 $ 7,298.71 $ 7,113.17 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 7,113.17 6,926.69 6,739.28 6,550.94 6,361.65 6,171.42 5,980.24 5,788.10 5,595.00 5,400.93 5,205.89 5,009.88 4,812.89 4,614.91 4,415.95 4,215.99 4,015.02 3,813.06 3,610.08 3,406.09 3,201.08 2,995.05 2,787.98 2,579.88 2,370.74 2,160.55 1,949.31 1,737.02 1,523.66 1,309.24 1,093.74 877.17 659.52 440.77 220.94 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 35.57 34.63 33.70 32.75 31.81 30.86 29.90 28.94 27.97 27.00 26.03 25.05 24.06 23.07 22.08 21.08 20.08 19.07 18.05 17.03 16.01 14.98 13.94 12.90 11.85 10.80 9.75 8.69 7.62 6.55 5.47 4.39 3.30 2.20 1.10 $186.48 $187.41 $188.34 $189.29 $190.23 $191.18 $192.14 $193.10 $194.07 $195.04 $196.01 $196.99 $197.98 $198.97 $199.96 $200.96 $201.97 $202.98 $203.99 $205.01 $206.04 $207.07 $208.10 $209.14 $210.19 $211.24 $212.29 $213.36 $214.42 $215.49 $216.57 $217.66 $218.74 $219.84 $220.94 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,926.69 6,739.28 6,550.94 6,361.65 6,171.42 5,980.24 5,788.10 5,595.00 5,400.93 5,205.89 5,009.88 4,812.89 4,614.91 4,415.95 4,215.99 4,015.02 3,813.06 3,610.08 3,406.09 3,201.08 2,995.05 2,787.98 2,579.88 2,370.74 2,160.55 1,949.31 1,737.02 1,523.66 1,309.24 1,093.74 877.17 659.52 440.77 220.94 (0.00)