Time Value of Money

Learn the core concepts of time value of money and how to apply them in Excel.

Why This Course?

The fundamental building block of all of finance is "time value of money". Unfortunately, it's poorly taught at most universities.

In this course, I walk you through how to build time value of money problems in Excel, and I do all of it without using a single Powerpoint slide. :)

We'll cover the essentials (PV, FV, etc.), IRR, NPV and by the end we'll discuss some of Excel's particular creations including XIRR and XNPV.

Best of all, you'll have Excel worksheets for all of it so if you get stuck, you'll be able to follow along on the worksheet.

Even if you tried to learn this before or you forgot what you learned years ago, I think you'll like my Excel based approach.

Thanks.

- Josh Kahr

Course curriculum

1. Future Value, The Basics
  FREE PREVIEW
2. Future Value, Compounding
3. Future Value, Problems
1. Present Value and Discounting
2. Present Value, Problems
1. Future Value of an Annuity
1. Present Value of an Annuity, The Basics
2. Welcome to Net Present Value ("NPV")
1. Internal Rate of Return
2. IRR and Iteration
3. IRR, Problem
1. The Basics of Net Present Value ("NPV")
1. RATE vs. IRR, Even and Uneven Cash Flows
2. Lottery Example
3. Breaking the IRR Formula
1. The Five Functions of a Dollar
1. Side Conversation: How Does PMT Work?
1. Length of Loan and Number of Periods Per Year
1. The Basics of XIRR
2. Sidebar: How Not To Write a Clause in an Operating Agreement
3. XNPV and Excel Timing Issues for the XIRR and IRR
1. The MIRR
1. Congrats! Here's what's next...
2. More resources for you
3. Before you go...

About this course

$49.00
31 lessons
2 hours of video content

Instructor(s)

Joshua Kahr

Senior Instructor

[email protected]

Joshua Kahr is the principal of Kahr Real Estate Services, a training and consulting company that he founded in 2002 and that serves the commercial real estate industry. In 2009, he founded Metropolitan America, a real estate investment company that owns and manages apartment buildings in New Jersey. In 2020, he started Essex Suites, a coworking company, that opened its first location in Verona, New Jersey.

Prior to this, he held positions in investment sales at a regional brokerage firm in New York City and in acquisitions at a fund that focused on environmentally contaminated real estate.

He was on the board of directors of two public companies, Monmouth Capital Corporation and Monmouth Real Estate. He was an advisory board member of Assess+RE which was sold to LightBox in 2021. He is currently on the advisory board of clik.ai.

Mr. Kahr has served as an adjunct associate professor since 2005 for Columbia University’s MS in Real Estate Development program where he has taught real estate finance, real estate capital markets, and related topics. He has also served as an adjunct professor at Northwestern, New York University, and Georgetown University. For corporations, he has taught over 200 two-day seminars on Excel modeling and Argus.

Publications include two books on real estate market analysis, Real Estate Market Valuation and Analysis (John Wiley and Sons: 2005) and Beyond the Bubble (Amacom Books: 2007).

He has a Master of Science in Real Estate from New York University (’97) and a Bachelor of Arts in Economics from Reed College (’92).

He is also licensed as a real estate broker in New York and New Jersey.

Discover your potential, starting today

Enroll today