This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Assignment 3 Part II [15 points] This is an updated version on Nov 18, 2010 Instructions: You need to submit one Excel file that contains all your answers in the Drop Box on the UW-ACE web site. You need to use a different sheet within your Excel file for each sub-question; name them as a, b, c, d and e, accordingly. When asked to provide an amortization schedule, this should include: time t, payment at time t, interest paid at time t, principal repaid at time t, outstanding balance at time t. If the question also asks for a specific answer, indicate your answer near the top of your sheet and highlight it so that is easy to see. Note: all amounts should be rounded to the nearest cent. So, you may want to use the function round(num, 2) when you are building up the tables. It is possible that your last payment will have to be adjusted (increased or decreased) to take into account rounding errors....
View Full Document
This note was uploaded on 11/30/2010 for the course MATH 235/237 taught by Professor Wilkie during the Spring '10 term at Waterloo.
- Spring '10