Question

In: Finance

In order to buy a house, Sebastian Cifuentes is going to borrow $450,000 today with a...

In order to buy a house, Sebastian Cifuentes is going to borrow $450,000 today with a 8 percent nominal annual rate of interest. He is going to make monthly payments over 25 years. Assume full amortization of the loan. If he pays an extra $500 toward principal each month, what will be the ending balance after two monthly payments?

A. $449,050

B. $448,047

C. $445,027

D. $450,012

E. $473,463

Solutions

Expert Solution

Answer is: B. $448,047

Solution:

Present Value                            450,000
Rate 8%
Monthly rate 0.67%
Number of periods (25 * 12 months)                                    300
Monthly payment                                3,473
Month Opening Balance Principal Interest Payment (+ 500) Ending Balance
1                            450,000                      973                    3,000                                         3,973                      449,027
2                            449,027                      980                    2,994                                         3,973                      448,047

Excel formulas:

Formula to find Monthly payment without excel:

Where,
PVA = Present value of annuity
A = Annuity or payment
i = Interest rate in decimal form
a = Number of payments in a year
n = Number of years

Since he pays $500 extra toward principal, the monthly payment will be $3473 + 500 =  $3,973


Related Solutions

You borrow $271,096 today to buy a house. You plan to make monthly payments over a 12-year period.
You borrow $271,096 today to buy a house. You plan to make monthly payments over a 12-year period. The bank has offered you a 4.06% interest rate, compounded monthly.What is your monthly payment amount?
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is 20 years. You obtain a 5-year fixed rate mortgage from TD bank at 2%/year (using Canadian mortgage convention). (a) How much do you owe the bank after the 60th payment? (b) For the 24th monthly payment, how much of it is for interest, and how much of it is for principal repayment? d) What is the present value of the interest portion of the...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is 20 years. You obtain a 5-year fixed rate mortgage from TD bank at 2%/year (using Canadian mortgage convention). (a) What is your monthly payment? (b) How much do you owe the bank after the 60th payment? (c) For the 24th monthly payment, how much of it is for interest, and how much of it is for principal repayment? (d) What is the present value...
You want to buy a house and will need to borrow $245,000. The interest rate on...
You want to buy a house and will need to borrow $245,000. The interest rate on your loan is 5.77 percent compounded monthly and the loan is for 30 years. What are your monthly mortgage payments?
You are planning to buy a house today. The house costs $350,000. You have $50,000 in...
You are planning to buy a house today. The house costs $350,000. 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. The bank is offering a 30​-year mortgage that requires annual payments and has an EAR of 5% per year. What will be your annual mortgage​ payment?
On March 1, you borrow $239,000 to buy a house. The mortgage rate is 7.75%. The...
On March 1, you borrow $239,000 to buy a house. The mortgage rate is 7.75%. The loan is to be repaid in equal monthly payments over 20 years. The first payment is due on April 1. How much of the third payment applies to the principal balance? (Assume that each month is equal to 1/12 of a summer).
You borrow $149000 to buy a house. The mortgage rate is 7.5% and the loan period...
You borrow $149000 to buy a house. The mortgage rate is 7.5% and the loan period is 30 years. Payments are made monthly. What is the monthly mortgage payment.
Question 3: Floating Rate Mortgage (8 marks) John is planning to buy a house worth $450,000,...
Question 3: Floating Rate Mortgage John is planning to buy a house worth $450,000, has $100,000 in savings that he will use as adown-payment and will borrow the remainder via a mortgage. He selects a floating rate, closed mortgage with a 3 year term and 25 year amortization period. He will make monthly payments and be charged an interest rate of 3.35% p.a., compounded semi-annually. Part A: How much will John owe after 1 year has passed if interest rates...
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and...
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and wish to repay the mortgage loan and the interest in 5 equal annual payments, the first one being payable on 12/31/20x1. The mortgage loan bears interest at 7%.         a) Calculate the annual mortgage payment required. Round off to the nearest cent (e.g.,    $112,753.32). b) Construct the mortgage payment schedule to see if the loan and interest will be paid    in full...
If you borrow $350,000 for 30 years at 4% annual interest rate to buy a house,...
If you borrow $350,000 for 30 years at 4% annual interest rate to buy a house, how much would you have to pay “at the end of each year” to the bank to pay it off over the full period?  If you had to pay “monthly” instead of “annually,” would the total cost be more, the same, or less?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT