Question

You are planning to buy a house worth $500,000 today. You plan to live there for 15 years and then sell it. Suppose you have $100,000 savings for the down payment. There are two financing options: a 15-year fixed-rate mortgage (4.00% APR) and a 30-year fixed-rate mortgage (5.00% APR). The benefit of borrowing a 30-year loan is that the monthly payment is lower. But since you only plan to hold the house for 15 years, when you sell the house you still owe the bank and you have to use part of the proceeds to repay the loan. Suppose if you take the 30-year loan, you can use the money saved from the lower monthly payment to invest in a stock portfolio that generates 10% annual return (APR). Which loan should you take? With proper formulas

a. What is the monthly payment if you take the 15-year loan?

b. What is the monthly payment if you take the 30-year loan?

c. What is the remaining balance of the 30-year loan at the end of 15 years ?

d. If you take the 30-year loan and use the money saved from the lower monthly payment (compared with that of a 15-year loan) to invest in the stock market and earn 10% annual return (APR), how much do you expect to have in your investment account at the end of 15 years?

e. Suppose you take the 30-year loan, use the money saved from the lower monthly payment to invest in the stock market as in (d), and sell the house for $700,000 in 15 years, how much money do you have after repaying the remaining loan amount?

f. Compared with the other option, where you take the 15-year loan and sell the house at the end of 15 years for $700,000, which option is better?

Answer #1

Please do rate me and mention doubts, if any, in the comments
section.

Aya and Harumi would like to buy a house and their dream house
costs $500,000. They have $50,000 saved up for a down payment but
would still need to take out a mortgage loan for the remaining
$450,000 and they’re not sure whether they could afford the monthly
loan payments. The bank has offered them an interest rate of 4.25%,
compounded monthly. How much would they have to be able to afford
to pay each month in order to pay...

You are planning to purchase a house for $180,000. You will pay
20% down payment and take a mortgage loan for the remaining 80%.
You could get a 3/1 ARM amortized over 15 years at 3.9 % or a fixed
15 year FRM loan at 5.3%. The expected interest rate of the ARM
from years 4 to 5 is 7.5%. You will live in the house for five
years, and after that you expect to sell the house for $200,000...

Consider a 30‐year mortgage on at $400,000 house that requires
monthly payments and has an interest rate (APR) of 8% per year. You
have $ 50,000 in cash that you can use as a down payment on the
house, but you need to borrow the rest of the purchase
price.
a) What will your monthly payments be if you sign up for this
mortgage?
b) Suppose you sell the house after 10 years. How much will you
need to pay...

1.)
You
want to buy a house in Hermosa Beach CA, but you can only afford to
make monthly payments of $7,100. The interest rate on mortgages
right now is 4.25% p.a. with monthly compounding (APR), fixed for
30 years, with monthly payments. You have $155,000 saved to use as
a downpayment. What is the most that you can afford to pay for a
house (ignoring closing costs, property taxes, etc..)?
Answer: $1,598,265.76
2.)
Under
the same assumptions described in...

Frodo is going to buy a new house for $304,000. The bank will
offer a loan for the total value of the house at 7.6% APR for 20
years. What will be the monthly payment for this mortgage?
To answer this question which calculator will you use?
Systematic Savings - Find total saved with a monthly deposit
Systematic Savings - Find monthly deposit to achieve a savings
goal
Loan - Find monthly payment for a loan
Loan - Find loan...

You have been saving money to buy a home and today, you decided
to buy a home and take out $350,000 mortgage loan from a bank. This
loan requires you to make a monthly payment for 30 years and the
interest rate on your loan is 4% APR compounded monthly. What is
your monthly mortgage payment for this loan? Please show your excel
formula in your answer and explain step-by-step calculation to
arrive to your answer.

you borrowed $500,000 to buy a house. The mortgage rate s 24%
(APR, monthly). The loan is to be repaid in equal monthly payments
over 30 years. 29 years has passed. How much you owe to the bank on
your home (loan principal) since you have 1 year left from your
mortgage? Assume that each month is equal to 1/12 of a year.

You want to buy your dream house. You currently have $15,000
saved and you need to have a 10% down payment plus an additional 5%
of the loan amount for closing costs. Assume the cost of the house
is $956,216. You can earn 7.5% per year in a savings account per
year. How long will it be before you have enough money for the down
payment and closing costs?
Given your current credit, you secure a 15-year fixed rate
mortgage...

You plan to buy a house that has the sale price of $180,000. A
local bank can offer you a conventional 30-year mortgage with 20%
down payment and 4% APR. The bank also charge you 2% fees off the
loan amount, including origination fee, document fee and etc. How
much would be your upfront payment and monthly mortgage payment
(a) Upfront payment
(b) Monthly mortgage payment

You are planning to buy a house today. The house costs $400000.
You have $57000 in cash that you can use as a down payment on the
house, but you need to borrow the rest of the purchase price. The
bank is offering a 30 -year mortgage that requires annual payments
and has an EAR of 8% per year. What will be your annual mortgage
payment?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 8 minutes ago

asked 10 minutes ago

asked 17 minutes ago

asked 32 minutes ago

asked 32 minutes ago

asked 39 minutes ago

asked 39 minutes ago

asked 46 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago