I've attached the questions and spreadsheets

Ch. 1: Questions 3 & 11 (Concepts Review and Critical Thinking Questions section)Ch. 2: Questions 4 & 9 (Questions and Problems section): Microsoft Excel template provided for Problem 4.Ch. 3: Questions 4 & 7 (Question and Problems section)Ch.4:Questions1&6(QuestionsandProblemssection):MicrosoftExceltemplateprovidedforProblem6. Chapter 4 Problems 5, 6, 20, 22 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." ets may require that nstalled in Excel. Chapter 4 Question 6 Input area: Sales Costs Taxable income Taxes Net income $ Current assets Fixed assets Total - $ - Payout ratio Tax rate Output area: Return on assets Retention ratio Internal growth rate #DIV/0! 100% #DIV/0! $ Debt Equity - Total $ - Chapter 4 Problems 5, 6, 20, 22 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." ets may require that nstalled in Excel. Chapter 4 Question 6 Input area: Sales Costs Taxable income Taxes Net income $ Current assets Fixed assets Total - $ - Payout ratio Tax rate Output area: Return on assets Retention ratio Internal growth rate #DIV/0! 100% #DIV/0! $ Debt Equity - Total $ - Chapter 2 Problems 2, 3, 4, 6, 7, 14, 15, 19 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." ets may require that nstalled in Excel. Chapter 2 Question 4 Addition to retained earnings $ - Earnings per share #DIV/0! Dividends per share #DIV/0! Corporations [LO3] What is the primary disadvantage of the corporate form of organization? Name at least two advantages of corporate organization Goal of the Firm [LO2] Evaluate the following statement: Managers should not focus on the current stock value because doing so will lead to an overemphasis on short-term profits at the expense of long-term profits. Calculating Additions to NWC [LO4] The 2014 balance sheet of Steelo, Inc., showed current assets of $4,630 and current liabilities of $2,190. The 2015 balance sheet showed current assets of $5,180 and current liabilities of $2,830. What was the company's 2015 change in net working capital, or NWC? Financial Ratios [LO2] Fully explain the kind of information the following financial ratios provide about a firm: a. Quick ratio. b. Cash ratio. c. Total asset turnover. d. Equity multiplier. e. Long-term debt ratio. f. Times interest earned ratio. g. Profit margin. h. Return on assets. i. Return on equity. j. Price-earnings ratio. DuPont Identity [LO3] Why is the DuPont identity a valuable tool for analyzing the performance of a firm? Discuss the types of information it reveals compared to ROE considered by itself. Sales Forecast [LO1] Why do you think most long-term financial planning begins with sales forecasts? Put differently, why are future sales the key input