List of LseMod Training Videos

Go to training videos

Learning the Basics - Videos 1 - 14

1.0 Training Introduction (4:21 mm:ss)

• Overview of LseMod and LseSum
• What is common to ALL programs
• LseMod vs. LseSum Reports - Explaining the output / reports

2.0 Overview of LseMod Tenant Rep (7:10 mm:ss)

• Organization
• Data entry
• Reports
• Navigation
• Toolbar

2.0g LseMod Gold Series - LseMod Pro (17:36 mm:ss)

• First view 2.0 for Data Entry, Navigation, & Toolbar
• Overview - Expansion, Sublease
• Reports
• Organization
• GAAP Rent
• Capital vs. Operating Lease Test

3.0 Overview of LseSum Tenant Rep (8:48 mm:ss)

• Reports
• Graphs
• Navigation
• Toolbar

4.0 Installing LseMod and Installing a Brother Printer Driver (7:10 mm:ss)

• Installing LseMod
• Deleting the LseMod icon
• Installing a Brother printer driver (needed to run the email commands)

5.0 Creating a Basic Analysis (13:12 mm:ss)

• Using the Basic Analysis command
• Enable macros
• Saving a LseMod file
• Hiding unused rows
• Adding comments

6.0 Logos, Changing Assumptions, Printing & Emailing (8:40 mm:ss)

• Adding a logo
• Changing Assumptions
• Printing reports
• Emailing reports
• Toolbar positioning

7.0 LseMod Tenant Rep Example 1 (Part 1 of 2 parts) (11:12 mm:ss)

• Covers: General Information - Rent, Part 1

7.1 LseMod Tenant Rep Example 1 (Part 2 of 2 parts) (11:20 mm:ss)

• Experienced user / classic approach to data entry
• Covers: Rent Increases - Other Factors Part 2

8.0 LseMod Tenant Rep Example 2 (11:52 mm:ss)

• Analyzing another property - after competing the analysis for 1 property

9.0 All About Rent (21:09 mm:ss)

• Free Rent
• Gross Free Rent
• Increases - different amounts, different dates
• Non-consecutive increases
• Look-up commands
• Monthly NPV report
• Additional Inputs sheet
• Re-Setting the formulas
• GAAP Rent (see video 2.0g - LseMod Gold Series)

10.0 All About Operating Expenses & Taxes (23:55 mm:ss)

• Rent Include Op. Exp.
• Op. Exp. include Real Estate Taxes
• Full Service and Net leases
• Base Year > Actual Cost
• Expense Stops
• Changing when costs start
• Monthly NPV report
• Additional Inputs sheet
• Re-Setting the formulas
• Tenant Electric
• After Hours HVAC
• What is Gross Rent
• Using Other Monthly Costs input section
• Changing name for Other Monthly Costs

11.0 Using the Lease Wizard (8:20 mm:ss)

• Learn how the Lease Wizard works
• Basic Analysis vs Lease Wizard

12.0 Using LseSum to create a Management Summary (13:42 mm:ss)

• Using the Link Wizard
• Multiple files open at once
• Files on a Server Apostrophes in file names
• Saving files - use "sum"
• Hiding Rows
• Printing & Email
• Showing costs in thousands

13.0 LseSum - Customizing Reports (17:44 mm:ss)

• Over 500 variables being compared
• LseMod's assumptions change
• Adding / Deleting line items
• Customizing Graphs
• Calculating totals and differences
• Highlighting in Yellow and/or Bolding
• Adding pictures and logos

14.0 LseSum - Advantage of linking files (2:05 mm:ss)

• What happens if change a LseMod file

Special Features / Commands

100.0 Goal Seek (4:49 mm:ss)

• Excel's Goal Seek function
• LseMod's Advanced Goal Seek

101.0 International Analyses (9:53 mm:ss)

• Currency, measurement
• Exchange Rate
• Reports
• Special Taxes e.g. VAT, GST, Mgmt Fee
• LseSum - Currency Options

102.0 International - Leasing space in TimBuck2 (18:28 mm:ss)

• An international example in TimBuck2
• Rent Review Calculator

103.0 Seeing the Landlord's side (5:57 mm:ss)

• Linking LseMod to a Landlord analysis
• What happens if change a LseMod file

104.0 Phased Occupancy (10:36 mm:ss)

• Creating a phased Occupancy Analysis

Specialty Programs: LseMod Buy
(Lease vs. Buy Analysis)

Buy 1.0 Overview of LseMod Buy & Condo (13:46 mm:ss)

• First view 2.0 for Data Entry, Navigation, & Toolbar
• Reports
• Organization
• Understanding Lease vs. Buy Reports

Buy 2.0 Create a detailed Lease vs. Buy Example (34:51 mm:ss)

• Create a detailed Lease vs. Buy Analysis
• Balloon Loans
• Opportunity Cost
• Lease vs Buy Mgmt Summary - Modify Report
  • - Pictures, Hiding rows, $/sf vs. $
• Reference - see videos
  • LseMod Overview
  • Installing LseMod & Brother Printer Driver
  • Logos, … Printing, Emailing
  • All About Rent
  • All About Operating Expenses & Taxes
  • Lease Wizard
  • LseSum
  • Adding pictures & logos
• Reference
  • Download Sample Reports from www.LseMod.com/downloads/Examples