Question

1 Approved Answer

Posted on Jun 26, 2024

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

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.
Using the data provided, complete 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.

Excel File Edit View Window B )) 69% [4 Sun Sep 13 11:20 PM Q DE AutoSave . Off) ACC306 - Assign... Krystl Robinson KR O X AutoSave . Off ACC306... Krystl Robinson KR X File Home Insert Draw Page Layout Formulas Data Review View Help File Home Insert Draw Page Layout Formulas Data Review View Help A25 X V fx Marketable securities, current X V fx Accounts payable and accrued expenses B Accounts payable and accrued expenses June 30, 20XB 80,085 0 Right-of-use lease assets December 31, 20XA 2 Accounts payable and accrued expenses December 31, 20XA 35,979 41 Receivable, net June 30, 20XB 50,842 3 Accumulated other comprehensive income June 30, 20XB 266 2 Receivable, net December 31, 20XA 55,694 4 Accumulated other comprehensive income December 31, 20XA 32 3 Other current assets December 31, 20XA 5 Additional paid-in capita June 30, 20XB 1,304,170 44 Total current assets December 31, 20XA Additional paid-in capita December 31, 20XA 1,306,653 45 Total assets December 31, 20XA 7 Cash and cash equivalents June 30, 20XB $ 352,387 46 Total current liabilities December 31, 20XA 8 Cash and cash equivalents December 31, 20XA $ 311,732 47 Total liabilities December 31, 20XA 9 Common stock, par value $0.01 June 30, 20XB 219 48 Total stockholders' equity December 31, 20XA 10 Common stock, par value $0.01 December 31, 20XA 217 49 Total liabilities and stockholders' equity December 31, 20XA 11 Contract liabilities , 20XB 40,826 Other current assets June 30, 20XB 12 Contract liabilities December 31, 20XA 38, 73 3 51 Total current assets June 30, 20XB 13 Deferred income tax liabilities June 30, 20XB 70,298 2 Total assets June 30, 20XB 14 Deferred income tax liabilities December 31, 20XA 59 ,358 3 Total current liabilities June 30, 20XB 15 Goodwil June 30, 20XB 732,799 54 Total liabilities June 30, 20XB 16 Goodwill December 31, 20XA 732,540 5 Total stockholders' equity June 30, 20XB 17 Income taxes payable June 30, 20XB 6.144 56 Total liabilities and stockholders' equity June 30, 20XB 18 Income taxes payable December 31, 20XA 419 19 Intangible assets, net June 30, 20XB 314,511 20 Intangible assets, net December 31, 20XA 328,344 21 Lease liabilities, current June 30, 20XB 26,462 22 Lease liabilities, current December 31, 20XA 23 Lease liabilities, non-current June 30, 20XB 90,501 24 Lease liabilities, non-current December 31, 20XA 25 Marketable securities, current June 30, 20XB 36,486 26 Marketable securities, current December 31, 20XA 37,121 27 Marketable securities, non-current June 30, 20XB 31,866 28 Marketable securities, non-current December 31, 20XA 37,678 29 Other assets June 30, 20XB 19,052 30 Other assets December 31, 20XA 19,429 31 Other current assets , 20XB 16,874 32 Other current assets December 31, 20XA 15,814 33 Other long-term liabilities June 30, 20XB 37,636 34 Other long-term liabilities December 31, 20XA 51,316 35 Property and equipment, net June 30, 20XB 119,040 36 Property and equipment, net December 31, 20XA 122,677 37 Retained earnings June 30, 20XB 1 18 ,783 38 Retained earnings December 31, 20XA 118 , 322 39 Right-of-use lease assets June 30, 20XB 101,533 40 Right-of-use lease assets December 31, 20XA 41 Receivable, net June 30, 20XB 50,842 42 Receivable, net December 31, 20XA 55,694 43 Other current assets December 31, 20XA 44 Total current assets December 31, 20XA Activate Windows 45 Total assets Balance Sheet Income Statement + December 31 20XA Balance Sheet| Income Statement Go to Settings to activate Windows. Select destination and press ENTER or choose Paste - - + 80% Select destination and press ENTER or choose Paste + 80% O e W 11:20 PM 9/13/2020