Get the answers you need at Westonci.ca, where our expert community is always ready to help with accurate information. Connect with a community of experts ready to provide precise solutions to your questions quickly and accurately. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

the purpose of this homework is to develop your own spreadsheet on constant payment mortgage (the most popular type of fixed rate mortgage) that can calculate its effective interest rate to a borrower (both before and after income-tax), and with an arbitrary prepayment before the loan maturity. note that when you set prepayment period to be the same as the maximum loan period, it is equivalent to the case of no prepayment. for example, suppose you have a 30 year loan, and you set prepayment period input in the template as 360. in this case, it is equivalent to the case that you hold the loan without prepayment1. this way, the spreadsheet is general enough to give you the effective interest rate with (and without) prepayment. the final spreadsheet shall be self-adaptive, which means when you change the inputs, it shall calculate and report the correct outputs automatically.