Question

In: Economics

You buy a new home for $500,000 on the first day of the month. You put...

You buy a new home for $500,000 on the first day of the month. You put down $50,000 and finance the rest with a mortgage at 6% annual interest compounded monthly on the last day of the month. Your monthly payments including principal and interest are 2500. Your payments are due on the first day of the month, starting next month. What is your loan balance after your third monthly payment ? explain how you got the answer !

Solutions

Expert Solution

First Method

Loan amount=500000-50000=$45000

Rate of interest=i=6%/12=0.5% per month

Interest for first installment=450000*0.5%=$2250

Amount due after 1st month=450000+2250=$452250

Balance due after 1st installment=452250-2500=$449750

Interest for second installment=449750*0.5%=$2248.75

Amount due after 2nd month=449750+2248.75=$451998.75

Balance due after 2nd installment=451998.75-2500=$449498.75

Interest for third installment=449498.75*0.5%=$2247.49

Amount due after 3rd month=449498.75+2247.49=$451746.24

Balance due after 3rd installment=451746.24-2500=$449246.24

With this method, we can calculate for small number of periods but it becomes very lengthy if period of payment is long. So, we can go for formula.

Second method

Balance due after 3rd installment=450000*(F/P,0.5%,3)-2500*(F/A,0.5%,3)

Let us calculate interest factors

(F/P,0.005,3)=(1+0.005)3=1.015075

Balance due after 3rd installment=450000*1.015075-2500*3.015205=$449246.24


Related Solutions

You need a 30-year, fixed-rate mortgage to buy a new home for$500,000. You will pay...
You need a 30-year, fixed-rate mortgage to buy a new home for $500,000. You will pay 20 percent down and borrow the rest at an APR of 6 percent compounded monthly. However, you can only make monthly payments of $1,800. The lender offers that you pay off the remaining loan balance at the end of 30 years as a single balloon payment. What will be the amount of the balloon payment if you are to keep your monthly payments at...
You buy a stock at $200 and buy an at-the-money 8-month European put option on the...
You buy a stock at $200 and buy an at-the-money 8-month European put option on the stock at a price of $15. The continuously compounded risk-free interest rate is 4%. Calculate the 8-month profit if the 8-month stock price is $180.
You want to buy a new piece of equipment for your business that costs $500,000. You...
You want to buy a new piece of equipment for your business that costs $500,000. You believe you can use the equipment to increase your gross profit by $45,000 each year for the next 15 years. The equipment will be depreciated over 10 years using straight-line depreciation and the half-year convention. Insurance for the new equipment will cost $150 per month. Utility and maintenance expense to support the new equipment will amount to $1,000 per month. Your business’ income tax...
You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. a. Calculate the monthly payments. b- Calculate the 1st month interest payment. c-Calculate the 1st month principal payments
You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. A. Calculate the 1st month interest payments B.Calculate the 1st month principal payments C.  Calculate the monthly payments. Place answer in the box below and use 2 decimals and no $ sign
You want to buy a new car for $25,000. You put $2000 down and are given...
You want to buy a new car for $25,000. You put $2000 down and are given $2000 as trade-in for your current car. You take out a loan for the remaining $21,000. The terms of the loan are an annual interest rate of 4.8% compounded monthly. You are to make 60 equal monthly payments (end of month) to pay off the loan. how can i get the answer using excel
Suppose that you wish to buy a new home that will cost you $482,472. You must...
Suppose that you wish to buy a new home that will cost you $482,472. You must put $80,000 down, and the bank offers you a 5-year 5.4% APR negative amortization loan with a payments $1,218 per month, and a balloon payment of $67,789 (your 360th payment). How much will your remaining payments be?
Suppose that you wish to buy a new home that will cost you $560,000. You must...
Suppose that you wish to buy a new home that will cost you $560,000. You must put $90,000 down, and will finance the rest at 3.6% APR, making monthly payments for 30 years at the end of each month. However, the loan is structured with a balloon payment of $100,000 in the last month. How much will your remaining monthly payments be?
Suppose that you wish to buy a new home that will cost you $467,043. You must...
Suppose that you wish to buy a new home that will cost you $467,043. You must put $80,000 down, and the bank offers you a 5-year 4.7% APR negative amortization loan with a payments $1,259 per month, and a balloon payment of $55,468 (your 360th payment). How much will your remaining payments be?
Suppose that you wish to buy a new home that will cost you $452,847. You must...
Suppose that you wish to buy a new home that will cost you $452,847. You must put $80,000 down, and the bank offers you a 5-year 5.1% APR negative amortization loan with a payments $1,258 per month, and a balloon payment of $92,233 (your 360th payment). How much will your remaining payments be?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT