Finish Spreadsheet Settlement For Free

Start by entering names of the people in your group in tab ?Expenses?, row 7, starting in column G and moving to the right. With each new expense you enter, simply click the checkboxes beneath the individual's name if he/she was part of that expense (including the person who paid for it).

=PMT(17%/12,212,5400) For example, in this formula the 17% annual interest rate is divided by 12, the number of months in a year. The NPER argument of 212 is the total number of payment periods for the loan. The PV or present value argument is 5400.

Once you have created an expense, enter the amount in the ?Amount? column and select the name of the person who paid from the drop-down in the ?Who Paid?? column. To include people in the split for an expense, just put an ?X? in the cell under their name.

Each person pays the same percentage as they make Add your individual incomes together to get your total household income. Then calculate the percentage of that total each partner makes. Add up all the expenses you've agreed to split. Then use the percentages from step two to see how much you're each responsible for.

To figure out how much each person owes, we use the SUMPRODUCT() formula to add up all the per person costs that a given friend is responsible for. In the image below, you can see how the SUMPRODUCT() formula simply multiplies the ?1? or ?0? in a given column with the per person cost in Column L.

Using the Expense Report Template in Excel: For each expense, enter the date and description. Use the dropdown menus to select payment type and category for each expense. For each expense, enter the total cost. Attach all necessary receipts to the document. Submit for review and approval!

Settlement is the process of reviewing the revenue and expenses associated with an event. Once the box office closes, you get to have a math party to calculate the profit and loss of the show. Depending on the agreed terms, you may also be determining the artist's final payout.