Hi all,
I would like to know how the system calculates all the disabled fields in the Financials section on the Project [pm_project] form which end users cannot enter.
Total planned cost:
Budget cost:
Estimate at completion:
Planned return:
Planned ROI %:
Net present value:
Internal rate of return %:
Estimate to completion:
Your help is much appreciated 🙂
Thank you,
Mazin
HI,
For ROI i am sure there is a business rule "Calculate ROI".
Then Planned return and few other fields are calculated fields:
Thanks,
Ashutosh
Please mark answer as correct or helpful as per its impact.
Hi ,
If you want to say that from where that values are populated then from Demand to Project they Appear.
Below is ss that will give you batter idea.
1]Demand Form
2] Project Form
If it helps,Please mark ✅ Correct and 👍 Helpful.
Warm Regards,
Milind
Hello here is how the system calculates each of the fields above -
Total planned cost - Is the total of planned capital and planned operating cost, Those two costs are populated from the Cost Plan Break Down table. It uses a business rule called "Rollup estimated cost to Project/Demand ". The "Total planned Cost" is populated with a business rule called "Update Total Plan Cost In Proj Currency". All that does is add the capital and ops cost. It uses a script include and business rules to populate the Project Planned cost - Now if the project has task and they have a planned cost associated with them they can get rolled up to the Project Planned cost as well. The Business rule that does that is called Project Actual Cost Rollup.
| Total estimated cost of the cost plan.
If the cost is recurring, the calculation is Quantity x Unit cost x number of fiscal periods. If the cost is non-recurring, the calculation is Quantity x Unit cost. |
This is a roll-up from all the actual costs on the Cost Plans on a project. Here is the business rule that populates the Project from Cost Plan Breakdown table - Update actual cost in project currency
Budget cost: This field is automatically populated from the project budget breakdowns in the cost plan breakdown table. When project funds are allocated for a fiscal year, the cost plan breakdown stores the budget allocation for each fiscal period. These amounts are rolled up and stored in the budget cost.
To manually enter a value, select a currency icon, and enter the value.
This also gets updated by the cost plan breakdown if there is a change
Estimate at completion: Sum of all actuals for past fiscal periods added to the functional cost for future fiscal periods. This get update by Script include called -
For example, the duration of a project is from January 01 to December 31, and if you check the Estimate at Completion in the month of May, it is calculated as: Sum of actuals from Jan to April + Sum of functional cost from May to December.
The calculation is done with a Script Include called - ProjectCalculateAJAX. To be honest I couldn't break down what exactly is going on in the script.
Planned return: This is calculated on the Project level using the "Calculate for Planned Return" business rule. here is the formula it uses - planned return cost = current planned benefit - current cost .
There is also an OOTB calculated value on the actual field as well
Planned ROI %: This is calculated with a business rule called "Calculate ROI". It calculates value = current benefits - current cost it then takes that and (value/current cost) * 100
if the current cost is <=0 the ROI is set to 0.
NPV and IRR calculations are being done for projects based on cost and benefit plans data.
For IRR to get populated, below conditions need to be satisfied:
1) Cost plan and/or benefit plan records should be present for at least two Fiscal years
2) Cost plan breakdown and benefit plan breakdown values are used to calculate IRR
3) There should be at least one fiscal year with +ve value(Sum of benefit plan breakdown values for the fiscal period is greater than the sum of cost plan breakdown values)
4) There should be at least one fiscal year with -ve value (Sum of cost plan breakdown values for the fiscal period is greater than the sum of benefit plan breakdown values)
Net present value: Net present value (NPV) is calculated from the estimated cost per year, the planned benefit per year, and the discount rate for the project.
The business rules that update those fields are on the Cost Break Down table and it is called - IRR and NPV on fiscal period update. The Script Includes that does all the calculations is called - BenefitAndCostPlanAggregatorAPI
Internal rate of return %:
| Annual interest rate required to achieve an NPV of zero.
Internal rate of return (IRR) helps to determine which projects can deliver higher rate of return in terms of revenue. |
Estimate to completion:
| Sum of all planned costs for future fiscal periods. |
- The calculation is done with a Script Include called - ProjectCalculateAJAX. To be honest I couldn't break down what exactly is going on in the script.
I might have missed one or two things. I hope that helps
here is the documentation as well
