# Solution Manual for Engineering with Excel, 5th Edition

Preview Extract
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)

## Document Preview (3 of 396 Pages)

User generated content is uploaded by users for the purposes of learning and should be used following SchloarOn's honor code & terms of service.
You are viewing preview pages of the document. Purchase to get full access instantly.
-37%

### Solution Manual for Engineering with Excel, 5th Edition

\$18.99 Save:\$11.00(37%)