David wrote:
How can I calculate the amount I would receive in
compound interest on a fixed amount at a fixed
interest rate for a fixed peirod.

One way:

=FV(rate,nper,0,pv) - pv

where "rate" is the "fixed interest rate" per
compounding period (e.g, 2.5%/365 for daily
compounding), "nper" is the number of compounding
periods over the "fixed period" (e.g, 5*365 for
daily compounding over 5 yr), and "pv" is the
"fixed amount".