Question

Darren Mack owns the "Gas n' Go" convenience store and gas station. After hearing a marketing lecture, he realizes that it might be possible to draw more customers to his high-margin convenience store by selling his gasoline at a lower price. However, the "Gas n' Go' is unable to qualify for volume discounts on its gasoline purchases, and therefore cannot sell gasoline for profit if the price is lowered. Each new pump will cost $85,000 to install, but will increase customer traffic in the store by 10,000 customers per year. Also, because the "Gas n' Go" would be selling its gasoline at no profit, Darren plans on increasing the profit margin on convenience store items incrementally over the next five years. Assume a discount rate of 9 percent. The projected convenience store sales per customer and the projected profit margin for the next five years are given in the table below. i Year Projected Convenience Store Sales Per Customer $4 $4.50 Projected Profit Margin 20% 25% 30% 35% $7 UWN $10 $11 40% a. What is the NPV of the next five years of cash flows if Darren had four new pumps installed? NPV = $ (Enter your response rounded to two decimal places.)

Answer 1

Year 1 Projected Projected Present Sale price No of Product Profit Profit PV factor Value per unit (a) Units (b) (c=axb) Margin (d) (e=dx c) @ 9% (f) (exf) $ 4.00 10000 $ 40,000 20% $ 8,000 0.917 $ 7,339.45 4.50 10000 $ 45,000 25% $ 11,250' 0.842 $ 9,468.90 7.00 10000 $ 70,000 30% $ 21,000 0.772 $ 16,215.85 10.00 10000 $ 1,00,000 35% $ 35,000 0.708 $ 24,794.88 $ 11.00 10000 $ 1,10,000 40% $ 44,000 0.650 $ 28,596.98 $ 86,416.07 Initial Investment $ -85,000.00 Net Present value of Project $ 1,416.07 5 Less :

In case of any doubt or issue, Please comment below