Interestprincipalrateterm So using cell references we have. The formula below does the trick. For example if the annual interest rate on your mortgage is 8 you would use 008 in the compound interest formula.
Simple Interest Principal Interest Rate Time Period.
C5 C7 C6 1000 10 005 500. The future value of the investment rounded to 2 decimal places is 12210. Simple Interest Principal Interest Rate Time Period. BeginalignedtextBeginning Valuetimesleft1leftfractextinterest ratetextNCPPY.