hi all good people,
As I am a new excel user and don't know how to work with formulas.

My question is if two partners are running a small business and investing
money and takes back when they are getting profit from business i a formula
to calculate.

Example,

Partner 1 invested 50,000
Partner 2 invested 25,000
profit earned by their business 100,000

both partners are want to get refund of their investment and the amount of
profit shared in 50:50
how to calculate this by formula.

I am hopeful to get answer from u good people.

Aarif