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 is the internal rate of return of the project, Hydroponics is consider...

Hydroponics is considering adding another greenhouse that would cost $95,000 and generate $20,000 in annual net cash flows over its 8 year expected life. What is this project's int

Terms "tangible" and "intangible" , Explain the meaning of the terms "tangi...

Explain the meaning of the terms "tangible" and "intangible" and discuss how these terms are used in describing assets.

Gaap - generally accepted accounting principles, ACCOUNTANCY PRINCIPLES (GA...

ACCOUNTANCY PRINCIPLES (GAAP - GENERALLY ACCEPTED ACCOUNTING PRINCIPLES) Accounting values, rules of conduct and action are explained by a variety of terms for instance convent

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

Show the management report, Q. Show the Management Report? Management's...

Q. Show the Management Report? Management's Report - Management is essential to include in its annual report its assessment of the effectiveness of the company's internal contr

Product costs and which are period costs, The costs that follow were extrac...

The costs that follow were extracted from the accounting records of various different manufacturers: 1.    Weekly wages of an equipment maintenance worker 2.    Marketing costs

Determine the growth rate of the nominal money supply, The income elasticit...

The income elasticity of money demand is 2/3. Real income is expected to grow by 4.5% over the next year, and the real interest rate is expected to remain constant over the next ye

Sequential stages of an accounting information system, Relationship between...

Relationship between these aspects is set out in Figure.                                 Figure: The accounting information system There are four sequential stages of an

Determine income statement and balance sheet, Prepare an Excel spreads...

Prepare an Excel spreadsheet containing the following: - Construct the next five-year pro-forma statements (income statement and balance sheet). - Estimate annual F

Explain depreciate non-current assets, Question: Lucy Kim is in the car...

Question: Lucy Kim is in the car hire business. The following information came from her Fixed Asset Register on 31 December 2009: On 31 March 2009, she sold the car wh

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