In yellow boxes 1,2,3,4,6,7,13 you must have created excel formulas (see cell 15 for example) In...

Transcribed Image Text:

In yellow boxes 1,2,3,4,6,7,13 you must have created excel formulas (see cell 15 for example) In yellow boxes 5,8, 10 & 11 just type in numbers or words 1. $160000 house is purchased with 5% down payment. The loan payment is monthly at 6% for 20 years. In Excel: calculate find the present value, i, total number of payments,see below. Calculate the payment amount 3 different ways, see below 2. In excel calculate down payment 3.i Mortgage amt PV- Down Payment= i= 4. n=# of pmts 5. Hand calculate mortgage payment pmt= 6. calculate payment with Fx (click on FORMULA click on Financial and scroll to PM pmt= 7. calculate payment with excel formula "-G5" (G10/(1-(1+G10)^-G11))" pmt= 422 8. Give 4 solutions to reduce monthly payment 1 1 2 3 4 9 Use the following web site and input given information. Click box to show amortization table. http://www.bretwhissel.net/cgi-bin/amortize 10. From the web site how much total interest is paid: 11. From web site what is the remaining principle after the first year of payments? 12 Other closing evnences are your attorney $500 bank attorney $500 title $600 donosit for taxes $1200 misc $500 1 =160000-G8 In yellow boxes 1,2,3,4,6,7,13 you must have created excel formulas (see cell 15 for example) In yellow boxes 5,8, 10 & 11 just type in numbers or words 1. $160000 house is purchased with 5% down payment. The loan payment is monthly at 6% for 20 years. In Excel: calculate find the present value, i, total number of payments,see below. Calculate the payment amount 3 different ways, see below 2. In excel calculate down payment 3.i Mortgage amt PV- Down Payment= i= 4. n=# of pmts 5. Hand calculate mortgage payment pmt= 6. calculate payment with Fx (click on FORMULA click on Financial and scroll to PM pmt= 7. calculate payment with excel formula "-G5" (G10/(1-(1+G10)^-G11))" pmt= 422 8. Give 4 solutions to reduce monthly payment 1 1 2 3 4 9 Use the following web site and input given information. Click box to show amortization table. http://www.bretwhissel.net/cgi-bin/amortize 10. From the web site how much total interest is paid: 11. From web site what is the remaining principle after the first year of payments? 12 Other closing evnences are your attorney $500 bank attorney $500 title $600 donosit for taxes $1200 misc $500 1 =160000-G8

Answer rating: 100% (QA)

Answer 1 To calculate the present value PV in Excel you can use the formula PV 160000 G8 2 The down ... View the full answer