Question: Please give me all Excel formulas: Derry Corp. is expected to have an EBIT of $ 2 . 1 million next year. Increases in depreciation,

Please give me all Excel formulas: Derry Corp. is expected to have an EBITof $2.1 million next year. Increases in depreciation, the increase in net workingcapital, and capital spending are expected to be $165,000, $80,000, and $120,000,respectively. All are expected to grow at 18 percent per year for four years. The companycurrently has $10.4 million in debt and 750,000 shares outstanding. After Year5, the adjusted cash flow from assets is expected to grow at 3 percent indefinitely. The companys WACC is 8.5 percent and the tax rate is 21 percent. What is the priceper share of the companys stock?Input Area:EBIT$2,100,000Depreciation$165,000Change in NWC$80,000Capital spending$120,000Increase per year EBIT18% Depreciation18% Change in NWC18% Capital spending18%Value of debt$10,400,000Shares outstanding 750,000Terminal growth rate3%WACC8.50%Tax rate21%(Use cells A6 to B19 from the given information to complete this question. You must use the built-in Excel function to answer this question.)Output Area:Year 1Year 2Year 3Year 4Year 5EBITDepreciationTaxes*Capital spendingChange in NWCACFAYear 6 ACFATerminal valueCompany valueValue of equityPrice per share

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!