Question: 1. Exercise One: You approve a fixed total annual payment loan for a small business owner -businesses like fixed payments to limit their future liabilities.

 1. Exercise One: You approve a fixed total annual payment loan

1. Exercise One: You approve a fixed total annual payment loan for a small business owner -businesses like fixed payments to limit their future liabilities. The loan amount is $5000, the duration of the loan is five years, and the interest rate is 9.75%. (a) Compute the fixed annual payment for this loan using the PMT function as shown in class, (b) Create an amortization schedule for this company, (c) Using a bar chart, graph the cash flows (i.e. Total Payment, Interest Paid, and Principal Paid) on the y-axis versus time on the x-axis, (d) Add data labels to your series, so that your customer can easily visualize the data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!