Hi,

I need to calculate amounts for 4 years, start date: March 1, 2012 and end date: June 1, 2015

The monthly payment is $2500. I need the annual total for year 1 to year 4 (which year 4 will not be a full year as well).

How would this formula be in Excel 2010?

Thanks for the help.


Vinnie