Week 5 Assignment 2 – Competency in Microsoft Excel
- 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.
Instructions
Part I
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:
- 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.
Part II
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.
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.
- By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution's policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
