Computing a Uniform Periodic Equivalent

Suppose you need a warehouse for ten years. You have two options:

  • pay rent for ten years at $23,000 per year

  • build a two-stage facility that you will maintain and which you intend to sell at the end of those ten years

Data sets describing these scenarios are available in the portfolio SASHELP.INVSAMP.BUYRENT. Which option is more financially sound if you desire a 12% MARR?

Open the portfolio SASHELP.INVSAMP.BUYRENT and compare the options.

To perform the periodic equivalent, follow these steps:

  1. Load the portfolio SASHELP.INVSAMP.BUYRENT.

  2. Select both cashflows.

  3. Select Analyze $\rightarrow $ Periodic Equivalent. This opens the Uniform Periodic Equivalent dialog box.

  4. Enter 01JAN1996 for the Start Date.

  5. Enter 10 for the Number of Periods.

  6. Select YEAR for the Interval.

  7. Enter 12 for the Constant MARR.

  8. Click Create Time Value Summary.

Figure 57.6: Computing a Uniform Periodic Equivalent


Figure 57.6 indicates that renting costs about $1,300 less each year. Hence, renting is more financially sound. Notice the periodic equivalent for renting is not $23,000. This is because the $23,000 per year does not account for the MARR.