MHB Find the value for calculate percentage

[prashant1]

Hi Friends,

I have x gross amount a = 1739598, Rate of interest R = 5%, and day difference d = 1. Future cash flow f = 176100

now npv = f/(1+r)^(d/360) i.e. 176100/(1+0.05)^(1/360) = 176076.135095

PA = a - npv i.e. 1739598 - 176076.135095 = 1563521.8649 round off value 1563522

rate CR = (PA/A)*100 i.e. (1563521.8649/1739598)*100 = 89.8783512053% round off 89.88%

Now i want to find the Future Cash flow f so that my CR rate will be exactly 89.00%

 

[tkhunny]

Note: 0.05 * 100 = 5 = 500% not 5%
Note: 0.05 = 5%

Have you considered working backwards?

However, your multiple uses of "round off value" suggest that it may not be possible. It is no longer a continuous process when you do that.

0.8900000 = What / 1739598? What = 1548242.22 -- No rounding allowed.
etc. Keep going backwards until you find your solution. Let's see your work.

Of course, "exactly" is a little dubious. You are using 360 days. Those increments are quite a bit larger than pieces of 365 days, or even 366 days.