Assignment Steps

Resources:Tutorial help on Excelfunctions can be found on the MicrosoftOfficewebsite. There are also additional tutorials via the web that offer support for office products.

Completethe following Questions and Problems (Concepts and Critical Thinking Questions for Ch. 1 Only) from each chapter as indicated.

Showall work and analysis.

Preparein MicrosoftExcel

• Ch. 1: Questions 3 & 11 (Concepts Review and Critical Thinking Questions section)
• Ch. 2: Questions 4 & 9 (Questions and Problems section): MicrosoftExceltemplate provided for Problem 4.
• Ch. 3: Questions 4 & 7 (Question and Problems section)
• Ch. 4: Questions 1 & 6 (Questions and Problems section): MicrosoftExceltemplate provided for Problem 6.

Materials

• Ch. 2 Problem 4 Microsoft Excel Template
• Ch. 4 Problem 6 Microsoft Excel Template
• Fundamentals of Corporate Finance, Ch. 1: Introduction to Corporate Finance
• Fundamentals of Corporate Finance, Ch. 2: Financial Statements, Taxes, and Cash Flow
• Fundamentals of Corporate Finance, Ch. 3: Working with Financial Statements
• Fundamentals of Corporate Finance, Ch. 4: Long-Term Financial Planning and Growth

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 Input area: Sales Costs Depreciation expense Interest expense Tax rate Cash dividends Shares outstanding Output area: Income Statement Sales Costs Depreciation expense EBIT Interest expense EBT Taxes (0%) Net income $ - $ - Addition to retained earnings $ - $ $ - Earnings per share #DIV/0! Dividends per share #DIV/0! 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 4. Per-Share Earnings and Dividends [LO1] Suppose the firm in Problem 3 had 90,000 shares of common stock outstanding. What is the earnings per share, or EPS, figure? What is the dividends per share figure? 9. 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? Chapter 3 4. Calculating Inventory Turnover [LO2] The Green Corporation has ending inventory of $417,381, and cost of goods sold for the year just ended was $4,682,715. What is the inventory turnover? The days' sales in inventory? How long on average did a unit of inventory sit on the shelf before it was sold? 7. DuPont Identity [LO4] If Roten Rooters, Inc., has an equity multiplier of 1.15, total asset turnover of 2.10, and a profit margin of 6.1 percent, what is its ROE? Chapter 4 1. Pro Forma Statements [LO1] Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well. Create the pro forma statements and reconcile them. What is the plug variable here? 6. Calculating Internal Growth [LO3] The most recent financial statements for Schenkel Co. are shown here: Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 30 percent dividend payout ratio. What is the internal growth rate