Simple xls! Cash flow report loan data

I'm looking to create a cash flow report from loan data in a spreadsheet. See attached. Should be easy for a data whiz!!! See input data tab on the attached, and then the template for the output table that will include the summary amount of payments (e.g. total cash paid on all the loans) by month until there is no more payment on any loan.