Ravi Sir's Cards › Excel
FD Calculator in Excel
Revision card 1 for FD Calculator in Excel: Maturity amount, rounded to rupees: =ROUND(FV(B6/B9,B9*B7,0,-B5),0) gives ₹1,41,478; Interest earned: =B10-B5 gives ₹41,478; Effective yearly yield: =(1+B6/B9)^B9-1 gives 7.19%.
Read card text
What this card says
1 for FD Calculator in Excel: Maturity amount, rounded to rupees: =ROUND(FV(B6/B9,B9*B7,0,-B5),0) gives ₹1,41,478
Interest earned: =B10-B5 gives ₹41,478
Effective yearly yield: =(1+B6/B9)^B9-1 gives 7.19%.
Learn this in the lesson: FD Calculator in Excel: Maturity Amount and Interest with Quarterly Compounding (Compare 3 Offers)