Question

Table 4- Balance Sheet for ALICO, in millions USD Cash and equivalents Accounts receivable Inventories Other current assets T5. Financial ratios - Using information in tables 4 and 5, respond the questions below. 5.1. Estimate ROE using the DuPont mo

0 0
Add a comment Improve this question Transcribed image text
Answer #1

5.1) As per Du Pont's model,

ROE =  (Net Income/Revenues) x (Revenues/Total Assets) x (Total Assets/ Shareholders' Equity)

For 2018, ROE = (12.800/81.281) X (81.281/423.422) X (423.422/177.595)

= 0.1575 X 0.1920 X 2.3842

= 7.21%

For 2018, ROE = (21.673/122.496) X (122.496/399.519) X (399.519/183.283)

= 0.1769 X 0.3066 X 2.1798

= 11.82%

5.2) The Company's operations have improved in operating efficiency with its profit margin improving from 15.75% in FY18 to 17.69% in FY19.

The Company's assets have generated higher revenues with higher asset use efficiency with its asset turnover ratio improving from 19.20 in FY18 to 30.66 in FY19.

Wthe decrease in total assets coupled with increased shareholder's equity on the back of increase in capital and ploughback of profits, the Company's equity multiplier has decreased from 238.42 in FY18 to 217.98 in FY19 resulting in lower leverage.

