LseMod Training Videos

Directions

1. Click on a link, below, to go to a training video.
2. If you wish to pause, restart, or move about through a video scroll down to the video navigation buttons at the bottom of all video screens.
3. When you want to return to this page, click the back button on your browser window.

GAAP Subleasing Example

• Data Entry for a Sublease Analysis (9:34 mm:ss)
• Calculating Your Current GAAP Rent (4:41 mm:ss)
• Explaining a GAAP Sublease Analysis (12:18 mm:ss)

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