Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Of The Future The Impact Of Technology Innovation

Authors: An Anthology Compiled And Contributed To By A. Michael Smith

1st Edition

1634540638, 978-1634540636

More Books

Students also viewed these Accounting questions

Question

What is the orientation toward time?

Answered: 1 week ago

Question

4. How is culture a contested site?

Answered: 1 week ago