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.

Prepare a balance sheet using the following data:

Accounts payable and accrued expenses ,December 31, 20XA, $85,979

Accumulated other comprehensive income, December 31, 20XA, $ 32

Additional paid-in capital ,December 31, 20XA ,$ 1,306,653

Cash and cash equivalents, December 31, 20XA ,$ 311,732

Common stock, par value $0.01 ,December 31, 20XA .$217

Contract liabilities, December 31, 20XA. $38,733

Deferred income tax liabilities, December 31, 20XA, $ 59,358

Goodwill, December 31, 20XA, $732,540

Income taxes payable, December 31, 20XA,$ 419

Intangible assets, net ,December 31, 20XA, $328,344

Lease liabilities, current December 31, 20XA , $0

Lease liabilities, non-current December 31, 20XA,$0

Marketable securities, current December 31, 20XA, $37,121

Marketable securities, non-current December 31, 20XA $ 37,678

Other assets December 31, 20XA, $19,429

Other current assets December 31, 20XA,$ 15,814

Other long-term liabilities December 31, 20XA, $51,316

Property and equipment, net December 31, 20XA, $122,677

Retained earnings December 31, 20XA $ 118,322

Right-of-use lease assets December 31, 20XA, $0

Receivable, net December 31, 20XA $55,694

Using the following titles:

Other current assets December 31, 20XA

Total current assets December 31, 20XA

Total assets December 31, 20XA

Total current liabilities December 31, 20XA

Total liabilities December 31, 20XA

Total stockholders' equity December 31, 20XA

Total liabilities and stockholders' equity December 31, 20XA

and for June 30, 20xb

Accounts payable and accrued expenses June 30, 20XB $80,085

Accumulated other comprehensive income June 30, 20XB $266

Additional paid-in capital June 30, 20XB $1,304,170

Cash and cash equivalents June 30, 20XB $ 352,387

Common stock, par value $0.01 June 30, 20XB $219

Contract liabilities June 30, 20XB $40,826

Deferred income tax liabilities June 30, 20XB $70,298

Goodwill June 30, 20XB $732,799

Income taxes payable June 30, 20XB $ 6,144

Intangible assets, net June 30, 20XB $314,511

Lease liabilities, current June 30, 20XB $26,462

Lease liabilities, non-current June 30, 20XB $90,501

Marketable securities, current June 30, 20XB $36,486

Marketable securities, non-current June 30, 20XB $ 31,866

Other assets June 30, 20XB $19,052

Other current assets June 30, 20XB $16,874

Other long-term liabilities June 30, 20XB $37,636

Property and equipment, net June 30, 20XB $ 119,040

Retained earnings June 30, 20XB $118,783

Right-of-use lease assets June 30, 20XB $101,533

Receivable, net June 30, 20XB $50,842

using the following titles

Other current assets June 30, 20XB

Total current assets June 30, 20XB

Total assets June 30, 20XB

Total current liabilities June 30, 20XB

Total liabilities June 30, 20XB

Total stockholders' equity June 30, 20XB

Total liabilities and stockholders' equity June 30, 20XB