Question: I need some help please (Marks: 15) Question 4 Beth, Heather, Claudia and Bianca have decided to start a new business. The four partners agree

 I need some help please (Marks: 15) Question 4 Beth, Heather,

I need some help please

(Marks: 15) Question 4 Beth, Heather, Claudia and Bianca have decided 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. In the Excel answer book for Question 4, create the following: A 0 H Beth Heather Claudia Bianca 199000 55000 44000 2 Contribution to start-up capital (Rands] = 242000 3 14 Contributions as ratio= 15 6 Share of first year's profit of R154000- 7 Share of second year's profit= Second year's total profit = Q.4.1 Express the respective contributions of the four partners as a ratio in cells B4 to E4, using an appropriate formula. Q.4.2 Determine each partner's share of the first year's profit of R154 000 by entering a suitable function/formula in cells 86 to E6. (4) Q.4.3 Given that Heather's share of the second year's profit is R37 350, determine the total profit made by the business that year, by inserting an appropriate formula into cell H8. Q.4.4 Determine each of the other partner's shares of the second year's profit by inserting (3) 17

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!