Question: Please answer using excel As a result of the lockdowns, the bank has announced it will immediately lower the interest rate they are charging on

Please answer using excel

Please answer using excel As a result of the lockdowns, the bank

As a result of the lockdowns, the bank has announced it will immediately lower the interest rate they are charging on loans to help small businesses. They are now charging an efflective monthly rate of 0.42% on all loans (including Zax's). Despite the lockdown, Zax has found that business has actually improved slightly, as more people are buying computers and accessories to set up their home offilces. Zax has decided to increase his repayment to $3201 per month starting next month. (c) How many full payments of $3201 will Zax make under this new arrangement? Keep in mind the bank is now charging a new interest rate, Zax still currently owes $291,000 on the loan, and the fifrst repayment moving forward is exactly one month from today. (1 mark) Answer: (d) The number you calculate in part c) represents the number of FULL re-payments of $3201 that Zax will make on this loan. Which of the following is the most accurate statement we can make about the Afinal extra repayment (if any), without doing any further calculations? O a. The extra repayment will be smaller than $3201 O b. The extra repayment will be larger than $3201 O c. There will not be any extra repayment required O d. We cannot say for certain without actually doing the calculation. (e) Calculate the size of the extra payment made exactly one month after the last full payment of $3201. Give your answer to the nearest cent. If there is no extra repayment needed, then your answer would be 0.(1 mark)

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!