Question
4. You plan to purchase a house with a value of $450 thousand dollars. ALMA bank provides you a loan with 5.55% annual rate and
4. You plan to purchase a house with a value of $450 thousand dollars. ALMA bank provides you a loan with 5.55% annual rate and 2.5 points charge in order to get the loan. TOWN bank does not charge you points, but its rate is 5.91%. Both banks give you a loan for twenty years with monthly payments. Provide detailed amortization tables for both options using EXCEL, and utilize as NPV and PV Excel functions in order to double check your calculations. Present your findings in a comparative graph and describe your analysis and suggestion in plain English. Allow in your EXCEL file for an alternative, your monthly payments may be higher or lower than the payment you find using the payment function, as long as the remaining amount of the loan can be paid at the last payment period.
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