Excel spreadsheets must be built and multiple formulas used to calculate a company's WACC ... Equity as % of Total Capital (Equity>Weight) After Tax Cost of Debt (Debt>Cost) Cost of Equity ...

For tax purposes, businesses can deduct ... the sum of the years’ digits method in Excel with this function. Excel is capable of calculating any depreciation method, including the: Most assets ...

The Excel formula for calculating the discount rate is =RATE ... and expected after-tax cash flows. We’ve already defined the discount rate as a WACC that causes the IRR to equal zero.