Interest Calculation

I am trying to calculate interest for an amount that has different interest rates for each year. The interest does not compound, rather just computes on the original amount.

E.g. I have an amount of $1000.00 paid on 1/31/2016, but was due on 1/31/12. Interest rates were 3%, 3%, 3%, 3%, and 4% for 2012-2016 respectively.

The formula I need to create is to count the number of days in each year for which the payment was late and multiply those days by the daily interest rate. So in this scenario, 1827 days total (which I can calculate easily). I need to be able to calculate 336 days for 2012, 365 days for 2013, etc.

In this scenario, I can do it by hand and get $24.02 in interest.

Additional Info...I have the table shown below in my spreadsheet. I need a formula that will count days in each year and multiply those days by the rate in the last column.

Start Date = 1/31/12
End Date = 1/31/16
Total Days = 1827

2017 4.00% 365 0.000109589
2016 4.00% 366 8.19672E-05
2015 3.00% 365 8.21918E-05
2014 3.00% 365 8.21918E-05
2013 3.00% 365 8.21918E-05
2012 3.00% 366 8.19672E-05
2011 4.00% 365 0.000109589
2010 4.00% 365 0.000109589
2009 5.00% 365 0.000136986
2008 8.00% 366 0.000218579
2007 8.00% 365 0.000219178
2006 6.00% 365 0.000164384
2005 5.00% 365 0.000136986
2004 4.00% 366 0.00010929
2003 6.00% 365 0.000164384
2002 7.00% 365 0.000191781
2001 9.00% 365 0.000246575
2000 8.00% 366 0.000218579

Thank you sir! This solved my issue.