Dividing partnership income Beau Dawson and Willow McDonald formed a partnership, investing $180,000 and $60,000, 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 5% allowed on original investments and the remainder divided in the ratio of 2:3. d. Salary allowances of $40,000 and $46,000, respectively, and the balance divided equally. e. Allowance of interest ot the rate of 5% on original investments, salary allowances of $40,000 and $46,000, respectively, and the remainder divided equally, Diving partnershy income Beau Dawson and Willow McDonald formed a partnership. The dota on their investing ts provided in the table below. Uing formulas and cell references, perform the required antlysis, and inpot your answers inso the Beou Dawson and Willow MeDonald columns. Transfer the numenic results for the green enty cets (B14,C14,B19,C19,B26.C26,B33,C33,B41,C41) into the appropriate fields in CNOWV tor grading . No agrenmont concorning division a nat inwima. c. Interest allowed on original invectments Remainder divided in the ratio of Formulas Boou Dawson Wilow McDonald Beav Dawson Wilow McDonald d. Boau Dawson's salary allowance $40,000 Willow McDonald's saiary allowance. $46,000 The balance divided equally. Beau Dawson Willow McDonaid Beau Diwson Formulas \begin{tabular}{ll} \hline 5. Interest allowed on original ivvestiments & \\ Beau Dawson's salayy allowance & 5%4 \\ Willow McOonalde salary allowance & $40,000 \\ \end{tabular} 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 5% allowed on original investments and the remainder divided in the ratio of 2:3. d. Salary allowances of $40,000 and $46,000, respectively, and the balance divided equally. e. Allowance of interest at the rate of 5% on original investments, salary allowances of $40,000 and $46,000, respectively, and the remainder divided equally. Track thy Work Set up a column for each partner and a total column. a. Determine the distribution of income and losses in the absence of a partnershlp agreement. b. Use the ratio of the partner's oniginal capital investment to distribute the net income