Given the following information regarding cash flows and discount rates, answer the questions below.
| Year | 0 | 1 | 2 | 3 | 4 |
| Nominal Cash Flow | -15,000 | 5,000 | 7,500 | 3,500 | 1,000 |
| Inflation | 0% | 2% | 1.75% | 1.5% | 1.25% |
| Real Rate | 0% | 4% | 4.5% | 5% | 5.5% |
a) What are the nominal rates for each year?
b) What are the discount rates for each year?
c) What is the NPV of the project?
| N | Year | 0 | 1 | 2 | 3 | 4 | ||
| A | Nominal Cash Flow | -15,000 | 5,000 | 7,500 | 3,500 | 1,000 | ||
| B | Inflation | 0% | 2% | 1.75% | 1.50% | 1.25% | ||
| C | Real Rate | 0% | 4% | 4.50% | 5% | 5.50% | ||
| D=B+C | Nominal Rate | 0.00% | 6.08% | 6.33% | 6.58% | 6.82% | ||
| Calculation of Nominal Rate | ((1+0)*(1+0))-1 | (1.02*1.04)-1 | (1.0175*1.045)-1 | (1.015*1.05)-1 | (1.025*1.055)-1 | |||
| Discount Rate | 0.00% | 6.08% | 6.33% | 6.58% | 6.82% | |||
| Present Value of Year 4 Cash Flow in year3 | 936 | (1000/1.0682) | ||||||
| Year 3 Cash Flow | 3,500 | |||||||
| Value of Cash Flow at end of Year3 | 4436 | (936+3500) | ||||||
| Present Value Cash Flow in year2 | 4162 | (4436/1.0658) | ||||||
| Year2 Cash Flow | 7500 | |||||||
| Value of Cash Flow at end of Year2 | 11662 | (4162+7500) | ||||||
| Present Value Cash Flow in year1 | 10968.002 | (11662/1.0633) | ||||||
| Year1 Cash Flow | 5,000 | |||||||
| Value of Cash Flow at end of Year1 | 15,968 | (10968+5000) | ||||||
| Present Value Cash Flow in year0 | 14951 | (15968/1.068) | ||||||
| Year0 Cash Flow | -15,000 | |||||||
| Net Present Value(NPV) | -49 | (14951-15000) | ||||||
Given the following information regarding cash flows and discount rates, answer the questions below. Year 0...
Given the following information regarding cash flows and discount rates, answer the questions below. Year 0 1 2 3 4 Nominal Cash Flow -11,000 4,000 5,000 6,000 1,000 Real Rate 0% 6% 5% 4% 5% Inflation Rate 0% 3.5% 3% 2.5% 2.5% a) What are the nominal rates for each year? b) What is the NPV of the project?
Please use Excel formulas
Question 4: Given the following information regarding cash flows and discount rates, answer the questions below. Year 2 3 4 Nominal Cash Flow 7,500.00 1,000.00 -15,000.00 5,000.00 3,500.00 Inflation 1.50% 1.75% 0.00% 2.00% 1.25% Real rate 5.00% 5.50% 0.00% 4.00% 4.50% What are the nominal rates for each year? (5) a) What are the discount rates for each year? (5) c) What is the NPV of the project? (5) b)
Corbin Co. forecasts the following nominal cash flows for a project: Year.......Cash Flows 0............-2,000 1............1,250 2............750 3...........500 The real rate of inflation is 7% and the inflation rate is 4%. Calculate the NPV for the project. Round to 2 decimals.
Restate the above net cash flow in real terms. Discount the
restated cash flows at a real discount rate. Assume a 20% nominal
rate and 10% expected inflation. NPV should be unchanged at +2,593,
or $2,593,000.
($ thousands) Period 1 - 14,100 -1,634 3.097 - 14,100 -1,362 2.151 2,593 (sum of PVS) Net cash flow Present value at 20% Net present value 3 6,473 3.746 4 10.684 5,152 5 10,135 4,073 6 5.907 1,978 7 3.419 954 Restate the above...
For the following set of cash flows, Year Cash Flow 0 –$7,500 1 3,500 2 6,200 3. 3,700 d. What is the NPV at a discount rate of 24 percent?
A project has the following cash flows: Year Cash Flows 0 -15,000 1 6,955 2 7,190 3 6,802 What is the NPV at a discount rate of zero percent?
39. A project has expected cash flows as shown below: Year 0 1-4 Net Cash Flow -25,000 5,000 4,000 8,000 7,000 If the firm's discount rate is 12 percent, what is the NPV of this project?
A project has expected cash flows as shown below: Year Net Cash Flow 0 -25,000 1-4 5,000 5-7 4,000 8 8,000 9 7,000 If the firm's discount rate is 12 percent, what is the NPV of this project?
4. Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0: $468,000 Cash flow year one: $135,000 Cash flow year two: $240,000 Cash flow year three: $185,000 Cash flow year four: $135,000 Plot the NPV profile of this project in Excel. Start with discount rate equal to zero and increase the discount rate by 2% increments until discount rate equal to 30%. For what discount rates would Lepton accept this project? For what discount rates...
For the following set of cash flows, Year Cash Flow 0 –$8,500 1 3,500 2 4,500 3 3,300 a. What is the NPV at a discount rate of 0 percent? b. What is the NPV at a discount rate of 8 percent? c. What is the NPV at a discount rate of 22 percent? d. What is the NPV at a discount rate of 27 percent?