10-Capital Budgeting - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
10model 10/6/2009 8:15 12/2/2002 Chapter 10. Model for Capital Budgeting Tools In this file we use Excel to do most of the calculations explained in Chapter 10. First, we analyze Projects S and L, whose cash flows are shown immediately below in both tabular and time line formats. Spreadsheet analyses can be set up vertically, in a table with columns, or horizontally, using time lines. For short problems, with just a few years, we generally use the time line format because rows can be added and we can set the problem up as a series of income statements. For long problems, it is often more convenient to use a tabular layout. Expected after-tax Project S Year (t) Project S Project L 0 1 2 3 4 0 ($1,000) ($1,000) (1,000) 500 400 300 100 1 500 100 2 400 300 Project L 3 300 400 4 100 600 0 1 2 3 4 (1,000) 100 300 400 600 Capital Budgeting Decision Criteria Here are the five key methods used to evaluate projects: (1) payback period, (2) discounted payback period, (3) net present value, (4) internal rate of return, and (5) modified internal rate of return. Using these criteria, financial analysts seek to identify those projects that will lead to the maximization of the firm's stock price. PAYBACK PERIOD The payback period is defined as the expected number of years required to recover the investment, and it was the first formal method used to evaluate capital budgeting projects. First, we identify the year in which the cumulative cash inflows exceed the initial cash outflows. That is the payback year. Then we take the previous year and add to it the unrecovered balance at the end of that year divided by the following year's cash flow. Generally speaking, the shorter the payback period, the better the investment. Project S Time period: 0 1 2 3 4 Cash flow: (1,000) 500 400 300 100 Cumulative cash flow: (1,000) (500) (100) 200 300 0.00 0.00 0.00 1.00 0.00 Use Logical "AND" to determine 0.00 0.00 0.00 2.33 0.00 the first positive cumulative CF. Payback: 2.33 Use Logical IF to find the Payback. Use Statistical Max function to Alternative calculation: 2.33 Alternative: Use nested IF statements to display payback. find payback. Fx > Logical > IF > OK, statements. Project L Time period: 0 1 2 3 4 Cash flow: (1,000) 100 300 400 600 Cumulative cash flow: (1,000) (900) (600) (200) 400 Payback: 3.33 Uses IF statement. DISCOUNTED PAYBACK PERIOD Discounted payback period uses the project's cost of capital to discount the expected cash flows. The calculation of discounted payback period is identical to the calculation of the regular payback period, except you must base the calculation on a new row of discounted cash flows. Note that both projects have a cost of capital of 10%. WACC
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/31/2009 for the course MBA 4500 taught by Professor Eyupcetin during the Spring '09 term at Istanbul Technical University.

Page1 / 6

10-Capital Budgeting - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online