John, Paul, George and Richard decide to start a new business. The four partners agree that any profit or loss made by the new business will be shared in the same ratio as their contributions to
the start-up capital of the business. Their respective contributions are indicated in the figure
below. In the fourth worksheet of your Excel answer book provided, create the following:
F
G
1
A
H o
John Paul George Richard
Contribution to start-up capital (in rands) = 30000 60000 40000 20000
2.
Contributions as ratio =
15
LE
share of first year's proflt of R50 000=
Share of second year's profil =
54000
Second year's profit =
Express the respective contributions of the four partners as a ratio in cells B4 to​