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

Compensation, how to treat salary compensation given to an employee how to ...

how to treat salary compensation given to an employee how to show this in company account

Rescission-statement of affairs-receiving order , Rescission of receiving o...

Rescission of receiving order The order may be rescinded by the court if: The court has sanctioned a composition or scheme of arrangement; The debts have been paid in

How many units must the division sell each year, unit selling price of prod...

unit selling price of products= $40 unit variable expense of product= $24 Total fixed expenses= 560,000 avg op assets= 3,000,000 1)how many units must the division sell each yea

Currency-option bond, You have the following limited information upon which...

You have the following limited information upon which to base your decision as to which is the better of two alternative funding arrangements: Alternative 1 is to arrange fun

Acid-test ratio, What is Acid-test ratio A measurement of the capabilit...

What is Acid-test ratio A measurement of the capability of a business to meet its short-term commitments. It is considered by dividing excluding stock, current assets, by curre

Calculate the weighted average cost of capital, Verizon Corporation has 55%...

Verizon Corporation has 55% equity and 45% debt (market values) in its capital structure. The pretax cost of debt is 7%, and that of equity 12%. The total value of the company is $

Determine the missing amounts, Two items are omitted from each of the follo...

Two items are omitted from each of the following summaries of balance sheet and income statement data for two corporations for the year 2014, Steven Craig and Georgia Enterprises.

Adjudication order-adjudication of debtor, Adjudication order The court...

Adjudication order The court may adjudge the debtor bankrupt on the application of the O.R. or any creditor in the following cases: If the creditors so resolve at their first

Illustrate individuals budget constraint, An individual is currently workin...

An individual is currently working 40 hours per week, earning $10 per hour.  He loses his job and successfully applies for unemployment insurance.  The insurance plan works as foll

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