I have written in the ratios and attatched information to help solve:

Column E Requires you to select (fill in or link to) the proper numbers from the appropriate Financial Statement
Column G Requires you to calculate the resulting ratio based on the component you selected, rounded to two places

AutoSave a APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 > v A A General Insert X G 27 Paste 1 Sensitivity y S90 Conditional Format Cell Formatting as Table Styles Format v Sort Filter Find Select Anaye Data T L15 fx A E Note: The estimated market value of the business is four times Net Income Before Interest Expense and Income Taxes B F 6 H T 1 . L M Round ta two decimal places -Rounctnumber 2) - Required: Complete the ratios and the open ended questions and then upload your file to CyberText.com for grading. 7 BASIC Esminga per Shar Not Income - Pretened Cliends 5 Average Shares of Common Stock Outstanding 10 11 1. Cash Fow on Total Assets Cash Flow From Operations 12 Average Total Assets 13 14 Bcos Va uc per Common Share Stockholders' Equity Apuhtale tu Cortor Sharee 16 Number of Comen Shares Outstanding 16 17 Current Ratio Current ARAR 18 Current Liabii.8 10 20 Total Asal Tumerar Net Sales 21 Average TalAl AS 22 23 24 Debt-to-Equity Reto - Total Lab Ities = Tutti Total Equity 25 26 Debt Ratio Total Liabilies 27 Tolal Assets 28 25 29 Times Interest Eamed Income Betane interest Expense and Income Tax Expense 30 Interest Expense 31 Days! Sales In Inventory Ending Inventory x 305 days 39 Cost of Goods Sold 34 35 Inventary Tumover Ratio Cost of Goods Sold = 36 Average Inventory 37 38 Dividend Yeld Annual Cash Druidend Par SA 39 Market Price Per Common Share 40 41 Net Income 42 Prof Margin Ratio Nal Sales 43 44 Gass Prott C amaz Virgi Ralia 45 Nat Salca 46 47 Price Eamings Ratio Market Prize Per Common Share 42 Eaminas Por Sham 49 50 Acid-Tusi Ratio Cash+Sho-t-Term InvestmentsO.ment RACAMADAS 51 Current Liabinus Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio + Ready + 100% % AutoSave on PO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v Arial v 10 v P General X [G El Insert Delete 27 v Paste BU B Av Sensitivity y S90 Conditional Format Cell Formatting as Table Styles Format v Sort Filter Find Select Anaye Data L15 f T A B D E F G H 1 . M NAtino Average Total Abu Net Sales Avanga Acount Rakes accounts Receivable, Net x 365 days Net Sales 59 Rebum on Assets 54 56 56 57 Acossunt echivale Tumawar Ratio 58 se Bc Ceys Sales Uncolected 61 82 Une complele sentences to vote the insure 83 64 Interpret and explain the company's Total 65 Aaret Tumaver NE 87 18 69 70 71 72 Interpret and explain this company's Account 79 Fiscalabis Turrower Ratia 74 75 TE 77 78 79 0 Interpret and explain this company's Dividend 81 Viac 82 83 94 85 AB 07 12 Interpret and explain this company's Cash 89 Flow on Total Assets 90 91 92 99 94 85 96 97 Explain why you would or would not nvest 98 th any 89 100 101 102 Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio + Ready E + 100% % AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Arial v 10 ~ A A . 29 General 28 Paste [G ** B 1 div 2 Delete Format v 5 Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter v Find Select Anayza Data 916 T + x fx A B C D F G H 1 J . K L M N 0 P a R S 1 2 2 3 A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2020 4 5 7 Cash Flow from Operating Activities $ 41.951.81 9 10 11 12 10.080.78 (9,868.25) (6.141.00) 14. 15 16 17 18 19 20 318.00 (415.00) (15,670.60) 7,983.94 Net Income Adjustments to reconcile net income to net cash flows from operating scdvibes: Deprecialion experts Increase in accounts receivable Increase in prepaid Insurance Change in prepaid rent Decrease in office supplies Increase in inventory Decrease in payables Increase in income tax payable Nel cash flows from operations Cash Flows from Investing Activities Purchase of equipment Netcash flows from investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from issuance of bonds payable Payment of cash dividende Nel cash flows frorn financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period $ 26,239.88 21 22 29 $ (520.00) (520.00) $ 24 25 26 27 28 29 20 31 72.900.00 128,034.12 (980.00) 199,954.12 $ $ 227,673.80 328,630.00 $ 556,303.60 32 33 24 35 Noncash Activities Purchased equipment hy issuing non payable $ 4,860.00 30 37 28 36 40 41 42 Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio + Ready + 100% AutoSave on APO... MS8672 - Saved Insert Draw Page Layout Formulas Data Home - Review View Tell me Share Comments Arial 10 9 ~ A A General 5 X G 22 Insert 28 1. Delete Paste B S% Anayza Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter Format v v Find Select Data H8 x fx Assets 11 1 N M a U Y Z PA AC AT Ar 41 4 A 46 2 A Byte of Accounting Halance Sheet As of December 31, 2020 7 9 41585 15 15 17 15 1 $ 93111 $ arees 1239 29 H. 25911 21 Current Art Couch AROUND Alwar Di Focoso HITAME PT Cie. Inulary TO Currones Lang. Tam Anar ON 010 E Asem. Der NE Cara buain Azem Dr.Com - DV - M L 1 Tab Leyte Toidla To 19191 22 SO 12 12160.6 PULLO BORG 3 HO 31.12 13 W12 98 Linea 40 29 24 28 20 27 28 $ 22/100 TO 2340 12e re 13. REIM 3134134 Current Liebe Assunta A. ASFA San Pay Inamos Rio Tow Curroni LongTama NA Bend Pione tr v Tabellen Teller Tot in 50 51 $ 480 DO STRONO F.12 1_1211012 1777413 312477 61 Blocker's 14 $ Ca 2 ww.. Fre rer RE Reine Frisines Tod's EN Total Labs and other's Equity 1800 429281 HA 9161 77 24 ! TE TI 76 20 M Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratia Ready 75% AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Arial v 10 ~ A A 29 General 28 [G Paste B B 1 AY 2 Delete Format v Conditional Format Cell Formatting as Table Styles S Sensitivity Sort Filter v Find Select Anayza Data A1 + x fx F G M a R S U V X Z 1 H 1 A Byte of Accounting, Inc. Statement of Stockholders' Equity For Year Ending December 31, 2020 T 8 9 10 11 12 Balance, Beginning of Period 18 issue of Common Stock 19 Cash Dividends 22 Net Income 23 Balance, End of Peria 21 Common Total Stock, S0.01 Additional Paid-in- Retained Capital Stockholders par value Earnings Equity $ $ 22.00 $ 356 378 03 S 24,000.00 $ 380,400.00 27.00 72 873.00 72,900.00 980.00 880.CO 41,951.8 41,551.81 $ 49.00 $ 429 251.00 $ 64,971.81 $ 494,271.01 $ 20 27 20 28 30 S1 32 34 325 36 32 S8 40 41 45 27 44 29 51 52 53 41 55 57 50 81 Stockholders Equity, 2020 Balance Sheet 2020 Cash Flow, 2020 Ratio Ready = S: E 94% AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 10 ~ A A . ale General insert Insert 2 Delete Format v 28 Paste Arial [G ** B 1 I U 2x fx VA S % > Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter v Find Select Anayza Data H47 B C E F G H 1 J K L L M N 0 P P 0 R R S T U u 1 2 3 D A Byte of Accounting, Inc. Income Statement For Year Ending December 31, 2020 Revenues Sacs Revenue $ 468,6C2,00 Cort af Goods Sold 229,121.00 Gross Profit $ 229,421.00 S 9 10 11 19 14 16 16 17 18 16 20 21 22 23 24 25 20 27 28 29 34 35 36 37 38 43 44 45 46 Operating Expenses Rent Expense Saary Experse Advertising Expense Renais & Maint Expense Supples Expunge Insurance Expense Depreciation Expanse Red Debt Fspanne Telephone Expune Total Operaing Expenses 30.000.00 96,200.00 4.735.00 14 905 90 2.888 00 267.00 10.0BC 2,028 75 6.070.00 165.954.53 $ 63 464 47 Income From Operations Before Interest and Income Taxes Interest Expense 7.630.12 Net Income Before TAX $ 55,235.75 Income Tax Expercele 13.903.04 41,951.81 Net Income Altar Tax 48 99 50 51 52 53 54 55 56 57 be 55 60 81 2 Income Statement, 2020 Stockholders Equity, 2020 Balance Sheet 2020 Cash Flaw, 2020 Ratin Ready + 100% AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 23 General Insert 2 Delete Format v 28.0 [G Paste B B I U d S% Conditional Format Cell Formatting as Table Styles Sort Filter Sensitivity Find Select Anayza Data 049 fx Capital Stock, $0.01 Par Value M N 0 Q R 8 S U v x X Y Z AA A AC AD AF AF AG 2 3 4 A Byte of Accounting Balance Sheet As of December 31, 2019 5 Assets $ 328,830.00 $ 39,000.00 600.00 Current Assets Cash Accounts Receivable Alowna for Doubtful Accounts NA Nal Receivable Prepaid Runt Office Supples Total Dument Assets 29,400.00 2,500.00 900.00 S S 361,430.00 $ 63,100.00 6,000.00 57,100.00 Long-Term Assets Office Equipment Accum Deor.comce Equipment Nalomon Fquipment Computer Exuperen! Acum Deor. Computer Equipment Net Computer Equipment Total Lang_Tamm Assets Total Assets 3 20.000.00 4,000.00 15,000.00 73,100.00 S 434,530.00 U 9 10 11 12 13 14 15 16 17 10 19 20 21 22 25 26 27 31 32 39 34 35 SF 32 38 39 40 41 142 49 44 45 40 47 48 49 50 51 52 53 54 55 50 57 Liabilities $ Current Liabllides Accounts Payable Salaries Payable Income Taxes Payable Tatal Liabilities 47,930.00 800.00 5,000.00 S 54,130.00 Stockholder's Equity $ Captal Stock $0.01 Par Valve Paid in Capital in Excess of Par Fatared Eamings Total Stochoder Fquity 22.00 260,379.00 24,000.00 389,400.00 Total Liabilities and Stockholder's Equity Balance Sheet, 2019 Income Statement, 2020 Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio Ready -- + 100% AutoSave a APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 > v A A General Insert X G 27 Paste 1 Sensitivity y S90 Conditional Format Cell Formatting as Table Styles Format v Sort Filter Find Select Anaye Data T L15 fx A E Note: The estimated market value of the business is four times Net Income Before Interest Expense and Income Taxes B F 6 H T 1 . L M Round ta two decimal places -Rounctnumber 2) - Required: Complete the ratios and the open ended questions and then upload your file to CyberText.com for grading. 7 BASIC Esminga per Shar Not Income - Pretened Cliends 5 Average Shares of Common Stock Outstanding 10 11 1. Cash Fow on Total Assets Cash Flow From Operations 12 Average Total Assets 13 14 Bcos Va uc per Common Share Stockholders' Equity Apuhtale tu Cortor Sharee 16 Number of Comen Shares Outstanding 16 17 Current Ratio Current ARAR 18 Current Liabii.8 10 20 Total Asal Tumerar Net Sales 21 Average TalAl AS 22 23 24 Debt-to-Equity Reto - Total Lab Ities = Tutti Total Equity 25 26 Debt Ratio Total Liabilies 27 Tolal Assets 28 25 29 Times Interest Eamed Income Betane interest Expense and Income Tax Expense 30 Interest Expense 31 Days! Sales In Inventory Ending Inventory x 305 days 39 Cost of Goods Sold 34 35 Inventary Tumover Ratio Cost of Goods Sold = 36 Average Inventory 37 38 Dividend Yeld Annual Cash Druidend Par SA 39 Market Price Per Common Share 40 41 Net Income 42 Prof Margin Ratio Nal Sales 43 44 Gass Prott C amaz Virgi Ralia 45 Nat Salca 46 47 Price Eamings Ratio Market Prize Per Common Share 42 Eaminas Por Sham 49 50 Acid-Tusi Ratio Cash+Sho-t-Term InvestmentsO.ment RACAMADAS 51 Current Liabinus Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio + Ready + 100% % AutoSave on PO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v Arial v 10 v P General X [G El Insert Delete 27 v Paste BU B Av Sensitivity y S90 Conditional Format Cell Formatting as Table Styles Format v Sort Filter Find Select Anaye Data L15 f T A B D E F G H 1 . M NAtino Average Total Abu Net Sales Avanga Acount Rakes accounts Receivable, Net x 365 days Net Sales 59 Rebum on Assets 54 56 56 57 Acossunt echivale Tumawar Ratio 58 se Bc Ceys Sales Uncolected 61 82 Une complele sentences to vote the insure 83 64 Interpret and explain the company's Total 65 Aaret Tumaver NE 87 18 69 70 71 72 Interpret and explain this company's Account 79 Fiscalabis Turrower Ratia 74 75 TE 77 78 79 0 Interpret and explain this company's Dividend 81 Viac 82 83 94 85 AB 07 12 Interpret and explain this company's Cash 89 Flow on Total Assets 90 91 92 99 94 85 96 97 Explain why you would or would not nvest 98 th any 89 100 101 102 Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio + Ready E + 100% % AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Arial v 10 ~ A A . 29 General 28 Paste [G ** B 1 div 2 Delete Format v 5 Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter v Find Select Anayza Data 916 T + x fx A B C D F G H 1 J . K L M N 0 P a R S 1 2 2 3 A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2020 4 5 7 Cash Flow from Operating Activities $ 41.951.81 9 10 11 12 10.080.78 (9,868.25) (6.141.00) 14. 15 16 17 18 19 20 318.00 (415.00) (15,670.60) 7,983.94 Net Income Adjustments to reconcile net income to net cash flows from operating scdvibes: Deprecialion experts Increase in accounts receivable Increase in prepaid Insurance Change in prepaid rent Decrease in office supplies Increase in inventory Decrease in payables Increase in income tax payable Nel cash flows from operations Cash Flows from Investing Activities Purchase of equipment Netcash flows from investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from issuance of bonds payable Payment of cash dividende Nel cash flows frorn financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period $ 26,239.88 21 22 29 $ (520.00) (520.00) $ 24 25 26 27 28 29 20 31 72.900.00 128,034.12 (980.00) 199,954.12 $ $ 227,673.80 328,630.00 $ 556,303.60 32 33 24 35 Noncash Activities Purchased equipment hy issuing non payable $ 4,860.00 30 37 28 36 40 41 42 Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio + Ready + 100% AutoSave on APO... MS8672 - Saved Insert Draw Page Layout Formulas Data Home - Review View Tell me Share Comments Arial 10 9 ~ A A General 5 X G 22 Insert 28 1. Delete Paste B S% Anayza Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter Format v v Find Select Data H8 x fx Assets 11 1 N M a U Y Z PA AC AT Ar 41 4 A 46 2 A Byte of Accounting Halance Sheet As of December 31, 2020 7 9 41585 15 15 17 15 1 $ 93111 $ arees 1239 29 H. 25911 21 Current Art Couch AROUND Alwar Di Focoso HITAME PT Cie. Inulary TO Currones Lang. Tam Anar ON 010 E Asem. Der NE Cara buain Azem Dr.Com - DV - M L 1 Tab Leyte Toidla To 19191 22 SO 12 12160.6 PULLO BORG 3 HO 31.12 13 W12 98 Linea 40 29 24 28 20 27 28 $ 22/100 TO 2340 12e re 13. REIM 3134134 Current Liebe Assunta A. ASFA San Pay Inamos Rio Tow Curroni LongTama NA Bend Pione tr v Tabellen Teller Tot in 50 51 $ 480 DO STRONO F.12 1_1211012 1777413 312477 61 Blocker's 14 $ Ca 2 ww.. Fre rer RE Reine Frisines Tod's EN Total Labs and other's Equity 1800 429281 HA 9161 77 24 ! TE TI 76 20 M Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratia Ready 75% AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Arial v 10 ~ A A 29 General 28 [G Paste B B 1 AY 2 Delete Format v Conditional Format Cell Formatting as Table Styles S Sensitivity Sort Filter v Find Select Anayza Data A1 + x fx F G M a R S U V X Z 1 H 1 A Byte of Accounting, Inc. Statement of Stockholders' Equity For Year Ending December 31, 2020 T 8 9 10 11 12 Balance, Beginning of Period 18 issue of Common Stock 19 Cash Dividends 22 Net Income 23 Balance, End of Peria 21 Common Total Stock, S0.01 Additional Paid-in- Retained Capital Stockholders par value Earnings Equity $ $ 22.00 $ 356 378 03 S 24,000.00 $ 380,400.00 27.00 72 873.00 72,900.00 980.00 880.CO 41,951.8 41,551.81 $ 49.00 $ 429 251.00 $ 64,971.81 $ 494,271.01 $ 20 27 20 28 30 S1 32 34 325 36 32 S8 40 41 45 27 44 29 51 52 53 41 55 57 50 81 Stockholders Equity, 2020 Balance Sheet 2020 Cash Flow, 2020 Ratio Ready = S: E 94% AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 10 ~ A A . ale General insert Insert 2 Delete Format v 28 Paste Arial [G ** B 1 I U 2x fx VA S % > Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter v Find Select Anayza Data H47 B C E F G H 1 J K L L M N 0 P P 0 R R S T U u 1 2 3 D A Byte of Accounting, Inc. Income Statement For Year Ending December 31, 2020 Revenues Sacs Revenue $ 468,6C2,00 Cort af Goods Sold 229,121.00 Gross Profit $ 229,421.00 S 9 10 11 19 14 16 16 17 18 16 20 21 22 23 24 25 20 27 28 29 34 35 36 37 38 43 44 45 46 Operating Expenses Rent Expense Saary Experse Advertising Expense Renais & Maint Expense Supples Expunge Insurance Expense Depreciation Expanse Red Debt Fspanne Telephone Expune Total Operaing Expenses 30.000.00 96,200.00 4.735.00 14 905 90 2.888 00 267.00 10.0BC 2,028 75 6.070.00 165.954.53 $ 63 464 47 Income From Operations Before Interest and Income Taxes Interest Expense 7.630.12 Net Income Before TAX $ 55,235.75 Income Tax Expercele 13.903.04 41,951.81 Net Income Altar Tax 48 99 50 51 52 53 54 55 56 57 be 55 60 81 2 Income Statement, 2020 Stockholders Equity, 2020 Balance Sheet 2020 Cash Flaw, 2020 Ratin Ready + 100% AutoSave on APO... MS8672 - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 23 General Insert 2 Delete Format v 28.0 [G Paste B B I U d S% Conditional Format Cell Formatting as Table Styles Sort Filter Sensitivity Find Select Anayza Data 049 fx Capital Stock, $0.01 Par Value M N 0 Q R 8 S U v x X Y Z AA A AC AD AF AF AG 2 3 4 A Byte of Accounting Balance Sheet As of December 31, 2019 5 Assets $ 328,830.00 $ 39,000.00 600.00 Current Assets Cash Accounts Receivable Alowna for Doubtful Accounts NA Nal Receivable Prepaid Runt Office Supples Total Dument Assets 29,400.00 2,500.00 900.00 S S 361,430.00 $ 63,100.00 6,000.00 57,100.00 Long-Term Assets Office Equipment Accum Deor.comce Equipment Nalomon Fquipment Computer Exuperen! Acum Deor. Computer Equipment Net Computer Equipment Total Lang_Tamm Assets Total Assets 3 20.000.00 4,000.00 15,000.00 73,100.00 S 434,530.00 U 9 10 11 12 13 14 15 16 17 10 19 20 21 22 25 26 27 31 32 39 34 35 SF 32 38 39 40 41 142 49 44 45 40 47 48 49 50 51 52 53 54 55 50 57 Liabilities $ Current Liabllides Accounts Payable Salaries Payable Income Taxes Payable Tatal Liabilities 47,930.00 800.00 5,000.00 S 54,130.00 Stockholder's Equity $ Captal Stock $0.01 Par Valve Paid in Capital in Excess of Par Fatared Eamings Total Stochoder Fquity 22.00 260,379.00 24,000.00 389,400.00 Total Liabilities and Stockholder's Equity Balance Sheet, 2019 Income Statement, 2020 Stockholders Equity, 2020 Balance Sheet, 2020 Cash Flow, 2020 Ratio Ready -- + 100%