• COULD SOMEONE PLEASE (PRETTY PLEASE WITH CHERRIES ON TOP)

  GIVE ME DIRECTIONS ON WHAT TO DO, WHERE TO START, SOMETHING, ANYTHING?

  I AM COMPLETELY LOST AND CONFUSED ON WHAT I AM SUPPOSED TO BE DOING

• 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 each reporting period.
• Using the data provided, complete(create) 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.
• 

COULD SOMEONE PLEASE (PRETTY PLEASE WITH CHERRIES ON TOP)

GIVE ME DIRECTIONS ON WHAT TO DO, WHERE TO START, SOMETHING, ANYTHING?

I AM COMPLETELY LOST AND CONFUSED ON WHAT I AM SUPPOSED TO BE DOING

Excel File Edit Edit View View Window M + * Q 69% (4) Sun Sep 13 11:20 PM Krystl tobinson KK AutoSave OH H 9 - ACC306 - Assign. Kryst Robinson K AutoSave On H. ACC ACC106... 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 Marketable securities, current Accounts payable and accrued expenses A 50.842 55,6M 20,095 85.979 756 32 1,304 170 1,306,653 $352,397 $ 311,732 719 21/ 40,826 38,733 70,29 59,358 737,799 732.540 6.144 419 314.511 328,344 26,452 A 1 Accounts payable and accrued expenses 2 Accounts payable and cruel expenses 3 Accumulated other comprehensive income - Acumulated other comprehensive income 5 Auctional puid-n capital 5 Additional pald-in capital ! Cash and cash equivalents 8 Cast and cast equivalents 9 Cammon stock, Al $0.01 10 Comman stock per value $0.01 11 Contract liabilities 12 Contract liabilities 12 Deferred income tax liabilities 14 Deferred income tax liabilities 15 Gadwill 16 Gaccwill 17 Income taxes payable 18 Income taxes payable 19 Intengible assets, net 20 Intangible assets, net 21 LAAT Abilities, current 22 Lease labilit es, current 23 Lesse abilities, non-current 24 LASA Abilities, ranurent 25 Marketable securities, current 26 Marketable securities, current 27 Marketable securities ranurent 28 Markatable securites, nan-current 29 Our assets 30 Other Asus 31 Other current assets 12 Other current assets 13 Other lone-term liabilities 34 Other long term liablities 25 Property and euipment, met 36 Property and fouipment, net 37 Hetained carnings 38 Retained earnings 19 Rightof-PASA Assets 40 Rght-of-uselcasc assets 41 Receivable, et 47 Recevabinet 43 Other current assets 44 Total current use 45 Total assets Balance Sheet Income Statement December 31, 20X4 June 30, 20XB December 31, 2OXA December 31, 20X4 December 31, 20XA December 31, 20XA December 31, 20X4 December 31, 20% necher 31, 2OXA December 31, 20X4 June 30, 20XB June 30, 20XR June 30, 20XB June 30, 20XE June 30, 20XF June 30, 20X8 June 30, 20XE June 30, 20X8 December 31, 20XA Jun 30, 20XR December 31, 2UXA June 30, 20XB December 31, 2XA June 30, 20% December 31, 20XA Jun 30, 20XR December 31, 20XA June 30, 20XD December 31, 2024 June 30, 20X2 December 31, 2CXA Jun 30, 20XR December 31, 20XA June 30, 20XB December 31, 2XA June 30, 20X2 December 31, 20XA Jun 30, 20XR December 31, 20XA June 30, 20XB December 31, 2XA Lune 30, 20% December 31, 20XA Jun 30, 20XR Decembar 21. 2UXA June 30, 20XD December 31, 2XA June 30, 20% December 31, 20XA Jun 30, 20XR December 31, 2UXA June 30, 20XD December 31, 2XA June 30, 20X2 December 31, 20XA Jun 24, 20XR December 31, 2UXA June 30, 20XB December 31, 2nX4 December 21, 2UXA December 31, 20XA Naroma 21 244 43 Right-of-use losse assets 41 Receivable, nout 142 Receivable, at 43 Uther current assets 44 Total current assets 145 Total AS 4 latal current abilities 47 Total liabilities 48 Tata Stockholders' eruity 49 Tatal liabiltics and stockholders' cquity 50 Other current assets 51 Total current assets 52 latalassets 53 Total current liabilities 54 Total lalities 55 Tatal stockholders' equity 55 Total liabilities and stockholders' equity 57 59 152 60 11 162 04 163 14 165 55 90,501 36,486 37.121 31,856 37,678 19,052 19,479 16,874 15,814 37,536 51,316 119,040 177,677 118,793 118,322 101,533 163 | 169 10 71 72 74 77 78 PE 180 50,842 55,694 912 Activate Windows Go to Settings to activate Windows Balance Sheet Income Statement Sclert destination and press ENTER ar choose Paste E 1 + 80% Select destination and press ENTER or choose Pacto 0 0 e W 11:20 PM 9/13/2020 Excel File Edit View Q Window ACC306 - Assignmeril 1 Excel File - Excel * ) 70% (4) Sun Sep 13 11 21 PM Krystl Rubinson KR AutoSave one 2 Search - X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Al x Amortization of intangible assets D E 15,417 0 64,139 31,342 1 Amortization of intangible assets 2 Amortization of intangible assets 3 General and administration 4 General and administration 5 Income before income taxes 6 Income before income taxes 7 Income from operations 8 Income from operations 9 Net income 10 Net income 11 Operational Costs 12 Operational Costs 13 Other costs 14 Other costs 15 Other income 16 Other income 17 Provision for income taxes (20%) 18 Provision for income taxes (20%) 19 Revenues 20 Revenues 21 Total costs and expenses 22 Total costs and expenses 23 B June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA December 31, 20XA June 30, 20XB June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA 68,452 134,050 7,179 5,347 3,327 289 $ 246,508 $ 116,469 24 25 Activate Windows Go to Settings to activate Windows Balance Sheet Income Statement + Resdy E B 7405 0 O W 11:21 PM 9/13/2020 Excel File Edit Edit View View Window M + * Q 69% (4) Sun Sep 13 11:20 PM Krystl tobinson KK AutoSave OH H 9 - ACC306 - Assign. Kryst Robinson K AutoSave On H. ACC ACC106... 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 Marketable securities, current Accounts payable and accrued expenses A 50.842 55,6M 20,095 85.979 756 32 1,304 170 1,306,653 $352,397 $ 311,732 719 21/ 40,826 38,733 70,29 59,358 737,799 732.540 6.144 419 314.511 328,344 26,452 A 1 Accounts payable and accrued expenses 2 Accounts payable and cruel expenses 3 Accumulated other comprehensive income - Acumulated other comprehensive income 5 Auctional puid-n capital 5 Additional pald-in capital ! Cash and cash equivalents 8 Cast and cast equivalents 9 Cammon stock, Al $0.01 10 Comman stock per value $0.01 11 Contract liabilities 12 Contract liabilities 12 Deferred income tax liabilities 14 Deferred income tax liabilities 15 Gadwill 16 Gaccwill 17 Income taxes payable 18 Income taxes payable 19 Intengible assets, net 20 Intangible assets, net 21 LAAT Abilities, current 22 Lease labilit es, current 23 Lesse abilities, non-current 24 LASA Abilities, ranurent 25 Marketable securities, current 26 Marketable securities, current 27 Marketable securities ranurent 28 Markatable securites, nan-current 29 Our assets 30 Other Asus 31 Other current assets 12 Other current assets 13 Other lone-term liabilities 34 Other long term liablities 25 Property and euipment, met 36 Property and fouipment, net 37 Hetained carnings 38 Retained earnings 19 Rightof-PASA Assets 40 Rght-of-uselcasc assets 41 Receivable, et 47 Recevabinet 43 Other current assets 44 Total current use 45 Total assets Balance Sheet Income Statement December 31, 20X4 June 30, 20XB December 31, 2OXA December 31, 20X4 December 31, 20XA December 31, 20XA December 31, 20X4 December 31, 20% necher 31, 2OXA December 31, 20X4 June 30, 20XB June 30, 20XR June 30, 20XB June 30, 20XE June 30, 20XF June 30, 20X8 June 30, 20XE June 30, 20X8 December 31, 20XA Jun 30, 20XR December 31, 2UXA June 30, 20XB December 31, 2XA June 30, 20% December 31, 20XA Jun 30, 20XR December 31, 20XA June 30, 20XD December 31, 2024 June 30, 20X2 December 31, 2CXA Jun 30, 20XR December 31, 20XA June 30, 20XB December 31, 2XA June 30, 20X2 December 31, 20XA Jun 30, 20XR December 31, 20XA June 30, 20XB December 31, 2XA Lune 30, 20% December 31, 20XA Jun 30, 20XR Decembar 21. 2UXA June 30, 20XD December 31, 2XA June 30, 20% December 31, 20XA Jun 30, 20XR December 31, 2UXA June 30, 20XD December 31, 2XA June 30, 20X2 December 31, 20XA Jun 24, 20XR December 31, 2UXA June 30, 20XB December 31, 2nX4 December 21, 2UXA December 31, 20XA Naroma 21 244 43 Right-of-use losse assets 41 Receivable, nout 142 Receivable, at 43 Uther current assets 44 Total current assets 145 Total AS 4 latal current abilities 47 Total liabilities 48 Tata Stockholders' eruity 49 Tatal liabiltics and stockholders' cquity 50 Other current assets 51 Total current assets 52 latalassets 53 Total current liabilities 54 Total lalities 55 Tatal stockholders' equity 55 Total liabilities and stockholders' equity 57 59 152 60 11 162 04 163 14 165 55 90,501 36,486 37.121 31,856 37,678 19,052 19,479 16,874 15,814 37,536 51,316 119,040 177,677 118,793 118,322 101,533 163 | 169 10 71 72 74 77 78 PE 180 50,842 55,694 912 Activate Windows Go to Settings to activate Windows Balance Sheet Income Statement Sclert destination and press ENTER ar choose Paste E 1 + 80% Select destination and press ENTER or choose Pacto 0 0 e W 11:20 PM 9/13/2020 Excel File Edit View Q Window ACC306 - Assignmeril 1 Excel File - Excel * ) 70% (4) Sun Sep 13 11 21 PM Krystl Rubinson KR AutoSave one 2 Search - X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Al x Amortization of intangible assets D E 15,417 0 64,139 31,342 1 Amortization of intangible assets 2 Amortization of intangible assets 3 General and administration 4 General and administration 5 Income before income taxes 6 Income before income taxes 7 Income from operations 8 Income from operations 9 Net income 10 Net income 11 Operational Costs 12 Operational Costs 13 Other costs 14 Other costs 15 Other income 16 Other income 17 Provision for income taxes (20%) 18 Provision for income taxes (20%) 19 Revenues 20 Revenues 21 Total costs and expenses 22 Total costs and expenses 23 B June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA December 31, 20XA June 30, 20XB June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA 68,452 134,050 7,179 5,347 3,327 289 $ 246,508 $ 116,469 24 25 Activate Windows Go to Settings to activate Windows Balance Sheet Income Statement + Resdy E B 7405 0 O W 11:21 PM 9/13/2020