If you deposit 1000 in a bank account which is paying 3 compound interest per year. Is now live on Udemy. The trick to using a spreadsheet for compound interest is using compounding periods instead of simply thinking in years.
PV FV 1rn.
A P1 rn nt. If you have borrowed money from a bank or building society for a mortgage. T Time Involved in years 05 years is calculated as 6 months etc. The trick to using a spreadsheet for compound interest is using compounding periods instead of simply thinking in years.