ECON 374 PROJECT -- PART 2 Financial Ratios Common sire balance sheet for 2021 Cash and equivalents Total current liabilities Student name here NWC to total assets Inventory Long-term debt Firm name here Interval measure Total current assets Total lia 'ities Total equity Total liabilities & equity Debtetorequitv ratio Long-term debt ratio Inventory turnover Days' sales in inventory Fixed asset turnover Return on assets Answer the following based on your ?ml's data lrom Part 1: Common size balance sheet for 2022 Cash and equivalents Total current liabilities Inventory Longrterm debt Total current assets Total liabilities Net PPE Total equity Total assets Total liabilities & equity What was the dollar amount of dividends your firm paid in 2021 and in 2022? 2021 2022 Dividends Return on equity Earnings per share PE ratio Market-to-book ratio n total sales What was your firm's percentage growth rate i revenue from 2021 to 2022? Sales revenue % growth rate Common base year balance sheet for 2022 using 2021 as the base year Cash and equivalents Total current liabilities Long-term debt Total liabilities Total equity Total liabilities Rt equity 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 Name the three ratios used for DuPont analysis of ROE, and provide the value of each ratio for each year 2021 2022 First ratio name here Second ratio name here Third ratio name here Common sire and base year balance sheet for 2022 using 2021 as the base year Cash and equivalents Total current liabilities Inventory Long-term debt Total current assets Total liabilities Total equity Total liabilities & equity Suppose you are taking out a loan. Vou 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 yourfirm's 2021 share price. If the annual interest rate on your loan is 6%, how much money are you borrowing? Amount borrowed Data from Part 1 of the project You are not required to copy your Part 1 data into the spaces below, but you may find it easier to enter formulas into the blue spaces above if you do. Financial statement data for: 2021 Cash And Equivalents 7116 Accounts Receivable 3558 3228 Net Property, Plant & Equipment Total Assets Total Current Lia Long-Term Debt Total Liabilities Total Equity Total Liabilities And Equity Total Revenue 33556 Cost Of Goods Sold 14262 Operating Income 9789 Net Income 9043 Payout Ratio % 0.332632 Share Price 138.48 Shares Out. 1119.6 

Please solve the blue boxes. This image can be transformed into an Excel file online for free( I cannot add the actual Excel file because the platform allows me to upload only pictures)

Transcribed Image Text:

Just Dew It Corporation reports the following balance sheet information for 2020 and 2021. Assets 2020 Current assets Cash $4,350 Accounts receivable Inventory $9,800 11,550 14,200 58,350 75,800 JUST DEW IT CORPORATION 2020 and 2021 Balance Sheets 2021 Liabilities and Owners' Equity Current liabilities Accounts payable Notes payable 2020 2021 $ 48,000 $49,800 10,350 18,600 Total $ 74,250 $99,800 Total Long-term debt $ 58,350 $68,400 $ 42,000 $34,000 Owners' equity Common stock and paid-in surplus $ 45,000 $45,000 Retained earnings 154,650 252,600 $ Total $ 199,650 300,200 $ 297,600 $ 300,000 $ $ $ Total liabilities and owners' equity 400,000 300,000 400,000 Net plant and equipment $225,750 Total assets Prepare the 2020 and 2021 common-size balance sheets for Just Dew It. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Just Dew It Corporation reports the following balance sheet information for 2020 and 2021. Assets 2020 Current assets Cash $4,350 Accounts receivable Inventory $9,800 11,550 14,200 58,350 75,800 JUST DEW IT CORPORATION 2020 and 2021 Balance Sheets 2021 Liabilities and Owners' Equity Current liabilities Accounts payable Notes payable 2020 2021 $ 48,000 $49,800 10,350 18,600 Total $ 74,250 $99,800 Total Long-term debt $ 58,350 $68,400 $ 42,000 $34,000 Owners' equity Common stock and paid-in surplus $ 45,000 $45,000 Retained earnings 154,650 252,600 $ Total $ 199,650 300,200 $ 297,600 $ 300,000 $ $ $ Total liabilities and owners' equity 400,000 300,000 400,000 Net plant and equipment $225,750 Total assets Prepare the 2020 and 2021 common-size balance sheets for Just Dew It. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Answer rating: 100% (QA)

Certainly To calculate the commonsize balance sheets for 2020 and 2021 you need to express each item ... View the full answer