Reference no: EM13745219
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 enterered:
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 yearis $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?
|
What style of leadership is most effective in organization
: Write a 400 word count dicussion on this topic. Please answer all three questions below thoroughly. Any sources need to be properly cited in APA form all sources must be scholarly and have a reference page below. What style of leadership is the ..
|
|
Conceptual framework convergence between the FASB and IASB
: What is one of the major differences between the IASB’s and FASB’s conceptual framework? Explain your answer. What is the current status of the conceptual framework convergence between the FASB and IASB?
|
|
What is the total of budgeted cash collections for december
: What is the total of budgeted cash collections for December? How much is the book value of accounts receivable at the end of December? How much is the income (loss) before income taxes for December? What is the projected balance in inventory on Decem..
|
|
Project in accordance with the charter template
: Provide a project charter of your selected project in accordance with the charter template found in Doc Sharing. Please put this in proper business writing format. Consider me to be your boss. A charter should be a minimum of 3-5 pages long( 3 woul..
|
|
Interest rate on capital investment
: 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 experienc..
|
|
Case study on rancho solano
: Rancho Solano Case Study that Provide an explanation, using appropriate management theories, for how the administration could have handled the closure effectively with stakeholders
|
|
Paper on epidemiology of a significant chronic disease
: Develop a 5 page, research paper on the epidemiology of a significant chronic disease, Infectious Disease, or genetic condition. Include distribution, prevalence, risk factors, criteria for causation and preventive measures
|
|
Amount of the discount on these bonds at issuance
: Tano issues bonds with a par value of $180,000 on January 1, 2013. The bonds’ annual contract rate is 8%, and interest is paid semiannually on June 30 and December 31. The bonds mature in three years. The annual market rate at the date of issuance is..
|
|
Boston pay to the bondholders every six months
: On January 1, 2013, Boston Enterprises issues bonds that have a $3,400,000 par value, mature in 20 years, and pay 9% interest semiannually on June 30 and December 31. The bonds are sold at par. How much interests will Boston pay (in cash) to the bond..
|