Please solve via excel and show calculation steps to solve table. Scenario: You have decided to finance a new home. The loan is for $248,000 and you are getting a rate of 5.9% per year compounded monthly. You have decided on a 15-year mortgage and will make monthly payments (end of the month). You decided you will pay 5% down at the beginning. You are working extra hours and expect to pay an extra $350 per month to knock down the principle. You make these payments for 6 years starting on month 25. The last EXTRA payment is on month 96. Build the amortization table. What month will you make your last payment? How much will your last payment be?

Please solve via excel and show calculation steps to solve table. Scenario: You have decided to finance a new home. The loan is for $248,000 and you are getting a rate of 5.9% per year compounded monthly. You have decided on a 15-year mortgage and will make monthly payments (end of the month). You decided you will pay 5% down at the beginning. You are working extra hours and expect to pay an extra $350 per month to knock down the principle. You make these payments for 6 years starting on month 25. The last EXTRA payment is on month 96. Build the amortization table. What month will you make your last payment? How much will your last payment be?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter5: Making Automobile And Housing Decisions

Section: Chapter Questions

Problem 8FPE

See similar textbooks

Similar questions

Suppose you decide to wait 5 years to save up before buying the house. You are able to put a down payment of $30,000 on the house, so that you only need to borrow $170,000 from the bank. Assume the interest rate is still the same, but you are now in a better financial position, and you can pay off the loan in 240 equal monthly payments. Answer the following questions about this loan. After making 240 monthly payments, how much of what you paid the bank was interest? $ . ROUND TO THE NEAREST CENT. THANKS APPRECIATE THE HELP!!!
You can afford payments of $950 per month for the purchase of a house. a) What is the largest amount you can finance for this house at 3.2% APR for 30 years? (Round to the nearest dollar.) b) How much total will you be paying the loan company at the end of 30 years for this house if you are paying $950 per month for 30 years? c) Now you are curious what the payments would be if you financed the amount found in part a) at 3.2% APR for 20 years instead of 30 years. How much would your monthly payments be if you financed the amount you found in part a) for 20 years at 3.2% APR? (Round to the nearest dollar.) d) Using the payments you found from part c), how much total will you pay the loan company at the end of 20 years?
You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Please show your work using excel formulas.
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 buying a new home and are planning to take out a 30-year, $300,000 mortgage. You are told that the interest rate on your loan will be 3%. You want to figure out how much you will have to pay on the mortgage each month. To analyze your potential loan, you have decided to use Microsoft Excel to calculate the monthly payments. To earn full credit your spreadsheet must contain the following elements: Calculate the required monthly payment using a built-in Excel function. Reference the interest rate via a cell name rather than a cell location Build a 360-month amortization table including the outstanding loan balance at the end of each month. Suppose instead of paying the required monthly payment, you decide to pay an extra $250 per month. How much sooner will you be able to pay off your loan?
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.
You are financing a new home. The loan is for $191,000 and you are getting rate of 4.1% per year. 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 $410 per month to knock down the principle. You make these payments for 4 years starting on month 1. The last payment is on month 48. Build the amortization table. What month will you make your last payment? How much will the last payment be?
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
After graduation, you just got hired by an engineering company and you were planning to take a loan in order to purchase a new car. Let's assume that the bank is willing to offer you a personal loan with an annual interest rate of 7% compounded yearly. The car price is 25,739 JD and you are capable to pay 5,400 JD per year. After how many years you will be able to pay back the loan with the accumulated interest (use a spreadsheet to answer this question) and draw the cash flow diagram?
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?
Suppose you have graduated from college and want to purchase a house. Your take-home pay is $4560 per month and you wish to stay within the recommended guidelines for mortgage amounts by only spending 14 of your take-home pay on a house payment. You have $18,500 saved for a down payment. With your good credit and the down payment you can get an APR from your bank of 4.35%, compounded monthly.a. What is the total cost of a house you could afford with a 15-year mortgage?b. What is the most that you could afford with a traditional 30-year mortgage instead of a 15-year?
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?