Discover answers to your most pressing questions at Westonci.ca, the ultimate Q&A platform that connects you with expert solutions. Join our platform to connect with experts ready to provide accurate answers to your questions in various fields. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.

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.

Sagot :

Thanks for stopping by. We are committed to providing the best answers for all your questions. See you again soon. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. Your questions are important to us at Westonci.ca. Visit again for expert answers and reliable information.