Savings interest monthly

JulianoTrevizan 

• If you are dealing with Simple Interest then use this table:

Quarterly:       i/4

Monthly:         i/12

Fortnightly:     i/26

Weekly:           i/52

Daily:              i/365

**Where i is rate of interest.

For example convert  Annual 4% to monthly should  =4%/12

.

• If you are dealing with Compound Interest then use this table:

Quarterly:        (1 + i)^(1/4) - 1

Monthly:          (1 + i)^(1/12) - 1

Weekly:            (1 + i)^(1/52) - 1

Daily:                (1 + i)^(1/365) - 1

**Where i is rate of interest.

For example convert Annual 4% to monthly should  =(1 + 0.4)^(1/12) - 1.

Check the cell L6 & N6 on the Savings sheet.