Question

McFann Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Year 1 Year 2 Year 3 Year 4 Unit sales 3,000 3,400 3,250 3,300 Sales price $17.33 $17.45 $18.24 $17.25 Variable cost per unit $8.88 $8.92 $9.03 $9.06 Fixed operating costs except depreciation $12,500 $13,000 $13,220 $13,250 Accelerated depreciation rate 33% 45% 15% 7% This project will require an investment of $10,000 in new Determine what the project's net present value (NPV) would be when using accelerated depreciation equipment. The equipment will have no salvage value at the end of the project's four-year life. McFann pays a O $20,559 O $23,643 O $24,671 constant tax rate of 40%, and it has a weighted average cost of capital (WACC) of 11%. Determine what the project's net present value (NPV) would be when using O $16,447 accelerated depreciation Now determine what the project's NPV would be when using straight-line depreciation Using the depreciation method will result in the highest NPV for the project. straight-line accelerated No other firm would take on this project if McFann turns it down. How much should McFann reduce the NPV of this project if it discovered that this project would reduce one of its division's net after-tax cash flows by $500 for each year of the four-year project? O $1,706 O $931 O $1,163 O $1,551 OOO O

Please answer all parts of the question!! Thanks!!

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

projects (Autosaved) (Autosaved) (Autosaved) - Microsoft Excel (Product Activation Failed) Page Layout File Home Insert Formulas Data Review View Add-Ins E AutoSum - Cut AC Wrap Text Calibri 11 General ECopy Fill Merge & Center Conditional Format Formatting as Table Styles Paste в IU* 0 00 Cell Insert Delete Format Sort & Find & % Format Painter Clear Filter Select Clipboard Styles Font Alignment Number Cells Editing fox AX401 Formula Bar ВС AU AV AW АХ AY AZ BА ВВ BD ВЕ 401 3000 3300 402 UNITS 3250 3400 403 17.45 ACCELERATED DEPRE SP 17.25 17.33 18.24 8.92 9.06 404 VC 8.88 9.03 405 YEAR 1 2 406 -10000 COST OF MACHINE 407 SALES 57585 62016 51750 56322.5 408 26640 29799 VARIABLE COST 28990 30804 13220 409 FIXED COST 12500 13000 13250 410 DEPRECIATION 3300 700 4500 1500 411 9310 9832.5 РВT 13066 17262 TAX @40% 5226.4 6904.8 412 3724 3933 5899.5 7839.6 10357.2 413 PAT 5586 414 DEPRECIATION 3300 4500 1500 700 9339.6 10399.5 11057.2 415 CFAT 8886 416 -10000 9339.6 417 TERMINAL CFAT 8886 10399.5 11057.2 PV FACTOR@11% 418 1 0.9009 0.8116 0.7312 0.6587 419 -10000 8005 8440 6829 7284 20559 420 NPV 421 HPR GMAM EAC МACRS NPV RELEVANT BETA LEVERED STEIN iD invest,EAA IRRnpvbeta REPLACEMENT S BOND RATION PBP ARR MI-np-ir REPLACEMENT OPTION TO WAIT Rea 120% erences: ED12 XУ W 08:16 TENG 23-11-2019

projects (Autosaved) (Autosaved) (Autosaved) - Microsoft Excel (Product Activation Failed) Page Layout File Home Insert Formulas Data Review View Add-Ins E AutoSum Cut Wrap Text Calibri 11 General Copy Fill Merge & Center Conditional Format Formatting as Table Styles Insert Delete Format Paste в IU* 000 Cell Sort & Find & % Format Painter Clear Filter Select Number Styles Clipboard Font Alignment Cells Editing fox AW440 AU AV AW AX AY AZ BА ВВ ВС BD ВЕ 421 422 423 3000 3250 UNITS 3300 3400 424 17.25 STRAIGHT LINE SP 17.33 17.45 18.24 425 9.03 VC 8.88 8.92 9.06 426 YEAR 0 1 2 3 4 427 -10000 COST OF MACHINE 428 57585 SALES 51750 56322.5 62016 29799 30804 429 VARIABLE COST 26640 28990 13220 13250 430 FIXED COST 12500 13000 431 2500 2500 2500 DEPRECIATION 2500 10110 12066 15462 432 РВT 11832.5 TAX @40% 4826.4 433 4044 4733 6184.8 7239.6 9277.2 434 PAT 6066 7099.5 435 DEPRECIATION 2500 2500 2500 2500 9599.5 9739.6 11777.2 436 CFAT 8566 437 -10000 9739.6 438 TERMINAL CFAT 8566 9599.5 11777.2 PV FACTOR @11% 0.8116 439 0.9009 0.7312 0.6587 440 -10000 7717 7791 7122 7758 20388 NPV 441 HPR GMAM EAC MACRS NPV RELEVANT STEIN iD IRRnpvbeta RATION PBP ARR invest, EAA MI-np-ir REPLACEMENT S BETA LEVERED REPLACEMENT BOND OPTION TO WAIT Rea 120% erences: ED12 XУ W 08:16 TENG 23-11-2019

projects (Autosaved) (Autosaved) (Autosaved) - Microsoft Excel (Product Activation Failed) Review File Home Insert Page Layout Formulas Data View Add-Ins Σ AutoSum - Cut AC EWrap Text Calibri 11 General E Copy Fill 1E Merge & Center Paste в IU* +.0 .00 Conditional Format Cell Insert Delete Format Sort & Find & % .00 0 Format Painter Clear Filter Select Formatting as Table Styles Styles Editing Clipboard Font Alignment Number Cells fox AX680 Formula Bar BА ВС AU AV AW AX AY AZ ВВ BD ВЕ 669 670 671 USING THE ACCELERATED DEPRECIATION METHOD WILL RESULT IN HIGHEST NPV 672 673 500 X PVIFA @11% 4 YEARS 674 REDUCTION IN NPV = 675 500 X 3.1024 676 1551 ANSWER 677 678 679 680 681 682 683 684 685 686 687 688 689 IRRnpvbeta NPV RELEVANT STEIN i invest, EAA MI-np-ir RATION PBP ARR REPLACEMENTS HPR GMAM EAC MACRS BETA LEVERED REPLACEMENT BOND OPTION TO WAIT E 120% II Rea erences: ED12 WA 08:17 TENG 23-11-2019