Please 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?
Please 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?
Chapter19: Lease And Intermediate-term Financing
Section: Chapter Questions
Problem 19P
Related questions
Question
Please 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?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
