Course
|
Excel

Valuing a Real Estate Investment

In this course, learn how to build your first, full valuation model from scratch. The investment opportunity is a downtown 3-bed apartment, recently put up for sale.
2 HOURS
Advanced
13 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create a model of a real estate investment problem
Project the future revenues from a real estate investment
Project the future expenses from a real estate investment
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Valuing a Real Estate Investment

In this course, learn how to build your first, full valuation model from scratch. The investment opportunity is a downtown 3-bed apartment, recently put up for sale.
2 HOURS
Advanced
13 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create a model of a real estate investment problem
Project the future revenues from a real estate investment
Project the future expenses from a real estate investment
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

13 Lessons
Introducing the Case
2 MINS
LESSON
Introducing the Case
Exercise

To begin, we'll learn about real estate asset we're going to value. We'll also meet the investor and his expectations for the investment.

Define the Model Structure
5 MINS
LESSON
Define the Model Structure
Exercise

In this lesson, we'll create a structure for the valuation model, defining the critical variables that will determine internal rate of return (IRR).

Revenue Projections
4 MINS
LESSON
Revenue Projections
Exercise

Generating revenue projections is typically the first Excel task we complete when building a valuation model. This part of the model is where market knowledge is most important.

Calculate Effective Gross Income
5 MINS
LESSON
Calculate Effective Gross Income
Exercise

Effective gross income accounts for revenue losses due to vacancy and collection losses. In this lesson, we'll learn how to include these variables in our model.

Expense Projections
5 MINS
LESSON
Expense Projections
Exercise

Expense projections are often ignored in real estate valuation but can have a big impact on final returns. Learn how to add them to your model in this lesson.

Navigation Tips for Models
2 MINS
LESSON
Navigation Tips for Models
Exercise

Navigating valuation models can be difficult as they grow. This lesson shows you a very useful tip that makes navigating models much easier.

Mortgage Calculations
6 MINS
LESSON
Mortgage Calculations
Exercise

Most real estate assets will be bought with loans to increase IRR. This can be tricky to incorporate into a model, due to the tax treatment of interest payments.

Income Tax Calculations
4 MINS
LESSON
Income Tax Calculations
Exercise

Income tax is paid on rental income received during the holding period. It can be reduced by loan interest repayments as we'll find out in this lesson.

Operating Cash Flows
3 MINS
LESSON
Operating Cash Flows
Exercise

Operating cash flows are the cash flows received by the investor each year from rental income. Cash flows can be positive or negative, depending the on expenses incurred.

Estimating the Final Selling Price
4 MINS
LESSON
Estimating the Final Selling Price
Exercise

The final selling price of our asset will be based on an income multiple. This variable is hard to predict but will hugely impact our final IRR.

Capital Gains Taxes
5 MINS
LESSON
Capital Gains Taxes
Exercise

Capital gains taxes (CGT) are incurred when you sell the asset at a profit. CGT rates can vary by asset and by location so you'll need some tax advice to calculate correctly.

Calculate Investment IRR
4 MINS
LESSON
Calculate Investment IRR
Exercise

To calculate our investment IRR, we need to combine the initial investment, operating cash flows and cash flows on sale. See how to calculate IRR in this lesson.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo