Larry Davis borrows $76,000 at 12 percent interest toward the purchase of a home. His mortgage...

Larry Davis borrows $76,000 at 12 percent interest toward the purchase of a home. His mortgage is for 30 years. Use Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. How much will his annual payments be?

How much interest will he pay over the life of the loan?

How much should he be willing to pay to get out of a 12 percent mortgage and into a 10 percent mortgage with 30 years remaining on the mortgage? Assume current interest rates are 10 percent. Carefully consider the time value of money. Disregard taxes.

Solutions

Expert Solution

Answer A) Loan amortisation at 12% for 30*12= 360 months for the borrowing of $76000

using formula in excel = PMT(12%/12,360,-76000,0,1)

Loan Principle Amount		76,000.00
Annual Interest Rate		12.00%
Loan Period (in months)		360.00
Original Repayment Amount(monthly)		781.75

His annual payments be = 781.75 * 12 = $ 9381

Answer B)

The complete calculation of loan will be as below:

Repayment Number	Opening Balance	Loan Repayment	Interest Charged	Capital Repaid	Closing Balance
1	$76,000.00	$781.75	$760.00	$21.75	$75,978.25
2	$75,978.25	$781.75	$759.78	$21.96	$75,956.29
3	$75,956.29	$781.75	$759.56	$22.18	$75,934.11
4	$75,934.11	$781.75	$759.34	$22.40	$75,911.70
5	$75,911.70	$781.75	$759.12	$22.63	$75,889.08
6	$75,889.08	$781.75	$758.89	$22.85	$75,866.22
…………………..
357	$3,050.34	$781.75	$30.50	$751.24	$2,299.10
358	$2,299.10	$781.75	$22.99	$758.75	$1,540.35
359	$1,540.35	$781.75	$15.40	$766.34	$774.01
360	$774.01	$781.75	$7.74	$774.01	$0.00
	Total	$281,428.41	$205,428.41	$76,000.00

Total Interest paid = $ 205428.41

Answer ) in case of 10 % loan calculation will be

Loan Principle Amount		76,000.00
Annual Interest Rate		10.00%
Loan Period (in months)		360.00
Original Repayment Amount(month)		666.95

Annual payment = 12 * 666.95 = $8003.45

Per year Saving to switch in 10% from 12% = $ 9381 - $8003.45=$1377.55

Total Benefit = PV ( $1377.55 for 30 years @ 10%)

Benefit = $12985.10 , as calculated below

years	Benefits	PV( Benefit)
1	$1,377.45	$1,252.23
2	$1,377.45	$1,138.39
3	$1,377.45	$1,034.90
4	$1,377.45	$940.82
5	$1,377.45	$855.29
6	$1,377.45	$777.53
7	$1,377.45	$706.85
8	$1,377.45	$642.59
9	$1,377.45	$584.17
10	$1,377.45	$531.07
11	$1,377.45	$482.79
12	$1,377.45	$438.90
13	$1,377.45	$399.00
14	$1,377.45	$362.73
15	$1,377.45	$329.75
16	$1,377.45	$299.77
17	$1,377.45	$272.52
18	$1,377.45	$247.75
19	$1,377.45	$225.22
20	$1,377.45	$204.75
21	$1,377.45	$186.14
22	$1,377.45	$169.21
23	$1,377.45	$153.83
24	$1,377.45	$139.85
25	$1,377.45	$127.13
26	$1,377.45	$115.58
27	$1,377.45	$105.07
28	$1,377.45	$95.52
29	$1,377.45	$86.83
30	$1,377.45	$78.94

	Total benfits	$12,985.10

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Larry Davis borrows $78,000 at 11 percent interest toward the purchase of a home. His mortgage...

Larry Davis borrows $78,000 at 11 percent interest toward the purchase of a home. His mortgage is for 25 years. Use Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. How much will his annual payments be? (Although home payments are usually on a monthly basis, we shall do our analysis on an annual basis for ease of computation. We will get a reasonably accurate answer.) (Do not round intermediate...

What will be the monthly payment on a home mortgage of $80,000 at 12% interest, to...

What will be the monthly payment on a home mortgage of $80,000 at 12% interest, to be amortized over 30 years? (Note: Since there are monthly payments, monthly compounding occurs) A. $771.46 B. $822.89 C. $925.75 D. $1,034.533

Gerry plans to purchase a $325,000 home with a 30 year mortgage and a 4.25% interest...

Gerry plans to purchase a $325,000 home with a 30 year mortgage and a 4.25% interest rate. Calculate his monthly payment to the nearest cent.

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years?

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years.

Suppose you want to purchase a home for $375,000 with a 30-year mortgage at 5.14% interest....

Suppose you want to purchase a home for $375,000 with a 30-year mortgage at 5.14% interest. Suppose also that you can put down 25%. What are the monthly payments? (Round your answer to the nearest cent.) What is the total amount paid for principal and interest? (Round your answer to the nearest cent.) What is the amount saved if this home is financed for 15 years instead of for 30 years? (Round your answer to the nearest cent.) $

This year, Major Healy paid $35,500 of interest on a mortgage on his home (he borrowed...

This year, Major Healy paid $35,500 of interest on a mortgage on his home (he borrowed $710,000 to buy the residence in 2015; $810,000 original purchase price and value at purchase), $5,500 of interest on a $110,000 home equity loan on his home (loan proceeds were used to buy antique cars), and $8,000 of interest on a mortgage on his vacation home (borrowed $160,000 to purchase the home in 2010; home purchased for $400,000). Major Healy’s AGI is $220,000. How...

In 2018, Bogart paid $20,000 of interest on a mortgage on his home (Bogart borrowed $600,000...

In 2018, Bogart paid $20,000 of interest on a mortgage on his home (Bogart borrowed $600,000 in 2015 to buy this primary residence and it is currently worth $1,000,000). In 2018 Bogart also paid $12,000 of interest on a $150,000 home equity loan on his home, and $10,000 of interest on a mortgage on his vacation home (loan of $300,000; home purchased for $400,000 in 2016). How much interest expense can Bogart deduct as an itemized deduction in 2018?

George secured an adjustable-rate mortgage (ARM) loan to help finance the purchase of his home 5...

George secured an adjustable-rate mortgage (ARM) loan to help finance the purchase of his home 5 years ago. The amount of the loan was $250,000 for a term of 30 years, with interest at the rate of 9%/year compounded monthly. Currently, the interest rate for his ARM is 5.5%/year compounded monthly, and George's monthly payments are due to be reset. What will be the new monthly payment? (Round your answer to the nearest cent.)

Mortgage interest rates and home prices 30-year mortgage rates year interest rate (%) Median home price...

Mortgage interest rates and home prices 30-year mortgage rates year interest rate (%) Median home price 1988 10.30 183,800 1989 10.30 183,200 1990 10.10 176,900 1991 9.30 173,500 1992 8.40 172,900 1993 7.30 173,200 1994 8.40 173,200 1995 7.90 169,700 1996 7.60 174,500 1997 7.60 177,900 1998 6.90 188,100 1999 7.40 203,200 2000 8.10 230,200 2001 7.00 258,200 2002 6.50 309,800 2003 5.50 329,800 1. Generate two separate scatter plots, following the requirements below, with the data provide. a. year...

Subjects