Question

In: Finance

Blooper’s analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic...

Blooper’s analysts have come up with the following revised estimates for its magnoosium mine:

Range

Pessimistic Optimistic
Initial investment + 50 % 25 %
Revenues 15 % + 25 %
Variable costs + 25 % 15 %
Fixed cost + 25 % 30 %
Working capital + 40 % 30 %
Solve for below info Project NPV
Pessimistic Expected Optimistic
Initial investment
Revenues
Variable costs
Fixed costs
Working capital
A. Inputs
Initial investment ($ thousands) 10,000
Salvage value ($ thousands) 2,000
Initial revenues ($ thousands) 15,000
Variable costs (% of revenues) 40.0%
Initial fixed costs ($ thousands) 4,000
Initial total expenses ($ thousands) 10,000
Inflation rate (%) 5.0%
Discount rate (%) 12.0%
Receivables (% of sales) 16.7%
Inventory (% of next year's costs) 15.0%
Tax rate (%) 35.0%
Year: 0 1 2 3 4 5 6
B. Fixed assets
Investments in fixed assets 10,000
Sales of fixed assets 1,300
Cash flow from fixed assets -10,000 1,300
C. Operating cash flow
Revenues 15,000 15,750 16,538 17,364 18,233
Variable expenses 6,000 6,300 6,615 6,946 7,293
Fixed expenses 4,000 4,200 4,410 4,631 4,862
Depreciation 2,000 2,000 2,000 2,000 2,000
Pretax profit 3,000 3,250 3,513 3,788 4,078
Tax 1,050 1,138 1,229 1,326 1,427
Profit after tax 1,950 2,113 2,283 2,462 2,650
Operating cash flow 3,950 4,113 4,283 4,462 4,650
D. Working capital
Working capital 1,500 4,075 4,279 4,493 4,717 3,039 0
Change in working capital 1,500 2,575 204 214 225 -1,679 -3,039
Cash flow from investment in working capital -1,500 -2,575 -204 -214 -225 1,679 3,039
0.408 0.408 0.408 0.408 0.250
E. Project valuation
Total project cash flow -11,500 1,375 3,909 4,069 4,238 6,329 4,339

Solutions

Expert Solution

Soln : For pessimistic view:

Year 0 1 2 3 4 5 6
B. Fixed assets
Investments in fixed assets 15,000
Sales of fixed assets 2,000
Cash flow from fixed assets -15,000 2,000
C. Operating cash flow
Revenues 12,750 13,388 14,057 14,760 15,498
Variable expenses 7,500 7,875 8,269 8,682 9,116
Fixed expenses 5,000 5,250 5,513 5,788 6,078
Depreciation 3,000 3,000 3,000 3,000 3,000
Pretax profit -2,750 -2,738 -2,724 -2,711 -2,696
Tax 0 0 0 0 0
Profit after tax -2,750 -2,738 -2,724 -2,711 -2,696
Operating cash flow 250 263 276 289 304
D. Working capital
Working capital 2,100 5,705 5,990 6,290 6,604 4,255 0
Change in working capital 2,100 3,605 285 300 314 -2,350 -4,255
Cash flow from investment in working capital -2,100 -3,605 -285 -300 -314 2,350 4,255
E. Project valuation
Total project cash flow -17,100 -3,355 -23 -24 -25 2,654 6,255
Discount factor 1 0.8929 0.7972 0.7118 0.6355 0.5674 0.5066
PV -17100 -2995.53 -18.13 -17.00 -15.93 1505.68 3168.775
NPV -15472.15

For estimated the table is given , we need to calculate the NPV with discounting @12%

Total project cash flow -11,500 1,375 3,909 4,069 4,238 6,329 4,339
Discount factor 1 0.89 0.80 0.71 0.64 0.57 0.51
PV -11500 1227.68 3116.23 2896.23 2693.33 3591.24 2198.27
NPV 4222.99

For Optimistic view:

Year 0 1 2 3 4 5 6
B. Fixed assets
Investments in fixed assets 7,500
Sales of fixed assets 1,300
Cash flow from fixed assets -7,500 1,300
C. Operating cash flow
Revenues 18,750 19,688 20,672 21,705 22,791
Variable expenses 5,100 5,355 5,623 5,904 6,199
Fixed expenses 2,800 2,940 3,087 3,241 3,403
Depreciation 1,500 1,500 1,500 1,500 1,500
Pretax profit 9,350 9,893 10,462 11,060 11,688
Tax 3,273 3,462 3,662 3,871 4,091
Profit after tax 6,078 6,430 6,800 7,189 7,597
Operating cash flow 7,578 7,930 8,300 8,689 9,097
D. Working capital
Working capital 1,050 2,853 2,995 3,145 3,302 2,127 0
Change in working capital 1,050 1,803 143 150 157 -1,175 -2,127
Cash flow from investment in working capital -1,050 -1,803 -143 -150 -157 1,175 2,127
E. Project valuation
Total project cash flow -8,550 5,775 7,788 8,151 8,532 10,272 4,127
Discount factor 1 0.8929 0.7972 0.7118 0.6355 0.5674 0.5066
PV -8550 5156.25 6208.14 5801.45 5422.18 5828.71 2091.02
NPV 21957.76

Related Solutions

Chapter 10.3 Blooper’s analysts have come up with the following revised estimates for its magnoosium mine:...
Chapter 10.3 Blooper’s analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment + 40 % – 15 % Revenues – 15 % + 20 % Variable costs + 25 % – 20 % Fixed cost + 40 % – 20 % Working capital + 45 % – 25 % Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as...
QUESTION 7    [18 MARKS) In the following table, optimistic, most likely and pessimistic time estimates have...
QUESTION 7    [18 MARKS) In the following table, optimistic, most likely and pessimistic time estimates have been given for each activity for a project. Task Immediate Predecessor(s) Time (days) Optimistic (a) Most Likely (m) Pessimistic (b) A None 5 7 12 B None 8 8 8 C A 2 6 10 D A,B 12 14 19 E C,D 6 6 12 F B,E 3 12 18 G F 6 8 10 Construct an activity on node network diagram for this...
Your firm is considering issuing​ one-year debt, and has come up with the following estimates of...
Your firm is considering issuing​ one-year debt, and has come up with the following estimates of the value of the interest tax shield and the probability of distress for different levels of​ debt: Debt Level​ (in $​ million) 0 40 50 60 70 80 90 PV​ (interest tax​ shield, $​ million) 0.00 0.76 0.95 1.14 1.33 1.52 1.71 Probability of Financial Distress 0% 0% 1% 2% 7% 16% 31% Suppose the firm has a beta of​ zero, so that the...
A corporation is assessing the risk of two capital budgeting proposals. The financial analysts have developed pessimistic, most likely
A corporation is assessing the risk of two capital budgeting proposals. The financial analysts have developed pessimistic, most likely, and optimistic estimates of the annual cash inflows which are given in the following table. The firm’s cost of capital is 10 percent. Project AInitial Investment$20,000Annual Cash Inflow; Outcome$5,000; Pessimistic10,000; Most likely15,000; Optimistic Project BInitial Investment$100,000Annual Cash Inflow; Outcome$20,000; Pessimistic40,000; Most likely100,000; Optimistic Questions:The expected net present value of project A if the outcomes are equally probable and the project has...
You have been asked to value Delta Corp and have come up with the following inputs:...
You have been asked to value Delta Corp and have come up with the following inputs: Delta 2019 Revenues $1,500 COGS (w/o Depreciation) as % of Revenue 50% Depreciation $40.00 Tax Rate 35.00% Capital Expenditure $60.00 Working Capital (as % of Revenue) 30.00% Beta during the high growth period 1.50 Expected Growth Rate in Revenues &EBIT during the high growth period 30.00% Expected Period of High Growth 3 years Growth rate After High-Growth Period 5.00% Beta After High-Growth Period 1.20...
Range Co. offers a postretirement benefit plan. Range estimates the following benefit payments for Reg Vick...
Range Co. offers a postretirement benefit plan. Range estimates the following benefit payments for Reg Vick after he retires on January 1, 2024: 2024 and 2025, $18,200 per year; 2026, $32,100; 2027 through 2029, $25,800 per year. Assume end- of-year payments. On December 31, 2016, Vick has completed 12 of his 16 years of eligibility. The discount rate is 5.15%. The plan is unfunded (no plan assets). Use the following present value factors for a lump sum payment of $1...
1 - A firm sells mid-range snowboards and estimates its demand curve to be Q =...
1 - A firm sells mid-range snowboards and estimates its demand curve to be Q = 15,700 – 17(P). Variable costs are $265. At what price does marginal revenue equal 0? Round your answer to the nearest dollar. 2 - A firm sells mid-range snowboards and estimates its demand curve to be Q = 12,700 – 32(P). Variable costs are $240. At what price does the firm's total contribution margin equal zero?
Cultural analysts have argued that privacy is less important to a generation that grew up with...
Cultural analysts have argued that privacy is less important to a generation that grew up with YouTube, Facebook, Twitter, and texting. On the other hand, this same generation has grown up with database technology more ubiquitous and capable than ever before. Think about how many times this week you've been involved (knowingly or not) with database systems. How do you think the tension between privacy and database technology will or should play out as powerful database applications become ever more...
Question 15 A firm sells mid-range snowboards and estimates its demand curve to be Q =...
Question 15 A firm sells mid-range snowboards and estimates its demand curve to be Q = 14,200 – 31(P). Variable costs are $268. At what price does the firm's total contribution margin equal zero? Question 16 The Pampered Pooch sells high-end pet furniture, specializing in small breed dogs. The most popular item is the memory foam dog bed, with the following demand curve: Q = 20,400 – 211(P). While expensive, the bed comes with a washable cover and free shipping....
Come up with five examples of firms that have used imitation as a way of reducing...
Come up with five examples of firms that have used imitation as a way of reducing the risk of entry. What aspects of risk was it meant to reduce? Was it successful? What aspects of the firm that were not generated by imitation made it unique, and were a potential source of advantage over competitors?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT