We will review the Internal Rate of Return IRR and Net Present Value NPV, focusing on real estate applications. Using an Excel financial calculator, you will practice real-world calculations for fundamental real estate financial analysis. This is a "hands-on" workshop. There are two hours of pre-study required. 

If you plan to take CCIM CI 101 in May of 2025 or need a review of basic financial calculations, this is for you! If this is new and you are in commercial real estate, this is a must!

This is part two of a two-part series. 

Basic Financial Calculations Using the Excel Calculator

Course Description: This calculator course is designed to give the student an understanding of financial analysis tools, concepts, and calculations necessary to compute and understand financial calculations for commercial real estate. It will prepare the student for the calculations used in the CCIM Intro course and beyond. Students will be provided with an invaluable Excel workbook that they will retain.

Course Requirements: Students must have a computer loaded with a FULL VERSION (activated) of Microsoft Excel.

Part 2

Internal Rate of Return (IRR) and Net Present Value (NPV)

Case study of a 4-unit apartment building.

1. 1. Direct capitalization
   2. Cash on cash calculations
   3. Net Operating Income per year
   4. Five-Year Cash Flow Model (NOI).
   5. Calculate the Forecasted Sales price.

Overview of concepts and calculations:

1. 1. Solve for the Internal Rate of Return (IRR)
   2. Solve for Net Present Value (NPV)
   3. Solve for Present Value (PV)

Once you register, you will receive a confirmation email, sample problems, and the Excel Financial Calculator. This is your prestudy.