Question
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
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.
C12 B D H K L M 1 Input 2 Loan Amount 3 Contractual Rate 4 Payments per Year 5 Loan Term (Years) 6 Ballon Ending Balance 7 Fees/Discount Points 8 Prepayment Penalty 9 Marginal Income Tax Rate 10 Prepay at the end of period $365,000.00 3.125% 12 15Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started