Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide excel spreadsheet screenshot so i know which cells to plug into formulas - thank you Assignment#1 Loan Amortization You are thinking of purchasing
please provide excel spreadsheet screenshot so i know which cells to plug into formulas - thank you
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 the 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started