Track Remaining Amounts with Staggered Dates

[Kimber]

A friend has 10 "loans" that will need to be paid back (if he leaves the company) in full the first year, 80% the second year, 60% after three years, 40% after four years, 20% after five years, and 0 after six years. Easy for one date and amount. However, he has roughly ten dates with different amounts. He would like to be able to see what is due today for each "loan" as well as the total due as of today's date. Thank you all for your help!

 

[Peter Bartholomew]

 

[Kimber]

Thank you, Peter! I needed to use the entire date so I ended up using the YEARFRAC function. I appreciate your help!

 

[Peter Bartholomew]

Glad you got there. You would probably had more answers if you had attached a sample workbook with the OP though.

 

[Kimber]

Glad you got there. You would probably had more answers if you had attached a sample workbook with the OP though.

I'll attach what I had before your answer. I am sorry I neglected to upload with my request.