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

What are allie''s stock basis, Monte and Allie each own 50% of Raider Corpo...

Monte and Allie each own 50% of Raider Corporation, an S corporation. Both individuals actively participate in Raider's business. On January 1, Monte and Allie have adjusted bases

Resolutions of creditors-bankruptcy, RESOLUTIONS OF CREDITORS Normally,...

RESOLUTIONS OF CREDITORS Normally, decisions at meetings of creditors are taken by ordinary resolution, viz., a resolution passed by a simple majority in value of creditors pre

Estimate the systematic risk of the new investment, Q. Estimate the systema...

Q. Estimate the systematic risk of the new investment? The beta of the comparator company will be utilized to estimate the systematic risk of the new investment. No un-gearing

Joint Audit, Impact of joint Audit on financial reporting quality

Impact of joint Audit on financial reporting quality

Rules of intestacy-no spouse but children, The intestate leaves no spouse b...

The intestate leaves no spouse but children The net estate devolves upon the surviving children and is divided equally between them. If any child has not, at the time of intest

Accounting standards in the united states, Which of the following was the f...

Which of the following was the first private sector entity that set accounting standards in the United States? a. Accounting Principles Board b. Committee on Acocounting Procedure

Leases, Company A(lessee) will rent inventory for you for 3 years rather th...

Company A(lessee) will rent inventory for you for 3 years rather than buying it for the regular price of $240,000. Normally these units, which cost us $120,000 to produce, will las

Determine the actual sales, CarloffCremes (CC) planned to sell 40,000 Queen...

CarloffCremes (CC) planned to sell 40,000 Queen size at $20 each and 20,000 King size at $15 each. Actual sales of the former were 45,000 and 25,000 of the latter, at $19 and $16 r

The principle of revenue, The principle that (1) requires revenue to be re...

The principle that (1) requires revenue to be recognized at the time it is earned, (2) allows the inflow of assets associated with revenue to be in a form other than cash and (3

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