Question
Please answer every question listed. Thank you SO much.
Use the information contained in these financial statements and notes to complete this case. All answers should be for the mo
CONSOLIDATED BALANCE SHEETS (In millions, except number of shares which are reflected in thousands and par value) September 2
CONSOLIDATED STATEMENTS OF SHAREHOLDERS EQUITY (In millions, except number of shares which are reflected in thousands) Commo
L. Financial Statement Analysis Ratios - Must show your work for all ratios. Calculate each ratio to three decimal places. (P
3. Total Asset Turnover (pages 561, 565) (6 Points) a. Calculate the Total Asset Turnover ratio. (6) Debt ratiopages 562, 565
5. Debt-to-Equity Ratio (pages 562, 565) (8 Points) a. Calculate the Debt-to-Equity Ratio. (4) b. What does this ratio tell y
d. If analyst give a range of higher than 20-25 for a stock to be considered overpriced and less than 5-8 for a stock to be c
b. Calculate the Days Sales in Inventory ratio. (6) c. Is this favorable or unfavorable? Why? (4) II. Summary (20 Points) Yo
0 0
Add a comment Improve this question Transcribed image text
Answer #1
1- current ratio =total of current assets/total of current liabilities 106869/79006 1.353 Ideal current ratio is 2 but company current ratio is 1.353 which is below the ideal ratio of two so we can say short term liquidity of the company is average not very good and not very bad as this ratio is above the ratio 1
profit margin ratio = net income/net sales 45687/215639 21.187% Company is earning profit at a rate of 21.187% which is a good sign of profitability as no other figure is provided for comparison so this is good rate of profit.
2- Accounts receivable turnover ratio = sales/average of accounts receivables 215639/16301.5 13.228
average accounts receivables (15754+16849)/2 16301.5
days sales uncollected ratio =365/accounts receivable turnover ratio 365/13.228 27.593 company gets its payment from debtors at a gap of 27 days so it seems favorable as so comparative figure is provided.
3- total asset turnover ratio = sales/average of total of assets 215639/306015.5 0.705
average of total of assets (321686+290345)/2 306015.5
4- debt ratio = total of liabilities/total of assets 193437/321686 0.601
company is 60% debt financed which shows a high degree of riskiness
5- debt to equity ratio = total of liabilities/total of equity 193437/128249 1.508 company debt equity ratio comprise of 1.5:1 . Which shows a high degree of riskiness
6- market price 264.29 27/11/2019
dividend yield = dividend per share/market price 2.18/264.29 0.825%
pe ratio = market price/eps 264.29/8.35 31.651
It seems over priced as its PE ratio is 31.651 which is more than the range of 20-25
7- inventory turnover ratio = cost of sales/average inventory 131376/2240.5 58.637
average inventory (2132+2349)/2 2240.5
days sales in inventory = 365/inventory turnover ratio 365/58.637 6.225
it seems unfavorable because creditors provide credit only for 6 days
Over conclusion we can drawn that company liquidity position is moderate as its current ratio is less than ideal ratio of 2. profitability position is good as company is earning a return more than 20%. It is highly levered company as its debt ratio is .6 or 60% of the assets are debt financed and deb to equity ratio is 1.5:1 which shows a high dependance on debt financing. efficiency ratio of the company is favorable. so over performance of the company is good.
Add a comment
Know the answer?
Add Answer to:
Please answer every question listed. Thank you SO much. Use the information contained in these financial...
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
  • Please answer all questions and make answers very clear. Thank you so much and I will...

    Please answer all questions and make answers very clear. Thank you so much and I will make sure to give a good rating!!! Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not need to include...

  • Please answer all questions listed. Whatever I can do to help, by giving a positive rating,...

    Please answer all questions listed. Whatever I can do to help, by giving a positive rating, thumbs up, etc. Let me know! Very desperate for help! Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not...

  • The first image is the original question, the rest are the answer choices for each box....

    The first image is the original question, the rest are the answer choices for each box. Last two images are apples financial statements. Question 4 4.5 pts Under the Chapter 12 Module you will find a document called "Apple IncBS for Homework". You will need that document to answer the following questions. What is Apple's Net Working Capital in 2018? [Select] What is Apple's Current Ratio in 2018? [Select] What is Apple's Debt Ratio in 2018? [Select] What is Apple's...

  • Please break it down completely. I need to see how the answer is found. There are...

    Please break it down completely. I need to see how the answer is found. There are 3 parts to this question attatched. Thanks The following summarized data (amounts in millions) are taken from the September 30, 2017, and September 24, 2016, comparative financial statements of Apple Inc., a company that designs, manufactures, and markets mobile communication and media devices and personal computers; sells a variety of related software, services, accessories, networking solutions, and offers third-party digital content and applications: 2017...

  • AA 8-1 Company Analysis LO C2, A1 Use Apple's financial statements in Appendix A to answer...

    AA 8-1 Company Analysis LO C2, A1Use Apple's financial statements in Appendix A to answer the following.Required:1. Identify the total amount of cash and cash equivalents for fiscal years ended (a) September 30, 2017, and (b) September 24,2016.2. Compute cash and cash equivalents as a percent of total current assets, total current liabilities, total shareholders' equity, and total assets at fiscal year-end for both 2017 and 2016.3. Compute the percent change between the beginning and ending year amounts of cash...

  • 2017 $ 229, 234 114,048 61,344 $ 48,351 2016 $ 215,639 131,376 60,024 $ 45,687 $...

    2017 $ 229, 234 114,048 61,344 $ 48,351 2016 $ 215,639 131,376 60,024 $ 45,687 $ 20,289 53,892 17,874 4,855 17,799 13,936 128,645 194,714 33,783 5,717 2,298 10,162 $ 375, 319 $ 20,484 46,671 15, 754 2,132 13, 545 8,283 106,869 170, 430 27,010 5,414 3,206 8,757 $ 321,686 For the Fiscal Years Ended September 30 and September 24, respectively: Net sales Costs of sales Operating income Net income At Year End: Assets Current assets: Cash and cash equivalents Short-term...

  • The following summarized data (amounts in millions) are taken from the September 30, 2017, and September...

    The following summarized data (amounts in millions) are taken from the September 30, 2017, and September 24, 2016, comparative financial statements of Apple Ic., a company that designs, manufactures, and markets mobile communication and media devices and personal computers; sells a variety of related software, services, accessories, networking solutions, and offers third-party digital content and applications: (Amounts Expressed in Millions) For the Fiscal Years Ended September 30 and September 24, respectively: Net sales 2017 2016 $ 215,639 $ 229,234 Costs...

  • please explain as i am lost on where to start even. let me know if you...

    please explain as i am lost on where to start even. let me know if you need more of the appendix A. thank you! AA 11-1 Company Analysis LO C2, A1, A4 Use Apple's financial statements in Appendix A to answer the following. Required: 1. How many shares of Apple common stock are issued and outstanding at() September 30, 2017, and (b) September 24, 2016? 2. What is the total amount of cash dividends paid to common stockholders for the...

  • need help ASAP! Using Apple's 2019 Financial Statements (see instructions and additional numbers below), calculate the...

    need help ASAP! Using Apple's 2019 Financial Statements (see instructions and additional numbers below), calculate the following ratios for September 29, 2018 and September 28, 2019, compare the two years for each ratio, and write 1-2 sentences to discuss the results of each ratio. For example, If the the current ratio increases in year 2, is this a favorable or unfavorable change? What does this mean about liquidity since this is a liquidity ratio? Reading the section in your book...

  • Using the formulas in Table 4.1 and Urban Outfitters’s financial statement starting on page 117, calculate...

    Using the formulas in Table 4.1 and Urban Outfitters’s financial statement starting on page 117, calculate the following measures of financial performance. Be sure to report items (a) through (e) in percentages (i.e., multiply your result x 100). a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times-interest-earned (or coverage) ratio e. Return on stockholders’ equity f. Return on assets g. Debt-to-equity ratio h. Days of inventory i. Inventory turnover ratio j. Average collection period From...

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