Question
In: Finance
You are considering the purchase of a home for $700,000. You have available a deposit of...
- 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
jeff jeffy answered 1 year agoRelated 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
Latest Questions
- For Questions 1-3: consider the following code: public class A { private int number; protected String...
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
ADVERTISEMENT