You find that a small business loan in the amount of 50,000 is the amount you need to purchase the restaurant location. After researching banks to find the best interest rate, you find that banks for small businesses offer the best interest rate of 9% interest that compounds monthly for 7 years
Should use PMT etc.
What is the monthly payment for this loan?
Show the formula that you used and the values used for each variable to calculate the monthly payment.
What is the unpaid balance of the loan at the end of the 1st year?
Show the formula that you used and the values used for each variable to calculate the unpaid balance at the end of the 1st year.
What is the unpaid balance at the end of the 6th year? Show the formula that you used and the values used for each variable to calculate the unpaid balance at the end of the 6th year.