Financial calculations on demand

Geeky
Kilo Guru

Can anybody please explain how financials are calculated on a demand?

How to allocate certain amount to the demand

How ROI% is calculated?

How net present value is calculated etc? Please explain these calculations with example.

find_real_file.png

1 ACCEPTED SOLUTION

Sandeep V1
ServiceNow Employee
ServiceNow Employee

Hi Srini,

I took even distribution for cost plans in my earlier calculations, that is why it is slightly off from the system NPV. But now that I see your data, the calculation is matching perfectly. Here is how it is done.

FY19 License cost planned cost = 4285. FY20 License cost planned cost = 5714

FY19 Resource cost plan planned cost = 5760. FY20 Resource cost plan planned cost = 6240

Total FY19 Planned cost = 10045

Total FY20 Planned cost = 11954. After applying discount rate, FY20 planned cost = 11954/1.1 =  10867

Total Planned cost = 10045 + 10867 = 20912

FY19 Benefit cost = 8823

FY20 Benefit cost = 21176. After applying discount rate, FY20 benefit cost = 21176/1.1 = 19250

Total Benefit cost = 19251 + 8823 = 28073

NPV = 28073 - 20912 = 7161

 

Let me know if this helps.

 

 

 

 

 

View solution in original post

35 REPLIES 35

yogesh41
ServiceNow Employee
ServiceNow Employee

Hi,

For a Demand, Cost Plan record captures planned expense,  Benefit Plan records captures benefit and Budget records capture capex/opex budget amount. So in above shared screen capture

Expense from Cost Plan record 

    Capex Cost - $10,000

    Opex Cost - $20,000 

    Total =. Cpeax + Opex = $30,000

Amount from Benefit Plan = $100,000

Planned Return = Benefit - Expense =  100,000 - 30,000 = $70,000

ROI = (Planned Cost / Financial Return ) * 100 = 233%

Please refer https://docs.servicenow.com/bundle/jakarta-it-business-management/page/product/planning-and-policy/task/t_CreatingDemands.html for more details.

-Yogesh

Hi Yogesh, Can you please put the $ amounts in the ROI calculation?  I am having trouble coming out with the 233% you are showing above.  I had Planned Cost = 110,000 / 70,000 Return = 1.571 *100?

sanjivsachdev
ServiceNow Employee
ServiceNow Employee

Please go to :

 

https://docs.servicenow.com/bundle/london-it-business-management/page/product/project-management/tas...

 

If you scroll down you will see NPV defined with a worked example.

 

However, to break this down into simple steps:

 

$1.00 today is worth $0.80 in two years time so the calculation uses the following data:

 

Today's cash = $1.00

Annual interest rate = 12%

Time Periods = 2

 

Formula

Today's Cash / (1+ Interest Rate) ^ Time Period

 

$1.00 / (1.12)^2  -> i.e. 1.12 to the power two or squared

 

$1.00 / 1.25

 

$0.80

 

 

sanjivsachdev
ServiceNow Employee
ServiceNow Employee

Capital Expense

Sum of all Cost Plans where Expense Type of the Cost Type = CapEx 

 

Operational Expense

Sum of all Cost Plans where Expense Type of the Cost Type = OpEx 

 

Financial Benefit

Sum of all Benefit Plans  

 

Financial Return

Financial Benefit - Total Costs  

 

Total Costs

Sum of Capital Expense and Operational Expense  

 

ROI%

Financial Return / Total Costs * 100

 

Score

(Value + Size + (1 / Risk)) / 3 

 

 

Internal Rate of Return

The discount rate required to achieve an NPV of zero

 

Resource Planned Cost

Total of cost plans generated by the resource plans for requested resources

 

Resource Allocated Cost

Total of cost plans generated by the resource plans for allocated resources

 

 

Hopefully this answers your question, if so please mark as helpful and mark the question answered.

 

Regards,

 

SS