Question

no excel

You are a Logistics Manager at an e-Commerce retail company. Your company currently uses third-party delivery services to deliver products ordered through your website. While third-party services are reliable, they have limitations that are preventing your company from differentiating from other e-Commerce retailers. Therefore, you are contemplating that your company should start its own delivery service for delivering the most commonly ordered products. You have done all the analyses and are left with calculating the payback period of the investment before you present it to management. Typically, management has funded investments with a payback period between 3-4 years. What is the payback period of this investment based on the information provided below? Will management invest in this project? Note: Please show all calculations and use only the information provided in this problem. Do not include any external information. The required investment for the service is $800,000. You are expecting an increase in monthly revenue of $30,000 for the next 5 years that is directly attributable to this service. You are also expecting incremental costs of $175,000 per year for the next five years.

Answer 1

As the cash flows are uniform we can use the following formula for oayback

Payback=Investment/(Increase in monthly revenue*12-Increase in annual Costs)=800000/(30000*12-175000)=4.32 years

As payback is more than the cutoff of 4 years, do not accept the project