If you took a home mortgage loan of$200.000 for 30 years at 9.2%. compoundedmonthly. Suppose after 5 years you had anadditional $10.000. Would you save more overthe life of the loan by paying an extra $10,000(one-time) with your 60th payment or bypaying $2,000 per month beginning with the61st payment? To help you answer thisquestion, complete the following.(a) Find monthly payments and find theunpaid balance after 60th payments with andwithout extra payment.(b) Determine how long it takes to pay off theloan with the regular payments you calculatedin (a) and the additional $10.000 payment.Then find the total interest paid.(c) Determine how long it takes to pay off theloan without the additional $10,000 payment,but with monthly payments of $2.000 fromthe 61st paymentThen find the total interest paid.(d) Which payment method costs less?

Loans and mortgages are paid by equal constant installments but payment for interest and payment for…

If you took a home mortgage loan of $200.000 for 30 years at 9.2%. compounde monthly. Suppose after 5 years you had an additional $10.000. Would you save more c the life of the loan by paying an extra $10,C (one-time) with your 60th payment or by paying $2,000 per month beginning with t 61st payment? To help you answer this

If you took a home mortgage loan of $200.000 for 30 years at 9.2%. compounde monthly. Suppose after 5 years you had an additional $10.000. Would you save more c the life of the loan by paying an extra $10,C (one-time) with your 60th payment or by paying $2,000 per month beginning with t 61st payment? To help you answer this

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 3PB: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...

See similar textbooks

Similar questions

Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
You lend $450 to a friend who promises to make 4 payments to you of $120 at the end of 6 months, 12 months, 18 months and 24 months. Draw a timeline from your perspective. If you can reliably earn 5% per year, what is the net present value (NPV) of this loan?
If you took a home mortgage loan of $150,000 for 30 years at 8.4%, compounded monthly your monthly payment would be $1142.76. Suppose after 2 years you had an additional $2000. Would you save more over the life of the loan by paying an extra $2000 with your 24th payment or by paying $1160 per month beginning with the 25th payment? To help you answer this question, complete the following, a) Find the unpaid balance after 24 payments (both including and not including the $2000 payment). b) Determine how long it takes to pay off the loan with the regular $1142.76 payments and the additional $2000 payment. Then find the total interest paid. c) Determine how long it takes to pay off the loan without the additional $2000 payment but with monthly payments of $1160 from the 25th payment. Then find the total interest paid. d) Which payment method costs less?
If you took a home mortgage loan of $150,000 for 30 years at 8.4%, compounded monthly, your monthly payments would be $1142.76. Suppose after 2 years you had an additional $2000. Would you save more over the life of the loan by paying an extra $2000 (one-time) with your 24th payment or by paying $1160 per month beginning with the 25th payment? To help you answer this question, complete the following. (a) Find the unpaid balance after 24 payments (b) Determine how long it takes to pay off the loan with the regular $1142.76 payments and the additional $2000 payment. Then find the total interest paid. (c) Determine how long it takes to pay off the loan without the additional $2000 payment, but with monthly payments of $1160 from the 25th payment. Then find the total interest paid. (d) Which payment method costs less?
After making payments of $901.10 for 8 years on your 30 year loan at 8.3%, you decide to sell your home. What is the loan payoff?
After making payments of $891.10 for 6 years on your 30-year loan at 8.1%, you decide to sell your home. What is the loan payoff? (Round your answer to two decimal places.)
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.
After making payments of $901.10 for 6 years on your 30-year loan at 8.9%, you decide to sell your home. What is the loan payoff?
You purchase a house and obtain a 30-year loan of $198,000 at an annual interest rate of 8.30%. (Round your answers to the nearest cent.) (a) What is the mortgage payment?$ (b) What is the total of the payments over the life of the loan?$ (c) Find the amount of interest paid on the mortgage loan over the 30 years.$
there is a house on sale for $800,000. You believe you can finance the home for $500,000 for 20 years at a 2% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel.
Suppose that you borrowed $300,000 to buy a house. a. You pay 3.37% interest rate for a 30-year loan. Create an amortization table with a spreadsheet, which clearly shows the monthly payment and how much you would pay in total interest over the whole loan. monthly payment = $ 1,325.46 total interest paid = $ 177,165.05