Save this video free

fnb100f260909a

Jeff Hunk · 1:00:15 · Watch on YouTube

Part of Borough of Manhattan Community College (CUNY) FNB 100. See all 36 lectures and search them

These notes were made with YouTube Collector. Paste any YouTube link and get the same: a summary, chapters and a searchable transcript.

Overview

Dr. Jeff Hong uses an Excel housing-investment model to distinguish capital gains, growth rates, and holding-period returns across two scenarios: living in a house without rental income and subletting it for cash flow. He then explains why dividing a total return by 11 years or taking a simple arithmetic average can misrepresent annual performance when returns compound, and introduces the geometric average as the more appropriate measure.

Key takeaways

Chapters

0:00 Class Setup, Screen Sharing, and Attendance
3:00 Reviewing the Two Housing Investment Scenarios
6:00 Downloading the Excel Workbook and Calculating Capital Gains
10:00 Entering Spreadsheet Formulas and Filling Annual Data
14:00 House Prices, Capital Gains, and Local Housing Demand
18:00 Scenario 1: Holding-Period Return Without Rental Cash Flow
22:00 Scenario 2: Adding Rental Income to the Housing Return
28:00 Calculating Year-over-Year House-Price Growth
32:00 Why Dividing Total Return by 11 Does Not Give Annual Growth
38:00 Using Excel AVERAGE and COUNT for Annual Growth Rates
44:00 Time-Series Trends and the Snowball Effect of Compounding
50:00 Geometric Average, CD Compounding, and Class Wrap-Up

Keep these chapters and the full searchable transcript in your own library.

Transcript excerpt

0:11 Okay, now I guess you can sign in now. I'm sharing my screen. Okay. And we'll be admitting. So you guys are getting on with it. Now what is the screen that it's HDMI? Yeah.

1:13 Every time every time. All right. So I uh I don't know if you have access to uh uh I mean because last time we were working on let me see it's Monday Wednesday class so we met last Wednesday. Let me go

2:10 CC space. I don't know. For some reason, I can't even log into uh a lot of things. So, good. I don't know. Okay. So, this is your class. So, uh, if I remember correctly, uh, and

3:02 I've got like six classes to handle, so my memory isn't always, uh, perfect as to where we stopped in the last class, but if I remember correctly, We stopped right before the uh growth rates versus return, right? To just to trust your memory. So this was our 902 class September 2nd and So uh we did

3:55 we did basically um uh so I uh I don't have this file uh you know I I can download new um so we found, you know, uh we we found basically a holding period return uh we found holding period return right in both scenario one and scenario two. Now I I wonder if you remember what scenario one and scenario two is. Uh buy uh we want scenario one is a king square you buy your house and use it as your home

4:48 right scenario two is what pay scenario two there's cash flow So in um in scenario one we uh our photo return scenario to the full liquid 7%. Now we want to know how the uh anyone

5:54 Capital gain is the growth in house

This is the start of the transcript. Save this video free for the whole transcript, searchable and time-coded.

In this course

Related notes

Summary, takeaways, and chapters were generated by AI from the video's transcript and may contain errors. The video belongs to its creator, Jeff Hunk.

Want the full transcript?

Save this video in YouTube Collector to get its complete searchable transcript, your own AI summaries, and a library that keeps every video you collect in one place.