Modeli At a minimum, use the following commands / Functions in Excel: Sum, Multiplication, Copy Down, PV Function. a. Set up a new template in Excel where you can enter the following data and a valuation for a bond comes up along with an amortization table. The first part of the model should be a place where data is entered. The second part should price the bond. The third part should show the amortization table using the effective interest method. $1,000,000 10% Face Value of Bond A - Face Interest Rate of Bond A- Interest payments are semiannual Issued January 1, 2018 Matured December 31, 2020 Market Rate of Interest on 1-1-18 12% b. Once the model is completed, enter the following data to see if your model will value a new bond and create an amortization table: $2,000,000 12% Face Value of Bond A - Face Interest Rate of Bond A- Interest payments are semiannual Issued January 1, 2018 Matured December 31, 2020 Market Rate of Interest on 1-1-18 Model II Use the following data on Tab for Data to automatically build a balance sheet in a second tab, a statement of retained earnings on the second tab, and an income statement (with income taxes calculated at 20% and including earnings per share) on a third tab. Company Name Unadjusted Trial Balance As of December 31, 20XX DR CR 112300 7500 10000 500 33000 5400 10000 26000 47000 Cash Acct Receiv ST Investments Supplies Inventory Merchandise Inventory PPd Insurance PPD Security PPD Rent Mach & Equipment Accumulated Depreciation Interest Payable Accounts Payable Note Payable Common Stock Pd In Cap Excess Par Retained Earnings Sales Revenue Interest Revenue Cost of Goods Sold Salaries Expense Insurance Expense Rent Expense Supplies Expense Security Expense Interest Expense Depreciation Expense Utilities Expense Totals 15667 1200 600 20000 200000 200000 72500 500 27000 180000 6600 22000 1500 2000 2400 15667 1600 510467 510467 Model III On a separate tab, use the data from the financial statements to feed into computations for the following ratios: 1) current ratio; 2) quick ratio; 3) debt-to-equity ratio; 4) debt to assets ratio; 5) times interest earned ratio; 6) return on assets ratio; 7) return on equity ratio. Make this look nice with color as a dashboard. If the numbers on the original financial statements change, the ratios should change