Spreadsheet: 147599d1332876391-daily-simple-interest-daily-simple-interest
Sheet: Simple

Loan Amount |  | 95000 |  |  |  |  |  | Statement
Annual interest rate % |  | 8 |  |  |  |  |  | Loan Amount |  | 95000 |  | Current balance
Daily interest rate % |  | 0.02191780821917808 |  |  |  |  |  | Annual interest rate % |  | 8 |  | 95543.56164383562
Start date |  | 2012-01-01 00:00:00 |  | Input Date. |  |  |  | Daily interest rate % |  | 0.02191780821917808
Current date |  | 2012-03-27 00:00:00 |  |  |  |  |  | Start date |  | 2012-01-01 00:00:00 |  | Total payments made
Days since loan started |  | 86 |  |  |  |  |  | Current date |  | 2012-03-27 00:00:00 |  | 5000
 |  |  |  |  |  |  |  | Days since loan started |  | 86
 |  |  |  |  |  |  | Adjusted |  |  |  |  | Additional withdrawals
Date | Beginning Daily Balance | Daily interest |  | Additional Loan | Payment Made | Current bal | Loan Amt |  |  |  |  | 5000
 |  |  |  |  |  | 95000 | 95000
2012-03-01 00:00:00 | 95000 | 20.82191780821918 | 20.82191780821918 |  |  | 95020.82191780822 | 95000 |  |  |  |  | Total interest charged
2012-03-02 00:00:00 | 95020.82191780822 | 20.82191780821918 | 41.64383561643836 |  |  | 95041.64383561644 | 95000 |  |  |  |  | 543.5616438356162
2012-03-03 00:00:00 | 95041.64383561644 | 20.82191780821918 | 62.46575342465754 |  |  | 95062.46575342467 | 95000
2012-03-04 00:00:00 | 95062.46575342467 | 20.82191780821918 | 83.28767123287672 | 5000 |  | 100083.2876712329 | 100000 |  | Loan |  | 95000
2012-03-05 00:00:00 | 100083.2876712329 | 21.91780821917808 | 105.2054794520548 |  |  | 100105.2054794521 | 100000 |  | Withdrawn |  | 5000
2012-03-06 00:00:00 | 100105.2054794521 | 21.91780821917808 | 127.1232876712329 |  | 5000 | 95127.12328767125 | 95000 |  | Interest |  | 543.5616438356162
2012-03-07 00:00:00 | 95127.12328767125 | 20.82191780821918 | 147.9452054794521 |  |  | 95147.94520547947 | 95000 |  | Total |  | 100543.5616438356
2012-03-08 00:00:00 | 95147.94520547947 | 20.82191780821918 | 168.7671232876712 |  |  | 95168.76712328769 | 95000 |  | Less paid |  | 5000
2012-03-09 00:00:00 | 95168.76712328769 | 20.82191780821918 | 189.5890410958904 |  |  | 95189.58904109591 | 95000 |  | Current balance |  | 95543.56164383562
2012-03-10 00:00:00 | 95189.58904109591 | 20.82191780821918 | 210.4109589041096 |  |  | 95210.41095890413 | 95000
2012-03-11 00:00:00 | 95210.41095890413 | 20.82191780821918 | 231.2328767123288 |  |  | 95231.23287671235 | 95000
2012-03-12 00:00:00 | 95231.23287671235 | 20.82191780821918 | 252.054794520548 |  |  | 95252.05479452058 | 95000 | This is what I am trying to do. |  |  | But I need the loan amount to change when a
2012-03-13 00:00:00 | 95252.05479452058 | 20.82191780821918 | 272.8767123287672 |  |  | 95272.8767123288 | 95000 | deposit or withdrawl is made.
2012-03-14 00:00:00 | 95272.8767123288 | 20.82191780821918 | 293.6986301369863 |  |  | 95293.69863013702 | 95000
2012-03-15 00:00:00 | 95293.69863013702 | 20.82191780821918 | 314.5205479452055 |  |  | 95314.52054794524 | 95000 | I need each day to be listed from start date to current date with all columns calculated.
2012-03-16 00:00:00 | 95314.52054794524 | 20.82191780821918 | 335.3424657534246 |  |  | 95335.34246575346 | 95000
2012-03-17 00:00:00 | 95335.34246575346 | 20.82191780821918 | 356.1643835616438 |  |  | 95356.16438356169 | 95000
2012-03-18 00:00:00 | 95356.16438356169 | 20.82191780821918 | 376.9863013698629 |  |  | 95376.9863013699 | 95000
2012-03-19 00:00:00 | 95376.9863013699 | 20.82191780821918 | 397.8082191780821 |  |  | 95397.80821917813 | 95000
2012-03-20 00:00:00 | 95397.80821917813 | 20.82191780821918 | 418.6301369863012 |  |  | 95418.63013698635 | 95000
2012-03-21 00:00:00 | 95418.63013698635 | 20.82191780821918 | 439.4520547945204 |  |  | 95439.45205479457 | 95000
2012-03-22 00:00:00 | 95439.45205479457 | 20.82191780821918 | 460.2739726027395 |  |  | 95460.2739726028 | 95000
2012-03-23 00:00:00 | 95460.2739726028 | 20.82191780821918 | 481.0958904109587 |  |  | 95481.09589041102 | 95000
2012-03-24 00:00:00 | 95481.09589041102 | 20.82191780821918 | 501.9178082191779 |  |  | 95501.91780821924 | 95000
2012-03-25 00:00:00 | 95501.91780821924 | 20.82191780821918 | 522.7397260273971 |  |  | 95522.73972602746 | 95000
2012-03-26 00:00:00 | 95522.73972602746 | 20.82191780821918 | 543.5616438356162 |  |  | 95543.56164383568 | 95000
 |  |  | #N/A |  |  |  | 95000
 |  |  | #N/A |  |  |  | 95000
 |  |  | #N/A |  |  |  | 95000
 |  |  | #N/A |  |  |  | 95000
 |  |  | #N/A |  |  |  | 95000