acct405 WEEK 8: INDIVIDUAL EXCEL PROJECT

Question # 00729001 Posted By: shortone Updated on: 06/30/2019 04:28 AM Due on: 06/30/2019
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image

Question

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?

Dot Image
Tutorials for this Question
  1. Tutorial # 00729542 Posted By: shortone Posted on: 06/30/2019 04:29 AM
    Puchased By: 3
    Tutorial Preview
    The solution of acct405 WEEK 8: INDIVIDUAL EXCEL PROJECT...
    Attachments
    act405.zip (300.75 KB)

Great! We have found the solution of this question!

Whatsapp Lisa