Save this video free

fnb100f260914a

Jeff Hunk · 1:41:57 · Watch on YouTube

Part of Borough of Manhattan Community College (CUNY) FNB 100. See all 37 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 completes the ROI lesson by distinguishing arithmetic averages from geometric averages, deriving compound growth with a 10% CD example, and showing how to calculate returns with Excel functions such as PRODUCT, COUNT, and GEOMEAN. He then connects investment returns to macroeconomic interest rates, explaining nominal versus real rates, inflation's effect on purchasing power, and why borrowing and lending respond differently to interest rates; supplemental instructor Anna Karen also outlines free tutoring and study support.

Key takeaways

Chapters

0:00 Class Setup: Download the ROI Spreadsheet and Follow Along
10:00 Why Arithmetic Annual Growth Rates Can Misstate House Returns
14:00 Testing an Average Against a 10% Certificate of Deposit
16:00 Deriving Annual Compounding from a $10,000 CD
22:00 Generalizing the CD Example to Future Value
27:00 Geometric Average Reproduces the Compounded Ending Value
32:00 Cross-Sectional Averages Versus Time-Series Growth
34:00 Including Rental Cash Flow in an Investment Return
38:00 Why Cash-Flow Returns Need a Different Geometric Average
45:00 Using Product Notation to Define Geometric Returns
54:00 Calculating Geometric Averages in Excel with PRODUCT and COUNT
1:04:00 Checking Excel Results with GEOMEAN and Understanding the Formula
1:10:00 Anna Karen Explains Supplemental Instruction and Study Support
1:20:00 ROI Review: Geometric Average as CAGR
1:23:00 Connecting Microeconomic ROI to Macroeconomic Interest Rates
1:25:00 Interest Rates as Economic Stimulus and Japan's Yen Carry Trade
1:28:00 Nominal CD Rates, Inflation, and the Real Interest Rate
1:31:00 Inflation's Effect on Purchasing Power: The Bottle-of-Coke Example
1:35:00 A 5% CD Return Can Lose Purchasing Power Under 10% Inflation
1:38:00 Lender and Borrower Perspectives and Wednesday's Online Class

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

Transcript excerpt

1:18 Hey, good morning everyone. Good morning. Happy Monday. Good morning. Good morning. I still see four people in the waiting room. Okay, I admitted I just submitted them all. Why is it still there? All right. I I Okay, I believe and I hope everyone has uh seen ah what's going on? I just admitted these two people. What's going on? Yes. >> Okay. So, uh first of all, I want you to um open this file, right? You know which file I'm talking about. Hey people still there.

2:09 I just did. Come on. I just did. All right. So last Wednesday and that was uh unfortunately uh the room assigned classroom was not a computer lab. So you probably didn't get a chance to uh download this unless you brought your uh unless you had brought your laptop with you. Uh so today I need you to download and um you should have actually after the class last Wednesday, you should have actually uh worked out the exercise we did last time

2:58 because by now you should have this uh already filled in up to this point, right? I mean uh up to this because we don't have time to redo this all over again. We lost already one day uh we lost we're already one day behind uh one:00 class. Remember I have on Monday, Monday, Wednesday I have 11:00 class which is yours. there was you know one o'clock class and one o'clock class fortunately it was a uh computer lab but you know uh not not very fortunately for me the

3:47 the instructor station was not uh touchscreen >> so um that that room also has a you know some limitations but at least the students could download the uh uh file and that work worked you know on the

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.