Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please do in excel and show work/explain. As shown in class, use Excel to solve all problems Exercise One: You are a loan approval officer
Please do in excel and show work/explain. As shown in class, use Excel to solve all problems Exercise One: You are a loan approval officer at KUNY Bank, and you approve a $10,000 loan for a small business. The duration of the loan is five years, and the interest rate is 12.25%. Per the terms of the loan, the borrower has to pay interest on the loan each year, plus a fixed annual payment of $2,000 to reduce the loan balance until full re- payment. Compute the following: (a) Create an amortization schedule for this company, (b) Graph the cash flows (i.e. Total Payment, Interest Paid, and Principal Paid) on the y- axis versus time on the x-axis. 1
Please do in excel and show work/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