Your firm has just lost its accounting system. The only thing you have left is the financial reports...

Question

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

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.
The memo will be submitted electronically as a Microsoft Word document with SWS formatting.

acc306-assignment-1-excel-file-safxkssb.xlsx

Siddharth · Accepted Answer

Balance Sheet
	BALANCE SHEET 
	as at 31st December 20XA
		31 Dec 20XA	30 June 20XB
	Assets
	Current assets
	Cash and cash equivalents	$ 311,732	$ 352,387
	Short-term investments	37,121	36,486
	Total cash	348853.00	388873.00
	Net receivables	55,694	50,842
	Other current assets	15,814	16,874
	Total current assets	420361.00	456589.00
	Non-current assets
	Property, plant and equipment	122,677	119,040
	Lease Assets	0.00	101,533
	Equity and other investments	37,678	31,866
	Goodwill	732,540	732,799
	Intangible assets	328,344	314,511
	Other long-term assets	19,429	19,052
	Total non-current assets	1240668.00	1318801.00
	Total assets	1661029.00	1775390.00
	Liabilities and stockholders' equity
	Liabilities
	Current liabilities
	Accounts payable	85,979	80,085
	Deferred revenues	38,

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment