Vampiress And Mindzai Spread Sheets

[windymiller2014]

VAMPIRESS AND MINDZAI SHEETS

 

I was just doing a final check today on spread sheets and have noted that maybe, some formulas are wrong using the above authors sheets. I Downloaded v18 of mindzai and vamps compounded contractual interest just before christmas, both sheets gave the same answer which was good, however, I loaded a new vamp compounded contractual today submitting the same figures and got a different answer. the formulas to question in vamps sheet are:

to day showing =(B13*(1+($B$7/365))^($B$6-C13))-B13

before christmas showing =(B13*(1+$B$7)^(($B$6-C13)/365))-B13

 

Have vamps sheets been updated or is something wrong

[RobberBank]

Would be good if someone can clarify before i send my claim off in the post tomorrow!

[Janet-M]

I will point this thread to Vamps for you

[blueskies]

I have sent a PM gazzard

[RobberBank]

=(B13*(1+($B$7/365))^($B$6-C13))-B13 ......

 

.....is the correct one according to my figures. I tested it by using one entry (£30) for the date 6/6/01 and then multiplying this by (29.69% / 365) . Carry the sum of this over to the next day (7/6/01) and then apply the same calculation.....and so and so on.....until todays date and it works out exactly the same.

 

Well at least i know what i mean!!!!

[bram stoker]

The formulae have since changed in my spreadsheets.