Problem 13-3 (LO 3, 4) Evaluating whether or not to continue to share profits. Raymond is a senior partner in a manufacturing firm and is approaching retirement age. In dis- cussing succession planning with the company partners, two alternatives have been presented to Raymond. The first alternative would call for Raymond to receive a distribution of his share of current-year 2015 profits on March 31, 2016, along with a lump sum payment of $1,500,000 for his capital balance. The 2015 profit-sharing agreement is as follows:

RaymondOther Partners

Salaries $125,000 $300,000

Bonus on income after bonus 10% 0%

Percentage of remaining profits 40% 60%

The second alternative would consist of the following components:

1. Adistributionofhisshareofcurrent-yearprofitsonMarch31,2016.

2. A distribution of his share of 2016?2017 profits on March 31 of each subsequent year. The profit-sharing agreement for 2016 and 2017 would be modified from the 2015 agreement as follows:

RaymondOther Partners

Salaries $80,000 $350,000

Bonus on income after bonus 0% 10%

Percentage of remaining profits 20% 80%

3. On March 31, 2018, Raymond would receive a lump sum payment of $1,700,000 for his interest in capital.

In order for Raymond to make an informed decision he has come to you seeking your advice on which alternative to accept. Raymond believes that they can invest all cash proceeds at a rate of 8% compounded annually. It is anticipated that the partnership will have income for years 2015?2017 of $550,000, $605,000, and $682,000, respectively.

Please use the attached spreadsheet that was provided by the professor.

Problem 13-3 Analysis of First Alternative Cash flow components: 2016 March 31, 2017 2018 Distribution of prior years income........................... Distribution of capital investment............. Return on proceeds ....... Total................................................ Present value index........................... Net present value............................... Allocation of $550,000 of Partnership Income Raymond Other Partners Profit and loss percentage.......................... Salary......................................................... Bonus (see below)........................................ Balance.................................................... Total........................................................... Bonus Year 2016 2017 Interest Rate Return on Proceeds Amount Invested Return Analysis of Second Alternative Cash flow components: 2016 March 31 2017 2018 Distribution of prior years income ........................... Distribution of capital investment............. Return on proceeds .......... Total................................................ Present value index........................... Net present value............................... Year 2016Allocation of $605,000 of Partnership Income Other Raymond Partners Profit and loss percentage.......................... Salary......................................................... Bonus (see below)........................................ Balance.................................................... Total........................................................... Year 2017Allocation of $682,000 of Partnership Income Other Raymond Partners Profit and loss percentage.......................... Salary......................................................... Bonus (see below)........................................ Balance.................................................... Total........................................................... Bonus Bonus Year 2016 2017 Interest Rate Return on Proceeds Amount Invested Return Total e Cumulative Total Total Income Cumulative Total Income Cumulative Total