ECON 374 PROJECT-PART 2 Student name here Firm name here Answer the following based on your...

 

Transcribed Image Text:

ECON 374 PROJECT-PART 2 Student name here Firm name here Answer the following based on your firm's data from Part 1 What was the dollar amount of dividends your firm paid in 2021 and in 2022? Dividends 2021 2022 What was your firm's percentage growth rate in total sales revenue from 2021 to 2022? Sales revenue % growth rate Suppose you received your firm's 2021 operating income three years ago and your firm's 2022 operating income two years ago. If you had invested both cash flows in an account earning 4.5% interest annually, how much would you have in that account today? Amount in account today Financial Ratios NWC to total assets Interval measure Debt-to-equity ratio Long-term debt ratio Inventory turnover Days' sales in inventory Fixed asset turnover Return on assets Return on equity Earnings per share PE ratio Market-to-book ratio 2021 2022 Name the three ratios used for DuPont analysis of ROE, and provide the value of each ratio for each year First ratio name here Second ratio name here Third ratio name here 2021 Common size balance sheet for 2021 Cash and equivalents Inventory Total current assets Net PPE Total assets Common size balance sheet for 2022 Cash and equivalents Total current liabilities Long-term debt Total liabilities Total equity Total liabilities & equity Total current liabilities Long-term debt Total liabilities Total equity Inventory Total current assets Net PPE Total assets Total liabilities & equity Common base year balance sheet for 2022 using 2021 as the base year Cash and equivalents Inventory 2022 Total current assets Net PPE Total assets Total current liabilities Long-term debt Total liabilities Total equity Total liabilities & equity 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. 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 money are you borrowing? Amount borrowed Common size and base year balance sheet for 2022 using 2021 as the base year Cash and equivalents" Inventory Total current assets Net PPE Total assets Total current liabilities Long-term debt Total liabilities Total equity Total liabilities & equity 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: 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. 2021 2022 6 Financial statement data for: 2021 2022 7 8 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 21 Cost Of Goods Sold 22 Operating Income 23 Net Income 24 Payout Ratio % 25 26 Share Price 27 Shares Out. 33566 44200 14262 18635 9789 15860 9043 12936 0.332632 0.248299 138.48 112.5 1119.6 1121 30 ECON 374 PROJECT-PART 2 Student name here Firm name here Answer the following based on your firm's data from Part 1 What was the dollar amount of dividends your firm paid in 2021 and in 2022? Dividends 2021 2022 What was your firm's percentage growth rate in total sales revenue from 2021 to 2022? Sales revenue % growth rate Suppose you received your firm's 2021 operating income three years ago and your firm's 2022 operating income two years ago. If you had invested both cash flows in an account earning 4.5% interest annually, how much would you have in that account today? Amount in account today Financial Ratios NWC to total assets Interval measure Debt-to-equity ratio Long-term debt ratio Inventory turnover Days' sales in inventory Fixed asset turnover Return on assets Return on equity Earnings per share PE ratio Market-to-book ratio 2021 2022 Name the three ratios used for DuPont analysis of ROE, and provide the value of each ratio for each year First ratio name here Second ratio name here Third ratio name here 2021 Common size balance sheet for 2021 Cash and equivalents Inventory Total current assets Net PPE Total assets Common size balance sheet for 2022 Cash and equivalents Total current liabilities Long-term debt Total liabilities Total equity Total liabilities & equity Total current liabilities Long-term debt Total liabilities Total equity Inventory Total current assets Net PPE Total assets Total liabilities & equity Common base year balance sheet for 2022 using 2021 as the base year Cash and equivalents Inventory 2022 Total current assets Net PPE Total assets Total current liabilities Long-term debt Total liabilities Total equity Total liabilities & equity 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. 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 money are you borrowing? Amount borrowed Common size and base year balance sheet for 2022 using 2021 as the base year Cash and equivalents" Inventory Total current assets Net PPE Total assets Total current liabilities Long-term debt Total liabilities Total equity Total liabilities & equity 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: 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. 2021 2022 6 Financial statement data for: 2021 2022 7 8 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 21 Cost Of Goods Sold 22 Operating Income 23 Net Income 24 Payout Ratio % 25 26 Share Price 27 Shares Out. 33566 44200 14262 18635 9789 15860 9043 12936 0.332632 0.248299 138.48 112.5 1119.6 1121 30