Excel assignment _xiaoqiao Wang

Excel assignment _xiaoqiao Wang - Loan Amortization Input...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Student Name Problem 1 af9c3e237c7d74827400fc5ab2da69b721e5e893.xlsx Loan Amortization Input Area 2 Amount $900,000.00 Principle $1,000,000.00 Years of payment 2 Interest rate per month 0.67% # of payment 24 # of Years in Loan 20 APR 4% # of Payments Per Year 12 Monthly interest rate 0.33% # of payment 240 Monthly payment ($39,082.43) Monthly Payment ($8,364.40) Present Value $974,828.66 Period Payment Interest Payment 1 ($8,364.40) ($1,697.73) ($6,666.67) $1,000,000.00 $998,302.27 2 ($8,364.40) ($1,709.05) ($6,655.35) $998,302.27 $996,593.21 3 Amount $1,000,000.00 3 ($8,364.40) ($1,720.45) ($6,643.95) $996,593.21 $994,872.77 Years of payment 4 4 ($8,364.40) ($1,731.92) ($6,632.49) $994,872.77 $993,140.85 # of payment 8 5 ($8,364.40) ($1,743.46) ($6,620.94) $993,140.85 $991,397.39 Each payment $150,000.00 6 ($8,364.40) ($1,755.08) ($6,609.32) $991,397.39 $989,642.31 7 ($8,364.40) ($1,766.79) ($6,597.62) $989,642.31 $987,875.52 Annual Interest rate 8.48% 8 ($8,364.40) ($1,778.56) ($6,585.84) $987,875.52 $986,096.96 9 ($8,364.40) ($1,790.42) ($6,573.98) $986,096.96 $984,306.54 10 ($8,364.40) ($1,802.36) ($6,562.04) $984,306.54 $982,504.18 11 ($8,364.40) ($1,814.37) ($6,550.03) $982,504.18 $980,689.81 12 ($8,364.40) ($1,826.47) ($6,537.93) $980,689.81 $978,863.34 13 ($8,364.40) ($1,838.65) ($6,525.76) $978,863.34 $977,024.69 14 ($8,364.40) ($1,850.90) ($6,513.50) $977,024.69 $975,173.79 15 ($8,364.40) ($1,863.24) ($6,501.16) $975,173.79 $973,310.55 16 ($8,364.40) ($1,875.66) ($6,488.74) $973,310.55 $971,434.88 17 ($8,364.40) ($1,888.17) ($6,476.23) $971,434.88 $969,546.72 18 ($8,364.40) ($1,900.76) ($6,463.64) $969,546.72 $967,645.96 19 ($8,364.40) ($1,913.43) ($6,450.97) $967,645.96 $965,732.53 20 ($8,364.40) ($1,926.18) ($6,438.22) $965,732.53 $963,806.35 21 ($8,364.40) ($1,939.03) ($6,425.38) $963,806.35 $961,867.32 22 ($8,364.40) ($1,951.95) ($6,412.45) $961,867.32 $959,915.37 23 ($8,364.40) ($1,964.96) ($6,399.44) $959,915.37 $957,950.41 24 ($8,364.40) ($1,978.06) ($6,386.34) $957,950.41 $955,972.34 25 ($8,364.40) ($1,991.25) ($6,373.15) $955,972.34 $953,981.09 26 ($8,364.40) ($2,004.53) ($6,359.87) $953,981.09 $951,976.56 27 ($8,364.40) ($2,017.89) ($6,346.51) $951,976.56 $949,958.67 28 ($8,364.40) ($2,031.34) ($6,333.06) $949,958.67 $947,927.33 29 ($8,364.40) ($2,044.89) ($6,319.52) $947,927.33 $945,882.44 30 ($8,364.40) ($2,058.52) ($6,305.88) $945,882.44 $943,823.93 31 ($8,364.40) ($2,072.24) ($6,292.16) $943,823.93 $941,751.69 32 ($8,364.40) ($2,086.06) ($6,278.34) $941,751.69 $939,665.63 33 ($8,364.40) ($2,099.96) ($6,264.44) $939,665.63 $937,565.67 34 ($8,364.40) ($2,113.96) ($6,250.44) $937,565.67 $935,451.70 35 ($8,364.40) ($2,128.06) ($6,236.34) $935,451.70 $933,323.65 36 ($8,364.40) ($2,142.24) ($6,222.16) $933,323.65 $931,181.40 37 ($8,364.40) ($2,156.52) ($6,207.88) $931,181.40 $929,024.88 38 ($8,364.40) ($2,170.90) ($6,193.50) $929,024.88 $926,853.98 39 ($8,364.40) ($2,185.37) ($6,179.03) $926,853.98 $924,668.60 40
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/24/2011 for the course BUS 301 taught by Professor Karake during the Fall '11 term at Maryland.

Page1 / 7

Excel assignment _xiaoqiao Wang - Loan Amortization Input...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online