financial statement with performing ratio analyses: current ratio: quick ratio :debt ratio : equity ratio : debt -to equity ratio : and profit margins

second PART

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; (f) debt-to-equity ratio ; and (9) profit margin for each reporting period. You must use Excel to compute the formulas. Part I: 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 $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. Using the data from your balance sheet and income statement, conduct the requested ratio analyses. Part II Write a two to three (2-3) page memo in which you summarize the firm's financial position, based on the information provided in Part I. In your summary, discuss whether the firm is financially strong, what they have more of (assets or liabilities), whether they are generating income, the results of their financial ratios, and whether you would invest in this company or not. The memo will be submitted electronically as a Microsoft Word document