Use spreadsheet to determine allocation, Financial Accounting

Assignment Help:

The Red and Blue partnership has been created to operate a law firm. The partners have been attempting to devise a fair system to allocate profits and losses. Red plans to work more billable hours each year than Blue. However, Blue has more experience and can charge a higher hourly rate. Red expects to invest more money in the business than Blue.
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 spreadsheet to determine allocation if partnership net income for the current year is $200,000, the number of billable hours is 2,000 for Red and 1,500 for Blue, the hourly rate for Red is $20 and for Blue is $30, Investment by Red is $80,000 and by blue 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 spread sheet again to make changes: Blue reports 1,700 billable hours, Red 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?

 


Related Discussions:- Use spreadsheet to determine allocation

Maximize revenues from sales, You are a manager at the DaimlerChrysler. Dai...

You are a manager at the DaimlerChrysler. Daimler-Chrysler has lost money on the Smart car since the first model rolled off the assembly line in 1998. By bringing its little car in

Defunct companies-liquidation of companies, Defunct Companies A company...

Defunct Companies A company may be dissolved under s.338 without winding up if the registrar has reasonable cause to believe it is defunct: The procedure is: a. Registrar writ

Practise.., What would be the effect on the balance sheet if adjustments (a...

What would be the effect on the balance sheet if adjustments (a) and (f) were omitted at the end of the year?k question #Minimum 100 words accepted#

Provision and contingences, what is the accounting procedure for a warranty...

what is the accounting procedure for a warranty provision?

Prepare a lease amortization schedule, LessorMfg Corp. is a manufacturer of...

LessorMfg Corp. is a manufacturer of heavy equipment. On January 1, 2013, LessorMfg Corp. leases equipment to Small Company under a six-year noncancelable lease agreement. The foll

Prepare the partnership''s income statement, The partnership of Lewis and C...

The partnership of Lewis and Clark had these balances at April 30, 2008: Cash........$28,000 Liabilities........56,000 Clark Capital...14,000 Other Assets...84,000 Service Re

Adjusting Entries, The company incurs a payroll payable of $645 per weekday...

The company incurs a payroll payable of $645 per weekday of operations. The mondays of january are the 3rd, 10th, 17th, 24th, and the 31st. Paydays are every other Friday with payd

Calculate operating cash flow , Question 1 The following information s...

Question 1 The following information should be used for questions #1 through #7: Jersies, Inc financial statement data.   2009 2010

Scheduling or budgeting, Tool Belt Store (TBS) is expanding its chain of ha...

Tool Belt Store (TBS) is expanding its chain of hardware stores across the country. TBS has more than 5,000 full-time employees and more than 20,000 part-time employees. TBS recent

Sundry matters-financial statement , Sundry Matters 1) The accounting ...

Sundry Matters 1) The accounting system is also appropriate for departmental accounts. 2) The branch stock account is a practical means of controlling stock at the branch.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd