Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the question below Assignment#1 Loan Amortization You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that

please answer the question below image text in transcribed
Assignment#1 Loan Amortization You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the house, but you need to borrow rest of the purchase price. The bank is offering a 20-year mortgage that requires monthly payments and has an annual interest rate of 6% per year. What will be your monthly payments if you sign up for this mortgage? Draw the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid throughout the life of the loan. Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan. Suppose you can only afford a monthly mortgage payment of $3,000 per month, would you purchase this house, if the interest rate increases to 7% per year and the length of repayment decreases to 15 years? Explain. Draw the new amortization schedule in a separate Excel sheet. Calculate the total amount of interest paid throughout the life of the loan. Even though the interest rate is higher, can the total amount of interest paid for the life of the loan be less than the total interest paid in the first amortization schedule? If so, by how much less? Explain. Assignment#1 Loan Amortization You are thinking of purchasing a house. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the house, but you need to borrow rest of the purchase price. The bank is offering a 20-year mortgage that requires monthly payments and has an annual interest rate of 6% per year. What will be your monthly payments if you sign up for this mortgage? Draw the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid throughout the life of the loan. Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan. Suppose you can only afford a monthly mortgage payment of $3,000 per month, would you purchase this house, if the interest rate increases to 7% per year and the length of repayment decreases to 15 years? Explain. Draw the new amortization schedule in a separate Excel sheet. Calculate the total amount of interest paid throughout the life of the loan. Even though the interest rate is higher, can the total amount of interest paid for the life of the loan be less than the total interest paid in the first amortization schedule? If so, by how much less? Explain

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Financial Machine Learning

Authors: Marcos Lopez De Prado

1st Edition

1119482089, 978-1119482086

More Books

Students also viewed these Finance questions