Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the following data calculate the following ratio's for all the of the given years: -Inventory Turnover -A/R Turnover -Average Collection Period -Fixed Asset
Based on the following data calculate the following ratio's for all the of the given years:
-Inventory Turnover
-A/R Turnover
-Average Collection Period
-Fixed Asset Turnover
-Total Asset Turnover
2019 103.44 50.75 52.68 7.89 44.79 15.98 -42.63 2016 71.01 21.26 49.75 12.13 37.62 13.70 -32.18 19.14 0.90 2018 89.47 35.81 53.66 7.95 45.70 13.93 -37.58 22.05 1.01 21.04 -0.14 20.89 20.89 2021 Interest Income - Bank 82.08 Total Interest Expense 32.05 Net Interest Income 50.04 Loan Loss Provision 9.07 Net Interest Inc. After Loan Loss Prov. 40.97 Non-Interest Income - Bank 16.75 Non-Interest Expense - Bank -46.15 Net Income Before Taxes 11.57 Provision for Income Taxes 0.50 Net Income After Taxes Minority Interest -0.18 Net Income Before Extraordinary Items 10.89 Net Income 10.89 Total Adjustments to Net Income -5.12 Income Available to Common Excluding Extraordinary Item: 5.78 Income Available to Common Including Extraordinary Items 5.78 Diluted Net Income 5.78 Diluted Weighted Average Shares 1,019.59 Diluted Earnings per Share (EPS) Excluding Extraordinary Ite: 0.01 Dividends per Share - Common Stock Primary Issue 0.00 Diluted Normalized Earnings per Share (EPS) 0.02 2017 74.56 25.51 49.05 10.03 39.01 15.22 -35.56 18.67 0.88 17.79 -0.09 17.70 17.70 2020 89.08 40.25 48.83 26.69 22.14 15.02 - 37.03 0.13 0.00 0.12 -0.12 0.00 0.00 -5.19 -5.19 -5.19 -5.19 1,019.59 -0.01 0.00 -0.01 2015 63.16 15.29 47.86 35.27 12.59 32.88 -28.59 16.88 0.80 16.08 -0.08 16.00 16.00 11.08 2014 53.99 11.39 42.60 17.75 24.84 15.66 -26.11 14.39 0.65 13.73 -0.06 13.68 13.68 18.24 18.14 0.82 17.32 -0.17 17.15 17.15 -0.04 18.20 18.20 -- -- 16.00 16.00 17.15 17.15 17.15 1,019.59 0.02 0.01 20.89 20.89 20.89 1,019.59 0.02 0.01 0.02 17.70 17.70 17.70 1,019.59 0.02 0.01 0.02 18.20 18.20 18.20 1,019.59 0.02 0.01 0.02 16.00 1,019.59 0.02 0.01 0.02 13.68 13.68 13.68 1,019.59 0.01 0.01 0.01 0.02 2018 2020 93.02 1,019.59 39.51 352.52 2,303.02 17.96 113.28 1,667.08 0.34 1,019.59 389.81 1,698.27 18.27 103.73 1,328.80 6.27 49.48 165.21 28.50 -45.23 507.27 2019 47.36 1,019.59 437.26 2,154.82 18.39 107.88 1,486.90 0.36 49.48 134.42 31.04 -45.23 777.80 14.58 2.68 110.70 1.54 371.82 2017 16.98 1,019.59 1452.96 1,401.05 16.08 103.73 1,214.29 6.26 49.48 152.59 2016 13.84 1,019.59 415.17 1,377.12 13.91 103.73 1,135.51 0.25 49.48 143.80 25.57 -45.23 407,40 2015 9.71 1,019.59 368.38 1,373.87 14.41 103.73 1,024.51 0.24 49.48 136.68 49.48 2014 11.18 1,019.59 455.69 1,157.48 11.43 103.73 993.28 6.23 49.48 129.72 25.02 -45.23 390.88 26.00 45.23 26.23 -45.23 2021 Cash & Due from Banks 288.37 Total Common Shares Outstanding 1,019.59 Other Earning Assets - Total 515.55 Net Loans 2,270.47 Accrued Expenses 21.29 Common Stock - Total 113.28 Total Deposits 2,092.74 Tangible Book Value per Share - Common Eq 0.35 Additional Paid-In Capital 49.48 Retained Earnings (Accumulated Deficit) 114.80 Property/Plant/Equipment - Total - Net 40.56 Treasury Stock - Common Total Short Term Borrowings 621.11 Unrealized Gain (Loss) 13.49 Other Current liabilities - Total 1.88 Other Equity - Total 108.25 Long Term Investments '1.67 Total Equity 354.07 Total Long Term Debt 2.27 Total Liabilities & Shareholders' Equity 3,135.07 Other Assets - Total 18.44 Total Debt 623.38 Total Assets 3,135.07 Capital Lease Obligations 2.27 Minority Interest 3.66 Other Liabilities - Total 38.05 Total Liabilities 2,781.00 109.31 32.21 -45.23 739.52 14.04 1.53 383.36 -45.23 477.50 2.74 2.55 2.54 1.93 1.71 107.88 1.53 1.52 260.57 10.00 10.00 1.54 348.74 6.00 2,801.59 19.28 739.52 2,801.59 2,687.62 15.61 777.80 2,687.62 1.52 273.19 6.00 2,168.59 10.99 507.27 2,168.59 1,916.04 17.30 383.36 1,916.04 251.78 0.00 1,846.03 12.79 407.40 1,846.03 3.94 244.65 6.00 1,790.05 8.15 477.50 1,790.05 3.88 237.69 0.00 1,662.58 9.34 390.88 1,662.58 3.58 3.41 23.20 3.59 26.44 2,315.80 34.90 3.32 35.87 1,655.47 3.21 31.68 1,594.25 3.15 23.90 1,545.39 3.12 24.46 1,424.88 2,452.86 1,895.40 2017 2018 -4.25 21.04 -2.58 2016 -1.54 2015 -1.96 16.08 2014 -1.61 17.79 2021 -9.22 11.08 -5.25 -0.23 -0.14 18.24 13.73 -8.34 -6.55 14.42 2.00 Capital Expenditures Net Income/Starting Line Financing Cash Flow Items Foreign Exchange Effects Total Cash Dividends Paid Depreciation/Depletion Net Change in Cash Other Investing Cash Flow Items - Total Cash from Investing Activities Non-Cash Items Cash from Financing Activities Changes in Working Capital Cash from Operating Activities Cash Interest Paid 2020 -3.98 0.12 85.08 0.06 -6.61 4.24 99.06 -6.60 -10.58 -2.96 78.47 29.71 31.10 5.19 2019 -4.61 17.32 87.71 -0.12 -10.21 3.69 233.78 -66.10 -70.71 -5.06 77.49 211.17 227.12 -9.31 1.89 -50.32 5.80 3.10 147.46 -9.29 2.27 45.69 -18.21 -22.45 -2.50 -9.29 56.63 77.43 -38.93 -22.57 -24.11 -129.10 -107.83 -117.05 -3.97 -5.39 -17.97 3.22 -8.34 2.07 -33.30 -5.80 -7.76 -6.02 -8.34 -29.33 -0.05 -1.66 -3.73 -3.92 -9.31 -60.00 -44.23 -8.34 -23.00 -4.13 -6.55 42.98 55.67 -6.44 6.49 -17.20 5.12 2019 103.44 50.75 52.68 7.89 44.79 15.98 -42.63 2016 71.01 21.26 49.75 12.13 37.62 13.70 -32.18 19.14 0.90 2018 89.47 35.81 53.66 7.95 45.70 13.93 -37.58 22.05 1.01 21.04 -0.14 20.89 20.89 2021 Interest Income - Bank 82.08 Total Interest Expense 32.05 Net Interest Income 50.04 Loan Loss Provision 9.07 Net Interest Inc. After Loan Loss Prov. 40.97 Non-Interest Income - Bank 16.75 Non-Interest Expense - Bank -46.15 Net Income Before Taxes 11.57 Provision for Income Taxes 0.50 Net Income After Taxes Minority Interest -0.18 Net Income Before Extraordinary Items 10.89 Net Income 10.89 Total Adjustments to Net Income -5.12 Income Available to Common Excluding Extraordinary Item: 5.78 Income Available to Common Including Extraordinary Items 5.78 Diluted Net Income 5.78 Diluted Weighted Average Shares 1,019.59 Diluted Earnings per Share (EPS) Excluding Extraordinary Ite: 0.01 Dividends per Share - Common Stock Primary Issue 0.00 Diluted Normalized Earnings per Share (EPS) 0.02 2017 74.56 25.51 49.05 10.03 39.01 15.22 -35.56 18.67 0.88 17.79 -0.09 17.70 17.70 2020 89.08 40.25 48.83 26.69 22.14 15.02 - 37.03 0.13 0.00 0.12 -0.12 0.00 0.00 -5.19 -5.19 -5.19 -5.19 1,019.59 -0.01 0.00 -0.01 2015 63.16 15.29 47.86 35.27 12.59 32.88 -28.59 16.88 0.80 16.08 -0.08 16.00 16.00 11.08 2014 53.99 11.39 42.60 17.75 24.84 15.66 -26.11 14.39 0.65 13.73 -0.06 13.68 13.68 18.24 18.14 0.82 17.32 -0.17 17.15 17.15 -0.04 18.20 18.20 -- -- 16.00 16.00 17.15 17.15 17.15 1,019.59 0.02 0.01 20.89 20.89 20.89 1,019.59 0.02 0.01 0.02 17.70 17.70 17.70 1,019.59 0.02 0.01 0.02 18.20 18.20 18.20 1,019.59 0.02 0.01 0.02 16.00 1,019.59 0.02 0.01 0.02 13.68 13.68 13.68 1,019.59 0.01 0.01 0.01 0.02 2018 2020 93.02 1,019.59 39.51 352.52 2,303.02 17.96 113.28 1,667.08 0.34 1,019.59 389.81 1,698.27 18.27 103.73 1,328.80 6.27 49.48 165.21 28.50 -45.23 507.27 2019 47.36 1,019.59 437.26 2,154.82 18.39 107.88 1,486.90 0.36 49.48 134.42 31.04 -45.23 777.80 14.58 2.68 110.70 1.54 371.82 2017 16.98 1,019.59 1452.96 1,401.05 16.08 103.73 1,214.29 6.26 49.48 152.59 2016 13.84 1,019.59 415.17 1,377.12 13.91 103.73 1,135.51 0.25 49.48 143.80 25.57 -45.23 407,40 2015 9.71 1,019.59 368.38 1,373.87 14.41 103.73 1,024.51 0.24 49.48 136.68 49.48 2014 11.18 1,019.59 455.69 1,157.48 11.43 103.73 993.28 6.23 49.48 129.72 25.02 -45.23 390.88 26.00 45.23 26.23 -45.23 2021 Cash & Due from Banks 288.37 Total Common Shares Outstanding 1,019.59 Other Earning Assets - Total 515.55 Net Loans 2,270.47 Accrued Expenses 21.29 Common Stock - Total 113.28 Total Deposits 2,092.74 Tangible Book Value per Share - Common Eq 0.35 Additional Paid-In Capital 49.48 Retained Earnings (Accumulated Deficit) 114.80 Property/Plant/Equipment - Total - Net 40.56 Treasury Stock - Common Total Short Term Borrowings 621.11 Unrealized Gain (Loss) 13.49 Other Current liabilities - Total 1.88 Other Equity - Total 108.25 Long Term Investments '1.67 Total Equity 354.07 Total Long Term Debt 2.27 Total Liabilities & Shareholders' Equity 3,135.07 Other Assets - Total 18.44 Total Debt 623.38 Total Assets 3,135.07 Capital Lease Obligations 2.27 Minority Interest 3.66 Other Liabilities - Total 38.05 Total Liabilities 2,781.00 109.31 32.21 -45.23 739.52 14.04 1.53 383.36 -45.23 477.50 2.74 2.55 2.54 1.93 1.71 107.88 1.53 1.52 260.57 10.00 10.00 1.54 348.74 6.00 2,801.59 19.28 739.52 2,801.59 2,687.62 15.61 777.80 2,687.62 1.52 273.19 6.00 2,168.59 10.99 507.27 2,168.59 1,916.04 17.30 383.36 1,916.04 251.78 0.00 1,846.03 12.79 407.40 1,846.03 3.94 244.65 6.00 1,790.05 8.15 477.50 1,790.05 3.88 237.69 0.00 1,662.58 9.34 390.88 1,662.58 3.58 3.41 23.20 3.59 26.44 2,315.80 34.90 3.32 35.87 1,655.47 3.21 31.68 1,594.25 3.15 23.90 1,545.39 3.12 24.46 1,424.88 2,452.86 1,895.40 2017 2018 -4.25 21.04 -2.58 2016 -1.54 2015 -1.96 16.08 2014 -1.61 17.79 2021 -9.22 11.08 -5.25 -0.23 -0.14 18.24 13.73 -8.34 -6.55 14.42 2.00 Capital Expenditures Net Income/Starting Line Financing Cash Flow Items Foreign Exchange Effects Total Cash Dividends Paid Depreciation/Depletion Net Change in Cash Other Investing Cash Flow Items - Total Cash from Investing Activities Non-Cash Items Cash from Financing Activities Changes in Working Capital Cash from Operating Activities Cash Interest Paid 2020 -3.98 0.12 85.08 0.06 -6.61 4.24 99.06 -6.60 -10.58 -2.96 78.47 29.71 31.10 5.19 2019 -4.61 17.32 87.71 -0.12 -10.21 3.69 233.78 -66.10 -70.71 -5.06 77.49 211.17 227.12 -9.31 1.89 -50.32 5.80 3.10 147.46 -9.29 2.27 45.69 -18.21 -22.45 -2.50 -9.29 56.63 77.43 -38.93 -22.57 -24.11 -129.10 -107.83 -117.05 -3.97 -5.39 -17.97 3.22 -8.34 2.07 -33.30 -5.80 -7.76 -6.02 -8.34 -29.33 -0.05 -1.66 -3.73 -3.92 -9.31 -60.00 -44.23 -8.34 -23.00 -4.13 -6.55 42.98 55.67 -6.44 6.49 -17.20 5.12Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started