Change 2,200,000 to 1,800,000 (new machinery cost) and change 150,000 to 200,000 (salvage value). Change 40 to 50 (price) and 32 to 30 (costs). These revisions will change most of the numbers in Table 1.

Fill in Xs in Table 1. 427-30. Change in NWC (net working capital) = inventories. Price + freight + installation + change in NWC = net investment outlay = project NCF (net cash flow) at year 0. Salvage value X tax rate = SV (salvage value) tax in year 4. Salvage value – SV tax + recovery of NWC = termination CF (cash flow). Net op (operating) cash flow + termination CF = project NCF.

Press CE/C to clear 1 number on screen of Texas Instrument Ba II Plus Financial calculator. If you ever need to clear CFs (cash flows), etc. in your calculator, press 2^nd (to get yellow above key functions) +I- (1 key) (reset) ENTER (set) 2^nd CPT (quit).

Fill in Xs. 393-8, 409-10, 427-30. Payback period of S = about 2 years, L = about 3 years. Omit MIRR.

Depreciable basis = price + freight + installation. In year 1, 2,000,000 X 33% (or 0.33) MACRS factor = 660,000 (depreciation expense). 2,000,000 – 660,000 = 1,340,000 end-of-year book value.

Table 1

MACRS Depr. End-of-year

Year Factor Expense Book Value

1 33% $660,000 $1,340,000

2 X X X

3 X X X

4 7 140,000 0

100% 2,000,000

See years 1 and 4 as examples in Table 1. In year 1, 50 X 100,000 = 5,000,000 – 3,000,000 (100,000 X 30) – 660,000 - 20,000 = 1,320,000 – 528,000 = 792,000 + 660,000 = 1,452,000 = project NCF

Cash Flow Statements:

Year 0 Year 1 Year 2 Year 3 Year 4

Unit price $ 50 X X $ 50

Unit sales 100,000 X X 100,000

Revenues 5,000,000 X X 5,000,000

Operating costs 3,000,000 X X 3,000,000

Depreciation 660,000 X X 140,000

Other project effects 20,000 X X 20,000

Before tax income 1,320,000 X X 1,840,000

Taxes 528,000 X X 736,000

Net income 792,000 X X 1,104,000

Plus depreciation 660,000 X X 140,000

Net op cash flow 1,452,000 X X 1,244,000

Salvage value 200,000

SV tax X

Recovery of NWC X

Termination CF X

Project NCF ($-2,100,000) X X X X

========= = = = =
 
 

Transcribed Image Text:

