posted
Okay, so I'm not the brightest bulb on the tree when it comes to mathmatics. It really bugs me and I've been trying to fill in gaps where poor math teachers and my lack of discipline caused me to realize that I'm a little slow in this department.
So anyways, I have some questions. I posted this in another forum, but there's only one fellow there that likes to do this sort of thing and I'm loathe to place the burden of my idiocy on his shoulders.
What I'm trying to do is compute daily compound interest for a few days at a time. I'm trying to build a calculator in excel that will make this job easier in the future. I've applied some formulas I've found in other places, but my numbers just don't seem to be adding up. I must be making an error.
So I'll repeat the short discussion here:
quote:Let me define some of these variables: FV = Future Value PV = Present Value i = Interest (yearly) n = Investment Period
Here's the compound interest formula, modified to calculate interest in days rather than years. It might be wrong too:
quote:FV = PV (1+(i/365))^n
Here's the same equation, solving for i:
quote:i = ((FV/PV)^(1/(n/365))-1)
I need to use that equation, because it's the only way to solve nth roots in excel...
Again, solving for n:
quote:n = (ln(FV/PV)/ln(1+(i/365))
And solving for PV:
quote:PV = FV/(1+(i/365)^n)
Am I wrong? These formulas just don't seem to be calculating right in Excel. Is it a rounding problem or am I just dumber at math than a 1st grade drop out?
Printer-friendly view of this topic