Add a comment
Know the answer?
Add Answer to:
Table 4- Balance Sheet for ALICO, in millions USD Cash and equivalents Accounts receivable Inventories Other...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Balance Sheet (Millions of $) Assets 2019 Cash and securities 1554 Accounts receivable 9660 Inventories 13440...

    Balance Sheet (Millions of $) Assets 2019 Cash and securities 1554 Accounts receivable 9660 Inventories 13440 Total current assets $24,654.00 Net plant and equipment 17346 Total assets $42,000.00 Liabilities and Equity Accounts payable 7980 Notes payable 5,880.00 Accruals 4620 Total current liabilities $18,480.00 Long-term bonds 10920 Total liabilities $29,400.00 Common stock (175 M shares) 3,360.00 Retained earnings 9240 Total common equity $12,600.00 Total liabilities and equity $42,000.00 Income Statement (Millions of $) 2019 Net sales $60,000.00 Operating costs except depr'n...

  • Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories...

    Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories 13,440.0 Total current assets $24,654.0 Net plant and equipment 17,346.0 $42,000.0 Total assets Liabilities and Equity Accounts payable Notes payable $7,980.0 5,880.0 Accruals 4,620.0 Total current liabilities $18,480.0 Long-term bonds 10,920.0 $29,400.0 Total liabilities Common stock 3,360.0 Retained earnings 9,240.0 $12,600.0 Total common equity Total liabilities and equity $42,000.0 Income Statement (Millions of $) 2016 Net sales $58,800.0 Operating costs except depreciation $54,978.0 $1,029.0...

  • Balance Sheet Assets Fiscal year is January-December. All values USD millions. 2017 Cash & Short Term...

    Balance Sheet Assets Fiscal year is January-December. All values USD millions. 2017 Cash & Short Term Investments 18.3B Total Accounts Receivable 13.49B Inventories 8.77B Other Current Assets 2.54B Total Current Assets 43.09B 2017 Net Property, Plant & Equipment 17.01B Total Investments and Advances 751M Long-Term Note Receivable - Intangible Assets 85.13B Other Assets 4.22B Total Assets 157.3B Liabilities & Shareholders' Equity 2017 ST Debt & Current Portion LT Debt 3.91B Accounts Payable 7.31B Income Tax Payable 1.85B Other Current Liabilities...

  • Balance Sheets 2019 2018 Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant...

    Balance Sheets 2019 2018 Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets $70 275 375 $720 $55 300 250 $605 1,490 $2,095 $3,020 $85 $ 150 175 50 120 45 Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and equity $345|| 450 1,225 1,000 $3,020 $180 290 1,225 400 $2,095 Income Statements Sales Operating costs excluding depreciation EBITDA Depreciation and amortization...

  • what is the debt to campital ratio? and ROIC and dividends per share Balance Sheet (Millions...

    what is the debt to campital ratio? and ROIC and dividends per share Balance Sheet (Millions of S) Assets Cash and securities Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities 2019 $4,200 17,500 20,300 $42.000 $28.000 $70,000 $22,509 14,391 6,000 $42.900 Long-term bonds Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity $11,000 $53,900 $3,542 12,558 $16,100 $70,000 Income Statement (Millions...

  • 2018 2017 Assets Cash and equivalents $14,000 11,000 Accounts receivable 35,000 30,000 Inventories 30,120 27,000 Total...

    2018 2017 Assets Cash and equivalents $14,000 11,000 Accounts receivable 35,000 30,000 Inventories 30,120 27,000 Total current assets 79,120 68,000 Net plant and equipment 48,000 45,000 Total assets $127,120 $113,000 Liabilities and Equity Accounts payable 8,500 10,500 Accruals 7,600 6,000 Notes payable 6,100 5,150 $ 19,650 Total current liabilities 24,200 Long-term bonds 10,000 10,000 $29,650 Total liabilities 34,200 Common stock (4,000 shares) 50,000 50,000 Retained earnings 42,920 33,350 Common equity 92,920 83,350 Total liabilities and equity $127,120 $113,000 Income Statement...

  • Amounts in millions Balance Sheet Cash and Cash Equivalents $2,200 Marketable Securities 15,300 Accounts Receivable (net)...

    Amounts in millions Balance Sheet Cash and Cash Equivalents $2,200 Marketable Securities 15,300 Accounts Receivable (net) 10,000 Total Current Assets 42,000 Total Assets 155.000 Current Liabilities 28,000 Long-Term Debt 47,500 Shareholders' Equity 79,500 Income Statement Interest Expense 3.200 Net Income Before Taxes 36,800 Calculate the following ratios: (Round to 2 decimal points) a. Times-interest-earned ratio 0 b. Quick ratio C. Current ratio

  • 2018 2017 Assets Cash and equivalents Accounts receivable Inventories Total current assets 999 991 Net plant...

    2018 2017 Assets Cash and equivalents Accounts receivable Inventories Total current assets 999 991 Net plant and equipment Total assets Liabilities and Equity 8 Accounts payable $ 11,000 8 Accruals 7,600 Notes payable 6,000 Total current liabilities Long-term bonds Total liabilities 99% 318 88 44,500 40,000 49,955 Common stock (4,000 shares) Retained earnings 40,000 49,955 35,100 Common equity $ 89,955 $75.100 Total liabilities and equity $134,555 $115,000 Income Statement for Year Ending December 31, 2018 Sales $225,000 Operating costs excluding...

  • Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $15,000...

    Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents Accounts receivable Inventories $15,000 14,000 30,000 .28,000 $81,235 $72,000 47,000 $119,000 35,000 31,235 Total current assets Net plant and equipment Total assets 50,000 $131,235 Liabilities and Equity Accounts payable Accruals Notes payable $10,000 7,100 7,000 8,500 7,000 5,150 Total current liabilities Long-term bonds Total liabilities Common stock (4,000 shares) Retained earnings 20,000 44,100 60,000 27,135 87,135 $131,235 $ 24,100 20,650 20,000 $40,650 60,000 18,350 $ 78,350 $119,000 Common...

  • 6 ANNUAL FINANCIAL REPORT All values USD Millions. Fiscal year is February-January. All values USD Millions....

    6 ANNUAL FINANCIAL REPORT All values USD Millions. Fiscal year is February-January. All values USD Millions. BALANCE SHEET Assets Cash & Short Term Investments Total Accounts Receivable Inventories Other Current Assets Total Current Assets 2020 723 15 3,537 374 4,649 2019 934 29 3,475 397 4,835 9,743 145 14,555 7,428 182 12,469 3 Net Property, Plant & Equipment 4 Other Assets 5 Total Assets -6 17 Liabilities & Shareholders' Equity 18 ST Debt & Current Portion LT Debt 19 Accounts...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT