Create an amortization schedule compute anns annualized and


Ann would like to buy a house. It costs $800,000. Her down payment will be $40,000. She will take out a mortgage for $760,000. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.00%. She must pay 2.5% in fees at the time of the loan.Note: the home is bought and the loan is taken in month 0, the first payment is due in month 1.

1. Create an amortization schedule

2. Compute Ann’s annualized and monthly IRR for the mortgage in the spreadsheet.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Create an amortization schedule compute anns annualized and
Reference No:- TGS02699532

Expected delivery within 24 Hours