How to Calculate IRR When There is a Single Cash Inflow
6.7 هزار بار بازدید -
2 سال پیش
-
This video shows how to
This video shows how to calculate the IRR (internal rate of return) of a project by hand when there is just a single cash inflow.
When a investment opportunity consists of a single cash inflow, you can directly calculate the IRR using the following formula:
0 = -Cash Outflow + [Cash Inflow/((1+r)^n)]
where "n" is the number of periods into the future when the cash inflow occurs (the cash outflow is assumed to occur today).
After plugging in the cash outflow, cash inflow, and "n" you will be able to solve for "r" which is the rate of return that would make the NPV equal to zero. Next, multiply the value you obtain for "r" by 100 to convert to a percentage. This percentage is your IRR (internal rate of return) for the project.
At the end of the video, I also show you how to calculate IRR in Excel using the "IRR" function.
0:00 Introduction
0:23 Formula for IRR
0:40 Example of calculating IRR
1:53 Algebra for calculating IRR
3:04 Convert to a percentage
3:37 Calculate IRR in Excel
—
Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world.
—
SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44-PAGE GUIDE TO U.S. TAXATION
• A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS
• MANY MORE FREE PDF GUIDES AND SPREADSHEETS
* http://eepurl.com/dIaa5z
—
SUPPORT EDSPIRA ON PATREON
*Patreon: prof_mclaughlin
—
GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT
* https://edspira.thinkific.com
—
LISTEN TO THE SCHEME PODCAST
* Apple Podcasts: https://podcasts.apple.com/us/podcast...
* Spotify: https://open.spotify.com/show/4WaNTqV...
* Website: https://www.edspira.com/podcast-2/
—
GET TAX TIPS ON TIKTOK
* TikTok: prof_mclaughlin
—
ACCESS INDEX OF VIDEOS
* https://www.edspira.com/index
—
CONNECT WITH EDSPIRA
* Facebook: Facebook: Edspira
* Instagram: Instagram: edspiradotcom
* LinkedIn: LinkedIn: edspira
—
CONNECT WITH MICHAEL
* Twitter: Twitter: Prof_McLaughlin
* LinkedIn: LinkedIn: prof-michael-mclaughlin
—
ABOUT EDSPIRA AND ITS CREATOR
* https://www.edspira.com/about/
* https://michaelmclaughlin.com
When a investment opportunity consists of a single cash inflow, you can directly calculate the IRR using the following formula:
0 = -Cash Outflow + [Cash Inflow/((1+r)^n)]
where "n" is the number of periods into the future when the cash inflow occurs (the cash outflow is assumed to occur today).
After plugging in the cash outflow, cash inflow, and "n" you will be able to solve for "r" which is the rate of return that would make the NPV equal to zero. Next, multiply the value you obtain for "r" by 100 to convert to a percentage. This percentage is your IRR (internal rate of return) for the project.
At the end of the video, I also show you how to calculate IRR in Excel using the "IRR" function.
0:00 Introduction
0:23 Formula for IRR
0:40 Example of calculating IRR
1:53 Algebra for calculating IRR
3:04 Convert to a percentage
3:37 Calculate IRR in Excel
—
Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world.
—
SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44-PAGE GUIDE TO U.S. TAXATION
• A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS
• MANY MORE FREE PDF GUIDES AND SPREADSHEETS
* http://eepurl.com/dIaa5z
—
SUPPORT EDSPIRA ON PATREON
*Patreon: prof_mclaughlin
—
GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT
* https://edspira.thinkific.com
—
LISTEN TO THE SCHEME PODCAST
* Apple Podcasts: https://podcasts.apple.com/us/podcast...
* Spotify: https://open.spotify.com/show/4WaNTqV...
* Website: https://www.edspira.com/podcast-2/
—
GET TAX TIPS ON TIKTOK
* TikTok: prof_mclaughlin
—
ACCESS INDEX OF VIDEOS
* https://www.edspira.com/index
—
CONNECT WITH EDSPIRA
* Facebook: Facebook: Edspira
* Instagram: Instagram: edspiradotcom
* LinkedIn: LinkedIn: edspira
—
CONNECT WITH MICHAEL
* Twitter: Twitter: Prof_McLaughlin
* LinkedIn: LinkedIn: prof-michael-mclaughlin
—
ABOUT EDSPIRA AND ITS CREATOR
* https://www.edspira.com/about/
* https://michaelmclaughlin.com
2 سال پیش
در تاریخ 1401/10/12 منتشر شده
است.
6,739
بـار بازدید شده