**Allocation of Profits and Losses in a Partnership** **The Scenario:** The Ace and Deuce partnership has been created to operate a law firm. The partners are attempting to devise a fair system to allocate profits and losses between Ace and Deuce. However, Deuce has more experience and can charge a higher hourly rate. Ace expects to work more billable hours each year than Deuce. Ace also plans to invest more money in the business than Deuce. **Required:** Build a spreadsheet that can be used to allocate profits and losses to these two partners each year. The spreadsheet should be constructed so that the following variables can be entered: 1. Net income for the year. 2. Number of billable hours for each partner. 3. Hourly rate for each partner. 4. Capital investment by each partner. 5. Interest rate on capital investment. 6. Profit and loss ratio. **Instructions:** 1. **Initial Scenario:** - Partnership net income for the current year is $200,000. - The number of billable hours is 2,000 for Ace and 1,500 for Deuce. - The hourly rate for Ace is $20 and for Deuce is $30. - Capital investment by Ace is $80,000 and by Deuce is $50,000. - Interest on capital will be accrued each year at 10 percent of the beginning balance. - Any remaining income amount will be split 50-50. 2. **First Exercise:** - Use this spreadsheet to determine the allocation if partnership net income for the current year is $200,000, the number of billable hours is 2,000 for Ace and 1,500 for Deuce, the hourly rate for Ace is $20, and for Deuce is $30, and investment by Ace is $80,000 and by Deuce is $50,000. Interest on capital will be accrued each year at 10 percent of the beginning balance. Any remaining income amount will be split 50-50. 3. **Adjustment Scenario:** - Use the spreadsheet a second time but make these changes: Deuce reports 1,700 billable hours, Ace invests $100,000, and interest will be recognized at a 12 percent annual rate. How do these three changes impact the allocation of the $200,000?
**Allocation of Profits and Losses in a Partnership** **The Scenario:** The Ace and Deuce partnership has been created to operate a law firm. The partners are attempting to devise a fair system to allocate profits and losses between Ace and Deuce. However, Deuce has more experience and can charge a higher hourly rate. Ace expects to work more billable hours each year than Deuce. Ace also plans to invest more money in the business than Deuce. **Required:** Build a spreadsheet that can be used to allocate profits and losses to these two partners each year. The spreadsheet should be constructed so that the following variables can be entered: 1. Net income for the year. 2. Number of billable hours for each partner. 3. Hourly rate for each partner. 4. Capital investment by each partner. 5. Interest rate on capital investment. 6. Profit and loss ratio. **Instructions:** 1. **Initial Scenario:** - Partnership net income for the current year is $200,000. - The number of billable hours is 2,000 for Ace and 1,500 for Deuce. - The hourly rate for Ace is $20 and for Deuce is $30. - Capital investment by Ace is $80,000 and by Deuce is $50,000. - Interest on capital will be accrued each year at 10 percent of the beginning balance. - Any remaining income amount will be split 50-50. 2. **First Exercise:** - Use this spreadsheet to determine the allocation if partnership net income for the current year is $200,000, the number of billable hours is 2,000 for Ace and 1,500 for Deuce, the hourly rate for Ace is $20, and for Deuce is $30, and investment by Ace is $80,000 and by Deuce is $50,000. Interest on capital will be accrued each year at 10 percent of the beginning balance. Any remaining income amount will be split 50-50. 3. **Adjustment Scenario:** - Use the spreadsheet a second time but make these changes: Deuce reports 1,700 billable hours, Ace invests $100,000, and interest will be recognized at a 12 percent annual rate. How do these three changes impact the allocation of the $200,000?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please assist with this problem
thank you
![**Allocation of Profits and Losses in a Partnership**
**The Scenario:**
The Ace and Deuce partnership has been created to operate a law firm. The partners are attempting to devise a fair system to allocate profits and losses between Ace and Deuce. However, Deuce has more experience and can charge a higher hourly rate. Ace expects to work more billable hours each year than Deuce. Ace also plans to invest more money in the business than Deuce.
**Required:**
Build a spreadsheet that can be used to allocate profits and losses to these two partners each year. The spreadsheet should be constructed so that the following variables can be entered:
1. Net income for the year.
2. Number of billable hours for each partner.
3. Hourly rate for each partner.
4. Capital investment by each partner.
5. Interest rate on capital investment.
6. Profit and loss ratio.
**Instructions:**
1. **Initial Scenario:**
- Partnership net income for the current year is $200,000.
- The number of billable hours is 2,000 for Ace and 1,500 for Deuce.
- The hourly rate for Ace is $20 and for Deuce is $30.
- Capital investment by Ace is $80,000 and by Deuce is $50,000.
- Interest on capital will be accrued each year at 10 percent of the beginning balance.
- Any remaining income amount will be split 50-50.
2. **First Exercise:**
- Use this spreadsheet to determine the allocation if partnership net income for the current year is $200,000, the number of billable hours is 2,000 for Ace and 1,500 for Deuce, the hourly rate for Ace is $20, and for Deuce is $30, and investment by Ace is $80,000 and by Deuce is $50,000. Interest on capital will be accrued each year at 10 percent of the beginning balance. Any remaining income amount will be split 50-50.
3. **Adjustment Scenario:**
- Use the spreadsheet a second time but make these changes: Deuce reports 1,700 billable hours, Ace invests $100,000, and interest will be recognized at a 12 percent annual rate. How do these three changes impact the allocation of the $200,000?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F44a47ef5-656d-44be-9b7c-c8791b8fa2d1%2F0ce58e2e-c20a-40c0-b224-ea248371819f%2Fdcbmxk.jpeg&w=3840&q=75)
Transcribed Image Text:**Allocation of Profits and Losses in a Partnership**
**The Scenario:**
The Ace and Deuce partnership has been created to operate a law firm. The partners are attempting to devise a fair system to allocate profits and losses between Ace and Deuce. However, Deuce has more experience and can charge a higher hourly rate. Ace expects to work more billable hours each year than Deuce. Ace also plans to invest more money in the business than Deuce.
**Required:**
Build a spreadsheet that can be used to allocate profits and losses to these two partners each year. The spreadsheet should be constructed so that the following variables can be entered:
1. Net income for the year.
2. Number of billable hours for each partner.
3. Hourly rate for each partner.
4. Capital investment by each partner.
5. Interest rate on capital investment.
6. Profit and loss ratio.
**Instructions:**
1. **Initial Scenario:**
- Partnership net income for the current year is $200,000.
- The number of billable hours is 2,000 for Ace and 1,500 for Deuce.
- The hourly rate for Ace is $20 and for Deuce is $30.
- Capital investment by Ace is $80,000 and by Deuce is $50,000.
- Interest on capital will be accrued each year at 10 percent of the beginning balance.
- Any remaining income amount will be split 50-50.
2. **First Exercise:**
- Use this spreadsheet to determine the allocation if partnership net income for the current year is $200,000, the number of billable hours is 2,000 for Ace and 1,500 for Deuce, the hourly rate for Ace is $20, and for Deuce is $30, and investment by Ace is $80,000 and by Deuce is $50,000. Interest on capital will be accrued each year at 10 percent of the beginning balance. Any remaining income amount will be split 50-50.
3. **Adjustment Scenario:**
- Use the spreadsheet a second time but make these changes: Deuce reports 1,700 billable hours, Ace invests $100,000, and interest will be recognized at a 12 percent annual rate. How do these three changes impact the allocation of the $200,000?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education