None You are financing a new home. Theloan is for $268,000 and you aregetting rate of 4.9% per yearcompounded monthly. You havedecided on a 15-year mortgageand will make monthly payments (end of the month). You will pay 6%down. To get the ball rolling, you areworking extra hours and expect topay an extra $375 per month toknock down the principle. You makethese payments for 6 years startingon month 25. The last EXTRApayment is on month 96. Build theamortization table. What month willyou make your last payment? Howmuch will the last payment be?

To build the amortization table, we'll start by calculating the monthly payment using the loan…

Answered: You are financing a new home. The loan…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

Joseph obtained a loan of $30,000.00 at 5.90% compounded quarterly. How long (rounded up to the next payment period) will it take to settle the loan with payments of $1,400.00 at the end of every 3 months? You plan to save money for a down payment of $37,000 to purchase an apartment. You can only afford to save $6,000 at the end of every 6 months into an account that earns interest at 6.50% compounded monthly. How long will it take you to save the planned amount?
You are financing a new home. The loan is for $281,000 and you are getting rate of 3.9% per year compounded monthly. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball rollng, you are working extra hours and expect to pay an extra $550 per month to knock down the principle. You make these EXTRA payments for 5 years starting on month 1. The last EXTRA payment is on month 60. Build the amortization table. What month will you make your last payment? How much will the last payment be? I Need this excel sheet please!
You are ready to buy a house and you have $75,000 for a down payment and closing costs. Closing costs are estimated to be 4.5% of the loan value. You have an annual salary of $115,000. The bank is willing to allow your monthly mortgage payment to be equal to 25% of your monthly income. The annual percentage rate on the loan is 6.5% per year with monthly compounding for a 15-year fixed rate loan. Create a loan amortization table in Excel for the original problem (6.5%). Show formulas.
You are buying your first house for $220,000 and are paying $30,000 as a down payment. You have arranged a 30-year mortgage loan with a 7% nominal interest rate and monthly payments. What are the equal monthly payments you must make?
You have decided to buy a car that costs $25,800. Since you do not have a big down payment, the lender offers you a loan with an APR of 6.01 percent compounded monthly for 6 years with the first monthly payment due today. What is the amount of your loan payment?
You need to borrow $750,000 to purchase a new house. JRE bank will loan you the money at an APR of 4.3% (monthly compounding) and a 15 year term (i.e. 180 monthly payments in total). After making exactly 27 payments, what is the total amount of interest you will have paid (rounded to the nearest dollar)? The total amount of interest is closest to: A. $63,309 OB. $84,140 c. $68,709 OD. $70,734 ...
You are ready to buy a house and you have $35,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $50,000. The interest rate on the loan is 5.75% per year with monthly compounding for a 20-year fixed rate loan. (a) The bank is willing to allow your monthly mortgage payment to be equal to 30% of your monthly income. Calculate the maximum amount the bank will loan you? (b) What is the maximum amount you can offer for the house if you borrow the maximum amount found in part (a)?
You took out a mortgage for $600,000. You need to pay $5,873 every month for 15 years. The monthly rate is 0.6999%. What is the APR?
You are planning to build a vacation home. Your rich uncle offers you a $35,000 loan at 10.5% interest if you make $325 per month payments at the end of each month, how many payments will be required to pay off the loan, and how many years will this take? show relevant calculation
You are considering the purchase of a $140,000 home and making a 20% down payment. You can obtain a 15 year mortgage at 6.50%, but you can get a 5.85% rate by paying 2 discount. Assuming the payments are reinvested, what is the breakeven in months?
You have just taken out a $15,000 car loan with a 7% APR, compounded monthly. The loan is for 5 years. When you make your first payment in one month, how much of the payment will go toward the principal of the loan and how much will go toward interest? The amount of your first payment that will go toward the interest of the loan is The amount of your first payment that will go toward the principal of the loan is
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?

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

SEE MORE TEXTBOOKS