Question

In: Finance

You are considering the purchase of a home for $700,000. You have available a deposit of...

  1. You are considering the purchase of a home for $700,000. You have available a deposit of $100,000. The bank will lend you money at 7 per cent per annum compounded monthly over a period up to 20 years. If you borrow the required funds over 20 years, what are the monthly repayments? After two years, how much do you still ow the bank? What is the interest component of the 25th repayment?

Solutions

Expert Solution

1. Monthly payment = Loan amount / present value Annuity factor(0.07/12,20*12)

i = Interest rate per month = 0.07/12 = 0.583%

Total payment periods = n = 20 years * 12 months = 240

Monthly payment = 600000 * i / [ 1 - (1+r)^-n]

Monthly payment = 600000 * 0.583% / [ 1 - (1.00583)^-240]

Monthly payment = 600000 * 0.583% / [ 1 - 0.24760]

Monthly payment = $4649.18 (approx)

2.

Cumulative principal paid = $29579.25

Loan balance after 2 years = 600000 - 29579.25 = 570420.75

3. Interest amount in payment 25 = $3327.45

*Please comment if you face any difficulty and please don't forget to thumbs up


Related Solutions

You are considering the purchase of a really nice home in three years. You have $100,000...
You are considering the purchase of a really nice home in three years. You have $100,000 in your bank savings account today but would rather wait to buy the house. You plan to leave the money there for three years under 4% APR with monthly compounding. You understand that this money alone will not be enough to buy the house of your dreams, so when it’s time to buy the house you will have to take out a mortgage loan....
The Jones’ have $50,000 in savings available for upfront costs on a home purchase. They qualified...
The Jones’ have $50,000 in savings available for upfront costs on a home purchase. They qualified for a 30-year mortgage at 4.5 percent APR. They also expect closing costs to total $4,000. They have budgeted $1,500 per month to allocate to housing costs, including monthly nonfinancing costs of $100 for homeowner’s insurance, $200 for property taxes, $150 for repairs and $50 for maintenance. What is the maximum they can afford to pay for a home? Show your work.
The Simpson’s are considering the purchase of a home. They currently have a combined annual gross...
The Simpson’s are considering the purchase of a home. They currently have a combined annual gross income of $68,000. Current Monthly Expenses are as follows: Car Payment $320 Credit Card$100 Student Loan $220 Their proposed mortgage payment (p&i) will be $820 per month, with an additional $70 per month for private mortgage insurance (PMI).Annual property taxes and homeowner’s insurance are $1,800 and $1,200 respectively. Complete the below worksheet to calculate the front end and back end ratios. Gross Monthly Income...
You have a sum of $10,000 available for investments. You are offered two options: Deposit the...
You have a sum of $10,000 available for investments. You are offered two options: Deposit the sum in a bank for 3 years, with an interest rate of 10% compounded annually. The bank is also prepared to take on any additional investments at the same rate at any time for the next 3 years. Invest the $10,000 in a project with an annual return of $4200. The project life is 3 years. Which is the preferred option? Explain your answer....
Problem 1 Zmolek Company is considering the purchase of a machine costing ₱700,000 with a useful...
Problem 1 Zmolek Company is considering the purchase of a machine costing ₱700,000 with a useful life of 10 years. Annual cash cost savings are expected to be ₱200,000. Zmolek's income tax rate is 40% and its cost of capital is 12%. Zmolek expects to use straight-line depreciation for tax purposes. Required: 1. Compute the expected increase in annual net cash flow for this project. 2. Compute the profitability index for the project. Problem 2 Racine Co. has the opportunity...
You are considering the purchase of a new home offered at a price of $225,000. Create...
You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: You will be making a down payment of 20% on the home. The bank will offer you a loan at an annual interest...
You are considering the purchase of a new home offered at a price of $225,000. Create...
You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: You will be making a down payment of 20% on the home (refer to Table 2.5 for loan and lease terms). The bank...
You are considering the purchase of a home priced at $175,000, using 15% down.
You are considering the purchase of a home priced at $175,000, using 15% down. The rest will be financed at 4.29% over 360 months.   What is your monthly payment expected to be?A) $853B) $1,187C) $735.25D) $556.7914) For the loan in #13, what is the loan constant?A) 5.93%B) 4.29%C) 8.17%D) 6.77%15) If there were 2 points and $790 in fees to the lender to be paid to obtain the interest rate in problem #13, what would be the APR of the...
You are considering the purchase of a home that would require a mortgage of $250,000 (i.e....
You are considering the purchase of a home that would require a mortgage of $250,000 (i.e. you are borrowing $250,000 from a bank to buy the house. You intend to pay the bank back through equal monthly instalments). Suppose you are interested in the arithmetic sum of all the instalments you pay. How much more in total will you pay if you select a 30-year mortgage with an APR of 5.65% rather than a 15-year mortgage at an APR 4.9%?...
LEZ Enterprises, Inc. has been considering the purchase of a new manufacturing facility for $700,000. The...
LEZ Enterprises, Inc. has been considering the purchase of a new manufacturing facility for $700,000. The facility is to be depreciated on a straight line basis over 14 years. It is expected to have no value after those 14 years. Cash flow from depreciation are considered to be risk-free and so they should be discounted at the risk-free rate. Operating revenues from the facility are expected to be $160,000 during the first year. The revenues are expected to increase at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT