Question

In: Finance

Josh and his new wife Samantha are buying their first house together. They secured a loan...

Josh and his new wife Samantha are buying their first house together. They secured a loan for $435,000 at a rate of 9.275% per year for 30 years.

SHOW FORMULAS USED

1)How much are the monthly payments?

2)6 years later, the couple decides they want to refinance their home. How much do they currently owe on the home?

3)The bank is offering a special deal of 6.35% on all home refinances. What would their new monthly payment be?

4)The couple is saving money for their first child. Now that they have refinanced their home, how much will the couple save every month?

5)The couple has made significant upgrades to their home which is currently valued at $575,000. Based on how much they owe at the time of refinance, how much equity do they have?

Solutions

Expert Solution

1]

Monthly loan payment is calculated using PMT function in Excel :

rate = 9.275% / 12   (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 435000 (loan amount)

PMT is calculated to be $3,586.52

2]

We calculate the principal paid off after 6 years (72 months) using CUMPRINC function in Excel :

rate = 9.275% / 12 (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 435000 (original loan amount)

start period = 1 (We are calculating principal paid off between 1st and 72nd month)

end period = 72 (We are calculating principal paid off between 1st and 72nd month)

type = 0 (each payment is made at the end of month)

CUMPRINC is calculated to be $21,502.03

The balance loan principal outstanding after 6 years =  $435,000 - $21,502.03 = $413,497.97

3]

Monthly loan payment is calculated using PMT function in Excel :

rate = 6.35% / 12   (converting annual rate into monthly rate)

nper = 24*12 (24 year loan with 12 monthly payments each year)

pv = 413497.97 (loan amount)

PMT is calculated to be $2,800.64

4]

Monthly saving =  $3,586.52 - $2,800.64 = $785.88


Related Solutions

1.Bob and his wife are buying a $300,000 house. They put 20% down and finance the...
1.Bob and his wife are buying a $300,000 house. They put 20% down and finance the $240,000 balance with a 30-year mortgage at 6.50% APR with monthly compounding. Compute the mortgage portion of their monthly payment. Round your answer to the nearest penny. For example, $2,371.243 should be entered as 2371.24 2.You just returned from a friend’s overseas wedding and you’ve run up a $5,000 bill on your credit card that charges 19.90% per year, compounded monthly. Your plan is...
Sarah secured a bank loan of $155,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $155,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 5 years. How much will Sarah still owe on her house? (Round your answer to the nearest cent.)
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $____
Sarah secured a bank loan of $175,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $175,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time?
Sarah secured a bank loan of $165,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $165,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $
The Flemings secured a bank loan of $240,000 to help finance thepurchase of a house....
The Flemings secured a bank loan of $240,000 to help finance the purchase of a house. The bank charges interest at a rate of 4%/year on the unpaid balance, and interest computations are made at the end of each month. The Flemings have agreed to repay the loan in equal monthly installments over 25 years. What should be the size of each repayment if the loan is to be amortized at the end of the term? (Round your answer to...
You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A) How...
You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A) How much will your monthly payments be? B) How much will go toward principal in the 75th month? How much will go toward interest in the 75th month? What will be the balance after 75 months? C) How much interest will you pay in total over the 30 years? D) If you do a 15-year loan instead of a 30-year one, how much will you...
You are buying a new house on a 30-year, 6.2% mortgage loan of $230,000. A. How...
You are buying a new house on a 30-year, 6.2% mortgage loan of $230,000. A. How much will your monthly payments be? B. How much will go toward principal in the 55th month? How much will go toward interest in the 55th month? What will be the balance after 55 months? C. How much interest will you pay in total over the 30 years? D. If you do a 15-year loan instead of a 30-year one, how much will you...
Samantha and Vikas are looking to buy a house in a new development. After looking at...
Samantha and Vikas are looking to buy a house in a new development. After looking at various models, the three models they like are colonial, split-entry, and single-story. The builder gave them the base price and the finished area in square feet of the three models. They want to know the model(s) with the least price per square foot. Instructions Write a program that accepts as input the base price and the finished area in square feet of the three...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT