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

Dissolutions, DISSOLUTIONS A partnership may be dissolved due to variou...

DISSOLUTIONS A partnership may be dissolved due to various reasons which include: Poor trading that has led to losses A partner dying or leaving the firm The time

Report to stockholders of a company, Q. Report to stockholders of a company...

Q. Report to stockholders of a company? Annual Report - Report to stockholders of a company that includes company's annual,audited BALANCE SHEET and related statements of earni

Receiving order, RECEIVING ORDER It includes five main important points...

RECEIVING ORDER It includes five main important points as follows: Effect of receiving order: The consequences of the making of the receiving order are:The debtor retain

Accounts relate to keenal real estate, Prepare a financial statement from a...

Prepare a financial statement from alphabetic listing of accounts: A number of accounts balances are listed below these accounts relate to Keenal Real Estate. During the year just

What amount did spear receive from the bond issurance?, On July 1, 2010, Sp...

On July 1, 2010, Spear Co. issued 1,000 of its 10%, $1,000 bonds at 99 plus accrued interest. The bonds are dated April 1, 2010 and mature on April 1, 2020. Interest is payable sem

Content of accounts-trusts accounts, Content of accounts Periodical acc...

Content of accounts Periodical accounts should normally consist of:         1.    Balance sheet of the whole trust;         2.    Capital account;         3.    Income account

Inventory management, Most firms build and keep inventories in the course o...

Most firms build and keep inventories in the course of doing business. Manufacturing firms hold raw material, finished goods and spares and work in process in inventories. Financia

Invoices before Inventory, How should I handle Booking an invoice in one mo...

How should I handle Booking an invoice in one month for Raw material that has not been received until the following month?

What is recapitalization, Q. What is Recapitalization? Recapitalization...

Q. What is Recapitalization? Recapitalization - An internal reorganization of a corporation including a rearrangement of capital structure by changing the kind of stock or numb

Foreing branches-branches, FOREING BRANCHES The head office my set up a b...

FOREING BRANCHES The head office my set up a branch in a foreign  country. IAS 21 requires that the results of that  foreign branch to be translated into the local currency for t

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