Spreadsheet: 525586d1498787990-interest-calculations-for-a-duration-of-period-with-compound-interest-on-quarterly-basis-compound-interest-calculations
Sheet: PF-Investments

2013-07-15 00:00:00 |  |  |  |  |  |  |  |  | NEED FORMULA IN  FOR ARRIVING THE FIGURE IN COLUMN "C"BASED ON THE PRINCIPLE OF ACCUMULATED COMPOUND INTEREST OF 90 DAYS. FOR EVERY 90 DAYS, THE INTEREST WILL BE ADDED TO PRINCIPAL TO CALCULATE THE INTEREST.  The interest formula in a such way that I can calculate interest for any number of days applying the principle of accumulated interest for a period of 90 days each.
 | Amount Invested | Interest | Maturity Value | Date of Investment | Date of Maturity | No. of             days | Rate of Interest | Remarks
 | 5000000 |  | 10017128 | 2011-11-26 00:00:00 | 2019-02-26 00:00:00 |  | 0.097
 | 5000000 |  | 10017128 | 2011-11-26 00:00:00 | 2019-02-26 00:00:00 |  | 0.097
 | 25000000 | 14489990 | 39489990 | 2012-02-18 00:00:00 | 2017-02-17 00:00:00 |  | 0.0925
 | 2700000 | 1565182 | 4265182 | 2012-04-05 00:00:00 | 2017-04-05 00:00:00 |  | 0.0925
 | 5000000 |  | 10017128 | 2012-05-28 00:00:00 | 2019-08-28 00:00:00 |  | 0.097
 | 5000000 |  | 10017128 | 2012-05-29 00:00:00 | 2019-08-28 00:00:00 |  | 0.097
 | 9500000 |  | 11960005 | 2016-03-06 00:00:00 | 2019-03-06 00:00:00 |  | 0.0775
 | 9500000 |  | 11960005 | 2016-03-06 00:00:00 | 2019-03-06 00:00:00 |  | 0.0775
 | 9500000 |  | 11960005 | 2016-03-06 00:00:00 | 2019-03-06 00:00:00 |  | 0.0775
 | 4488126 |  | 5650317 | 2016-03-06 00:00:00 | 2019-03-06 00:00:00 |  | 0.0775
 | 9900000 |  | 12948091 | 2016-03-09 00:00:00 | 2017-11-25 00:00:00 |  | 0.0905
 | 9900000 |  | 12948091 | 2014-11-25 00:00:00 | 2017-11-25 00:00:00 |  | 0.0905
 | 9900000 |  | 12948091 | 2014-11-25 00:00:00 | 2017-11-25 00:00:00 |  | 0.0905
 | 9900000 |  | 12948091 | 2014-11-25 00:00:00 | 2017-11-25 00:00:00 |  | 0.0905
 | 1962468 |  | 2566689 | 2014-11-25 00:00:00 | 2017-11-25 00:00:00 |  | 0.0905
 | 1500000 |  | 1961833 | 2014-11-19 00:00:00 | 2017-11-18 00:00:00 |  | 0.0905
 | 9900000 |  | 12648226 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 9900000 |  | 12648226 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 9900000 |  | 12648226 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 9900000 |  | 12648226 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 9900000 |  | 12648226 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 9900000 |  | 12648226 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 7068158 |  | 9030269 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 1120875 |  | 1432028 | 2015-10-02 00:00:00 | 2018-10-02 00:00:00 |  | 0.0825
 | 16000000 |  | 17031429 | 2015-08-14 00:00:00 | 2016-05-28 00:00:00 |  | 0.08
 | 8000000 |  | 8384109 | 2015-10-26 00:00:00 | 2016-06-26 00:00:00 |  | 0.07
 | 9000000 |  | 9419356 | 2015-11-18 00:00:00 | 2016-06-28 00:00:00 |  | 0.075
 | 3500000 |  | 3663083 | 2015-11-18 00:00:00 | 2016-06-28 00:00:00 |  | 0.075
 | 6499145 |  | 6885739 | 2015-11-18 00:00:00 | 2016-08-28 00:00:00 |  | 0.075
 | 9000000 |  | 9741889 | 2015-09-30 00:00:00 | 2016-09-30 00:00:00 |  | 0.08
 | 8500000 |  | 9200673 | 2015-09-30 00:00:00 | 2016-09-30 00:00:00 |  | 0.08
 | 3000000 |  | 3164097 | 2016-01-12 00:00:00 | 2016-09-29 00:00:00 |  | 0.075
 | 3000000 |  | 3168151 | 2015-11-16 00:00:00 | 2016-08-29 00:00:00 |  | 0.07
 | 4200000 |  | 4429735 | 2015-12-11 00:00:00 | 2016-08-29 00:00:00 |  | 0.075
 | 9000000 |  | 9455823 | 2015-12-31 00:00:00 | 2016-08-29 00:00:00 |  | 0.075
 | 3000000 |  | 3218861 | 2016-02-19 00:00:00 | 2017-01-30 00:00:00 |  | 0.075
 | 6000000 |  | 6532338 | 2016-02-19 00:00:00 | 2017-03-30 00:00:00 |  | 0.0775
 | 2500000 |  | 2610090 | 2016-02-29 00:00:00 | 2016-09-27 00:00:00 |  | 0.075
 | 1500000 |  | 1575651 | 2016-02-29 00:00:00 | 2016-10-27 00:00:00 |  | 0.075