How to Summarize Multiple Business Loans Amortization Schedules

[Jeff_G]

Hi, I am looking for an excel workbook or formula to do the following:

1. I need to create multiple notes receivable amortization schedules (preferably all in one workbook and one loan to a tab);
2. Create a summary tab to summarize the balances of the loans at the end of a reporting period to understand the remaining principle and interest earned (summary tab within the workbook);
3. The note receivable amortization schedules will have various start and end dates;

Does anyone have any suggestions on an existing workbook or formula and how to structure the data?

Thank you
Jeff

 

[Jim J J]

Hi, I am looking for an excel workbook or formula to do the following:

1. I need to create multiple notes receivable amortization schedules (preferably all in one workbook and one loan to a tab);
2. Create a summary tab to summarize the balances of the loans at the end of a reporting period to understand the remaining principle and interest earned (summary tab within the workbook);
3. The note receivable amortization schedules will have various start and end dates;

Does anyone have any suggestions on an existing workbook or formula and how to structure the data?

Thank you
Jeff

I have the exact same situation. Did you find a solution ? Thanks