The Distance Plus partnership has the following capital balances at the beginning of the current year along with respective profit and loss percentages:

Tiger $(40\%)$ $$60,00040\%$

Phil $(30\%)30,00030\%$

Ernie $(30\%)45,00030\%$

Sergio invests $$60,00020\%$

Required:

Note: Use the cells A$2$ to C$8$ from the above information to complete this question.

Prepare a schedule calculating the balance to be credited to each partner's account if Sergio invests $$60,000$ for a $20\%$ interest. Assume the bonus method is used.

Tiger Phil Ernie Sergio

I arrived to the balances to be credited below but my results are not correct per grading system... Please give me support

Sergio investment $$8,400$ $$6,300$ $$6,300$ $$39,000$