Adjusted Cash Flow From Assets - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 E General Wrap Text HH Paste .. 4.0 B I U Merge & Center $ - %, Insert Delete Format Editi Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells A1 foc A B D E F - G . K 1 2 3 You have looked at the current financial statements for Reigle Homes, Co. The company has an EBIT of $2.95 million this year. Depreciation, the increase in net working capital, and capital spending were $235,000, $105,000, and $475,000, respectively. You expect that over the next five years, EBIT will grow at 15 percent per year, depreciation and capital spending will grow at 20 percent per year, and NWC will grow at 10 percent per year. The company has $19.5 million in debt and 400,000 shares outstanding. After Year 5, the adjusted cash flow from assets is expected to grow at 3.5 percent indefinitely. The company's WACC is 9.25 percent, and the tax rate is 22 percent. What is the price per share of the company's stock? A B D E F G H - J 4 5 6 7 $ $ $ 2,950,000 235,000 105,000 475,000 8 9 10 11 12 EBIT Depreciation Change in NWC Capital spending Increase per year EBIT Depreciation Change in NWC Capital spending Value of debt Shares outstanding Terminal growth rate WACC Tax rate 13 14 15 $ 15% 20% 10% 20% 19,500,000 400,000 3.50% 9.25% 22% 16 17 18 19 20 21 Complete the following analysis. Do not hard code values in your calculations. Year 1 Year 2 Year 3 Year 4 Year 5 EBIT Depreciation Taxes* Capital spending Change in NWC ACFA Year 6 ACFA Terminal value Company value Value of equity Price per share