
please show how to solve using excel.
Two years ago, Sarah purchased a house of $500,000. Sarah borrows a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 6.25%. Payment terms are being made monthly to amortize the loan over 30 years. Sarah found another lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at 5% with monthly payments for 30 years. Suppose that the new lender will charge 2.5 discount points on the new loan and other refinancing costs will equal $10,000.
a. What is the new loan amount if Sarah chooses to refinance?
b. Should Sarah refinance if she holds the loan for 30 years?
c. If Sarah chooses to refinance, at least how many years should she stay in the house (do not prepay) and Why?

Step by stepSolved in 2 steps

- Please show exactly how to solve this in excel and all steps in excel please. Five years ago, Charles purchased a house for $500,000. Charles borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 5%. Payment terms are being made monthly to amortize the loan over 30 years. Charles has found another lender who will refinance the current outstanding loan balance at 4.0% with monthly payments for 30 years. The new lender will charge two discount points on the new loan. Other refinancing costs will equal $2,000. What is the monthly payment for the current loan? What is the new loan amount if Charles chooses to refinance? What is the monthly payment for the new loan? What is the effective cost of Charles new loan if he holds the loan for 30 years? If Charles wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?arrow_forwardPlease help solve this and please show all the steps to solve this step by step. Two years ago, Martin purchased a house for $100,000. Martin borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 6%. Payment terms are being made monthly to amortize the loan over 30 years. Martin has found another lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at 4.5% with monthly payments for 30 years. Suppose that the new lender will charge three discount points on the new loan and other refinancing costs will equal $3,000. What is the new loan amount if you choose to refinance? What is Martin's monthly payment for the new loan? What is the effective cost of Martin's new loan and do you refinance if he holds the loan for 30 years?arrow_forwardPlease help solve this and please show all the steps to solve this step by step in Excel. Two years ago, Martin purchased a house for $100,000. Martin borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 6%. Payment terms are being made monthly to amortize the loan over 30 years. Martin has found another lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at 4.5% with monthly payments for 30 years. Suppose that the new lender will charge three discount points on the new loan and other refinancing costs will equal $3,000. What is the new loan amount if you choose to refinance? What is Martin's monthly payment for the new loan? What is the effective cost of Martin's new loan and do you refinance if he holds the loan for 30 years?arrow_forward
- LaTisha owed $65,000 when she graduated from college. Suppose her 10-year loan had an APR of 4.5% with monthly payments of $673.65. How much will she spend on interest over the life of the loan? Round your answer to the nearest cent. Use the spreadsheet to solve.arrow_forwardPlease help me to solve this problemarrow_forwardStephen has just purchased a home for $153,200. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 4.75%. Stephen has agreed to pay 25% of the purchase price as a down payment. If Stephen made the same loan for 20 years, how much interest would he save? E Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. Stephen would save $ (Round to the nearest cent as needed.)arrow_forward
- Susan would like to buy a car. She went to the bank and got a loan for $40,000 at the annual interest rate of 4%, for 4 years. Calculate the monthly payment. Calculate the interest on the payment. Calculate the total payment. Make complete amortization schedule on excelarrow_forwardPlease show all steps in excel to solve this. Five years ago, Charles purchased a house for $500,000. Charles borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 5%. Payment terms are being made monthly to amortize the loan over 30 years. Charles has found another lender who will refinance the current outstanding loan balance at 4.0% with monthly payments for 30 years. The new lender will charge two discount points on the new loan. Other refinancing costs will equal $2,000. What is the monthly payment for the current loan? What is the new loan amount if Charles chooses to refinance? What is the monthly payment for the new loan? What is the effective cost of Charles new loan if he holds the loan for 30 years? If Charles wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?arrow_forwardNeed help pleasearrow_forward
- A borrower has a 30-year mortgage loan for $200,000 with an interest rate of 6% APR compounded monthly and level monthly payments. At the end of year 10, she unexpectedly won a lottery and received an after-tax cash of $10,000. She used that cash to pay down the principal of her mortgage loan and will keep paying the same monthly payment till she pays off the mortgage loan. How many more months will she has to payarrow_forwardGabby is planning to buy a home. She has some money for a down payment already saved. She sees a home she would like and calculates that she would need to borrow $210,000 from a bank for a 30-year period. The APR is 7.2%. What will be her total interest for the 30 years? Step 1) What is the monthly payment? Step 2) What are the total payments ($) for the entirety of the loan? Step 3) What is the total interest?arrow_forwardStephen has just purchased a home for $125,000. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 5.00%. Stephen has agreed to pay 25% of the purchase price as a down payment. Find the total interest Stephen will pay if he pays the loan on schedule. E Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. The total interest is S. (Round to the nearest cent as needed.)arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

