Instructions
1. Make a copy of this template and keep it as a backup
2. Only fill in values in the white blocks.
3. Grey cells contain formulas
4. Red cells contain instructions
5. Green Cells contain the resulting ratios.
6. These examples are based on Examples given in the text book
Scenario A
Example 3.3 page 111
Calculation of a new profit-sharing ratio where the previous partners
Fill in the existing ratios previous profit-sharing ratio, a profit share to a new partner
Old ratio
Partner 1 2
Partner 2 3
New Partner Ratio
Denominators of old
partnership 5
Fill in new Parteners Ratio
New partner Ratio
Fill in 1 in Numerator
Fill in 5 in Denominator Numerator: 1
Denominator: 3
if the new partners ratio is 1/5
Scenario B
Example 3.4 page 112
Calculation of a new profit-sharing ratio where the previous partners
Fill in the existing ratios partner
Old ration
Partner 1 2
Fill in the ratio at which
shares will be relinquished. If
it is equal, fill in 1 for both
partners
1. Make a copy of this template and keep it as a backup
2. Only fill in values in the white blocks.
3. Grey cells contain formulas
4. Red cells contain instructions
5. Green Cells contain the resulting ratios.
6. These examples are based on Examples given in the text book
Scenario A
Example 3.3 page 111
Calculation of a new profit-sharing ratio where the previous partners
Fill in the existing ratios previous profit-sharing ratio, a profit share to a new partner
Old ratio
Partner 1 2
Partner 2 3
New Partner Ratio
Denominators of old
partnership 5
Fill in new Parteners Ratio
New partner Ratio
Fill in 1 in Numerator
Fill in 5 in Denominator Numerator: 1
Denominator: 3
if the new partners ratio is 1/5
Scenario B
Example 3.4 page 112
Calculation of a new profit-sharing ratio where the previous partners
Fill in the existing ratios partner
Old ration
Partner 1 2
Fill in the ratio at which
shares will be relinquished. If
it is equal, fill in 1 for both
partners
