Question

In: Finance

4) 25% A) Using the following information, Compute NPV if we proceed TODAY as if there...

4) 25% A) Using the following information, Compute NPV if we proceed TODAY as if there is no option
B) Using the real option methodology of ch. 26, should Bert wait a year if they will "know" which cash flow will occur? Compute NPV of waiting! Use WACC to discount ALL cash flows!! Should we "wait" or proceed "now"??
Bert is considering purchase = $       18,000 20 = Years project will go on
Net Cash Flows = $         2,950 11% = WACC
If wait one year --
Purchase price = $       17,000
high cash flow = $         3,750
Chance of high cash flow = 60%
Low cash flow = $         1,700

Solutions

Expert Solution

1- no option
WACC 11%
Project life 20
PV -18000
PMT 2950
NPV (using Excel function) =PV(11%,20,-2950,0,0)-18000
$5,491.82
NPV using cash flows-
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Cash flows $(18,000.00) $    2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00 $ 2,950.00
PV $(18,000.00) $    2,657.66 $ 2,394.29 $ 2,157.01 $ 1,943.26 $ 1,750.68 $ 1,577.19 $ 1,420.89 $ 1,280.08 $ 1,153.23 $ 1,038.94 $    935.99 $    843.23 $    759.67 $    684.38 $    616.56 $    555.46 $    500.42 $    450.83 $    406.15 $    365.90
NPV $    5,491.82
2- evaluating option
High cash flow
NPV (using Excel function) =(PV(11%,19,-3750,0,0)-17000)/(1+11%)^1
$11,168.79
Low cash flow
NPV (using Excel function) =(PV(11%,19,-1700,0,0)-17000)/(1+11%)^1
-$3,309.19
NPV using cash flows (high)-
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Cash flows $                -   $(17,000.00) $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 3,750.00
PV $                -   $(15,315.32) $ 3,043.58 $ 2,741.97 $ 2,470.24 $ 2,225.44 $ 2,004.90 $ 1,806.22 $ 1,627.22 $ 1,465.97 $ 1,320.69 $ 1,189.81 $ 1,071.90 $    965.68 $    869.98 $    783.77 $    706.10 $    636.12 $    573.08 $    516.29 $    465.13
NPV $ 11,168.79
NPV using cash flows (low)-
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Cash flows $                -   $(17,000.00) $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00 $ 1,700.00
PV $                -   $(15,315.32) $ 1,379.76 $ 1,243.03 $ 1,119.84 $ 1,008.87 $    908.89 $    818.82 $    737.68 $    664.57 $    598.71 $    539.38 $    485.93 $    437.77 $    394.39 $    355.31 $    320.10 $    288.38 $    259.80 $    234.05 $    210.86
NPV $   (3,309.19)
Chances of high cash flow 60%
Chances of low cash flow 40%
Probability weighted cash flow
=60%*11168.79+40%*-3309.19        5,377.60
NPV of waiting          (114.22)

As we can see, the probable cash flows from waiting are lower than those from starting today. Hence, it is advisabel to invest today and not take the option.


Related Solutions

