Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

image text in transcribed

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 15

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Models For Management And Planning

Authors: James R Morris, John P Daley

2nd Edition

1498765041, 9781498765046

More Books

Students also viewed these Finance questions

Question

OUTCOME 3 Describe pay equity and strategies for implementing it.

Answered: 1 week ago