Why This Course?

I've been building financial models for over 20 years, and I can tell you that no one wants to review your model. 


People want to have your model answer questions, and if you want to answer questions, you need to use the "What If" tools. 

Take this course, and you'll understand how to use the tools that bring your model to life. 

Enjoy. 

- Josh Kahr 

Tools

What tools are discussed in this course?

  • Goal Seek is using to quickly give you the input you need to get the answer you want.

  • Data Tables are how you generate a sensitivity analysis. It'll let you analyze a deal or give a stellar presentation.

  • Scenario Manager is used for scenario analysis. It's the most powerful tool in Excel that almost no one uses.

  • Solver is used to solve problems that have negative feedback loops.

Course curriculum

    1. A message from your instructor

      FREE PREVIEW

    2. How to use this course

      FREE PREVIEW

    3. Have a question? Feedback?

      FREE PREVIEW

    4. Before we begin...

      FREE PREVIEW

    1. Example of Goal Seek

      FREE PREVIEW

    2. The Basics of Goal Seek

      FREE PREVIEW

    3. Goal Seek and Precision

    1. Example of Data Tables

    2. The Basics of Data Table

    3. Calculation Speed and Settings

    4. Links and Circular Calculations in Data Tables

    5. Many Output, One Input Data Table

    6. Approach 1 - Many Output, One Input Data Table

    7. Approach 2 - Many Output, One Input Data Table

    1. Example of Scenario Manager

    2. The Old Way of Comparing Scenarios

    3. Scenario Manager

    1. Solver, Basic Example

    2. Turning On Solver

    3. The Basics of Solver, Solving For A Value

    4. Solver, A Better Example

    5. Solver, A Better Example

    1. Congrats! Here's what's next...

    2. More resources for you

    3. Before you go...

About this course

  • $49.00
  • 25 lessons
  • 1.5 hours of video content

Instructor(s)

Joshua Kahr

Senior Instructor

Joshua Kahr is the principal of Kahr Real Estate Services, a training and consulting company that he founded in 2002 and that serves the commercial real estate industry. In 2009, he founded Metropolitan America, a real estate investment company that owns and manages apartment buildings in New Jersey. In 2020, he started Essex Suites, a coworking company, that opened its first location in Verona, New Jersey.

Prior to this, he held positions in investment sales at a regional brokerage firm in New York City and in acquisitions at a fund that focused on environmentally contaminated real estate.

He was on the board of directors of two public companies, Monmouth Capital Corporation and Monmouth Real Estate. He was an advisory board member of Assess+RE which was sold to LightBox in 2021. He is currently on the advisory board of clik.ai.

Mr. Kahr has served as an adjunct associate professor since 2005 for Columbia University’s MS in Real Estate Development program where he has taught real estate finance, real estate capital markets, and related topics. He has also served as an adjunct professor at Northwestern, New York University, and Georgetown University. For corporations, he has taught over 200 two-day seminars on Excel modeling and Argus.

Publications include two books on real estate market analysis, Real Estate Market Valuation and Analysis (John Wiley and Sons: 2005) and Beyond the Bubble (Amacom Books: 2007).

He has a Master of Science in Real Estate from New York University (’97) and a Bachelor of Arts in Economics from Reed College (’92).

He is also licensed as a real estate broker in New York and New Jersey.

Discover your potential, starting today

Enroll today