please show step by step

and ensure to show the formulas used

if possible can you olease use excel sheet

financial statement with performing ratio analyses: current ratio: quick ratio :debt ratio : equity ratio : debt -to equity ratio : and profit margins Create Financial Statements for Frozen Fractals Corp. Once you have prepared the financial statements, use Excel to perform the following ratio analyses: (a) current ratio : (b) quick ratio: (c) debt ratio; (d) equity ratio; (1) debt-to-equity ratio ; and (9) profit margin for each reporting period. You must use Excel to compute the formulas. Part 1: Create Financial Statements for Frozen Fractals Corp. for info below You will be required to use formulas and/functions to recreate the firm's financial statements. create an income statement, statement of owner's equity, and balance sheet in Excel for Frozen Fractals Corp. With the exception of the Jacqueline Elise, Capital account (the balance for which is from 12/1/2016), the company had the following account balances as of 12/31/2016. Accounts Payable Accounts Receivable Auto Expense Cash Furniture Jacqueline Elise, Capital - 12/1/2016 Jacqueline Elise, Drawing $6,000 $4,100 $9,400 $61,000 $8,000 $73,200 $3,000 Land Office Expense Rent Revenue Sales Revenue Supplies Expense Telephone Expense Utilities Expense $27,000 $4,000 $8,500 $41,000 $2,500 $6,100 $3,600 When creating the financial statements, be certain to use the techniques from this chapter to present each in good form Accounts Payable Accounts Receivable Auto Expense Cash Furniture Jacqueline Elise, Capital - 12/1/2016 Jacqueline Elise, Drawing 56,000 $4,100 59,400 561,000 58,000 $73.200 $3,000 Land Office Expense Rent Revenue Sales Revenue Supplies Expense Telephone Expense Utilities Expense $27,000 4.000 $8.500 541,000 $2,500 56,100 53.600 When creating the financial statements, be certain to use the techniques from this chapter to present each in good form