You plan to buy a house in 24 months. The cost of the house at that...

You plan to buy a house in 24 months. The cost of the house at that time will be $300,000 . How much do you have to invest each month, starting next month, for 12 months to exactly pay for the house if you r investments earn 4.50% APR (compounded monthly)?

Solutions

Expert Solution

The following are the obtained results in spreadsheet:

The following are the data inputs in spreadsheet:

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You plan to retire in 15 years and buy a house in Oviedo, Florida. The house...

You plan to retire in 15 years and buy a house in Oviedo, Florida. The house you are looking at currently costs $150,000 and is expected to increase in value each year at a rate of 6 percent. Assuming you can earn 9 percent annually on your investments, how much must you invest at the end of each of the next 15 years to be able to buy your dream home when you retire? a. If the house you are...

You are looking to buy your first house. The cost of the house is $325,000. The...

You are looking to buy your first house. The cost of the house is $325,000. The bank has agreed to make a loan to you for 30 years at 3.15% if you can make a down payment of 7.00%, and the loan payments do not exceed 36% of your gross monthly income. Based upon this information: What is the amount of the mortgage loan that the bank will lend to you? What will be the amount of your monthly payments?...

You are planning to buy a house worth $500,000 today. You plan to live there for...

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 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 have decided to become a student landlord and plan to buy a house in “The...

You have decided to become a student landlord and plan to buy a house in “The Village” for $920,000. You parents have agreed to supply $200,000 to be used as a down payment, leaving $720,000 to be financed by means of a mortgage. The mortgage broker has quoted 5.25% quoted rate based on a 25-year amortization, which will be compounded semi-annually in accordance with Canadian law. a) What would be the amount of monthly payments on the mortgage? b) What...

You looking to buy your first house. The cost of the house is $350,000. The bank...

You looking to buy your first house. The cost of the house is $350,000. The bank has agreed to make a loan to you for 30 years at 3.25% if you can make a down payment of 10%, and the loan payments equal 40% of your gross monthly income. Based upon this information: A. What will be the amount of your monthly payments? B. How much is your gross monthly income? C. What must your annual salary be in order...

You wish to buy a house today for $350,000. You plan to put 10% down and...

You wish to buy a house today for $350,000. You plan to put 10% down and finance the rest at 5.20% p.a. for thirty years. You will make equal monthly payments of $_______.

You wish to buy a house today for $350,000. You plan to put 10% down and...

You wish to buy a house today for $350,000. You plan to put 10% down and finance the rest at 5.20% p.a. for thirty years. You will make equal monthly payments of $_______.

You want to buy a house that costs $194,000. You plan on making downpayment of 10%....

You want to buy a house that costs $194,000. You plan on making downpayment of 10%. You found a loan with a 5.9% annual rate compounded monthly for 20 years. How much interest is paid over the life of the loan. Round your answer to two decimal places. Do not include the $ sign in your answer.

Subjects