LseMod Help |
Every now
and then a deal might require you to Take Down space over time or Phase into
more space. The first step is to make sure that all required space leased, e.g.
the rsf, is filled in on the Inputs sheet in the SQUARE FOOTAGE input
section. If you
are using LseMod Tenant Rep, Industrial, Landlord, Retail and Economic
Development, then next, go to the Additional
Inputs
sheet (tab on the bottom to the right of the Inputs sheet). In LseMod Tenant
Rep, Industrial, Landlord, Retail and Economic Development there is a column
that you can adjust for square footage. If you are using LseMod Pro or Sublease,
see the Note at the end of this write-up. Just
scroll to the month of Phase in and add in the white column the square footage
you wish to increase up to. For example your starting square footage is 18,500;
in month 34 of a 68 month term you’re phasing into an additional 4,500 square
feet so now in month 34 you will add the additional 4,500 square feet and you’ll
see in the gray column D that you now have 23,000 total square feet. To carry
that down the term in row 21 you’ll find a Fill
Down
button (button has no label, but is in row 21). How to show a phased
occupancy

LseMod can even handle a multiple phase in (or out) of space.
In the example below, 1,500 sf is being added in month 59.
Note: We have shown the Total additional space in month 59 (4,500
from before and the additional 1,500). To fill the cells below you can copy and
paste or using an Excel feature, scroll to the lower right of that cell (cell in
month 59) until you see a black plus sign, drag down the cell down for as long
as you wish. The fill down button can only be used once.

Note: When you go to the Financial Summary the space leased just below the year setting will show like the graphic below with RSF Leased – Weighted Average. The actual dollar cost can be seen on the Monthly NPV sheet. The first format shown is format 1 – just showing the $/sf, the second format shown is for 4


Note: For LseMod Pro and LseMod
Sublease, you will need to run two analyses and combine them in LseSum.
TIP: Be sure on the second
analysis to make the analysis start date the same as the “analysis” start date
for the first analysis.
How to change the Analysis Start Date
|
|
Silver
|
|
Gold
|
|
Specialty |
|
ü |
LseMod Tenant Rep |
|
LseMod Pro |
|
LseMod Condo |
|
ü |
LseMod Industrial |
|
LseMod Purchase |
ü |
LseMod Commission |
|
ü |
LseMod Landlord |
|
LseMod Sale Leaseback |
|
SpacePro |
|
|
LseMod Buy |
|
|
|
|
|
|
LseMod Sublease |
|
|
|
|
|
ü |
LseMod Retail |
|
|
|
|
|
ü |
LseMod Economic Development |
|
|
|
|