{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Homework 1 Excel Solutions

Homework 1 Excel Solutions - Loan Rate Term Period 1 2 3 4...

This preview shows pages 1–3. Sign up to view the full content.

Loan 200000 Rate 0.12 Term 20 Period Payment Balance Principal Interest 200000 1 (\$2,202.17) \$199,797.83 \$202.17 (\$2,000.00) 2 (\$2,202.17) \$199,593.63 \$204.19 (\$1,997.98) 3 (\$2,202.17) \$199,387.40 \$206.24 (\$1,995.94) 4 (\$2,202.17) \$199,179.10 \$208.30 (\$1,993.87) 5 (\$2,202.17) \$198,968.72 \$210.38 (\$1,991.79) 6 (\$2,202.17) \$198,756.23 \$212.49 (\$1,989.69) 7 (\$2,202.17) \$198,541.62 \$214.61 (\$1,987.56) 8 (\$2,202.17) \$198,324.87 \$216.76 (\$1,985.42) 9 (\$2,202.17) \$198,105.94 \$218.92 (\$1,983.25) 10 (\$2,202.17) \$197,884.83 \$221.11 (\$1,981.06) 11 (\$2,202.17) \$197,661.51 \$223.32 (\$1,978.85) 12 (\$2,202.17) \$197,435.95 \$225.56 (\$1,976.62) 13 (\$2,202.17) \$197,208.14 \$227.81 (\$1,974.36) 14 (\$2,202.17) \$196,978.05 \$230.09 (\$1,972.08) 15 (\$2,202.17) \$196,745.65 \$232.39 (\$1,969.78) 16 (\$2,202.17) \$196,510.94 \$234.72 (\$1,967.46) 17 (\$2,202.17) \$196,273.88 \$237.06 (\$1,965.11) 18 (\$2,202.17) \$196,034.44 \$239.43 (\$1,962.74) 19 (\$2,202.17) \$195,792.61 \$241.83 (\$1,960.34) 20 (\$2,202.17) \$195,548.37 \$244.25 (\$1,957.93) 21 (\$2,202.17) \$195,301.68 \$246.69 (\$1,955.48) 22 (\$2,202.17) \$195,052.52 \$249.16 (\$1,953.02) 23 (\$2,202.17) \$194,800.88 \$251.65 (\$1,950.53) 24 (\$2,202.17) \$194,546.71 \$254.16 (\$1,948.01) 25 (\$2,202.17) \$194,290.01 \$256.71 (\$1,945.47) 26 (\$2,202.17) \$194,030.74 \$259.27 (\$1,942.90) 27 (\$2,202.17) \$193,768.87 \$261.86 (\$1,940.31) 28 (\$2,202.17) \$193,504.39 \$264.48 (\$1,937.69) 29 (\$2,202.17) \$193,237.26 \$267.13 (\$1,935.04) 30 (\$2,202.17) \$192,967.46 \$269.80 (\$1,932.37) 31 (\$2,202.17) \$192,694.96 \$272.50 (\$1,929.67) 32 (\$2,202.17) \$192,419.74 \$275.22 (\$1,926.95) 33 (\$2,202.17) \$192,141.76 \$277.97 (\$1,924.20) 34 (\$2,202.17) \$191,861.01 \$280.75 (\$1,921.42) 35 (\$2,202.17) \$191,577.45 \$283.56 (\$1,918.61) 36 (\$2,202.17) \$191,291.05 \$286.40 (\$1,915.77) 37 (\$2,202.17) \$191,001.79 \$289.26 (\$1,912.91) 38 (\$2,202.17) \$190,709.63 \$292.15 (\$1,910.02) 39 (\$2,202.17) \$190,414.56 \$295.08 (\$1,907.10) 40 (\$2,202.17) \$190,116.53 \$298.03 (\$1,904.15) 41 (\$2,202.17) \$189,815.52 \$301.01 (\$1,901.17) 42 (\$2,202.17) \$189,511.51 \$304.02 (\$1,898.16) 43 (\$2,202.17) \$189,204.45 \$307.06 (\$1,895.12) 44 (\$2,202.17) \$188,894.32 \$310.13 (\$1,892.04) 45 (\$2,202.17) \$188,581.09 \$313.23 (\$1,888.94)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
46 (\$2,202.17) \$188,264.73 \$316.36 (\$1,885.81) 47 (\$2,202.17) \$187,945.21 \$319.52 (\$1,882.65) 48 (\$2,202.17) \$187,622.49 \$322.72 (\$1,879.45) 49 (\$2,202.17) \$187,296.54 \$325.95 (\$1,876.22) 50 (\$2,202.17) \$186,967.33 \$329.21 (\$1,872.97) 51 (\$2,202.17) \$186,634.83 \$332.50 (\$1,869.67) 52 (\$2,202.17) \$186,299.01 \$335.82 (\$1,866.35) 53 (\$2,202.17) \$185,959.83 \$339.18 (\$1,862.99) 54 (\$2,202.17) \$185,617.25 \$342.57 (\$1,859.60) 55 (\$2,202.17) \$185,271.25 \$346.00 (\$1,856.17) 56 (\$2,202.17) \$184,921.79 \$349.46 (\$1,852.71) 57 (\$2,202.17) \$184,568.84 \$352.95 (\$1,849.22) 58 (\$2,202.17) \$184,212.36 \$356.48 (\$1,845.69) 59 (\$2,202.17) \$183,852.31 \$360.05 (\$1,842.12) 60 (\$2,202.17) \$183,488.66 \$363.65 (\$1,838.52) 61 (\$2,202.17) \$183,121.37 \$367.29 (\$1,834.89) 62 (\$2,202.17) \$182,750.41 \$370.96 (\$1,831.21) 63 (\$2,202.17) \$182,375.75
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 25

Homework 1 Excel Solutions - Loan Rate Term Period 1 2 3 4...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online