1. Compute the NPV of a project with the following information. The IRR is 9%. The...
1. Compute the NPV of a project with the following information. The IRR is 9%. The project life is 3 years. The initial cost is $19,000. In years 1 and 2 the cash inflows are $4,500 and $5,500, respectively. Cash flow in year 3 is missing. WACC is 12%.
Given the following information, estimate the cash flows of this project and then compute the NPV...
Given the following information, estimate the cash flows of this project and then compute the NPV of this project. Estimated Sales: 50,000 units per year for each of the next 3 years Estimate Sale Price: $1,050 per unit Variable Cost: $1,000 per unit Fixed Costs: $1,500,000 per year Initial Investment in Plant and Machinery: $1,500,000 to be depreciated to a salvage value of $0 over the next three years. We sell the machine at $45000 in the market at the...
What is the payback period, NPV, IRR of A. Using this information, should we accept Project...
What is the payback period, NPV, IRR of A. Using this information, should we accept Project A. Why or why not. Given the following information answer the question above. The discount rate is 10 percent.      PROJECT A       t           Cash Flow       0          (150,000)        1          40,000           2          40,000              3          40,000          4           40,000           5            40,000               ROUND TO NEAREST DOLLAR OR TEN %
Problem 13-4 NPV with Non-normal Cash Flows (LG13-3) Compute the NPV for Project K if the...
Problem 13-4 NPV with Non-normal Cash Flows (LG13-3) Compute the NPV for Project K if the appropriate cost of capital is 7 percent. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to 2 decimal places.) Project K Time: 0 1 2 3 4 5 Cash flow: –$11,900 $5,950 $6,950 $6,950 $5,950 –$14,900
a. Compute the future value at the end of 4 years of $900 invested today at...
a. Compute the future value at the end of 4 years of $900 invested today at an interest rate of 6 per cent and describe two business uses for this specific type of computation. b. Compute the future value at the end of 4 years of $900 put away in a savings account each of four years at an interest rate of 6 per cent and describe two business uses for this specific type of computation. c. Explain the time...
Based on the following information for project X, should we undertake the venture? (Use NPV technique)....
Based on the following information for project X, should we undertake the venture? (Use NPV technique). Project X involves a new type of design. We think we can sell 6,000 units per year at a price of 1 € each. Variable costs will run about 0.4 € per unit, and the product should have a four-year life. Fixed costs for the project will run 450 € per year. Further, we will need to invest a total of 4000 € in...
4/ Using the following accounts and an overhead rate of 150% of direct labor cost, compute...
4/ Using the following accounts and an overhead rate of 150% of direct labor cost, compute the amount of applied overhead. Work in Process Inventory Beginning WIP 35,300 Direct materials 55,500 Direct labor ? Factory Overhead ? To Finished Goods 213,300 Ending WIP 25,300 Finished Goods Inventory Beginning FG 5,300 Cost of Goods Mfg'd 213,300 Multiple Choice $90,800. $83,250. $147,800. $59,120. $88,680. 5/ The B&T Company's production costs for May are: direct labor, $19,000; indirect labor, $7,100; direct materials, $15,600;...
Using the financial information in the following tables, compute the required ratios for AJ Ltd ABC...
Using the financial information in the following tables, compute the required ratios for AJ Ltd ABC COMPANY BALANCE SHEET AS OF DECEMBER 31, 2018 ASSETS 2018 2017 2016 Current assets     Cash $501,992 $434,215 $375,141     Accounts receivable 335,272 302,514 241,764     Inventory 515,174 505,321 310,885     Prepaid expenses 251,874 231,100 136,388     Total current assets $1,604,312 $1,473,150 $1,064,178 Property, plant, and equipment 765,215 735,531 705,132 Accumulated depreciation -218,284 -196,842 -175,400 TOTAL ASSETS $2,151,243 $2,011,839 $1,593,910 LIABILITIES Current liabilities     Accounts payable $248,494 $366,864 $322,156     Accrued...
Using the following information, please compute the investment performance and end of period asset value for...
Using the following information, please compute the investment performance and end of period asset value for the following “realistic” scenario. A $100,000 investment in a 15 year, AA-rated corporate bond with a 5 percent coupon. Please calculate the annual interest income that you would receive each year, along with the value that you will receive when your bond matures. The 15-year average return for the S&P 500 from January 1973 to December 2016 (29 separate 15 year periods) was as...
Using the following information for RZX Corp. and the general economy, compute the weighted average cost...
Using the following information for RZX Corp. and the general economy, compute the weighted average cost of capital for RZX Corp: – The YTM on 20-year U.S. Treasury bonds is 3.5%. The market risk premium is 5.5%. – RZX has 6.75% coupon bonds that were issued five years ago, mature in 20 years, make semiannual interest payments, and currently sell for $1,036.60. – The current price of the firm’s 6.80%, $100.00 par value, quarterly dividend, perpetual preferred stock is $104.50....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT