Food Industry's
Return on Investment Guidelines
For Companies Evaluating Private vs. Public Warehousing
Prepared by
for
For
International Association of Refrigerated Warehouses1500 King St., Suite 201
Alexandria, Virginia 22314, USA
703-373-4300, 703-373-4301 fax, email@iarw.org, www.iarw.org
Contents
IntroductionCompletion of this KitReturn on Investment (ROI) and Net Present Value (NPV)Information needed to calculate ROIInformation needed to calculate NPVWorksheet #1 — Computing Return on Investment (ROI)Worksheet #2 — Calculations of Net Present Value of Cash Outflows, Private vs. PublicSupplemental Schedule A — Investment Costs, Private WarehouseSupplemental Schedule B — Operating Expenses, Private WarehouseIntroduction
Because capital expenditure decisions involve significant resources that are committed long into the future, considerable time and effort should go into the evaluation of plant asset proposals. The length of time that financial resources are committed makes capital expenditures more risky than other investments. Before beginning a capital expenditure program that involves a large outlay of funds that will be tied up for many years, management should seek assurance that they will receive an acceptable return on investment. In order to quantitatively select from several options, the predicted cash flows must be compared to the required investments to determine if the return generated from each option meets or exceeds what management considers acceptable.
The purpose of this Return on Investment (ROI) Kit is to assist your company in evaluating whetheryour refrigerated warehouse needs can best be met through construction of your company’s own distribution center, (referred to in this Kit as “private warehouse space”), or through use of one of the many public facilities available worldwide. In other words, is it better to construct your own facilities or “outsource” for space in public refrigerated warehouses?
Several techniques are available for evaluating capital expenditure proposals. This ROI Kit helps to organize factors to be considered in the capital expenditure decision, and provides worksheets to document your calculation of two commonly used methods. These two methods consist of:Return on Investment: This calculation, also known as the book value rate of return, is commonly used because it is based on the accrual method of financial statement preparation, and is easy to apply. Its weakness is that is fails to consider the time value of money. The investment to be
evaluated is the investment you would make if your company met its refrigerated storage needs by constructing your own refrigerated warehouse. The return on this investment will be defined as the difference between the annualized cost of building and operating your private refrigerated warehouse vs. the annual cost of using public refrigerated warehouse capacity.
Net Present Value: Present value is a way of re-stating a stream of future cash flows into today’s dollars. When present value is applied to a capital investment, the future return is generally in the form of cash generated by the asset acquired. This model, however, calculates the net present value (NPV) of the cash outflows related to each option. All other factors being equal, the option with the lower present value cost is generally the most profitable decision.Completion of this Kit
This Kit has been organized into two sections and worksheets to help you in collecting the appropriate data for performing each of these two calculations. Use of this kit assumes that you have already assembled the projected capital investment and operating costs of building and operating your own warehouse. Should you need assistance in assembling that information, however, supplemental schedules A and B have been included for your use in generating that For simplicity, cash flow projections in Worksheet #2 assumes that all capital expenditures are incurred in the first year, and operating expenses are incurred equally over the time period selected by you to perform the net present value analysis.
areas of the worksheet are protected cells. You may move from box to box by using the tab key. Once your data is entered, the worksheet automatically calculates the remaining portions of the worksheets.
Should you find it necessary to use supplemental schedules A or B, the total from those
supplemental worksheets do not automatically carry forward to the ROI or NPV worksheets. If necessary, you must enter the totals from those supplemental worksheets onto the appropriate lines of the ROI or NPV worksheets. When entering data on line 3b of worksheet #2 - NPV, don't forget that these operatin expenses should be net of the income tax benefit for both Private and Public Options. (See Supplemental Schedule B, Line 9)
Public refrigerated warehousemen would appreciate the opportunity to assist you in completing this Kit by providing an estimate of the annual expense you would incur if you used the services of their refrigerated warehouses. Their experience may also prove valuable in accumulating all appropriate costs associated with building and operating refrigerated warehouses. They can also provide comparative statistical data in other areas of the decision analysis.Return on Investment (ROI) and Net Present Value (NPV)
The Return on Investment (ROI) calculations measures the rate of return on your proposed decision to make an investment in constructing your company's private warehouse facility. The return on this investment is defined as the difference between the annualized cost of building and operating a private refrigerated warehouse versus the annual cost of using a public refrigerated warehouse. ROI is used by many companies to refer to their own measure of project profitability. That rate of return is then compared with other investment options to determine which option exhibits a potential for a greater return. For instance, can you achieve a better use of capital by investing in other facilities, new products and technology, marketing, or in research and development?
Accounting or book value ROI calculations assume straight-line depreciation of all depreciable assets, and a constant annual difference in costs between the private and public refrigerated
warehouse options. When these assumptions are valid, the ROI calculation is a straightforward way to evaluate a decision between private and public options. It fails, however, to consider the time value of money. In addition, some assumptions used in applying the ROI method may not be true, such as cash flow differences from year to year. For example, the ROI method is not appropriate When additional capital expenditures are made after the project has started. Not including these costs will tend to understate the cost of the private warehouse option.
When the use of accelerated depreciation varies the income tax impact each year, and calculations are made on an after-tax basis.
When the investment in building and equipment does not occur all at once. For example, if the purchase of some equipment may be deferred to coincide with the subsequent increase in revenues generated by the new project.
A discounted cash flow method may be more appropriate when cash flows differ from year to year because it can accommodate cash flow fluctuations, and because it considers the time value of money. A variation on the discounted cash flow method is called the \method, which assumes some minimum desired rate of return. This desired rate of return is the rate at which the cash flows are discounted to present dollars. A capital investment proposal is
considered acceptable if the present value of its future expected net cash flows equals or exceeds the amount of the initial investment. More specifically, this kit assists you in identifying net cash flows related to costs of both a private or public warehouse option, and then calculates the net present value (NPV) of each. All other factors being equal, you should choose the option with the Information Needed to Calculate Worksheet #1 - ROI
1a. Annual Cost to Use Public Refrigerated Warehouse Space:
As discussed elsewhere in this Kit, this information may be obtained from a local public refrigerated warehouse.
1b. Transportation Costs:
Your cost estimate should include the costs to convey items to and from the warehouse.
2. Total Annual Operating Expenses to Operate Your Private Warehouse:
If you have not already generated this information, Supplemental Schedule B included within this Kit may be used to accumulate operating expenses normally considered in refrigerated warehouse operations. In generating your operating cost estimates be sure to consider the following expenses unique to refrigerated warehouses:
Operating and maintenance of refrigeration systems.
Increased use of electric power with the possibility of peak power electric penalty rates. Additional clothing and protection equipment for employees working in a refrigerated environment.
Increased safety and environmental expenses associated with ammonia refrigeration systems.Because of their situation-specific nature, the costs related to blast freezing are not specifically included in this worksheet. Each situation must be uniquely evaluated. Accurate determinations of these costs can be obtained by contacting a Public Refrigerated Warehouse.
4. Total Costs to Construct Your Private Warehouse:
Supplemental Schedule A has been enclosed in this Kit to assist you in accumulating the cost of your investment in your company’s own refrigerated warehouse. Otherwise use your own estimate of those capital costs. Your estimates should consider the following construction costs considered unique to refrigerated warehouses: Refrigeration equipment
Additional insulation, including floor Refrigerated loading docks Freezer and escape doors Freezer clothes
Inspection room equipment
Underfloor heating system
Information Needed to Calculate Worksheet #2 - NPV
1. The Period over Which to Perform the Analysis.
This may cover the entire useful life of the private warehouse option, or some shorter period of
time. A shorter period will be relevant if your company has a shorter investment horizon, or if there is some uncertainty about costs after a certain point in time.
2. Required Rate of Return.
This rate should reflect the time value of money and the risk of the cash flows of the two options. Management should use their judgement in arriving at the required rate of return. Since greater risk is attached to capital investments than to a bank loan, the rate is usually above the interest rate at which banks are lending money. After a company’s required rate of return is estimated, the present value method can be applied to discount the cash flows to the present.
3. The Relevant Annual Cash Flows.
Document the annual cash flows for both the public and private options separately so as to consider the tax implications of each option. Cash flows for each project should be measured on an after tax basis. In addition to statutory tax rates, three things affect the company’s taxes; revenues, expenses, and timing of recognition of those revenues and expenses for tax purposes. The present value of taxes paid is less on a revenue item the further into the future that the tax payment actually occurs. Similarly, the present value of taxes saved is greater on an expense item the sooner the reduction in taxes paid actually occurs. The most common discrepancy between cash flow timing and tax recognition concerns depreciation. Because depreciation is included in expenses, it affects the timing of tax payments. Remember that cash is expended upon acquisition of a capital asset. Consequently, depreciation is not a cash expense. However, the tax deduction associated with a. Private Warehouse:
For simplicity purposes, Worksheet #2 assumes that all capital expenditures are incurred in the first year, and operating expenses are incurred equally over the time period selected by you to perform the analysis. In performing a more detailed analysis using your own worksheet, you should consider the additional costs unique to a refrigerated warehouse. Construction of your own warehouse involves initial cash flows from the capital investment, followed by cash flows from operating activities. Also consider capital costs for each year that such costs will be incurred should they not all be incurred in year one, the cash inflow (net of tax), of a gain on sale of the asset, salvage value or market value in the final year.
Operating expenses of your private warehouse option should be converted to cash flows net of tax for each year of operation. Consider unique start up costs in the early years, and additional costs associated with closing down the facility at the end of its useful life. Also consider fixed costs of your private facility that may be only part time based on seasonal fluctuations.b. Public Warehouse: