Loading table of contents...
Getting Started - v2009.1
Getting Started
How to Install and Activate LseMod
Training Videos
Other Training & Help Resouces
Help Contained in the Programs
LseMod and Office 2007
Free Calculators
Overview / Contacts
Objective of this Help file
Contact Information
Color Codes in Help File
Satisfacton Policy
About Support Agreements
What if I change PC's
Product Upgrades
Help file updates
LseMod
Applies to all programs
How to organize files
How to use file names to simplify organization
How to unprotect files
How to get back the toolbar - it disappeared
How to change costs to regular numbers or to thousands
How to create your own templates
How to change colors
How to transfer my install to a new computer
How to solve error message - Cannot Shift Objects off Sheet
How to see the formulas
How to adjust column widths if seeing ######
How to add user notes and comments to the reports
How to fix if the program is not calculating
How to customize the number format
How to use International currency formats
How to move the toolbar
How to save a file using Office 2007 so someone with Office 2003 can open it
How to turn off Auto Save
How to Show and Explain the Concessions Impact
How to make a file Read Only
Neat Stuff to know
How to find the unamortized costs
How to change the description for Other Annual Costs
How to include a Commission or Agency Fee in Tenant's Cost
How to show an Early Termination with buyout
How to change Other Factors
How to find the rent, operating expenses and taxes for any month
How to include an Administrative Fee that you charge back to an end user group
How to compare leases with different terms, e.g. a 5 year lease vs. a 7 year lease.
How to include costs from another space being leased, e.g. paying double rent
How to include Marketing Time in LseMod Landlord
How to quickly check your work or an analysis done by someone else
How the LseMod toolbar works
How to create formulas in LseMod, shortcuts
How to include a Stamp Tax in LseMod
How to link 2 LseMod files
How do I create a Buy vs Buy report
Discount Rate
How to change the discount (NPV) rate
How to change the discount (NPV) rate from monthly to quarterly, or annual
How to change the discount (NPV) rate for the Concessions Impact
How to change the discount (NPV) rate for the Net Effective Rate
Space Leased
How to change the add-on or loss factor
How to calculate the add-on or loss factor
How to enter the headcount for cost per headcount
How to calculate the cost per workstation, per seat, per partner, per door etc.
How to show a phased occupancy
How to show an analysis with multiple floors taken down at different times
How to change or calculate the load factor
How to calculate the blended add-on or loss factor
Lease Term & Dates
How to set or change the lease term
How to change from Lease Year to Calendar Year to Fiscal Year
How to Include Free Rent outside the Lease Term
How to change the Analysis Start Date
How to show a Partial Term in the financial analysis
How to change when Project Costs (e.g. construction) start
How to find which costs are included in Project Costs
How to set the dates so the free rent shows in separate year from the rest of the lease
How to find a date given the lease month
How to fill in the proposal date
How to account a partial months rent
How to get the dates to line up if leasing different spaces at different start dates
Rent
How to change the rent from /year to /month or visa versa
How to add Free Rent
How to add Net or Gross Free Rent
How to Include Free Rent outside the Lease Term
How to increase the rent by a percentage
How to see the rent costs monthly
How to enter rent increases using the annual rent
How to enter rent increases using just the fixed increase
How to re-set the rent increase formulas
How to step the rent and have a percentage increase
How to calculate the blended rent
How to calculate the weighted average rent
How to calculate a rent review (UK)
How to add fixed increases above the 10 fields
How to see the actual rent on a per month basis
How to include a Base Rent annual % increase that only applies to part of the Base Rent
How to include a % rent increase starting the beginning of the 3rd year
How to include free rent at some date other than the start of the lease
How to show a rent increase at 3% for the first five years, then 5% for the next five years
Showing Free Rent outside the term on the Financial Reports
How to include a Management Fee on Rent
How to set the dates so the free rent shows in separate year from the rest of the lease
Operating Expenses & Taxes
How to re-set the Operating Expense and Taxes formulas
How to show an Expense Stop for Operating Expenses or Taxes
How to explain a Top Stop or Base Stop
How to show Operating Expenses are capped
How to re-set the base year
How to change when pass-through costs start
How to change when Operating Expenses or Taxes start
How to include Tenant Electric
How to understand how LseMod calculates Operating Expenses and Taxes
How to show Porter's Wage in LseMod
Security Deposit & Letter of Credit
How to make the Security Deposit 3 (or some other multiple) months of rent
How to make the Security Deposit based on Gross Rent
How to show a Letter of Credit
Construction
How to change Construction Costs from rentable to usable, or visa versa
How to use Construction Financing
How to show the Landlord’s Construction Allowance includes design fees
How to amortize construction costs
How to add mid-term construction costs
How to include a Construction Management Fee
Reports sheet
How to hide rows
How to show ALL the Key Assumptons on the Financial Summary Report
How to hide Net Effective Rate, NPV, NOI, Taxes, EBITDA
How to show the Net Effective Rent
How to see the different printouts
How to understand how LseMod Pro Reports sheet is organized
Showing Free Rent outside the term on the Financial Reports
Assumptions Printout
How to customize the Assumptions Printout
How to hide the Concessions Impact
Unique to LseMod Pro
About Subleasing in LseMod Pro
How to hide AfterTax line items
How do I find the NPV if the term is greater than 30 years
How to see the Sublease Calculations
How to see the Restoration Calculations
How to set the Occupancy Date (when different from start of GAAP lease term)
How to include a Carryover Accrual for Restoration
How to change the NPV for the GAAP Sublease Calculations
How to create a budget using LseMod
How to compare a proposal to a budget
How to include a custom Approval Form in LseMod
How to add Capital Cost occurring later in the lease
How to adjust the rent for GAAP and LL paid costs
How to use the GAAP rent override command
How to add a midterm Landlord Cash Inducement per GAAP
How to include a new Landlord paying rent on Old Space per GAAP
How to show a Landlord Cash Credit on a renewal, not spending capital, and using GAAP
LseSum
Applies to all programs
How to organize files
How to use file names to simplify organization
How to unprotect files
How to get back the toolbar - it disappeared
How to change costs to regular numbers or to thousands
How to create your own templates
How to change colors
How to transfer my install to a new computer
How to solve error message - Cannot Shift Objects off Sheet
How to see the formulas
How to adjust column widths if seeing ######
How to add user notes and comments to the reports
How to fix if the program is not calculating
How to customize the number format
How to use International currency formats
How to move the toolbar
How to save a file using Office 2007 so someone with Office 2003 can open it
How to turn off Auto Save
How to Show and Explain the Concessions Impact
How to make a file Read Only
Neat Stuff to know
How to show a Partial Term in LseSum
How to add files to LseSum
How to delete files from LseSum
How to Edit the Graphs, e.g. change Names, Font, etc.
How to find the source of the data from LseMod
How to add User Defined calculations or costs to LseSum
How to create a custom Management Summary
How to hide AfterTax line items in LseSum
How to make LseSum link faster
How do I show costs per sf when the LseMod source report is in square meters
How to compare costs in the local currency AND in U.S. dollars
How the LseSum toolbar works
How to create a User Defined graph
How to add line items to LseSum
Printing, Email, Presentations
How to print
How to Email reports and graphs
How to print to PDF
How to add to email reports from other Excel files
How to protect or unprotect Email files
How to add reports to Email files
How to change the print settings
How to print a wide (e.g. 20 year) report
How to change the order of the email reports
How to save the selection of the reports for email
How to change the sheet title in an email report
How to merge a LseMod file with a non LseMod report or file
How to change or create a Prefix for an Email report or graph
How to customize the Table of Contents
How to create an Email for a complex scenario
How to change an Email file
Other
How is the Silver Series different from the Gold Series
How is LseMod Buy different from LseMod Purchase
Consulting
Seat License
Site License
Definitions
Accretion
Add-On factor ( % )
Annuity Rent
Average Base Rent
Average Gross Rent
Average Net Rent
Base Year
Budget Year
CAF
Cash Flow
Circulation - Factor, %, Space
Common Areas
Const. Mgmt. Fee
Construction Costs
Const. Mgmt Fee
Discount Rate
EBITDA
Eff
Effective Rent
Efficiency Factor
Expense Stop
Full Service Lease
GAAP Term
Gross Pallet Capacity
Hydro
Income Statement
LL
Landlord's Net Return
Load Factors
Loss Factor
LseMod
Lease Year
Leases, types of
Loss / Load Factors
Model
NER
NPV
Net Effective Base Rent (NEBR)
Net Effective Rate (NER)
Net sf
Occupancy Term
Op. Exp.
Operating Expenses
Personnel Space
Present Value
P&L
rsf
Scenario Analysis
Support Space
Taxes (Special)
Tenant Direct
Tenant Electric
TI Allowance
TI's
usf
Utilities