1. Perform a sensitivity analysis on each of the key variables listed below, assuming they can...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Perform a sensitivity analysis on each of the key variables listed below, assuming they can each vary from their base-case or expected value by 10 percent. unit sales growth rate in unit sales sales price per unit variable cost per unit fixed costs growth rate in sales price per unit growth rate in variable cost per unit growth rate in fixed costs expected salvage value tax rate cost of capital (hurdle rate) working capital as percentage of total revenues Which variables appear to have the most impact on the net present value of the project? Column3 Equipment cost Economic life Salvage value Tax rate Cost of capital Units sold Sales growth rate Sales price per unit Sales price growth rate Variable cost per unit Variable cost growth rate Fixed costs Fixed cost growth rate Net working capital / Sales Annual operating cash flows Unit sales (rounded down) Unit price (rounded) Unit variable cost (rounded) Total revenues Less: Total variable costs Less: Total fixed costs Less: Depreciation Earnings before interest and taxes Less: Taxes @ 25.00% NOPAT Add back depreciation Net operating cash flows Depreciation expense Cash Flows for Net Working Capital Total revenues NWC 15% of total revenues CF due to investment in NWC Salvage Value Cash from salvage value Less: Book value Gain (loss) on asset disposal Tax on salvage value gain (loss) Net cash flow from salvage Projected Net Cash Flows Investment in capital assets Operating cash flows Cash flows for net working capital Salvage cash flows Net cash flows NPV = IRR = Column1 $1,000,000 5 $100,000 Uniform 25.00% 10.00% 20,000 Normal 3.00% Triangular $50 4.00% Normal $25 5.00% Traingular $200,000 2.00% Uniform 15.00% Year 0 $150,000 ($150,000) ($1,000,000) Column2 ($150.000) ($1,150,000) $173,344 15.03% Year 1 20,000 $50.00 $25.00 200.000 $100,000 25.000 $75,000 200.000 $275,000 20.00% Year 2 $200,000 20,600 $52.00 $26.25 $1,000,000 $1,071,200 $1,147,469 $1,229,069 500,000 540,750 584,768 200,000 204,000 208,080 320.000 $6,450 1.613 $4,838 320.000 $324,838 32.00% $320,000 Year 3 21,218 $54.08 $27.56 $1,000,000 $160,680 $172,120 ($10,680) ($11,440) 192.000 $162,621 40.655 $121,966 192.000 $313,966 Year 4 19.20% $192,000 21,854 $56.24 $28.94 632,455 212,242 115.200 $269,173 67.293 $201,879 115.200 $317,079 11.52% $115,200 Year 5 $275,000 $324,838 $313,966 $317,079 ($10.680) ($11.440) ($12.240) ($13,122) $264,320 $313,397 $301,726 $303,957 22,509 $58.49 $30.39 $1,316,551 684,049 216,486 115.200 $300,816 75.204 $225,612 115.200 $340,812 $1,071,200 $1,147,469 $1,229,069 $1,316,551 $197,483 $184,360 ($12,240) ($13,122) $197,483 11.52% $115,200 $100,000 57.600 $42,400 10.600 $89,400 $340,812 $197,483 $89.400 $627,695 $100,000 - $10,600 1. Perform a sensitivity analysis on each of the key variables listed below, assuming they can each vary from their base-case or expected value by 10 percent. unit sales growth rate in unit sales sales price per unit variable cost per unit fixed costs growth rate in sales price per unit growth rate in variable cost per unit growth rate in fixed costs expected salvage value tax rate cost of capital (hurdle rate) working capital as percentage of total revenues Which variables appear to have the most impact on the net present value of the project? Column3 Equipment cost Economic life Salvage value Tax rate Cost of capital Units sold Sales growth rate Sales price per unit Sales price growth rate Variable cost per unit Variable cost growth rate Fixed costs Fixed cost growth rate Net working capital / Sales Annual operating cash flows Unit sales (rounded down) Unit price (rounded) Unit variable cost (rounded) Total revenues Less: Total variable costs Less: Total fixed costs Less: Depreciation Earnings before interest and taxes Less: Taxes @ 25.00% NOPAT Add back depreciation Net operating cash flows Depreciation expense Cash Flows for Net Working Capital Total revenues NWC 15% of total revenues CF due to investment in NWC Salvage Value Cash from salvage value Less: Book value Gain (loss) on asset disposal Tax on salvage value gain (loss) Net cash flow from salvage Projected Net Cash Flows Investment in capital assets Operating cash flows Cash flows for net working capital Salvage cash flows Net cash flows NPV = IRR = Column1 $1,000,000 5 $100,000 Uniform 25.00% 10.00% 20,000 Normal 3.00% Triangular $50 4.00% Normal $25 5.00% Traingular $200,000 2.00% Uniform 15.00% Year 0 $150,000 ($150,000) ($1,000,000) Column2 ($150.000) ($1,150,000) $173,344 15.03% Year 1 20,000 $50.00 $25.00 200.000 $100,000 25.000 $75,000 200.000 $275,000 20.00% Year 2 $200,000 20,600 $52.00 $26.25 $1,000,000 $1,071,200 $1,147,469 $1,229,069 500,000 540,750 584,768 200,000 204,000 208,080 320.000 $6,450 1.613 $4,838 320.000 $324,838 32.00% $320,000 Year 3 21,218 $54.08 $27.56 $1,000,000 $160,680 $172,120 ($10,680) ($11,440) 192.000 $162,621 40.655 $121,966 192.000 $313,966 Year 4 19.20% $192,000 21,854 $56.24 $28.94 632,455 212,242 115.200 $269,173 67.293 $201,879 115.200 $317,079 11.52% $115,200 Year 5 $275,000 $324,838 $313,966 $317,079 ($10.680) ($11.440) ($12.240) ($13,122) $264,320 $313,397 $301,726 $303,957 22,509 $58.49 $30.39 $1,316,551 684,049 216,486 115.200 $300,816 75.204 $225,612 115.200 $340,812 $1,071,200 $1,147,469 $1,229,069 $1,316,551 $197,483 $184,360 ($12,240) ($13,122) $197,483 11.52% $115,200 $100,000 57.600 $42,400 10.600 $89,400 $340,812 $197,483 $89.400 $627,695 $100,000 - $10,600
Expert Answer:
Answer rating: 100% (QA)
Here are the key variables that appear to have the most impact on the NPV of the project based on 10 ... View the full answer
Related Book For
Essentials of Managerial Finance
ISBN: 978-0324422702
14th edition
Authors: Scott Besley, Eugene F. Brigham
Posted Date:
Students also viewed these finance questions
-
What was the cost of raw materials used in production? How much of the materials in ( 1 ) above consisted of indirect materials? How much of the factory labor cost is indirect labor? What was the...
-
Allied Food Products is considering expanding into the fruit juice business with a new fresh lemon juice product. Assume that you were recently hired as assistant to the director of capital budgeting...
-
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by Sidney Johnson, a recently graduated MBA. The production line...
-
Calculate the standard entropy change for the following reactions at 25C. Comment on the sign of r S. (a) 2 Al(s) + 3 Cl 2 (g) 2 AlCl 3 (s) (b) 2 CH 3 OH() + 3 O 2 (g) 2 CO 2 (g) + 4 H 2 O(g)
-
When a "dry-cell" flashlight battery with an internal resistance of 0.33 is connected to a 1.50- light bulb, the bulb shines dimly. However, when a lead-acid "wet-cell" battery with an internal...
-
Using the same data, plot and interpret error a line chart showing the mean neuroticism for students and lecturers.
-
Prepare journal entries to record the following merchandising transactions of Bask Company, which applies the peipetual inventory system. July 1 Purchased merchandise from Black Company for $6,000...
-
NPV versus IRR Consider the following two mutually exclusive projects: Sketch the NPV profiles for X and Y over a range of discount rates from zero to 25 percent. What is the crossover rate for these...
-
Solve for Zz. Submit your answer in terms of degrees. > A 93 2 B
-
The general ledger of Zips Storage at January 1, 2024, includes the following account balances: Accounts Debits Credits Cash $26,300 17,100 Accounts Receivable Prepaid Insurance Land 15,400 165,000...
-
Billingsly Products uses the conventional retail method to estimate its ending inventories. The following data has been summarized for the year 2024: Inventory, January 1 Purchases Net markups Net...
-
Assume that Smiths Auto Sales paid \($50,000\) for equipment with a 10-year life and zero expected residual value. After using the equipment for 4 years, the company determines that the asset will...
-
Define the term nexus. Does nexus require a physical presence? Does nexus mean the same thing for different types of taxes?
-
Which of the following are characteristics of fees? A. They are usually smaller in amount than taxes B. They are a voluntary payment C. They are made to a segregated fund D. They are for a specific...
-
Micron Precision purchased a computer for \($3,100\), debiting Computer equipment. During 2010 and 2011, Micron Precision recorded total depreciation of \($2,200\) on the computer. On January 1,...
-
Assume your client receives a nexus questionnaire from a state. What should you advise them to do? A. Do nothingthe state will eventually give up B. Ask the state how much they think your client owes...
-
. 4:25 PM Wed Dec 6 . . . @ 42% Pricing Exercise F...SIGNMENT copy Home Insert Draw Layout Review View References Table ... Arial 11 B I U aA v A =q v 2. Complete the "what-if" chart below...
-
The cost curve for the city water supply is C(Q) = 16 + 1/4 Q2, where Q is the amount of water supplied and C(Q) is the cost of providing Q acre-feet of water. (An acre-foot is the amount of water...
-
What impact does a compensating balance requirement have on the cost of borrowing from a bank if the firm generally holds little or no checking balances at the bank? What would the impact be if the...
-
Van Auken Lumbers 2009 income statement is shown here: Sales........................................................................ $36,000 Cost of goods...
-
How do financial intermediaries in the United States differ from their counterparts in other countries? Why are they different?
-
Farha Co. purchases a machine for $11,500, terms 2/10, n/60, FOB shipping point. The seller pre paid the $260 freight charges, adding the amount to the invoice and bringing its total to $11,760. The...
-
On April 1, 2004, Stones Backfioe Co. purchases a trencher for $250,000. The machine is expected to last five years and have a salvage value of $25,000. Compute depreciation expense for year 2005...
-
On January 1, KB Store had $450,000 of inventory at cost. In the first quarter of the year, it purchased $1,590,000 of merchandise, returned $23,100, and paid freight charges of $37,600 on purchased...
Study smarter with the SolutionInn App