| Worksheets and
Supplemental Schedules To
complete each worksheet, simply enter your data into the appropriate
shaded boxes. All other 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 operating expenses should be net of the
income tax benefit for both Private and Public Options. (See
Supplemental Schedule B, Line 9)
Click
here to go to the following worksheets and schedules
- Worksheet #1: Computing Return
on Investment (ROI)
- Worksheet #2: Calculations of
Net Present Value of Cash Outflows—Private vs. Public
- Schedule A: Investment
Costs—Private Warehouse
- Schedule B: Operating
Expenses—Private Warehouse
Related Links:
|
