Explain, how to calculate 'total earnings'.

OR

What is the use of 'NPV' function ) Write and explain its syntax.

Total Earnings (TE) : BPE + DA + HRA + TRA Where BPE = BP* NOEDP / NODM BPE = Basic Pay Earned BP = Basic Pay NOEDP = Number of effective days present NOTDP = Number of days of the month—leave days DA = Dearness Allowance HRA = House Rent Allowance TRA = Transport Allowance TE can be calculated by using the above mentioned formula Or Q. What is the use of…………………… Ans. This function calculates the net present value of an investment by using a discount rate and a series of future payments. Syntax : NPV (rate, value $\displaystyle 1$, value $\displaystyle 2$, ... ) rate : It is the rate of discount over the length of the period Value $\displaystyle 1$, Value $\displaystyle 2$ ... are $\displaystyle 1$ to $\displaystyle 254$ arguments representing payments and incomes. Value $\displaystyle 1$ ... Value $\displaystyle 2$ ... must be equally spaced in time and occur at the end of each period. NPV uses the order of Value $\displaystyle 1$, Value $\displaystyle 2$, ... to interpret the order of cash flow. It is essential that the entry for payment and income values are in the correct sequence.