Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down...

Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down payment. His plans call for making additional monthly deposits into an investment account over the next 36 months. Billy McMahon wants to make the purchase 48 months from today and wants to have $180,000 saved up for the down payment.

a. What is the amount of each of the additional payments he must make for his plan to work out? Assume Billy can earn 2% annual return in his investment account.

b. Prepare an amortization schedule proving the answer you computed in a. is correct.

c. If Billy takes out a 30-year, $720,000 mortgage at 4%, what will his mortgage payments be?

d. Prepare an amortization schedule to prove that your answer is right and his mortgage will be paid off in 30 years.

e. Assume he pays an additional $800 towards his mortgage each month. How much sooner will he be able to pay off her mortgage?

f. Prepare an amortization schedule proving your answer in e.

Solutions

Expert Solution

ekkarill92 answered 11 months ago

Next > < Previous

Related Solutions

Billy McMahon is interested in buying a waterfront condo and has saved $100,000 for the down...

Jacqui has already saved $575,000 as a deposit for a new waterfront villa in the Hamptons.

Jacqui has already saved $575,000 as a deposit for a new waterfront villa in the Hamptons. It will cost her a total of $3.5 million to purchase this property. She plans to borrow the rest from CityGroup over 15 years at a rate of 3.2% p.a. compounding monthly. What would be Jacqui's monthly repayments?

Jaime is buying her first house. He has saved $30,000 for a down payment. The bank...

Jaime is buying her first house. He has saved $30,000 for a down payment. The bank requires 20% down and she found a 30-year loan for 4.9% interest. Jaime finds a house for the maximum amount he could afford. (A) How much can Jaime afford for her house? (B) Find the amount of the mortgage. (C) Find the monthly payment. (D) How much did he end up paying? How much of that was interest?

Suppose you are buying your first condo for $160,000, and you will make a $15,000 down...

Suppose you are buying your first condo for $160,000, and you will make a $15,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 4.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be?

You are buying your first condo for $220,000 and are making a $20,000 down payment. You...

You are buying your first condo for $220,000 and are making a $20,000 down payment. You have arranged to finance the remaining amount with a 30-year monthly payment amortized mortgage at a 5.75% nominal interest rate. What will your monthly payments be? a. $1,167.15 b. $1,900.88 c. $1,200.93 d. $1,962.70 e. $1,324.02 f. $2,100.04 What is the estimated payoff on the mortgage question above after you have paid for 10 years? Show how you obtained the mortgage balance using Excel...

1. You are interested in buying a 2-bedroom condo in Cincinnati. The price is $300,000. You...

1. You are interested in buying a 2-bedroom condo in Cincinnati. The price is $300,000. You have a 30-year 3% APR mortgage with 20% down payment. a. What would be the monthly mortgage payment? b. Suppose you rent the property out and the rental you collect will just cover the mortgage payment. You plan to keep the property till the mortgage matures and do not plan to make any pre-payment. What is your annual investment return (please calculate the bond-equivalent...

You are buying a condo on the beach in Galveston, TX. Here are the details. Overview:...

You are buying a condo on the beach in Galveston, TX. Here are the details. Overview: condo 893 sqft 2 beds $286/sqft 2 baths 673 Built in 2006 131 days on Trulia Description: New washer/dryer, fresh paint in living and kitchen in October. This condo is one of the best on Seawall. enjoy the beautiful interior with its relaxed atmosphere. You'll be drawn to the balcony where you will enjoy the amazing biew of the ocean and enjoy the sounds...

Percentages: A. Mr. Rios saved $ 49 on a television by buying it with a 28%...

Percentages: A. Mr. Rios saved $ 49 on a television by buying it with a 28% discount on the regular price. What was the regular price of the TV? B.The insurance company “Fénix” reported that in one month there were 122 claims. Thirty-seven of the claims were against car insurance. What percent of the claims were against car insurance?

Suppose you are buying a beach house condo for $450,000. You are planning to finance the...

Suppose you are buying a beach house condo for $450,000. You are planning to finance the ENTIRE amount of the condo via a mortgage for 30 years, 5% fixed, 0-points. The HOA fees, property taxes, Annual maintenance + Upkeep of the condo = $12,000 per year. Utilities are $150/month You are planning to rent this condo, and your rental income is $40,000 per year (gross), which goes up by 2% per year. Expenses to rent out the property are 30%...

(In Java Using recursive techniques) When buying a house or condo (using a mortgage), or when...

(In Java Using recursive techniques) When buying a house or condo (using a mortgage), or when taking out a loan, you’ll likely wind up with some form of a fixed monthly payment. Mortgages and loans work this way: You take out a loan from the bank or lender for a specified amount of money at a specified annual interest rate with a specified monthly payment amount At the beginning of every month, interest is added to the amount you owe...

Subjects