In this 2-day course, you will master the advanced Excel tricks, techniques, and tools financial analysts use to build and audit financial models. This will also cover real estate fundamentals used to create real estate models. You will create a real estate acquisition model using assumptions for the purchase price, financing, operating performance, and exit cap rate.

warning-standard-solid This course has a prerequisite

Prior financial experience is helpful, but not required. 

Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements.

What You'll Learn

  • Financial functions: NPV, IRR, XNPV, and XIRR
  • Advanced database functions: VLOOKUP-MATCH, & INDEX-MATCH
  • Create Data Tables to show outputs based on various scenarios
  • Use Goal Seek's powerful calculation tools
  • Create financial projections based on historical data
  • Master Excel with a variety of shortcuts finance professionals need
  • Create a mortgage model in Excel
  • Evaluate a real estate acquisition and calculate levered and unlevered returns