Clipboard Font Alignment Number E1 fr G H A B D E F 2 Create an amortization schedules using the following assumptions: 3 4 Please make note of the following: 5 Show your work 6 7 8 Loan Term 30 Year - ARM 9 Purchaes Price $150,000.00 10 Down Payment 7.00% 11 Loan Amount $139,500.00 12 Interest Rate 9.00% 11% 15% 12% 13 Balance @ End of Year 5 Year 10 Year 15 Year 20 14 $133,752.68 15 16 Debt Service Beginning Monthly Interest Amortization 17 Month Balance Payment Rate Interest / Principal 18 1 $139,500.00 $1,122.45 0.75% $1,046.25 $76.20 19 2 $139,423.80 $1,122.45 0.75% $1,045.68 $76.77 20 3 $139,347.03 $1,122.45 0.75% $1,045.10 $77.35 21 4 $139,269.68 $1,122.45 0.75% $1,044.52 $77.93 Sheet2 Ending Balance $139,423.80 $139,347.03 $139,269.68 $139,191.76 D H A 4 in N00 6 7 8 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 9 10 11 w No 12 14 15 16 B $139,269.68 $1,122.45 $139,191.76 $1,122.45 $139,113.24 $1,122.45 $139,034.14 $1,122.45 $138,954.45 $1,122.45 $138,874.16 $1,122.45 $138,793.26 $1,122.45 $138,711.76 $1,122.45 $138,629.65 $1,122.45 $138,546.92 $1,122.45 $138,463.58 $1,122.45 $138,379.60 $1,122.45 $138,295.00 $1,122.45 $138,209.76 $1,122.45 $138,123.88 $1,122.45 $138,037.36 $1,122.45 $137,950.19 $1,122.45 $137,862.37 $1,122.45 $137,773.89 $1,122.45 $137,684.74 $1,122.45 $137,594.93 $1,122.45 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,044.52 $1,043.94 $1,043.35 $1,042.76 $1,042.16 $1,041.56 $1,040.95 $1,040.34 $1,039.72 $1,039.10 $1,038.48 $1,037.85 $1,037.21 $1,036.57 $1,035.93 $1,035.28 $1,034.63 $1,033.97 $1,033.30 $1,032.64 $1,031.96 $77.93 $78.51 $79.10 $79.69 $80.29 $80.89 $81.50 $82.11 $82.73 $83.35 $83.97 $84.60 $85.24 $85.88 $86.52 $87.17 $87.82 $88.48 $89.15 $89.81 $90.49 G $139,191.76 $139,113.24 $139,034.14 $138,954.45 $138,874.16 $138,793.26 $138,711.76 $138,629.65 $138,546.92 $138,463.58 $138,379.60 $138,295.00 $138,209.76 $138,123.88 $138,037.36 $137,950.19 $137,862.37 $137,773.89 $137,684.74 $137,594.93 $137,504.44 17 18 19 36 37 38 39 40 41 20 21 22 23 24 Sheet2 A 24 H 41 D 0.75% 0.75% 42 25 26 27 28 29 30 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 50 51 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Sheet2 B $137,594.93 $1,122.45 $137,504.44 $1,122.45 $137,413.27 $1,122.45 $137,321.42 $1,122.45 $137,228.88 $1,122.45 $137,135.65 $1,122.45 $137,041.72 $1,122.45 $136,947.08 $1,122.45 $136,851.73 $1,122.45 $136,755.67 $1,122.45 $136,658.89 $1,122.45 $136,561.38 $1,122.45 $136,463.14 $1,122.45 $136,364.16 $1,122.45 $136,264.45 $1,122.45 $136,163.98 $1,122.45 $136,062.76 $1,122.45 $135,960.78 $1,122.45 $135,858.04 $1,122.45 $135,754.52 $1,122.45 $135,650.23 $1,122.45 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,031.96 $1,031.28 $1,030.60 $1,029.91 $1,029.22 $1,028.52 $1,027.81 $1,027.10 $1,026.39 $1,025.67 $1,024.94 $1,024.21 $1,023.47 $1,022.73 $1,021.98 $1,021.23 $1,020.47 $1,019.71 $1,018.94 $1,018.16 $1,017.38 F $90.49 $91.17 $91.85 $92.54 $93.23 $93.93 $94.64 $95.35 $96.06 $96.78 $97.51 $98.24 $98.98 $99.72 $100.47 $101.22 $101.98 $102.74 $103.51 $104.29 $105.07 G $137,504.44 $137,413.27 $137,321.42 $137,228.88 $137,135.65 $137,041.72 $136,947.08 $136,851.73 $136,755.67 $136,658.89 $136,561.38 $136,463.14 $136,364.16 $136,264.45 $136,163.98 $136,062.76 $135,960.78 $135,858.04 $135,754.52 $135,650.23 $135,545.16 K23 fi H 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 A 44 45 46 47 48 49 50 51 52 B $135,650.23 $1,122.45 $135,545.16 $1,122.45 $135,439.30 $1,122.45 $135,332.64 $1,122.45 $135,225.18 $1,122.45 $135,116.92 $1,122.45 $135,007.85 $1,122.45 $134,897.96 $1,122.45 $134,787.24 $1,122.45 $134,675.70 $1,122.45 $134,563.32 $1,122.45 $134,450.09 $1,122.45 $134,336.02 $1,122.45 $134,221.09 $1,122.45 $134,105.30 $1,122.45 $133,988.64 $1,122.45 $133,871.10 $1,122.45 D 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% E $1,017.38 $1,016.59 $1,015.79 $1,014.99 $1,014.19 $1,013.38 $1,012.56 $1,011.73 $1,010.90 $1,010.07 $1,009.22 $1,008.38 $1,007.52 $1,006.66 $1,005.79 $1,004.91 $1,004.03 F $105.07 $105.86 $106.66 $107.46 $108.26 $109.07 $109.89 $110.72 $111.55 $112.38 $113.23 $114.07 $114.93 $115.79 $116.66 $117.54 $118.42 G $135,545.16 $135,439.30 $135,332.64 $135,225.18 $135,116.92 $135,007.85 $134,897.96 $134,787.24 $134,675.70 $134,563.32 $134,450.09 $134,336.02 $134,221.09 $134,105.30 $133,988.64 $133,871.10 $133,752.68 53 54 55 56 57 58 59 60 78 79 80