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 $ million next year. Increases in depreciation, the increase in net workingcapital and capital spending are expected to be $ $ and $respectively All are expected to grow at percent per year for four years. The companycurrently has $ million in debt and shares outstanding. After Year the adjusted cash flow from assets is expected to grow at percent indefinitely. The companys WACC is percent and the tax rate is percent. What is the priceper share of the companys stock?Input Area:EBIT$Depreciation$Change in NWC$Capital spending$Increase per year EBIT Depreciation Change in NWC Capital spendingValue of debt$Shares outstanding Terminal growth rateWACCTax rateUse cells A to B from the given information to complete this question. You must use the builtin Excel function to answer this question.Output Area:Year Year Year Year Year EBITDepreciationTaxesCapital spendingChange in NWCACFAYear 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
