Present value and annuity payment

[Former Member]

Dear experts,

Models/applications details:

SAP BusinessObjects EPM, Add-in for Microsoft Office

Version 10.0 SP 25 Patch2 .NET4

CPMBPC Release 800, SP-Level 0021 Support package SAPK-80021INCPMBPC

Component: SAP_BW

Release 740

SP-Level : 0020

Support package SAPKW74020

List of dimensions

ACCOUNT_PL (Accounts), TIME, VERSION (Actual / Plan / Forecast), COMPANY, DATASOURCE, FOCUS (Competence center / Business line), MEASURE, RPTCURRENCY, TERM (Lifetime of the contract), PARTNER (Client segment), VENDOR (Supplier).

Script: to be launched by DM package

Calculation engine JAVASCRIPT.

The aim is to create 2 functions:

1)to calculate the present value of loans ((analogue to PV function in Excel)

2)annuity payment (analogue to PMT function in Excel)

These functions are to be used in the calculation of the balance value of the loan portfolio.

1)Present value

Where:

• PV = Present value of the annuity
• P = Fixed payment
• r = Interest rate
• n = Total number of periods of annuity payments

2) annuity payment

annuity-payment-formula1.png

An annuity is a series of equal cash flows, spaced equally in time. The goal in this example is to have 100,000 at the end of 10 years, with an interest rate of 5%. Which returns 7,950.46. Payments are made annually, at the end of each year.

Could you please advise,

• I did not find any build-in formula in ScriptLogic to calculate present value and annuity payment. Is there any?
• How is it possible to create these 2 functions and apply them repeatedly (for example, each month comes a new batch of loans with different characteristics). Could you please share the scripting?

[former_member186338]

Sorry, but I you haven't accepted correct answer for your previous question!

[Former Member]

vadim.kalinin, Done

[former_member186338]

About this question: I do not understand how the data for calculations is stored in BPC model (P, r, n)

Also Excel sample is missing...

[Former Member]

I have prepared the Excel file, but I cannot attach it. Excel files are not supported

[Former Member]

Here is the screenshot.

[former_member186338]

Sorry, but still not clear!

How starting period is defined? And resulting periods?

[former_member186338 · Accepted solution]

In general, the starting period can be any period of the year and calculation results has to be saved in number of periods of some years.

The following logic can't be calculated effectively using script logic! Don't waste time.

Write custom logic badi.

P.S. For sure, in ABAP - no issues with formulas...

[Former Member · Accepted solution]

Are there any examples for these functions in ABAP? Could you please share if possible?

[former_member186338 · Accepted solution]

a.tkachova

Just open ABAP help for power:

https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-US/index.htm

ipow - Integer Power Function

PV can be calculated in a loop... DO N TIMES. ... ENDDO.

Nothing special...