Question
You just obtained a personal loan for $135,000 at 3.152% compounded monthly. For the fun of it, you are choosing to make regular quarterly payments
You just obtained a personal loan for $135,000 at 3.152% compounded monthly. For the fun of it, you are choosing to make regular quarterly payments of $8580. (Question to be done in excel)
How many payments will be required to pay off your personal loan?
What will be the term of your personal loan, expressed in years and months? Your calculation should show a number of years and months (even if its 0 month) (Hint: use the ROUNDing features; cell reference 12 months/year). Perform the following calculations without an amortization schedule. Do not calculate any value twice.
What will be the loan balance after 2 years?
What will be the principal reduction of the loan during the 3rd year?
What will be the total amount of interest paid during the 3rd year?
What will be the size of the final loan payment?
Prepare a complete amortization schedule for your loan. ROUND all monetary values to the nearest cent. Express only the totals as currency. Perform checks to compare the answer of each of the above questions with your results from the amortization schedule. Choose a colour scheme such that the first answer is highlighted the same colour as the matching answer in the schedule (choose colours that are not too dark). Use a different colour for each new answer and its check. Please note: Some checks can be shown by highlighting cells directly on the amortization schedule; other checks will require a simple calculation using some amortization schedule values. Do any simple calculation beside the amortization schedule. Label clearly! For example, you might want to add a thicker border around a group of cells to indicate a check corresponding to a sum from a series of values.
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