using the data provided creat an excel worksheet that contains the firm's balance sheet amd income statement. using the data from your balance sheet and income statement conduct the requested ratio analyses.

12 Clipboard Font Alignment i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate i ADDITIONAL INFORMATION If you need to make a quick edit before renewing your subscription, learn more about Office for the we Learn More A24 B C D 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 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 26 27 28 29 30 31 32 33 24 Total current liabilities D A53 1 Accounts payable and accrued expenses 2 Accounts payable and accrued expenses 3 Accumulated other comprehensive income 4 Accumulated other comprehensive income 5 Additional paid-in capital 6 Additional paid in capital 7 Cash and cash equivalents Cash and cash equivalents 9 Common stock, par value $0.01 10 common stock, par value $0.01 11 Contract liabilities 12 Contract liabilities 13 Deferred income tax liabilities 14 Deferred income tax liabilities 15 Goodwill 16 Goodwill 17 income taxes payable 18 Income taxes payable 19 Intangible assets, net 20 Intangible assets, net 21 Lease liabilities, current 22 Lease liabilities, current 23 Lease liabilities, non-current 24 Lease liabilities, non current 25 Marketable securities, current 26 Marketable securities, current 27 Marketable securities, non current 28 Marketable securities, non-current 29 Other assets 30 Other assets 31 Other current assets 32 Other current assets 33 other long-term liabilities 34 Other long term liabilities 35 Property and equipment, net June 30, 20X8 December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 2XA June 30, 20x8 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 June 30, 20XB December 31, 20XA June 30, 20XB December 31, 2OXA 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 June 30, 20XB December 31, 20XA June 30, 20x8 December 31, 20XA June 30, 20X2 na ML 80,085 85,979 266 32 1,304,170 1,306,653 $352,387 $311,732 219 217 40,826 38,733 70,298 59,358 732,799 732,540 6,144 119 314,511 328,344 26,462 90,501 36,486 37,121 31,866 37,678 19,052 19,429 16,874 15,814 37,636 51,316 119,040 1919 Balance Sheet Income Statement 37,678 19,052 19,429 16,874 15,814 37,636 51,316 119,040 122,677 118,783 118,322 101,533 26 Marketable securities, 27 Marketable securities, non-current 28 Marketable securities, non-current 29 Other assets 30 Other assets 31 Other current assets 32 Other current assets 33 other long-term liabilities 34 Other long-term liabilities 35 Property and equipment, net 36 Property and equipment, net 37 Retained earnings 38 Retained earnings 39 Right-of-use lease assets 40 Right-of-use lease assets 41 Receivable, net 42 Receivable, net 43 Other current assets 44 Total current assets 45 Total assets 46 Total current liabilities 47 Total liabilities 48 Total stockholders' equity 49 Total liabilities and stockholders' equity 50 Other current assets 51 Total current assets 52 Total assets 53 Total current liabilities 54 Total liabilities 55 Total stockholders' equity 56 Total liabilities and stockholders' equity 57 58 59 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 June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB 50,842 55,694 + co Balance Sheet Income Statement 12 Clipboard Font Alignment i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate i ADDITIONAL INFORMATION If you need to make a quick edit before renewing your subscription, learn more about Office for the we Learn More A24 B C D 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 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 26 27 28 29 30 31 32 33 24 Total current liabilities D A53 1 Accounts payable and accrued expenses 2 Accounts payable and accrued expenses 3 Accumulated other comprehensive income 4 Accumulated other comprehensive income 5 Additional paid-in capital 6 Additional paid in capital 7 Cash and cash equivalents Cash and cash equivalents 9 Common stock, par value $0.01 10 common stock, par value $0.01 11 Contract liabilities 12 Contract liabilities 13 Deferred income tax liabilities 14 Deferred income tax liabilities 15 Goodwill 16 Goodwill 17 income taxes payable 18 Income taxes payable 19 Intangible assets, net 20 Intangible assets, net 21 Lease liabilities, current 22 Lease liabilities, current 23 Lease liabilities, non-current 24 Lease liabilities, non current 25 Marketable securities, current 26 Marketable securities, current 27 Marketable securities, non current 28 Marketable securities, non-current 29 Other assets 30 Other assets 31 Other current assets 32 Other current assets 33 other long-term liabilities 34 Other long term liabilities 35 Property and equipment, net June 30, 20X8 December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 2XA June 30, 20x8 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 June 30, 20XB December 31, 20XA June 30, 20XB December 31, 2OXA 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 June 30, 20XB December 31, 20XA June 30, 20x8 December 31, 20XA June 30, 20X2 na ML 80,085 85,979 266 32 1,304,170 1,306,653 $352,387 $311,732 219 217 40,826 38,733 70,298 59,358 732,799 732,540 6,144 119 314,511 328,344 26,462 90,501 36,486 37,121 31,866 37,678 19,052 19,429 16,874 15,814 37,636 51,316 119,040 1919 Balance Sheet Income Statement 37,678 19,052 19,429 16,874 15,814 37,636 51,316 119,040 122,677 118,783 118,322 101,533 26 Marketable securities, 27 Marketable securities, non-current 28 Marketable securities, non-current 29 Other assets 30 Other assets 31 Other current assets 32 Other current assets 33 other long-term liabilities 34 Other long-term liabilities 35 Property and equipment, net 36 Property and equipment, net 37 Retained earnings 38 Retained earnings 39 Right-of-use lease assets 40 Right-of-use lease assets 41 Receivable, net 42 Receivable, net 43 Other current assets 44 Total current assets 45 Total assets 46 Total current liabilities 47 Total liabilities 48 Total stockholders' equity 49 Total liabilities and stockholders' equity 50 Other current assets 51 Total current assets 52 Total assets 53 Total current liabilities 54 Total liabilities 55 Total stockholders' equity 56 Total liabilities and stockholders' equity 57 58 59 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 June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA June 30, 20XB December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA December 31, 20XA June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB June 30, 20XB 50,842 55,694 + co Balance Sheet Income Statement