computation in excel

Problem: The partnership of Cruz, Vidal and Santos have capital account balances as follows: Cruz, P35,000.00; Vidal, P50,000.00; Santos, P40,000.00. Their profit and loss ratios are 30%, 50%, and 30% respectively. With the consent and knowledge of Cruz and Vidal, Santos sold his full interest to Roxas. Santos was paid P46,000.00 in cash. Question no. 1. The new capital balances would be: a. Cruz, P35,000.00' Vidal, P50,000.00; Roxas, P46,000.00 b. Cruz, P36,800.00; Vidal, P53,000.00; Roxas, P41,200.00 c. Cruz, P35,000.00; Vidal, P50,000.00; Roxas, P40,000.00 d. Answer not given