Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with question 3. I attached the tables also. If my numbers are incorrect please help. Thank You!!! 34 3. Calculate the new
Please help me with question 3. I attached the tables also. If my numbers are incorrect please help. Thank You!!!
34 3. Calculate the new NPV and IRR. Should the Project be accepted? | 35 Instructions Cost of Capital Capital Budgeting O Type here to search et e L BE ele CD Table 1 MACRS Depreciation $350 Year 7 Year class Depreciation 1 14.29% $50.02 2 24.49% $85.72 3 17.49% $61.22 12.49% $43.72 8.93% $31.26 8.92% $31.22 8.93% $31.26 4.46% $15.61 Table 2 (Ctrl) - B Cash from Cash outflow, Revenue in expenses in Depreciation in 5 Year $Millions $Millions $Millions Instructions Cost of Capital Capital Budgeting 00 VOU AWN Taxable income Tax in $Millions in $ Millions 27.5% rate After tax Cash Flow In $Millions NPV e - L o e O Cow Type here to search S. 2 4 $50.02 $85.72 $61.22 $43.72 $31.26 $31.22 $31.26 $15.61 9 $1,800 $1,900 $2,000 $2,100 $2,200 $2,300 $2,400 $2,500 $2,600 $2,700 $2,600 $2,500 $2,400 $2,200 $2,000 $1,800 $1,500 Cost of Capital $1,728 $1,824 $1,920 $2,016 $2,112 $2,208 $2,304 $2,400 $2,496 $2,592 $2,496 $2,400 $2,304 $2,112 $1,920 $1,728 $1,440 Capital Budgeting $21.99 $9.72 $18.79 $40.29 $56.75 $60.78 $64.75 $84.39 $104.00 $108.00 $104.00 $100.00 $96.00 $88.00 $80.00 $72.00 $60.00 $6.05 -$2.67 $5.17 $11.08 $15.60 $16.71 $17.80 $23.21 $28.60 $29.70 $28.60 $27.50 $26.40 $24.20 $22.00 $19.80 $16.50 $65.95 $78.67 $74.83 $72.92 $72.40 $75.29 $78.20 $76.79 $75.40 $78.30 $75.40 $72.50 $69.60 $63.80 $58.00 $52.20 $43.50 $2.31 $2.76 $2.63 $2.56 $2.54 $2.64 $2.74 $2.69 $2.65 $2.75 $2.65 $2.54 $2.44 $2.24 $2.04 $1.83 $1.53 1 10 11 12 13 6 (Ctrl- 15 16 17 Instructions W E e Le x O 89% Type here to search M 18 $1,200 $1,152 $48.00 $13.20 $34.80 $1.22 19 $800 $768 $32.00 $8.80 $23.20 $0.81 20 $400 $384 $16.00 $4.40 $27.60 $0.97 Table 3 NPV= $44.54 Tax in Millions Cash from Cash outflow, 27.5% rate in Revenue in expenses in Depreciation in Taxable income years 1, 2, 3 and After tax Cash Flow In 8 Year $Millions $Millions $Millions in $ Millions 50% there after Millions INPV $1,800 $1,762.56 $50.02 -$12.57 -$3.46 $40.90 $27.27 2 $1,860.48 $85.72 -$46.20 -$12.70 $52.22 $34.82 3 $2,000 $1,958.40 $61.22 -$19.62 -$5.40 $47.00 $31.33 $2,100 $2,056.32 $43.72 -$0.04 -$0.02 $43.70 $29.13 Blooms $2,200 $2,154.24 $31.26 $14.50 $7.25 $38.51 $25.67 $2,300 $2,252.16 $31.22 $16.62 $8.31 $39.53 $26.35 7 $2,350.08 $2,400 $31.26 $18.67 $9.33 $40.59 $27.06 $2,448.00 $15.61 $2,500 $36.39 $18.20 $33.80 $22.53 Instructions Cost of Capital Capital Budgeting 0 $1,900 4 89%) . Type here to search M N $0.00 $0.00 $0.00 U 12 - $2,600 $2,700 $2,600 $2,500 $2,400 $2,200 $2,000 $1,800 $1,500 $1,200 N $2,545.92 $2,643.84 $2,545.92 $2,448.00 $2,350.08 $2,154.24 $1,958.40 $1,762.56 $1,468.80 $1,175.04 $783.36 $391.68 $54.08 $56.16 $54.08 $52.00 $49.92 $45.76 $41.60 $37.44 $31.20 $24.96 $16.64 $8.32 $27.04 $28.08 $27.04 $26.00 $24.96 $22.88 $20.80 $18.72 $15.60 $12.48 $8.32 $4.16 S $27.04 $18.03 $28.08 $18.72 $27.04 $18.03 $26.00 $17.33 $24.96 $16.64 $22.88 $15.25 $20.80 $13.87 $18.72 $12.48 $15.60 $10.40 $12.48 $8.32 $8.32 $5.55 $4.16 $2.77 NPV= $381.55 w 15 16 17 $800 $400 D (Ctri) 89 8 Instructions Cost of Capital Capital Budgeting 899 Type here to search 63 Year 64 65 Depreciation in Taxable income Revenue Expenses SMillions in $ Millions Taxes $1,800 $1,835.25 $50.02 -$85.27 $1,900 $1,937.21 $85.72 -$122.93 3 $2,000 $2,039.17 $61.22 -$100.39 $2,100 $2,141.13 $43.72 -$84.85 $2,200 $2,243.08 $31.26 -$74.34 $2,300 $2,345.04 $31.22 -$76.26 $2,400 $2,447.00 $31.26 -$78.26 $2,500 $2,548.96 $15.61 -$64.57 $2,600 $2,650.92 -$50.92 $2,700 $2,752.88 -$52.88 $2,600 $2,650.92 -$50.92 $2,500 $2,548.96 -$48.96 $2,400 $2,447.00 -$47.00 $2,200 $2,243.08 -$43.08 Instructions Cost of Capital Capital Budgeting B00U After tax Cash Flow In $Millions NPV -$42.64 $7.38 $4.92 -$61.46 $24.26 $16.17 -$50.19 $11.03 $7.35 -$42.42 $86.14 $57.43 -$37.17 -$5.91 ($3.94) -$38.13 -$6.91 ($4.61) -$39.13 -$7.87 ($5.25) -$32.29 -$16.68 ($11.12) -$25.46 -$25.46 ($16.97) - $26.44 -$26.44 ($17.63) -$25.46 -$25.46 ($16.97) -$24.48 -$24.48 ($16.32) -$23.50 -$23.50 ($15.67) -$21.54 -$21.54 ($14.36) Bicol O Type here to search M $2,000 $1,800 $1,500 $1,200 $800 $400 N $2,039.17 $1,835.25 $1,529.38 $1,223.50 $815.67 $407.83 -$39.17 -$35.25 -$29.38 -$23.50 -$15.67 -$7.83 -$19.58 -$17.63 $14.69 -$11.75 $7.83 -$3.92 ST -$19.58 ($13.06) -$17.63 ($11.75) -$14.69 ($9.79) $11.75 ($7.83) -$7.83 ($5.22) -$3.92 ($2.61) NPV= ($87.23) IRR= 9% in mmm (Ctrl) - Instructions Cost of Capital Capital Budgeting Type here to search 34 3. Calculate the new NPV and IRR. Should the Project be accepted? | 35 Instructions Cost of Capital Capital Budgeting O Type here to search et e L BE ele CD Table 1 MACRS Depreciation $350 Year 7 Year class Depreciation 1 14.29% $50.02 2 24.49% $85.72 3 17.49% $61.22 12.49% $43.72 8.93% $31.26 8.92% $31.22 8.93% $31.26 4.46% $15.61 Table 2 (Ctrl) - B Cash from Cash outflow, Revenue in expenses in Depreciation in 5 Year $Millions $Millions $Millions Instructions Cost of Capital Capital Budgeting 00 VOU AWN Taxable income Tax in $Millions in $ Millions 27.5% rate After tax Cash Flow In $Millions NPV e - L o e O Cow Type here to search S. 2 4 $50.02 $85.72 $61.22 $43.72 $31.26 $31.22 $31.26 $15.61 9 $1,800 $1,900 $2,000 $2,100 $2,200 $2,300 $2,400 $2,500 $2,600 $2,700 $2,600 $2,500 $2,400 $2,200 $2,000 $1,800 $1,500 Cost of Capital $1,728 $1,824 $1,920 $2,016 $2,112 $2,208 $2,304 $2,400 $2,496 $2,592 $2,496 $2,400 $2,304 $2,112 $1,920 $1,728 $1,440 Capital Budgeting $21.99 $9.72 $18.79 $40.29 $56.75 $60.78 $64.75 $84.39 $104.00 $108.00 $104.00 $100.00 $96.00 $88.00 $80.00 $72.00 $60.00 $6.05 -$2.67 $5.17 $11.08 $15.60 $16.71 $17.80 $23.21 $28.60 $29.70 $28.60 $27.50 $26.40 $24.20 $22.00 $19.80 $16.50 $65.95 $78.67 $74.83 $72.92 $72.40 $75.29 $78.20 $76.79 $75.40 $78.30 $75.40 $72.50 $69.60 $63.80 $58.00 $52.20 $43.50 $2.31 $2.76 $2.63 $2.56 $2.54 $2.64 $2.74 $2.69 $2.65 $2.75 $2.65 $2.54 $2.44 $2.24 $2.04 $1.83 $1.53 1 10 11 12 13 6 (Ctrl- 15 16 17 Instructions W E e Le x O 89% Type here to search M 18 $1,200 $1,152 $48.00 $13.20 $34.80 $1.22 19 $800 $768 $32.00 $8.80 $23.20 $0.81 20 $400 $384 $16.00 $4.40 $27.60 $0.97 Table 3 NPV= $44.54 Tax in Millions Cash from Cash outflow, 27.5% rate in Revenue in expenses in Depreciation in Taxable income years 1, 2, 3 and After tax Cash Flow In 8 Year $Millions $Millions $Millions in $ Millions 50% there after Millions INPV $1,800 $1,762.56 $50.02 -$12.57 -$3.46 $40.90 $27.27 2 $1,860.48 $85.72 -$46.20 -$12.70 $52.22 $34.82 3 $2,000 $1,958.40 $61.22 -$19.62 -$5.40 $47.00 $31.33 $2,100 $2,056.32 $43.72 -$0.04 -$0.02 $43.70 $29.13 Blooms $2,200 $2,154.24 $31.26 $14.50 $7.25 $38.51 $25.67 $2,300 $2,252.16 $31.22 $16.62 $8.31 $39.53 $26.35 7 $2,350.08 $2,400 $31.26 $18.67 $9.33 $40.59 $27.06 $2,448.00 $15.61 $2,500 $36.39 $18.20 $33.80 $22.53 Instructions Cost of Capital Capital Budgeting 0 $1,900 4 89%) . Type here to search M N $0.00 $0.00 $0.00 U 12 - $2,600 $2,700 $2,600 $2,500 $2,400 $2,200 $2,000 $1,800 $1,500 $1,200 N $2,545.92 $2,643.84 $2,545.92 $2,448.00 $2,350.08 $2,154.24 $1,958.40 $1,762.56 $1,468.80 $1,175.04 $783.36 $391.68 $54.08 $56.16 $54.08 $52.00 $49.92 $45.76 $41.60 $37.44 $31.20 $24.96 $16.64 $8.32 $27.04 $28.08 $27.04 $26.00 $24.96 $22.88 $20.80 $18.72 $15.60 $12.48 $8.32 $4.16 S $27.04 $18.03 $28.08 $18.72 $27.04 $18.03 $26.00 $17.33 $24.96 $16.64 $22.88 $15.25 $20.80 $13.87 $18.72 $12.48 $15.60 $10.40 $12.48 $8.32 $8.32 $5.55 $4.16 $2.77 NPV= $381.55 w 15 16 17 $800 $400 D (Ctri) 89 8 Instructions Cost of Capital Capital Budgeting 899 Type here to search 63 Year 64 65 Depreciation in Taxable income Revenue Expenses SMillions in $ Millions Taxes $1,800 $1,835.25 $50.02 -$85.27 $1,900 $1,937.21 $85.72 -$122.93 3 $2,000 $2,039.17 $61.22 -$100.39 $2,100 $2,141.13 $43.72 -$84.85 $2,200 $2,243.08 $31.26 -$74.34 $2,300 $2,345.04 $31.22 -$76.26 $2,400 $2,447.00 $31.26 -$78.26 $2,500 $2,548.96 $15.61 -$64.57 $2,600 $2,650.92 -$50.92 $2,700 $2,752.88 -$52.88 $2,600 $2,650.92 -$50.92 $2,500 $2,548.96 -$48.96 $2,400 $2,447.00 -$47.00 $2,200 $2,243.08 -$43.08 Instructions Cost of Capital Capital Budgeting B00U After tax Cash Flow In $Millions NPV -$42.64 $7.38 $4.92 -$61.46 $24.26 $16.17 -$50.19 $11.03 $7.35 -$42.42 $86.14 $57.43 -$37.17 -$5.91 ($3.94) -$38.13 -$6.91 ($4.61) -$39.13 -$7.87 ($5.25) -$32.29 -$16.68 ($11.12) -$25.46 -$25.46 ($16.97) - $26.44 -$26.44 ($17.63) -$25.46 -$25.46 ($16.97) -$24.48 -$24.48 ($16.32) -$23.50 -$23.50 ($15.67) -$21.54 -$21.54 ($14.36) Bicol O Type here to search M $2,000 $1,800 $1,500 $1,200 $800 $400 N $2,039.17 $1,835.25 $1,529.38 $1,223.50 $815.67 $407.83 -$39.17 -$35.25 -$29.38 -$23.50 -$15.67 -$7.83 -$19.58 -$17.63 $14.69 -$11.75 $7.83 -$3.92 ST -$19.58 ($13.06) -$17.63 ($11.75) -$14.69 ($9.79) $11.75 ($7.83) -$7.83 ($5.22) -$3.92 ($2.61) NPV= ($87.23) IRR= 9% in mmm (Ctrl) - Instructions Cost of Capital Capital Budgeting Type here to searchStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started