- From Microsoft Excel for Accounting, complete Extend Your Skills EA2-E1: Create Financial Statements for Frozen Fractals Corp.
Once you have prepared the financial statements, use Excel to perform a ratio analysis as instructed below and write a memo analyzing the company’s financial position.
You must use Excel formulas to compute the ratios and totals on the financial statements where applicable. Points will be deducted if you do not use formulas for your calculations.
From Microsoft Excel for Accounting, Complete EA2-E1: Create Financial Statements for Frozen Fractals Corp. Use formulas and functions to recreate the firm’s financial statements.
Using the data from your balance sheet, statement of owner’s equity, and income statement, perform the following ratio analyses:Anatomy homework help: Competency In Microsoft Excel
- Current ratio.
- Quick ratio.
- Debt ratio.
- Equity ratio.
- Debt-to-equity ratio.
- Profit margin ratio.
- Refer to Chapter 9 of Microsoft Excel for Accounting for the formulas for the ratios.
Submit one Excel workbook for Part I with each financial statement on a separate tab. Put the financial ratios on a separate tab. Label each tab accordingly.
Write a 2–3 page memo analyzing the company’s financial position based on the financial statement results and ratio calculations performed in Part I.
In your summary, discuss the following:
- Whether the firm is financially strong.
- What they have more of (assets or liabilities).
- Whether or not they are generating income.
- The results of their financial ratios.
- Whether or not you would invest in this company.
- The memo will be submitted electronically as a Microsoft Word document.
This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.Anatomy homework help: Competency In Microsoft Excel
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
The specific course learning outcome associated with this assignment is:
- Demonstrate the use of various functions and applications in Microsoft Excel for accounting records and reports.
https://www.writers24x7.com/wp-content/uploads/2020/11/logo-writers24x7-1.png 0 0 Writers24x7 https://www.writers24x7.com/wp-content/uploads/2020/11/logo-writers24x7-1.png Writers24x72021-06-09 16:01:222021-06-09 16:01:22Anatomy homework help: Competency In Microsoft Excel