Do you have the payment made each period?
It appears to be E column / C column. Which doesnt really make sense?Originally Posted by ByTheCringe2
Anyway that means you need to calculate the present value which is why I asked the questions above. i think I may be off track tho.
More details would be nice.
-concerning the round is because the data mgiv provided had only 4 digits
-concerning the formula, it depends: up to one/one and a half years, it's normally used the simple actualization, that is = C / (1 + r% * dt ) ( they are normaly deposit rates calculated normally on a ACT/360 day basis ); above the one year mark ( market convention ) one normally switch to a compound actualization = C * (1 + r% )^t, because you assume the capital to be reinvested at same rate for the time t ( day convention: ACT/ACT, 30/360, etc. ) which actually is not the case, but it's easy and fast to calculate ( basically it assumes a flat yield curve ). Normally in financial markets on the base of deposit, futures and swap rates, one calculate a zero curve ( with the bootstrapping method ) and from there a REAL the discount curve, for each maturity.
having that you can calculate the pv any of your investments.
There are currently 1 users browsing this thread. (0 members and 1 guests)