Question: how to calculate compound interest on daily basis in excel?
Answer: Daily Compound Interest = Ending Investment – Start Amount.
Daily Compound Interest = [Start Amount * (1 + (Interest Rate / 365)) ^ (n * 365)] – Start Amount.
Daily Compound Interest = [Start Amount * (1 + Interest Rate) ^ n] – Start Amount.