= 2. 3. 4 A Wine Depot is considering several alternative means of financing an expansion. One alternative is to borrow $500,000 from a local bank, but another alternativeis to borrow this amount from investors by issuing bonds. Both alternatives involve a 3- year debt period with quarterly payments. Modify the workbookch5-06 to compute a loan and bond analysis, naming and formatting cell ranges as appropriate. Assume an annual loan rate of 3 percent, an annual bond statedrate of 3 percent, and a market annual interest rate of 3.5 percent. Wine Depot Bond Amortization Schedule Stated Rate Market Rate Quarterly Interest Payment Bond Term Face Value Proceeds (Discount) Premium B C D E F Vin Interest Payment # Payment Interest Expense (Discount) Carrying Amortization Premium Value $ $ 5 1 5. 2 7 3 3. 4 3. 5 6 1 7 2 8 B 9 1 10 5 11 5. 12 7 Totals