Question

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 on each of these ratios will help with this part of the project. Make sure you show ALL of your work. If you calculate a number, you MUST show how it was calculated. ALL work must be completed in EXCEL. 1-Current Ratio 2-Inventory Turnover Ratio 3-Days Sales in Inventory 4-Debt to equity ratio 5-Debt ratio 6-Profit margin ratio 7-Gross margin ratio 8- Return on total assets

Answer 1

Current Current Opening closing Cost g Debt Equity Assets liabilities Inventory Inuentorly Sales Sept 28 2019 162819 105718 3956 4106 161782 91807 45174 Sept 28 2018 131339 115929 4855 3956 163756 93735 40201 a Net proht Gross profil Total Assets Closing Assets Opening Assets Aurage Assets Average Inventory Cost of sales of products Total Sales ① Current Ratio e 55256 59531 98392 161839 338516 365725 338516 36513 365725 375319 352221 370522 4406 4031 144996 148164 260174 265595 Assets liabilities 28.09.2018 a 131339 115929 2 1.13 times Current Current 2 28.09.2019 163819 105718 1.54 times - This ratio shows "does your business have enough I current assets to meet its cuscent li abilities" Here ratio earlies was 1:13 but now it is 1 1.54 times which shows that ability a busines to pay its current liabilities is improved.

Page Turnover ucentory Rtio ucentory & ons for 28 Cost & Sales Average Inventory 39 29 28.09. 2019 161782 144996 4031 6 35.97 6 28.09.2018 - 163756 148164 4406 e 33.63 to manage its inventory the ratio shows that investment in stock & measures decrease any has effiaency a increase decreased firm in its 339 125 रड Day sales in inventory c Closing Inventory Cost & sales" X365 - 319 R2 3956 x 365 64 75 28.09.2019 28.09.2018 4106 365 - 144996 148164 9.75 - - 10.34 number of days a company took sell its inventory during a It La descubes company the to year in it's ratio pace of this change decreased that its descubes of selling company has inventory. Debt Equity o Debt to Equity Rato 28.09.2019 91807 xloo 28-09.2018 93735 1100 40201 233.17. en 45174 203-23.1.

It indicates composition company Decrease in positive aspect that decreased in capital of capital strucure of a the reato is av describes that debt is. structure Debt Ratio Deht Total 28.09.2019 91807 x 100 Assets 28.09.2018 93135 x 100 365725 =2563 338516 27.12.11 This assets which ratio describes how much is debt. This ratio shows debt is increased percentage of total has increased in capttal structure @ Profit Margin Ratio a Net profit xoo - Sales 28.09.2018 28.09.2019 55256 260194 = 39531_ X 100 x100 2655 95 22.41 -1. = 21.24 ) = . It is says shows earned that how this much reatio percentage of has decuased net proft sales which puont ewening capauty is decreased

I Gross margin Rabu Guess profit Atoo sales 98393 28:09 19 - 98392 260174 e 31.821 - X 100 28 09 18 101839 265595 38 34 Albo 2 I shows uned by that the how much ./ company d sales has grans profits decreased It a Return on Total Assets a Net Total profit Assets 28.09.2019 55256 2 28-09.2018 59531 min 365725 x 100 338516 16.32.1 e 16.28. It shows an a which I the a shows return Company return that . on is earned on total This ratio is increased assets of company is increased