Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. Ace plans to work more billable hours each year than Deuce. However, Deuce has more experience and can charge a higher hourly rate. Ace expects 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:

Net income for the year.

Number of billable hours for each partner.

Hourly rate for each partner.

Capital investment by each partner.

Interest rate on capital investment.

Profit and loss ratio.

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.

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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Anxiety Audit

Authors: Lynn Lyons

1st Edition

0757324258, 978-0757324253

More Books

Students also viewed these Accounting questions