Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This question uses excel. Please provide any formulas and steps necessary to complete it. Thanks! You wish to borrow $275,000 for a home. The payments
This question uses excel. Please provide any formulas and steps necessary to complete it. Thanks!
You wish to borrow $275,000 for a home. The payments are monthly for 30 years and Your APR is 5%. Note that the loan is compounded monthly and you are not dealing with an annual rate of 5%. Please do the following: (a) Calculate the monthly payment using the PMT function in Excel rounded to the penny (not displayed that way but truly rounded). Create an amortization table for the full life of the loan. Please construct the payment to make either the scheduled payment or the appropriate payment to pay off the loan if the ending balance would have been within $10 of the scheduled payment. All 360 pavment cells should have this same formula. I found the ABS function to be helpful. (b) To the side of your amortization table, populate two columns to show the break- down of each payment into principal and interest components. (c) Please plot the amount of principal and interest paid each month. In addition, plot the loan balance. Your scale for the balance will dwarf your principal and interest payments, so use the right axis for your loan balance. Fix the range of that axis to be $0 to $300,000. The axis on the right is called a secondary axis in Excel. An example is shown below. Bicycle Sales 400 525 500 300 450 E 425 400 100 1999 2000 2001 2002 2003 Bicycles SoldAverage PriceStep 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