Best Offer for Books in Amazon

Showing posts with label how to use compound interest formula in Excel.. Show all posts
Showing posts with label how to use compound interest formula in Excel.. Show all posts

Friday, 22 November 2019

HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL ?

HOW TO USE COMPOUND INTEREST FORMULA IN EXCEL 
A                                                           B
Intial investment 24000
annual interest rate 8%
No. of Compounding periods 12
Years 1
   
Balance              25,991.99

in the Above table We have to find out compound interest and future value from the using given formula. 
the Compound Formula : =B3*(1+B4/B5)^(B6*B5)

B3 = Initial Investment                     : Rs. 24000/-
B4 = Annual interest Rate                : 8% p.a
B5 = no of Compound periods         : 12 
B6 = Year                                          : 1
Future Balance                                  :  Rs. 25,991.99/-


How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.