Question: Trump Pump Company (FIN5303-01; Spring 2017)
Although you were hired as a financial analyst after completing your MBA, your first assignment at Trump Pump is with the firm's marketing department. Part of the "Make Great Pumps Even Greater Again" campaign includes your boss lending you to the marketing department to help them develop some analytical procedures that the sales force can use to demonstrate the financial benefits of buying Trump Pump's products. Trump pumps cost more because they use no parts from Mexico. To offset the price, each pump comes a coupon for a free tax credit on the next purchase from Trump Pump, a round of golf a Mar a Lago and a 14 ct. gold leaf "Trump" logo sticker for the front office door.
Trump Pump manufactures pump systems that are used in a wide variety of applications including water distribution, sewage treatment, petroleum refining, and pipeline transmission. The complete systems include sophisticated pumps, sensors, valves, and control units that continuously monitor the flow rate and the pressure along a line and automatically adjust the pump to meet pre-set pressure specifications. Most of Trump Pump's systems are made up of standard components, and most complete systems are priced from $600,000 to $1,000,000. Because of the technical nature of the products, the majority of Trump Pump's salespeople have a background in engineering, not finance and marketing.
As you think about this assignment, you quickly come to the conclusion that the best way to "sell" a system to a cost-conscious customer is to conduct a capital budgeting analysis to demonstrate the cost effectiveness of the system. Further, you conclude that the best way to begin is with an analysis for one of Trump Pump's actual customers.
From discussions with the firm's salespeople, you determine that a proposed sale to the Oklahoma City Water Department is perfect to use as an illustration. OKC Water is considering the purchase of one of Trump Pump's standard water pump systems which costs $850,000, including delivery. It will cost OKC Water another $8,000 transportation and $40,000 to install the equipment. This expense (transportation and installation) will be added to the price of the equipment to determine the depreciable basis of the system. Also, the new pump will require an increase in working capital of $35,000. OKC Water will depreciate the pump system to zero using straight-line method for six years. They plan to sell the system at the end of nine years for $450,000. After the first year, OKC Water will be required to pay $11,000 per year for a service and maintenance contract with payments at the beginning of each year.
The system from Trump Pump would replace a pump that OKC Water is now using. That pump has been depreciated to a book value of zero but will be sold for $70,000 if the new system is purchased. OKC Water recently spent $70,000 just one year ago to upgrade their existing pump system. (OKC Water believes the $55, 000 for repairs should be a cost to the present evaluation because it did not increase the salvage value of their current pump.) By replacing the old pump, OKC Water should save $380,000 annually in pre-tax operating costs. OKC Water estimates that its cost of capital is 12% and its tax rate is 34%. If purchased, the new pump will be housed in a building owned by OKC Water and currently leased to a fishing guide service which pays OKC Pump $26,000 at the beginning of each year to use the building. Because of the noise, the fishing guide service will have to move out of the building.
After developing a capital budgeting analysis for the pump system, write a description of the analysis to be used by Trump Pump sales representatives to help sell the system to OKC Water. Remember that the analysis will be used to help non-finance sales representatives sell equipment to non-finance customers. The analysis must be understandable and clear. Show each step and calculation such that an intelligent person not trained in finance can understand. Also, include a spreadsheet that calculates your results (template included). Calculate Payback Period, Net Present Value, Internal Rate of Return, Profitability Index, and Modified Internal Rate of Return.
1. What is the project's NPV? Could the NPV of this project be different for OKC Water than for some other company if both companies expect the same cash flows? Explain.
2. What is the project's IRR? Assuming the same cash flows, could the IRR for this project differ for OKC Water compared to another company? Explain.
3. Calculate the payback period. What are the disadvantages of the payback period? Does payback period provide any useful information regarding capital budgeting decisions?
4. Calculate the project's MIRR. Why is MIRR considered to be superior to the IRR? How does MIRR differ from IRR?
5. Calculate the project's Profitability Index.
6. Should OKC Water purchase the new pump system? Why?
7. The management at OKC Water tells you that they should not buy your pump system because they had spent $55,000 to upgrade the old pump just one year ago. How would you overcome this objection to buying the pump system from Trump Pump Company?
The excel file enclosed below:
Attachment:- Trump-Pump.xls