ROI Tracker

ROI: Return on Investment (ROI) is a common financial metric used to measure the likelihood of gaining a return from an investment. It’s often used to compare the efficiency of different investments

Step 1: Define Investments and Returns

Firstly, define your investments (your costs) and your returns. This could include costs such as labour, materials, training, and maintenance, while returns could include increased revenue, decreased costs, or improved productivity. It’s important to be as comprehensive as possible when defining these values.

Step 2: Check and Calculate ROI

ROI is calculated by subtracting the cost of the investment from the gain from the investment, then dividing the result by the cost of the investment, and finally multiplying it by 100 to get a percentage.

Step 3: Monitor Trends and take a decision
Monitor the trends of Revenue against Investment in multiple Dimension and take future decisions

The Worksheets

1. Master	Define the Mast information like Projects/Value Streams, Investment Types, Expense Types This Slide is to create the Master list of all projects or value stream, Typical Expense types like Labour Cost, Materials cost, Training cost etc, there are options to create 50 different types of Expenses, similarly have option to create Master list for Returns for Example Revenue Captured, Productivity Increased, Profit from sale etc. These master list will be used to add transaction as on when the user will hit a expense or return. It also have an option to identify 3 favourite Projects or Value Stream
2. Project Investment and Revenue	This slide for adding Expense and Return details, with Specific date, type of Expense if it’s a Expense, or type of returns if it is return
3. ROI Till Date	This slide is to quicky Summarize the total Investment and Returns till date, and Calculate the ROI
4. Analysis-Specific Duration	To drill down the above summarised data, user can navigate to next slide and filter on Specific Quarter with in last 3 years, or Months with in last three years. To get project with Investments or Returns for the selected time duration
5. ROI-Dashboard	This is the slide to analyse the Investment and Returns with multiple different aspects like. 1. Project of Value Stream comparison on ROI There are options to filter on projects or a specific past date to get the data for based on the transaction captured till that day and for that Project. 2. Investment, revenue and ROI, till Selected Date 3. ROI Comparison for Favourite 3 Projects or Value Stream 4. Monthly Trend of Selected Project till selected Date 5. Quarterly Trend of Selected Project till selected Date 6. Breakdown of types of investment on Total Investment till that selected date and selected project 7. Breakdown of types of revenue on Total Investment till that selected date and selected project 8. Trend Analyse to month level of a specific Investment or revenue types 9. Quarterly Trend analysis of Selected Project with Comparison on Investment and Revenue 10. Monthly Trend analysis of Selected Project with Comparison on Investment and Revenue
6. Investment and Revenue	Internal Data Management – Default is Hidden
7. Monthly Trend Cumulative	Internal Data Management – Default is Hidden
8. Quarterly Trend Cumulative	Internal Data Management – Default is Hidden

Number of Transaction allowed	4000
Number of Projects or Value Stream	100
Max Investment Types	50
Max Revenue Types	50
Number of Years in Past for Trend analysis	3 years

How Can I raise a Support Request ?

Option 1 – Raise a Support request
https://agiledigest.atlassian.net/servicedesk/customer/portal/1/group/2/create/10

Option 2 : email us at [email protected]
Does this have any Macros?

Yes, To refresh the Pivot table and graphs on change of key filter, If you don’t enable the content, you need to refresh the charts and tables manually
Can I change the formulas?

Yes you can, a precautionary measure is always to keep a copy, so that in case some problems appear, you can revert back to copied template
Can I change/delete Agile Digest Logos?

Yes, however, unauthorized copies or distribution outside your project for commercial purposes is strictly prohibited.

Quick Glance

Price

Original price was: ₹4,000.00.Current price is: ₹2,800.00. + Tax

Add to Cart

Enquire now more information about

ROI Tracker

We recognize that committing to training investments can be a challenging decision. Rest assured, our team is here to assist you. Kindly provide your information in the form below, and we will promptly reach out to you with the necessary details.