4.1 Constant Discount Rate

К оглавлению1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 
85 86 87 88 89 90 91 92 93 94 95 96 97 

Problem. A project requires a current investment of $100.00 and yields future expected cash flows of

$21.00, $34.00, $40.00, $33.00, and $17.00 in periods 1 through 5, respectively. All figures are in

thousands of dollars. The inflation rate is 3.0%. For these expected cash flows, the appropriate Real

Discount Rate is 5.0%. What is the net present value of this project?

Solution Strategy. We begin by calculating the (nominal) discount rate from the inflation rate and the

real discount rate. The rest of the net present value calculation is the same as the Net Present Value -

Constant Discount Rate spreadsheet.

FIGURE 4.1 Spreadsheet for Real and Inflation - Constant Discount Rate.

How To Build Your Own Spreadsheet Model.

1. Start with the Net Present Value - Constant Discount Rate Spreadsheet, Insert Rows, And

Move One Item. Open the spreadsheet that you created for Net Present Value - Constant

Discount Rate and immediately save the spreadsheet under a new name using the File | Save As

command. Select the cell A5 and click on Insert | Rows. Select the range A11:A13 and click on

Insert | Rows. Select the range A6:B6, click on Edit | Cut, select the cell A12, and click on Edit

| Paste.

2. Inputs. Enter the inputs in the range B5:B6.

3. Discount Rate. The formula for the (Nominal) Discount Rate = (1 + Inflation Rate) * (1 + Real

Discount Rate) - 1. Enter =(1+B5)*(1+B6)-1 in cell B12.

The Net Present Value of this project is $15.72.

Problem. A project requires a current investment of $100.00 and yields future expected cash flows of

$21.00, $34.00, $40.00, $33.00, and $17.00 in periods 1 through 5, respectively. All figures are in

thousands of dollars. The inflation rate is 3.0%. For these expected cash flows, the appropriate Real

Discount Rate is 5.0%. What is the net present value of this project?

Solution Strategy. We begin by calculating the (nominal) discount rate from the inflation rate and the

real discount rate. The rest of the net present value calculation is the same as the Net Present Value -

Constant Discount Rate spreadsheet.

FIGURE 4.1 Spreadsheet for Real and Inflation - Constant Discount Rate.

How To Build Your Own Spreadsheet Model.

1. Start with the Net Present Value - Constant Discount Rate Spreadsheet, Insert Rows, And

Move One Item. Open the spreadsheet that you created for Net Present Value - Constant

Discount Rate and immediately save the spreadsheet under a new name using the File | Save As

command. Select the cell A5 and click on Insert | Rows. Select the range A11:A13 and click on

Insert | Rows. Select the range A6:B6, click on Edit | Cut, select the cell A12, and click on Edit

| Paste.

2. Inputs. Enter the inputs in the range B5:B6.

3. Discount Rate. The formula for the (Nominal) Discount Rate = (1 + Inflation Rate) * (1 + Real

Discount Rate) - 1. Enter =(1+B5)*(1+B6)-1 in cell B12.

The Net Present Value of this project is $15.72.