Manual Import Module: Setting up Argus Reports and Pasting into Module

[LoganCebrzynski]

The Manual Import Module allows for Argus model cashflows to be imported into a template that is CRE Suite compatible. This tutorial will detail how to create the necessary report package within Argus and how to paste the information from those reports into the module correctly. Once the information from those reports are processed, the module allows the user to manipulate purchase, debt, disposition, and waterfall assumptions, the bucketing of operating expenses, and the timing of capital expenditures.

1. Set up report packages within Argus
   a. Cash flow statement for Analysis Period +1 yr (need Forward-12 for terminal value)
   b. Lease Summary Report (Current Tenants)

2. Within Argus select File > Control Panel > Report Packages > Add

For Cash Flow Report:

For Lease Summary Report:

TO PASTE INTO MODULE

1. Cash Flow Report
   a. Select the whole sheet and unmerge document then deselect “Wrap Text”
   b. Copy & Paste (Values only) the monthly cash flow report from AE starting with the Month # row and down (cell A8 in the screenshot below) into Cell H13 of the MANUAL-Cash Flow tab.

2. Lease Summary Report
   a. Select the whole sheet and unmerge document then deselect “Wrap Text”
   b. Copy & Paste (Values only) from Cell A1 to the bottom of the last tenant of the Lease Summary Report into Cell E3 of the LSRDump tab

NEXT STEPS:

1. Once the cash flow and lease summary reports have been pasted in, click the “Process Pasted Data” button on the Manual – Cash Flow tab. It will take a second to calculate everything and then automatically bounce you to the Project Summary Report tab.
2. Bucket the operating expenses and CapEx in the ExpBUCKETING and CapXBUCKETING tabs by entering the buckets you want to show up in the reports in column B, and then row-by-row choosing the buckets which correspond with each operating expense.
   NOTE: If your Argus model includes OpEx sublines, only bucket either the overall total or each individual subline, but not both, otherwise the total calculation will double count the operating expense. (Screenshots included below)

DO:

OR:

DO NOT DO:

3. Enter any scheduled capital expenditures and their timings that will occur during the hold period in the CapXBUDGETING tab. This will exclude any capital costs that are handled up front during the acquisition of the property (those will be included in the Acquisition Assumptions in the Inputs tab)
4. Fill out any Acquisition, Debt, Exit, and Waterfall Assumptions in the Inputs tab so the reports are able to calculate accurate project level returns and provide a big-picture view of the project.