tailieunhanh - Ebook Excel modeling in corporate finance (5/E): Part 2

Part 2 book “Excel modeling in corporate finance” has contents: Cost-Reducing project, break-even analysis, corporate financial planning, life-cycle financial planning, international parity, binomial option pricing, real options, debt and equity valuation, useful excel tricks, and other contents. | 108 PART 4 Capital Budgeting PART 4 CAPITAL BUDGETING Chapter 14 Project NPV Basics Problem. Suppose a firm is considering the following project, where all of the dollar figures are in thousands of dollars. In year 0, the project requires an $11,350 investment in plant and equipment, is depreciated using the straight-line method over seven years, and has a salvage value of $1,400 in year 7. The project is forecast to generate sales of 2,000 units in year 1, rising to 7,400 units in year 5, declining to 1,800 units in year 7, and dropping to zero in year 8. The inflation rate is forecast to be in year 1, rising to in year 5, and then leveling off. The real cost of capital is forecast to be in year 1, rising to in year 7. The tax rate is forecast to be a constant . Sales revenue per unit is forecast to be $ in year 1 and then grow with inflation. Variable cost per unit is forecast to be $ in year 1 and then grow with inflation. Cash fixed costs are forecast to be $5,280 in year 1 and then grow with inflation. What is the project’s NPV? Solution Strategy. Forecast key assumptions, discounting, sales revenue per unit, variable costs per unit, and fixed costs over the seven year horizon. Then, forecast the project income and expense items. Calculate the net cash flows. Discount each cash flow back to the present and sum to get the NPV. Modeling Issue. The inflation rate is forecast separately and explicitly enters into the calculation of: (1) the discount rate (= cost of capital) and (2) price or cost / unit items. This guarantees that we are consistent in the way we are treating the inflation component of cash flows in the numerator of the NPV calculation and the inflation component of the discount rate in the denominator of the NPV calculation. This avoids a common error in practice: people often treat cash flows and discount rates as if they were unrelated to each other and thus they are inconsistent in .