cre.propertymetrics.com Open in urlscan Pro
18.205.222.128  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Currently on Sale 


INTRODUCING EXCEL BASICS FOR REAL ESTATE

Learn how to use Excel step by step by building practical commercial real estate
projects


Get Access Now

Spreadsheets are unavoidable in commercial real estate. On any given day it is
not uncommon to use Excel to analyze a rent roll, do some basic data analysis,
create an amortization schedule, build a development budget, or run some quick
financial calculations.

Yet, most Excel courses for commercial real estate focus on advanced concepts
and more complicated models. This course takes a different approach. Instead, we
teach you the basics of Excel with several practical commercial real estate
projects that you can use right now in your day to day work.

If you are a beginner when it comes to Excel, or if you just want to brush up on
your skills, then this course is for you.


WHAT WOULD LEARNING EXCEL BASICS FOR REAL ESTATE DO FOR YOU?



 * Gain confidence when working with spreadsheets day to day
 * Create your own customized Excels models to improve your productivity
 * Understand how to build practical commercial real estate projects that you
   can use in your own work
 * Feel more at ease when working with someone else’s spreadsheets




WHAT IS EXCEL BASICS FOR REAL ESTATE?



Excel basics for real estate is an online interactive video-based course that
teaches you the fundamentals of Microsoft Excel, with practical commercial real
estate specific projects. It’s for beginners who want a head start and industry
professionals who want to brush up on their skills.

The training is released in 4 separate modules and consists of easy-to-follow
videos and done-for-you templates. All of the training is online, contained in
the private member only site.

During the course we’ll walk through the basics of Excel formulas, formatting,
and data analysis. We will then apply this knowledge to several commercial real
estate specific projects. These include a maximum loan analysis, rent roll,
construction and development budget, amortization table, multifamily proforma,
and a back of the envelope development analysis.

Plus, you’re a student for life. That means you don’t have to worry about
forgetting the material because you can retake the course at any time.


WHO SHOULD TAKE THIS COURSE?



 * New commercial real estate professionals who need to learn the basics of
   Excel for the first time.
 * Existing commercial real estate professionals who want to brush up on their
   Excel skills.
 * Career changers who want to break into the industry but don’t have a
   background that includes Excel.
 * Students who want to learn Excel basics with practical commercial real estate
   projects.


GET INSTANT ACCESS


Buy Now


WHAT'S INCLUDED:



MODULE 1: KEY EXCEL CONCEPTS

 * How to use common Excel functions including sum, sumif, sumproduct, min, max,
   index/match, and more
 * Review of basic mathematical operations in Excel including addition,
   subtraction, multiplication, division, exponents, and combinations of
   operations.
 * How to create basic formatting in Excel including dates, currency, fonts,
   gridlines, conditional formatting, custom formatting, and more.
 * Overview of basic data analysis in Excel including data validation, charts,
   and graphs.
 * Includes demonstration of key concepts as well as interactive practice
   problems.

MODULE 2: MAXIMUM LOAN ANALYSIS

 * How a maximum loan analysis works and why it matters
 * Step by step creation of a maximum loan analysis calculator in Excel
 * Includes loan to value, debt service coverage ratio, and debt yield
   calculations

MODULE 3: COMMERCIAL RENT ROLL

 * Overview of the commercial rent roll and how it is used
 * Review of tenant concentration risk and lease rollover risk
 * Includes suite, tenant name, area, annual base rent, lease type, lease start
   dates, lease expiration dates, lease term calculations, security deposit,
   lease status, and tenant type.

MODULE 4: AMORTIZATION SCHEDULE

 * Overview of how an amortization schedule works
 * Step by step walkthrough showing how to build a complete amortization
   schedule in Excel
 * Includes sections for monthly payments, dates, interest ceilings, interest
   floors, interest forecasts, and balloon payments

MODULE 5: DEVELOPMENT BUDGET

 * Overview of how a development budget works
 * Step by step interest reserve calculation for a construction loan
 * Includes high level categories for land costs, hard costs, soft costs, and
   financing costs.
 * Line items for the commonly used costs with a breakout of funding source for
   each cost
 * Summary view that rolls up individual line item costs into an easier to read
   budget summary

MODULE 6: MULTIFAMILY PROFORMA

 * How to build a multi-year cash flow projection in Excel for a multifamily
   project, step-by-step.
 * Includes calculations for unit mix, cash flow before tax, financing
   assumptions, growth rate assumptions, and more.
 * Dynamically calculate a 5 year proforma and net sale proceeds at the end of
   the holding period.
 * Financial ratios including yield on cost, cash on cash, equity multiple,
   operating expense ratio, debt service coverage ratio, breakeven occupancy
   ratio, and more.
 * Discounted cash flow analysis with internal rate of return, net present
   value, investment value, and sensitivity inputs.

MODULE 7: BACK OF THE ENVELOPE DEVELOPMENT ANALYSIS

 * Overview of how a back of the envelope develop analysis works
 * Estimates for stabilized unit economics, operating statement, sources and
   uses of funds, interest reserve, lease up period.
 * Calculations for trended and untrended NOI, equity multiple, yield on cost,
   development spread, profit margin, and more.

> I have to compliment your company on clearly explaining valuation concepts to
> me. To put this into context, I asked my professor in my investment class last
> week if he knew of a way to value an income property using discounted cash
> flow analysis. Long story short…you guys are smarter than my professor. THANKS
> PropertyMetrics! “ Jonathan Torres | College Student

> I want you to know how much I appreciate PropertyMetrics. As a 30 year real
> estate attorney focusing primarily on commercial leasing and purchase and sale
> of commercial properties, it is extremely helpful to see the principles I have
> learned and used for so many years explained so clearly. Jon K. Ladd |
> Business and Real Estate Law Group


GET INSTANT ACCESS


Buy Now


OUR RISK-FREE GUARANTEE



Try the course 100% risk free. If you aren’t satisfied within 60 days then we’ll
issue a full refund. No waiting. No questions asked. No risk.