Question

In: Finance

You have a mortgage with a remaining balance of $160,000 and 200 more monthly payments. The...

You have a mortgage with a remaining balance of $160,000 and 200 more monthly payments.
The bank charges you 5% APR with monthly compounding on the loan. The current payments are $1,200 per month.

Due to covid-19 you have lost your job and need to skip the payments in months 1 to 5 .The bank offers you two alternatives.
In alternative 1 you will start making payments again, in month 6 but with new payments that take into account the interest the bank charges you over the months you skipped. You would have these new payments in months 6 to 205

In alternative 2, you keep the same payments of $1,200 and make these in months, 6 to 205 but pay a "delay fee" of $2,000 in month 5
Which alternative is cheaper in present value terms as of month 5 and by how much if you earn 7% on your investments?

Go with Alt 2. It is cheaper by $2,618.83

Go with Alt 1. It is cheaper by $1,354.31

Go with Alt 1. It is cheaper by $2,618.83

Go with Alt 2. It is cheaper by $1,354.31

Solutions

Expert Solution

Alternative I

Remaining Balance today = 160000

Interest rate per month = 5%/12 =0.004166666667

Number of interest accrued = 5

So balance at end of 5 month = Present value*(1+i)^n

160000*(1+0.004166666667)^5

$163,361.2271

Now this is balance at month 5 (P) =$163,361.23

Number of periods of repayment (n) = 200

Interest rate per month = 5%/12 =0.004166666667

so equal monthly payment payable for loan =Monthly payment formula = P*i/(1-((1+i)^-n))

163361.23*0.004166666667/(1-((1+0.004166666667)^-200))

1205.478326

Now we will calculate present value of $1205.48 for us.

Number of months (n) = 200

Opportunity cost of capital permonth (i)= 7%/12 =0.005833333333

Present value of annuity = =monthly payment *(1-((1+i)^-n))/i

1205.48*(1-((1+0.00583333333)^-200))/0.00583333333

142082.5815

Alternative II

delay fee paid at end of month 5 = $2000

Present value will be same at that time = $2000

Monthly payment made for 200 months = $1200

Number of months (n) = 200

Opportunity cost of capital permonth (i)= 7%/12 =0.005833333333

Present value of annuity = =monthly payment *(1-((1+i)^-n))/i

1200*(1-((1+0.00583333333)^-200))/0.00583333333

=141436.6873

Alternative II present value total = 2000+141436.6873

143436.6873

Alternative I present value is 142082.5815

Alternative II present value is 143436.6873

So alternative I is cheaper by 1354.11

Answer is II Go with Alt 1. It is cheaper by $1,354.31


Related Solutions

USING MATLAB: A simple mortgage calculator that will output the monthly payment, the remaining balance, and...
USING MATLAB: A simple mortgage calculator that will output the monthly payment, the remaining balance, and so on. years=30; annual_rate=0.04; % 2.75% annual rate house_value=500,000; downpayment=3.5; % 25% down and plot results
The aveedas gross monthly income is 4300.00 . They have 18 remaining payments of 360.00 on...
The aveedas gross monthly income is 4300.00 . They have 18 remaining payments of 360.00 on a new car. They are applying for a 15 year, 71,000 mortgage at 6.5% . The taxes and insurance on the house are 290.00 per month. The bank will only approve a loan that has a total monthly mortgage payment of principal , interest , property taxes and homeowners insurance that is less than or equal to 28% of their adjusted monthly income ....
You need a loan of $160,000 to buy a home. Calculate your monthly payments and total...
You need a loan of $160,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. Choice 1: 30 year fixed rate at 5% with closing costs if $2300 and no points. Choice 2: 30 year fixed rate at 4.5% with closing costs of $2300 and 5 points. What is the monthly payment for choice one? What is the monthly payment for choice two? what is the total closing cost for choice one? what...
Given a mortgage pool with $100,000 principal, scheduled monthly principal payments of $200, CPR of 6%...
Given a mortgage pool with $100,000 principal, scheduled monthly principal payments of $200, CPR of 6% and an age of 40 months. The total expected cash flow from principal payment for the next month is closest to A 481 B 513 C 713
Financial Planning Exercise 7 Calculating monthly mortgage payments EXHIBIT 5.6 A Table of Monthly Mortgage Payments...
Financial Planning Exercise 7 Calculating monthly mortgage payments EXHIBIT 5.6 A Table of Monthly Mortgage Payments (Monthly Payments Necessary to Repay a $10,000 Loan) The monthly loan payments on a mortgage vary not only by the amount of the loan but also by the rate of interest and loan maturity. LOAN MATURITY Rate of Interest 10 Years 15 Years 20 Years 25 Years 30 Years 5.0% $106.07 $79.08 $66.00 $58.46 $53.68 5.5 108.53 81.71 68.79 61.41 56.79 6.0 111.02 84.39...
You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is...
You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is 16 percent. How much will you pay over the course of the loan? With four years left on the loan, how much will you still owe? Excel
You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is...
You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is 16 percent. How much will you pay over the course of the loan? With four years left on the loan, how much will you still owe? excel
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the...
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the United States. If the standard deviation is approximately 180 and the mortgage payments are approximately normally distributed, find the probabilities. Use a TI-83 Plus/TI-84 Plus calculator and round the answers to at least four decimal places. (a) (a)The selected monthly payment is more than $1400 (a)The selected monthly payment is more than 1400 P(Z>1400)= 2) Prison Sentences The average prison sentence for a person...
Suppose that 20 monthly payments of $100 each are followed by 30 monthly payments of $200...
Suppose that 20 monthly payments of $100 each are followed by 30 monthly payments of $200 each. If the interest is at an effective monthly rate of 0.5%, what is the accumulated value of the series at the time of the final payment?
To buy a $160,000​house, you take out a 6​% ​(APR compounded​ monthly) mortgage for $130,000. Five...
To buy a $160,000​house, you take out a 6​% ​(APR compounded​ monthly) mortgage for $130,000. Five years​ later, you sell the house for $195,000 ​(after all other selling​ expenses). What equity​ (the amount that you can keep before​ tax) would you realize with a 30​-year repayment​ term? Note: For tax​ purpose, do not consider the time value of money on​ $30,000 down payment made five years ago. The realized equity will be $____ thousand?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT