How to calculate expenses in a dynamic cash

sarena76

New Member
Joined
Jul 5, 2019
Messages
1
I have 4 columns for each partner.

Contribution
Expenses
Balance
%Balance



In the second column (Expenses) I see the expenses that are being made and that should be divided among those people who have a contribution percentage (see the last column), and each one will spend based on that percentage

The problem appears when another person wants to contribute. For example, Dante e Selene have invested 100€ each one, then spent 20€ and the expense was divided according to the percentage of the balance. If Michele wants to invest 100 and then there is a new expense, the new expense should be divided according to the NEW percentage of the balance. The old expenses should not be add to MICHELE but only the expenses post-date investment from MICHELE.

Instead, the old expenses are also divided by Michele ...
At the time of the old expense (20€) Michele had not invested yet and then he would not have to pay anything ...
It has to be this way for each person who invests successively
Past expenses should not be calculated among those people who invest now

[the well ](https://docs.google.com/file/d/1YT-...qtbaIW/edit?usp=docslist_api&filetype=msexcel)

I hope you can help me…
Thank you in advance
Sebastian A.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top