Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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: 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 B6 to E6. 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 an appropriate formula into cells B8, D8 and E8
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started