Question

In: Economics

Determine the discounted payback period of a new manufacturing process that costs $15,000,000 with an annual...

Determine the discounted payback period of a new manufacturing process that costs $15,000,000 with an annual savings of $3,800,000 going up by 3% per year at a MARR of 10%

Please show all work and steps. Any help will be appreciated and thank you for your time!

Solutions

Expert Solution

P = F/(1+i)^t

Present value of annual savings of yr 1 = 3800000 / (1+0.1) = 3454545.45

Cumulative cash flow after including presnt value of yr 1 = -15000000 + 3454545.45 = -11545454.55

Present value of annual savings of yr 2 = 3800000 * (1+0.03) / (1+0.1)^2

= 3800000 * (1.03) / (1.1)^2

= 3234710.74

Cumulative cash flow after including presnt value of yr 2 =-11545454.55 + 3234710.74 = -8310743.81

Present value of annual savings of yr 3 = 3800000 * (1+0.03)^2 / (1+0.1)^3

= 3800000 * (1.03)^2 / (1.1)^3

= 3028865.515

Cumulative cash flow after including presnt value of yr 3 =-8310743.81 + 3028865.515 = -5281878.295

Present value of annual savings of yr 4 = 3800000 * (1+0.03)^3 / (1+0.1)^4

= 3800000 * (1.03)^3 / (1.1)^4

= 2836119.527

Cumulative cash flow after including presnt value of yr 4 =-5281878.295 + 2836119.527 = - 2445758.768

Present value of annual savings of yr 5 = 3800000 * (1+0.03)^4 / (1+0.1)^5

= 3800000 * (1.03)^4 / (1.1)^5

= 2655639.194

Cumulative cash flow after including presnt value of yr 5 = - 2445758.768 + 2655639.194 = 209880.43

Discounted payback period = 4 + (2445758.768 / 2655639.194)

= 4 + 0.92 = 4.92 yrs


Related Solutions

Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following after-tax cash flow projections. Also tell me whether the IRR is greater or less then the RRR. A. Year ATCF 0 $(60,000) 1 21,000 2 27,000 3 24,000 4 16,000 Assume a 16% required rate of return
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following after-tax cash flow projections. Also tell me whether the IRR is greater or less then the RRR B. Year ATCF 0 (100,000) 1 (320,000) 2 130,000 3 185,000 4 200,000 5 195,000 6 150,000 Assume a 20% required rate of return
Distinguish between the payback period and the discounted payback period?
Distinguish between the payback period and the discounted payback period?
Using a 7% annual cost of capital, what is the discounted payback period in years of...
Using a 7% annual cost of capital, what is the discounted payback period in years of the potential project below? round to 2 decimals Year-----Cash Flows 0..............-5000 1...............1625 2..............1668 3..............1616 4..............1679 5..............1619 can you please let me know how you find this? especially if using a financial calculator. Thanks!
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index...
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and the risk free...
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present...
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and...
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3....
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3. Net Present Value 4. Profitability Index (Benefit-Cost Ratio) 5. Internal Rate of Return 6. Modified Internal Rate of Return Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital...
q.1 Discounted payback period. ​Becker, Inc. uses the discounted payback period for projects costing less than​...
q.1 Discounted payback period. ​Becker, Inc. uses the discounted payback period for projects costing less than​ $25,000 and has a cutoff period of four years for these​ small-value projects. Two​ projects, R and​ S, are under consideration. Their anticipated cash flows are listed in the following table. If Becker uses a discount rate of 4 %4% on these​ projects, are they accepted or​ rejected? If it uses a discount rate of 12 %12%​? A discount rate of 18 %18%​? Why...
​(Payback and discounted payback period​ calculations) The​ Bar-None Manufacturing Co. manufactures fence panels used in cattle...
​(Payback and discounted payback period​ calculations) The​ Bar-None Manufacturing Co. manufactures fence panels used in cattle feed lots throughout the Midwest. ​ Bar-None's management is considering three investment projects for next year but​ doesn't want to make any investment that requires more than three years to recover the​ firm's initial investment. The cash flows for the three projects​ (Project A, Project​B, and Project​ C) are as​ follows: Year Project A Project B Project C 0 $(950) $(9,000) $(6,500) 1 530...
(Payback and discounted payback period calculations) The Bar-None Manufacturing Co. manufactures fence panels used in cattle...
(Payback and discounted payback period calculations) The Bar-None Manufacturing Co. manufactures fence panels used in cattle feed lots throughout the Midwest. Bar-None's management is considering three investment projects for next year but doesn't want to make any investment that requires more than three years to recover the firm's initial investment. The cash flows for the three projects (Project A, Project B, and Project C) are as follows: a. Given Bar-None's three-year payback period, which of the projects will qualify for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT