The Shared Expense Calculator

Going on a trip with friends and sharing expenses?  This Excel spreadsheet is exactly what you need to calculate what everyone owes.  Enter your expenses and who is the sharing the cost, and the spreadsheet will do the rest by calculating everyone’s split and totaling what is owed by each person.  The spreadsheet will also calculate how much each person has already spent and deduct that number from what they owe.  This is a great calculator for keeping track of who paid how much and what they owe or need to be paid.  This is also a great spreadsheet for analysts to see how formulas work in Excel.