How to calculate the Profitability Index (PI) in an Excel spreadsheet

My eFinancesheet
My eFinancesheet
74 بار بازدید - 3 سال پیش - How to calculate the Profitability
How to calculate the Profitability Index (PI) in an Excel spreadsheet

Hi guys, In this video I've shown the calculation of the Profitability Index (PI) in Excel. The Profitability Index is the ratio of the present value of benefit to the present value of cost. It is also known as the Benefit-Cost Ratio (B/C).

Time Stamps
00:00 Introduction
00:29 Meaning of Profitability Index
00:56 Preliminary Information for Calculation
01:45 Calculation of Present Value Interest Factor (PVIF)
02:08 Calculation of Present Value (PV)
02:22 Calculation of Cumulative Present Value
02:42 Comparison Between NPV and PI
03:10 Calculation of Total Present Value (TPV)
03:46 Calculation of Net Cash Outlay (NCO)
04:15 Calculation of Profitability Index (PI)
05:19 Decision Making by PI
07:18 Result Analysis
07:54 Signing Off

To download the Excel file: https://docs.google.com/spreadsheets/...

To get the theoretical knowledge, please visit the blog by clicking on the link below: https://myefinancesheet.blogspot.com/...

#PI #ProfitabilityIndex #CapitalBudgeting
To get in touch please follow on:
▶Facebook: Facebook: myefinancesheet​​​​
▶ Twitter: Twitter: myefinancesheet​​​​
▶ Instagram: Instagram: ​
▶ YouTube: https://www.seevid.ir/fa/result?ytch=UCj4j​...
▶ Blogger: https://myefinancesheet.blogspot.com
▶ G-Mail: [email protected]

Thanks for watching the videos. If you like it, please hit the like button, and don't forget to subscribe and hit the notification bell for quick updates.
Thank you...
3 سال پیش در تاریخ 1399/11/18 منتشر شده است.
74 بـار بازدید شده
... بیشتر