Carmelo Fernandez and Bobby Morett formed a partnership, investing $$67,500$ and $$202,500,$ respectively.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

Determine their participation in the year's net income of $$275,000$ under each of the following independent assumptions:

a$.$ No agreement concerning division of net income.

b$.$ Divided in the ratio of original capital investment.

c$.$ Interest at the rate of $6\%$ allowed on original investments and the remainder divided in the ratio of $2$:$3.$

d$.$ Salary allowances of $$40,000$ and $$49,000,$ respectively, and the balance divided equally.

e$.$ Allowance of interest at the rate of $6\%$ on original investments, salary allowances of $$40,000$ and $$49,000,$ respectively, and the remainder divided equally.