Originally published: 16/07/2019 08:02
Publication number: ELQ-77509-1
View all versions & Certificate
Publication number: ELQ-77509-1
View all versions & Certificate
Internal rate of return on projects
This tool calculates the highest internal rate of return on projects.
by Arno Wakfer
BI Consultant & Trainer | Specialising in Data Analytics & Visualisation | Microsoft Power BI Data AnalystFollow 15
BI Consultant & Trainer | Specialising in Data Analytics & Visualisation | Microsoft Power BI Data AnalystFollow 15
Description
This tool calculates the highest internal rate of return an ranking across 5 projects.
Inputs required for each project as comparative:
Year 0 = Expected cash outflow of investment
Year 1+ = Expected cash inflow/ outflow for each subsequent periods
Disclaimer
This tool is used at your own discretion. Any corrective steps taken are at your own risk. It is advised that you consult a Finance professional to help you with your decision making.
About the Author
Arno is a Senior Finance professional with more than 15 years experience in Financial Management and Accounting in various roles as CFO, Finance Manager and Finance Business Partner having work in South Africa and Australia.
He is a Chartered Accountant, Certified Financial Modeling and Valuation Analyst and holds a Diploma in Advanced Business Management. Key competencies include Business metrics, Reporting, Business Intelligence, Dashboards, Financial Analysis, Cash Flow, Profitability, Systems, Processes & Automation, Strategy, Planning, Forecasting, Financial Modelling & Troubleshooting
He is passionate about Finance creating value to help drive Business performance and has posted more than 150 articles on LinkedIn and on his blog at FinanceValueCreation.com.
His tools, templates and reading material are practical, easy to understand and are aligned to the Value Creation Framework of creating value through Intelligence, Improvements and Insights.
Arno mentors Accountants from time to time and is generous with sharing his knowledge with like minded professionals.
This tool calculates the highest internal rate of return an ranking across 5 projects.
Inputs required for each project as comparative:
Year 0 = Expected cash outflow of investment
Year 1+ = Expected cash inflow/ outflow for each subsequent periods
Disclaimer
This tool is used at your own discretion. Any corrective steps taken are at your own risk. It is advised that you consult a Finance professional to help you with your decision making.
About the Author
Arno is a Senior Finance professional with more than 15 years experience in Financial Management and Accounting in various roles as CFO, Finance Manager and Finance Business Partner having work in South Africa and Australia.
He is a Chartered Accountant, Certified Financial Modeling and Valuation Analyst and holds a Diploma in Advanced Business Management. Key competencies include Business metrics, Reporting, Business Intelligence, Dashboards, Financial Analysis, Cash Flow, Profitability, Systems, Processes & Automation, Strategy, Planning, Forecasting, Financial Modelling & Troubleshooting
He is passionate about Finance creating value to help drive Business performance and has posted more than 150 articles on LinkedIn and on his blog at FinanceValueCreation.com.
His tools, templates and reading material are practical, easy to understand and are aligned to the Value Creation Framework of creating value through Intelligence, Improvements and Insights.
Arno mentors Accountants from time to time and is generous with sharing his knowledge with like minded professionals.
This Best Practice includes
1 Excel file