Save this video free

fnb100f260908

Jeff Hunk · 1:19:25 · 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

Jeff Hong uses an Excel housing-investment exercise comparing a 2005 to 2016, 11-year holding period to explain why arithmetic average returns overstate performance when returns compound. He derives geometric-average formulas for investments with and without rental cash flows, demonstrates Excel functions such as COUNT, PRODUCT, and GEOMEAN, and reports a 16.34% geometric average for the cash-flow scenario.

Key takeaways

Chapters

0:00 Opening Class and Retrieving the Excel Housing Workbook
4:00 Recapping 11-Year Housing Returns With and Without Rent
10:27 Why Total Return Divided by 11 Is Not an Annual Average
13:00 Compounding as Repeated Growth on Principal and Accumulated Interest
15:30 Fixed Rates, Credit Risk, and the 2007 Subprime Mortgage Crisis
23:15 Modeling Compounding When Annual Interest Rates Change
33:15 Connecting the 2005 to 2016 House-Price Series to Geometric Returns
40:10 Setting Up the Geometric Average From Future and Present Values
46:30 Testing Geometric and Arithmetic Averages Against the Ending House Value
53:30 Separating House-Price Growth From Total Return With Rental Cash Flow
58:30 Deriving a Geometric Average for Returns That Include Cash Flows
1:04:00 Building Annual Gross-Return Factors in Excel
1:07:00 Calculating the Cash-Flow Scenario's 16.34% Geometric Average
1:10:50 Why Excel's GEOMEAN Is Not a Black Box
1:14:30 Checking Student Results and Saving the Completed Workbook

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

Transcript excerpt

0:54 All right. Good afternoon everyone. Good afternoon. >> Good afternoon. >> Hi. Good afternoon Valerie. >> Good afternoon. Uh that's Dennis. Uh I see also uh Oshola Wish Sahara. >> All righty. Uh I see only two people with a camera on but uh please if you um [clears throat] if your camera is not on please turn it on now and let me also there are two people. All righty. So, I think I have how many

1:43 people? I >> This just said turn the cameras on. >> My teacher, I'm not turning a thing on. >> Yeah, please turn it on. Please turn it on. >> All right. So, uh let me um >> Okay. Hide floating reading control. So everyone please open this file that you were working on last time last Thursday. Uh we were working on this Excel file, right? Did I just admit it? Okay. Admit that person, right? Did I admit that person a while ago?

2:34 Uh do you have it? Even if I didn't tell you to uh save it, you should have saved I mean any file that you are working on, right? Uh you should you should save it for later, right? U okay keeps me okay constantly. Uh so if you have this file uh please uh give me that green check mark right yeah in the react buttons right at the bottom you will see react button and if you click on it uh you will see um green check mark if you have this file please

3:22 um give me that green check mark Okay. All right. Noel, thank you. Sahara, thank you. And Oshola and Dennis and Nicholas, Valerie, thank you. Uh, what about the rest of the class? Ana, thank you. And Wii and Michael Michael Ktos. And

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.