Robert Montoya's management expects to sell 100,000 bottles of the new wine in each of the next 4 years, at a wholesale price of $40 per bottle, but $32 per bottle would be needed toya's sales manager which expressed concern that the wine project would cut into the firm's sales cash operating costs. In examining the sales figures, Sharpe noted a short memo from Robert M of other wines-this type of effect is called cannibalization. Specifically, the sales manager esti- then talked to both the sales and production managers and concluded that the new project would mated that existing wine sales would fall by 5 percent if the new wine were introduced. Sharpe probably lower the firm's existing wine sales by $60,000 per year, but, at the same time, it would effect would be -$60,000+ $40,000-$20,000. Robert Montoya's federal-plus-state tax rate is 40 also reduce production costs by $40,000 per year, all on a pre-tax basis. Thus, the net externality percent, and its overall cost of capital is 10 percent, calculated as follows: WACC = Waka (1-T) + Wsk = 0.5(10%) (0.6) + 0.5(14%) = 10%. Now assume that you are Sharpe's assistant and she has asked you to analyze this project, along with two other projects, and then to present your findings in a "tutorial" manner to Robert Montoya's executive committee. As financial vice president, Sharpe wants to educate some of the other executives, especially the marketing and sales managers, in the theory of capital budgeting so that these executives will have a better understanding of capital budgeting decisions. Therefore, Sharpe wants you to ask and then answer a series of questions as set forth next. Keep in mind that you will be questioned closely during your presentation, so you should understand every step of the analysis, including any assumptions and weaknesses that may be lurking in the background and that someone might spring on you in the meeting. ile Specifics on the other two projects that must be analyzed are provided in Questions 9 and 10. Thanksgenosios glaspano Inter ishoda pnten om bet lato Hou QUESTIONS das tend llegad wind 1. Define the term "incremental cash flow." Since the project will be financed in part by debt, should the cash flow statement include interest expenses? Explain.melasng M toda . si qu fod od blader ste er nok estilou ROUNDING 2. Should the $300,000 that was spent to rehabilitate the plant be included in the analysis? Explain. Jarrow truyla rodol o apare di avant Drummuted tronulups so sds of 000.0518 19 ROM Enlil emais d 3. Suppose another winemaker had expressed an interest in leasing the wine production site for $30,000 a year. If this were true (in fact it was not), how would that information be incorpo- borated into the analysis? Jurongas sainionas sed vesnida gapo sill steizmigab ufhi wolledi 4. What is Robert Montoya's Year 0 net investment outlay on this project? What is the can expected nonoperating cash flow when the project is terminated at Year 4? (Hint: Use Table 1 as a guide.) blon 4 Hoida 5. Estimate the project's operating cash flows. (Hint: Again use Table 1 as a guide.) What are the project's NPV, IRR, modified IRR (MIRR), and payback? Should the project be under- du taken? [Remember: The MIRR is found in three steps: (1) compound all cash inflows for- ward to the terminal year at the cost of capital, (2) sum the compounded cash inflows to obtain the terminal value of the inflows, and (3) find the discount rate which forces the pre sent value of the terminal value to equal the present value of the net investment outlays. This discount rate is defined as the MIRR.] Robert Montoya's management expects to sell 100,000 bottles of the new wine in each of the next 4 years, at a wholesale price of $40 per bottle, but $32 per bottle would be needed toya's sales manager which expressed concern that the wine project would cut into the firm's sales cash operating costs. In examining the sales figures, Sharpe noted a short memo from Robert M of other wines-this type of effect is called cannibalization. Specifically, the sales manager esti- then talked to both the sales and production managers and concluded that the new project would mated that existing wine sales would fall by 5 percent if the new wine were introduced. Sharpe probably lower the firm's existing wine sales by $60,000 per year, but, at the same time, it would effect would be -$60,000+ $40,000-$20,000. Robert Montoya's federal-plus-state tax rate is 40 also reduce production costs by $40,000 per year, all on a pre-tax basis. Thus, the net externality percent, and its overall cost of capital is 10 percent, calculated as follows: WACC = Waka (1-T) + Wsk = 0.5(10%) (0.6) + 0.5(14%) = 10%. Now assume that you are Sharpe's assistant and she has asked you to analyze this project, along with two other projects, and then to present your findings in a "tutorial" manner to Robert Montoya's executive committee. As financial vice president, Sharpe wants to educate some of the other executives, especially the marketing and sales managers, in the theory of capital budgeting so that these executives will have a better understanding of capital budgeting decisions. Therefore, Sharpe wants you to ask and then answer a series of questions as set forth next. Keep in mind that you will be questioned closely during your presentation, so you should understand every step of the analysis, including any assumptions and weaknesses that may be lurking in the background and that someone might spring on you in the meeting. ile Specifics on the other two projects that must be analyzed are provided in Questions 9 and 10. Thanksgenosios glaspano Inter ishoda pnten om bet lato Hou QUESTIONS das tend llegad wind 1. Define the term "incremental cash flow." Since the project will be financed in part by debt, should the cash flow statement include interest expenses? Explain.melasng M toda . si qu fod od blader ste er nok estilou ROUNDING 2. Should the $300,000 that was spent to rehabilitate the plant be included in the analysis? Explain. Jarrow truyla rodol o apare di avant Drummuted tronulups so sds of 000.0518 19 ROM Enlil emais d 3. Suppose another winemaker had expressed an interest in leasing the wine production site for $30,000 a year. If this were true (in fact it was not), how would that information be incorpo- borated into the analysis? Jurongas sainionas sed vesnida gapo sill steizmigab ufhi wolledi 4. What is Robert Montoya's Year 0 net investment outlay on this project? What is the can expected nonoperating cash flow when the project is terminated at Year 4? (Hint: Use Table 1 as a guide.) blon 4 Hoida 5. Estimate the project's operating cash flows. (Hint: Again use Table 1 as a guide.) What are the project's NPV, IRR, modified IRR (MIRR), and payback? Should the project be under- du taken? [Remember: The MIRR is found in three steps: (1) compound all cash inflows for- ward to the terminal year at the cost of capital, (2) sum the compounded cash inflows to obtain the terminal value of the inflows, and (3) find the discount rate which forces the pre sent value of the terminal value to equal the present value of the net investment outlays. This discount rate is defined as the MIRR.]

Answer rating: 100% (QA)

answer Lets address each of the questions Define the term incremental cash flow Since the project will be financed in part by debt should the cash flow statement include interest expenses Explain Incr... View the full answer