Save this video free

fnb100f260903

Jeff Hunk · 1:20:55 · 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 develops the holding-period return formula using a house bought for $150,000 at the end of 2005 and sold for $500,000 at the end of 2016, then compares living in it with renting it out. He shows how to calculate capital gains and rental income in Excel, explains why dividing a multiyear return by 11 misstates annual performance, and introduces geometric averaging through the mathematics of compound interest.

Key takeaways

Chapters

0:00 Course Setup: Attendance, Brightspace, and Required Materials
10:25 Holding-Period Return: Reading the Price and Time Subscripts
13:00 A House as an Asset: Appreciation and Rental Income
17:00 Two House-Investment Scenarios and Total Return
19:48 Zoom Roster Names and Attendance Records
27:50 Download the Excel Exercise and Set Up Year-End Data
31:36 Calculate Annual Capital Gains with Excel Fill
36:10 Scenario 1 Return and Absolute Cell References
40:54 Scenario 2: Add Annual Rental Income to Return
45:10 Why Total Return Divided by 11 Is Not Annual Return
49:20 Year-over-Year Growth Rates and the Compounding Problem
54:20 Arithmetic, Weighted, and Geometric Averages
57:00 Course Credits and Dice Probabilities as Weights
1:02:30 Time-Series Data and the Need for Geometric Averages
1:07:00 Compound Interest: From $10,000 to the Year-10 Value
1:10:00 From Compound Growth to the Geometric Annual Return

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

Transcript excerpt

0:34 in progress. All right. Good afternoon everyone. Good afternoon. Good afternoon.

1:21 >> Good afternoon. I see a few people still without any camera. Please uh please turn on your camera, please. Uh, I see Oshola with no camera. Sonobu Doris, thank you. Uh, is Oh, Dennis, I'm sorry. Dennis, thank you. >> All right. Uh, Sahara, please turn on your camera. Noel, please turn on your camera. All right. So um uh we didn't do much on we couldn't do much on uh Tuesday. Of course that was the first day and I had to basically walk you through the uh uh the layout of the uh bright space

2:12 uh and uh basic ground rules. Uh so uh I will have to assume that you have watched all the videos that are due. Now there is someone named Zoom user but you know uh that that's not going to count because that's not attendance because I don't know who you are right think about it. >> I'm sorry. Is it me? >> Yeah. Please put the name. Please sign in with your formal name please. is I mean the name that were you the name that matches your full name on the roster. I mean but were you here last time? >> I couldn't log in so I just was able to now because I had to get my email

2:58 figured out. >> Oh, okay. But please >> I don't know why it didn't prompt me. Usually prompts me to sign in with my name. Um but I is it okay if I put in chat just for this class and I'll try to log in with my school email next time? >> Well, I guess you can currently I mean you need to uh change that sign in name. I mean uh maybe not

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.