1. In an Excel spreadsheet, prepare the financial statements. Create an income statement . statement of retained earnings . and balance sheet . Be sure to use your own formulas whenever there is a calculation . Do your own work . Show:I each financial statement in a separate sheet within your excel spreadsheet. Be sure to clearly identify {rename} each sheet so the sheet corresponds to the statements. Determine how much cash the company has on hand . Perform ratio analysis on ABC Company. Calculate: 1. current ratio. 2. quick ratio . 3. debt ratio. 4. debt to net 1worth ratio . 5. times interest earned. 5. average inventory tumover ratio . 1. average age of inventory . S. receivables turnover ratio. 9. average collection period ratio . 1E]. payables tumover ratio . 11. average payable period ratio . 12. total asset tumover ratio {total asset turnover ratio 1'. 13. gross profit on sales ratio {gross profit margin or GPM]. 14. operating profit on sales ratio {operating profit margin or 0PM 1'. 15. net profit on sales ratio {net profit margin or NPM]. 16. net profit to assets ratio {return on assets or RDA]. 1?. net profit to equity ratio {return on equity or ROE}