Loading...

Course Description

One of the most powerful features of a well-designed financial model is adaptability. The capacity for a model to accommodate the various scenarios a client may face, and dynamically address these variables, is crucial in that model becoming trusted and used. This lesson will cover two conditional calculations: IF statements and LOOKUP functions.

In this lesson, you will create adaptability within your models through the use of the two conditional calculations: IF statements and LOOKUP functions. Professor Lebret presents a hypothetical deal in which the amortization table data must adjust based on the exit year. Highlighting the pros and cons of both functions, you will begin to recognize when to use each to gain the desired outcome for your audience. And the best way to get started with these two commonly used functions? Binomial trees drawn with just paper and pencil. This simple practice will serve as a starting place for you to illustrate the needs of the model before you spend time creating it in Excel. For the best experience, complete "Modeling Essentials and Introduction to Discounted Cash Flow: Discounted Cash Flows in Real Estate" prior to taking this lesson.

Benefits to the Learner

  • Perform IF statement and LOOKUP functions in Excel
  • Determine when to strategically apply IF statements and LOOKUP functions to your model to gain the desired outcome for your audience              
Loading...
Enroll Now - Select a section to enroll in
Type
self-paced (non-instructor led)
Dates
Jun 02, 2023 to Dec 31, 2030
Total Number of Hours
1.0
Course Fee(s)
Regular Price $0.00
Required fields are indicated by .