Can you Complete in excel and show formulas and step by step on how to complete it

Case 4 - 20 marks Loan/Bond - M&T's Wine Hut M&T's Wine Hut is considering several alternative means of financing an expansion. One alternative is to borrow $500,000 from a local bank, but another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 5-year debt period. Modify the Loan and Bond worksheets to compute a loan and bond analysis. Assume an annual loan rate of 3 percent, and annual bond stated rate of 3 percent and a market annual interest rate of 3.5%. The Loans will be repaid on a monthly basis whereas the bonds will be on a quarterly payment schedule. c C D w E F G I 1 J A B 1 M&T's Wine Hut 2 Loan Amortization Schedule 3 4 Loan Amount 5 Loan Term 5 Rate 7 Payment B Payment # Payment Interest Principal Balance 0 1 2 3 1 2 4 3 5 6 4 5 Total 7 8 9 CO 1 -2 -3 -4 5 26 -7 Inventory Income Statement Balance Sheet Ratio Analysis Asset 1001, 1002, 1003 Summary Loan Bond Cash Budget Ready C D E F G H. B 1 M&T's Wine Hut 2 Bond Amortization Schedule 3 4. Market Rate 5 Stated Rate 6 Interest Payment 7 Bond Term 8 Face Value 9 Proceeds 10 (Discount) / Premium 11 Interest 12 Payment # Payment 13 14 1 15 2 16 3 17 4 18 5 19 Totals 20 21 22 23 24 Interest Expense (Discount) Premium Carrying Value Amortization 25 26 Inventory Income Statement Balance Sheet Ratio Analysis Asset 1001, 1002, 1003 Summary Loan Bond Cash Budget