You need to help EIS decide whether to go ahead with the Pathrite system or not. Provide all relevant information and analysis,including a computation of the net present value and internal rate of return of the Pathrite system project. This case is about capital budgeting. However, some of the issues that you will need to grapple with are raised in the modules covering Stock Valuation and Capital Markets. Keep in mind that there is a lot of information in the case: regarding each piece of information, ask yourself whether it's relevant or not and if relevant, how. Keep in mind also that cost of capital is a conceptual quantity that can be measured using several pieces of information. Capital Budgeting is not a mechanistic exercise, not in the forecasting of cashflows and not in the estimation of cost of capital. Note that you should use the weighted average cost of capital formula to compute the cost of capital, viz. WACC = (proportion of equity in the firm's liability structure)(cost of equity capital) + (proportion of debt in the firm's liability structure)(cost of debt capital)(1-marginal tax rate). The write-up should be in Word (with an accompanying Excel spreadsheet showing the computations)
You first need to come up with the basic incremental cashflows. That involves simply computing the after-tax earnings year-by-year and adding back depreciation.
The treatment of inflation has to be consistent with the discount rate used. You can treat all the cashflows as nominal cashflows, incorporating inflation and then you don’t have to do anything about the inflation rate given. However, the constant assumed savings makes that unlikely. So if the savings are treated as savings, unadjusted for inflation, the right thing to do is to inflate the savings at the rate of inflation. However, it is important to keep in mind that tax savings do not increase at the rate of inflation. Also, the discount rate for nominal cashflows has to be a nominal rate, not an inflation-adjusted real rate.
The depreciation used in my attached Excel spreadsheet follows the half-year life convention, which says that EIS could start depreciating in year zero, as long as the purchase had occurred in year zero (but I am not necessarily looking for this much sophistication).
The key thing in the computation of the discount rate is the realization that there are many ways of computing the cost of equity and the cost of debt. For the cost of debt, the bond yield could be used or the yield on comparably rated bonds could be used. The 8% coupon rate is not the cost of debt unless the debt is sold at par, in which case it would be the yield, as well.
For the cost of equity, you can use the CAPM, but that is only one method. You could also use the Gordon growth model formula, which says that r = D/P + g (this will be discussed in more detail in Module 9). You could also look at the actual historical average return.
Finally, I expect you to think about sensitivity. Taking the expected cashflows is not recognizing the sensitivity of the realized NPV to the actual cashflows. Looking at the NPV separately under the different scenarios allows us to look at the probability of ending up with a negative realized NPV, which you don’t get by simply using the expected cashflows in your computation.
please refer the below screenshots of the pdf from Excelerite Integrated Systems, Inc. (EIS) and upload a screenshot of the word file ans excel sheet workings.
Hi, I am Chartered Accountant with 15 years of experience, in financial analysis, book keeping, accounting, budgeting I can complete this job to the best of your expectations Thanks