Question: Download the spreadsheet Assignment1_Data from Moodle. The data contains (partial) information for Grizzly Bear Muffin Company's balance sheet and income statement. Complete the balance sheet
Download the spreadsheet "Assignment1_Data" from Moodle. The data contains (partial) information for Grizzly Bear Muffin Company's balance sheet and income statement. Complete the balance sheet and income statement, and then answer the following questions.Calculate the number of shares outstanding for the company and the market price per share at the end of 2020.Calculate the cash flow from operations, net capital spending, and the change in NWC to calculate the cash flow from assets. Then, calculate the cash flow to creditors and cash flow to shareholders to calculate the cash flow from assets from the "uses" side and confirm that the cash-flow identity is satisfied.Use information from the balance sheet and income statement to calculate the following financial ratios and the market value added (MVA). Whenever balance sheet numbers are used to calculate financial ratios, please ensure that you use the average of the 2019 and 2020 numbers in your calculation. To calculate MVA, you can assume that1the average book value number for common stock and paid-in-surplus is the amount that the shareholders initially invested in the company.the average book value number for common stock and paid-in-surplus is the amount that the shareholders initially invested in the company.\table[[Short-term Solvency Ratios],[Current Ratio,],[Quick Ratio,],[NWC to total assets,],[Asset Utilization Ratios],[Days' sales in inventory,],[Receivables Turnover,],[Long-term Solvency Ratios],[Equity Multiplier,],[Cash Coverage Ratio,],[Profitability Ratios],[Profit Margin,],[Return on equity,],[Market Value Ratios],[Market-to-book ratio,],[Market Value Added ($M),]]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
