Question: ASSIGNMENT 1: Competency in Microsoft Excel Due Week 5 and worth 200 points Your firm has just lost its accounting system. The only thing you

ASSIGNMENT 1: Competency in Microsoft Excel

Due Week 5 and worth 200 points

Your firm has just lost its accounting system. The only thing you have left is the financial reports from the December 31, 20XA and June 30, 20XB reporting period, but the data is garbled. You have been asked by your Controller to reconstruct the Balance Sheet & Income Statements in Excel for each of these reporting periods as well as performing the following ratio analyses: (a) current ratio ; (b) quick ratio; (c)debt ratio; (d) equity ratio; (f)debt-to-equity ratio ;and (g)profit margin for eachreportingperiod.

To complete Assignment 1,please downloadACC306 - Assignment 1Excel File.

Part I:

Using the data provided by your professor, create an Excel worksheet that contains the firm's balance sheet and income statement. You will be required to use formulas and/functions to recreate the firm's financial statements, such as the items in YELLOW.
Using the data from your balance sheet and income statement, conduct the requested ratio analyses.
You will submit one Excel workbook for Part I

ASSIGNMENT 1: Competency in Microsoft ExcelDue Week 5 and worth 200 pointsYour

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

ASSIGNMENT 1: Competency in Microsoft Excel Due Week 5 and worth 200 points Your firm has just lost its accounting system. The only thing you have left is the financial reports from the December 31,...

Due Week 5 and worth 200 points Your firm has just lost its accounting system. The only thing you have left is the financial reports from the December 31, 20XA and June 30, 20XB reporting period, but...

ASSIGNMENT 2: Competency in QuickBooks Online Due Week 10 and worth 200 points You have been hired by Rain Cross Auto Detail to manage their accounting operations. The first thing you will need to do...

ASSIGNMENT 1: Competency in Microsoft Excel Your firm has just lost its accounting system. The only thing you have left is the financial reports from the December 31, 20XA and June 30, 20XB reporting...

Due Week 4 and worth 200 points It's one thing to be able to look at a Financial Report and analyze it using ratios and comparisons. However, keep in mind that when you do that, you are studying...

A man buys a car for $3000 with no money down. He pays for the car in 30 equal monthly payments with interest at 12% per annum, compounded monthly. What is his monthly loan payment?

Which molecule, shown below, matches the following IR spectrum? L00 4000 3000 1000 NEVENUBERIl

5. As shown in Exhibit A-8, the slope of straight line AB a. decreases with increases in X. b. increases with increases in X. c. increases with decreases in X. d. remains constant with changes in X.

QUESTION 1 Given corporate data on 22 public utility companies in the United States, we are interested in separating them into 2 clusters using k-means clustering algorithm. The normalized values of...

7. How can the models we use have a detrimental effect on others?

2. In this chapter, the reader should reflect on the following concepts: Systemic structuring, the displaced error, the communicable part of knowl-edge, tacit knowledge, hidden knowledge, analogy,...

2. List five points that are crucial to pay attention to if you want to positively influence someone from a foreign culture.