Save this video free

fnb100f260909b

Jeff Hunk · 48:48 · 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 a house investment example covering 2005 to 2016 to explain holding-period returns, rental cash flows, and why an 11-year total return cannot simply be divided by 11 to find an annual return. He demonstrates Excel formulas and reusable soft coding, contrasts arithmetic and geometric averages, and explains compounding with a 10% bank-deposit example.

Key takeaways

Chapters

0:00 Course Setup and the House-Value Spreadsheet Exercise
5:40 Holding-Period Return for an Owner-Occupied House
10:55 Adding Rental Income to the House Investment Return
13:56 Why an 11-Year Return Cannot Be Divided by 11
16:58 Calculating Arithmetic Average Growth in Excel
21:25 Time-Series Growth and the Compounding Problem
26:02 Geometric Average for Annualized House-Price Growth
32:20 A 10% Bank Deposit Shows How Compounding Works
41:50 Class Wrap-Up, Laptop Reminder, and Attendance

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

Transcript excerpt

0:16 recording in progress. >> All right. So, let me show my screen. Joshua. So, uh I didn't even This isn't me. I mean, uh whoever logged into this station, that wasn't me. Let's Let's do uh anyway. me. So, uh, what's happening

1:19 that you need? Oh. [clears throat] to space. Okay, I'm in. Oh, who wants me? So if you remember from our last class which was last Wednesday um everyone [clears throat] everyone is aware and everyone knows that uh if if you go to the bottom of our course

2:08 modules. Right. Okay. Let me click load more. Right. Don't just stay there. 902. Right. Our class recording. we were [clears throat] we were beginning to talk about the um uh house value example, right? So, um uh since we I was going to do the um uh this exercise hands-on, but we don't have any computer. This is not a computer left. So, we'll do this next time and instead we're going to move on

2:57 right to um uh the next video and I will explain to you every once in a while um as we go along what all right I oh without okay let me okay let me stop then since we

4:01 So I want to watch uh and [clears throat] even if this session is being recorded. But I'll be using the uh Oh, this is not even white board. I don't pay. They have a lot of small chalks here. I brought some light chalk uh markers. So this file right I told you to download this file which is you know um uh you know don't just open it download

4:50 that was the file that you saw last time and so it's downloaded you open So you might wonder, oh Uh now I I don't think this is going to be

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.