Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use the figures below to calculate: Payback period, discounted payback period, IRR, Modified IRR, and Profitability Index. 0 2 4 Unit sales Revenues Costs
Please use the figures below to calculate:
Payback period, discounted payback period, IRR, Modified IRR, and Profitability Index.
0 2 4 Unit sales Revenues Costs Depreciation EBIT Taxes NOPAT Depreciation Operating cash flow Initial investment After-tax salvage value Investment in net working capital Net cash flows Present value of net cash flows 1 3 1500 1560 1622 1687 $337,500.00 $361,530.00 $387,270.94 $414,844.63 $225,000.00 $241,020.00 $258,180.62 $276,563.08 $116,655.00 $155,575.00 $51,835.00 $25,935.00 -$4,155.00 $35,065.00 $77,255.31 $112,346.54 -$1,246.50 $10,519.50 $23,176.59 $33,703.96 -$2,908.50 $24,545.50 $54,078.72 $78,642.58 $116,655.00 $155,575.00 $51,835.00 $25,935.00 $113,746.50 $131,029.50 $105,913.72 $104,577.58 -$350,000.00 $52,500.00 $50,625.00 $3,604.50 $3,861.14 $4,136.05 $62,226.69 -$400,625.00 $110,142.00 $127,168.36 $101, 777.66 $219,304.27 $101,616.53 $108,243.51 $79,925.74 $158,888.58 $48,049.36 years years NPV Payback Discounted payback IRR Modified IRR Profitability index 13.16% 0 2 4 Unit sales Revenues Costs Depreciation EBIT Taxes NOPAT Depreciation Operating cash flow Initial investment After-tax salvage value Investment in net working capital Net cash flows Present value of net cash flows 1 3 1500 1560 1622 1687 $337,500.00 $361,530.00 $387,270.94 $414,844.63 $225,000.00 $241,020.00 $258,180.62 $276,563.08 $116,655.00 $155,575.00 $51,835.00 $25,935.00 -$4,155.00 $35,065.00 $77,255.31 $112,346.54 -$1,246.50 $10,519.50 $23,176.59 $33,703.96 -$2,908.50 $24,545.50 $54,078.72 $78,642.58 $116,655.00 $155,575.00 $51,835.00 $25,935.00 $113,746.50 $131,029.50 $105,913.72 $104,577.58 -$350,000.00 $52,500.00 $50,625.00 $3,604.50 $3,861.14 $4,136.05 $62,226.69 -$400,625.00 $110,142.00 $127,168.36 $101, 777.66 $219,304.27 $101,616.53 $108,243.51 $79,925.74 $158,888.58 $48,049.36 years years NPV Payback Discounted payback IRR Modified IRR Profitability index 13.16%
Step 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