You work for the CFO of a coffee franchise that is contemplating about open a new store near Drexel university. The total cost of opening a shop is $500,000. The store will open on the 1/1/2020. You have decided to finance this project by borrowing $300,000 from a bank. The APR of this loan is 4.75%. The loan requires quarterly payment. The loan will be amortized with a fixed payment amount over 5years. | a. What is the quarterly payment for this loan? b. Complete the amortization table in excel (tab Qle)