ACTSC231 ASSIGNMENT 6 PART 2, DUE MONDAY, AUG 2Instructions:You need to submit one Excel file that contains all your answers inthe Drop Box on the UW-ACE web site by the end of Monday Aug 2. You can use adifferent sheet within your Excel file for each sub-question; name the sheet according tothe sub-question(s) it refers to (e.g., 1b, 2bc, etc). when asked to provide an amortizationschedule, this should include: time t, payment at time t, interest paid at time t, principalpaid amount at time t, outstanding balance at time t.If the question also asks for aspecific answer, indicate your answer near the top of your sheet and highlight it so thatis easy to see.Note: all amounts should be rounded to the nearest cent.Hence it ispossible that your last payment will have to be adjusted (increased or decreased) to takeinto account rounding errors.[20 points]Anne wants to buy a house selling at $500,000. She can afford to makea down payment of $90,000.She wants to take out a 25-year mortgage with monthly(end of the month) payments based on a nominal rate of 4.5% compounded monthly.
This is the end of the preview.
access the rest of the document.