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

NPO, #questionWise Owls, an NFPO, began operations at the beginning of 20X1...

#questionWise Owls, an NFPO, began operations at the beginning of 20X1 to provide free tutoring and homework assistance, as well as a nutrition program, to low-income immigrant chi

Writing assignment, you are aceo of acme ,inc located in united states .you...

you are aceo of acme ,inc located in united states .you use the discounted pay back period method and accept all projects that pay back in hree years.a project that will cost 5,500

Adjustments, Is goodwill a fictitious asset?

Is goodwill a fictitious asset?

Partnership and sole trader, what are the advantage and disadvantage to mr ...

what are the advantage and disadvantage to mr fish, mr Lobster of forming a partnership rather than a close corporation or a company?

Balance Sheet & Statement of Cash Flows, I need some guidance in how certai...

I need some guidance in how certain events are to be recorded on both the balance sheet and statement of cash flows.

Ias 1 rules, IAS 1 rules IAS 1 requires companies to observe the follow...

IAS 1 rules IAS 1 requires companies to observe the following rules in preparing published financial statements: 1) The financial statements should reflect a true and fair v

What do you understand by measurement date in stock option, Q. What do you ...

Q. What do you understand by Measurement Date in stock option? Measurement Date - The date at which equity share price and other pertinent factors, like expected volatility tha

Cost estimation, 1a. Explain why it is the case that the value of intermedi...

1a. Explain why it is the case that the value of intermediate goods produced and sold during the year is not included directly as part of GDP, but the value of intermediate goods p

Numerical question, Data for 2013 were as follows: PBO, January 1, $244,000...

Data for 2013 were as follows: PBO, January 1, $244,000 and December 31, $274,000; pension plan assets (fair value) January 1, $190,000, and December 31, $233,000. The projected be

Internal audit department and financial statements, 1.  What cost flow assu...

1.  What cost flow assumption does the company use to value inventories? 2.  What was the amount of expense that the company reported for inventory write-downs during 2011? 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