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 The Distance Plus partnership has the following capital balances at the beginning of the current year along with respective profit and

loss percentages:

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.

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$

I have errors in the excel cells B$4,$ C$4,$ D$4,$ E$4$ I am not sure how to correct them... Thanks