6 Financial statement data for: 2021 2022 Co Cash And Equivalents 7116 2773 9 Accounts Receivable 3568 5610 10 Inventory 3228 6341 11 Total Current Assets 20075 20724 12 Net Property, Plant & Equipment 5072 5799 13 Total Assets 41240 49014 14 Total Current Liabilities 11951 11866 15 Long-Term Debt 13701 13537 16 Total Liabilities 31290 31001 17 Total Equity 9950 18013 18 Total Liabilities And Equity 41240 49014 19 20 Total Revenue 33566 44200 21 Cost Of Goods Sold 14262 18635 22 Operating Income 9789 15860 23 Net Income 9043 12936 24 Payout Ratio % 0.332632 0.248299 25 26 Share Price 138.48 112.5 27 Shares Out. 1119.6 1121

 

ECON 374 PROJECT -- PART 2 Financial Ratios Common size balance sheet for 2021 2021 2022 Cash and equivalents Total current liabilities IN 3 Student name here NWC to total assets Inventory Long-term debt 4 Firm name here Interval measure Total current assets Total liabilities Debt-to-equity ratio + Net PPE Total equity 6 Answer the following based on your firm's data from Part 1: Long-term debt ratio Total assets Total liabilities & equity 7 Inventory turnover 8 What was the dollar amount of dividends your firm paid in Days' sales in inventory Common size balance sheet for 2022 9 2021 and in 2022? 2021 2022 Fixed asset turnover Cash and equivalents Total current liabilities 10 Dividends Return on assets Inventory Long-term debt 11 Return on equity Total current assets Total liabilities 12 What was your firm's percentage growth rate in total sales Earnings per share Net PPE Total equity 13 revenue from 2021 to 2022? PE ratio Total assets Total liabilities & equity 14 Sales revenue % growth rate Market-to-book ratio 15 Common base year balance sheet for 2022 using 2021 as the base year 16 Suppose you received your firm's 2021 operating income Name the three ratios used for DuPont analysis of ROE, and Cash and equivalents Total current liabilities 17 three years ago and your firm's 2022 operating income two provide the value of each ratio for each year Inventory Long-term debt 18 years ago. If you had invested both cash flows in an account 2021 2022 Total current assets Total liabilities 19 earning 4.5% interest annually, how much would you have in First ratio name here Net PPE Total equity 20 that account today? Second ratio name here Total assets abilities & equity 21 Amount in account today Third ratio name here 22 Common size and base year balance sheet for 2022 using 2021 as the base year 23 Cash and equivalents Total current liabilities 24 Suppose you are taking out a loan. You agree to pay back the loan by making annual payments at the end of each of the next ten years. Inventory Long-term debt 25 The dollar amount of each annual payment equals your firm's 2021 share price. If the annual interest rate on your loan is 6%, how much Total current assets Total liabilities 26 money are you borrowing? Net PPE Total equity 27 Amount borrowed Total assets Total liabilities & equity 28 

30 Data from Part 1 of the project 31 You are not required to copy your Part 1 data into the spaces below, but you 32 may find it easier to enter formulas into the blue spaces above if you do. 33 Financial statement data for: 2021 2022 34 35 Cash And Equivalents 36 Accounts Receivable 37 Inventory 38 Total Current Assets 39 Net Property, Plant & Equipment 40 Total Assets 41 Total Current Liabilities 42 Long-Term Debt 43 Total Liabilities 44 Total Equity 45 Total Liabilities And Equity 46 47 Total Revenue 48 Cost Of Goods Sold 49 Operating Income 50 Net Income 51 Payout Ratio % 52 53 Share Price 54 Shares Out.

Transcribed Image Text:

6 Financial statement data for: 2021 2022 7 8 Cash And Equivalents 7116 2773 9 Accounts Receivable 3568 5610 10 Inventory 3228 6341 11 Total Current Assets 20075 20724 12 Net Property, Plant & Equipment 5072 5799 13 Total Assets 41240 49014 14 Total Current Liabilities 11951 11866 15 Long-Term Debt 13701 13537 16 Total Liabilities 31290 31001 17 Total Equity 9950 18013 18 Total Liabilities And Equity 41240 49014 19 20 Total Revenue 33566 44200 21 Cost Of Goods Sold 14262 18635 23 22222 Net Income 24 25 27 Operating Income Payout Ratio % 26 Share Price 30 Shares Out 9789 15860 9043 12936 0.332632 0.248299 138.48 112.5 1119.6 1121 6 Financial statement data for: 2021 2022 7 8 Cash And Equivalents 7116 2773 9 Accounts Receivable 3568 5610 10 Inventory 3228 6341 11 Total Current Assets 20075 20724 12 Net Property, Plant & Equipment 5072 5799 13 Total Assets 41240 49014 14 Total Current Liabilities 11951 11866 15 Long-Term Debt 13701 13537 16 Total Liabilities 31290 31001 17 Total Equity 9950 18013 18 Total Liabilities And Equity 41240 49014 19 20 Total Revenue 33566 44200 21 Cost Of Goods Sold 14262 18635 23 22222 Net Income 24 25 27 Operating Income Payout Ratio % 26 Share Price 30 Shares Out 9789 15860 9043 12936 0.332632 0.248299 138.48 112.5 1119.6 1121