Reference no: EM131285735
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 the above spreadsheet to determine allocation if partnership net income for the current yearis $200,000, the number of billable hoursis 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 the 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?
|
Members to be the surrogate mothers
: What are your thoughts on couples using family members to be the surrogate mothers? Does it make a difference if the couple is using their own fertilized egg versus the egg of the surrogate?
|
|
International operational expansion
: Other managers in your company may be planning a major new product offering, or an international operational expansion. One role of the financial manager is to provide forecasts for a new business plan.
|
|
Calculate the npv of the wildcat oil well
: Calculate the NPV of the wildcat oil well, taking account of the probability of a dry hole, the shipping costs, the decline in production, and the forecasted increase in oil prices.
|
|
Components of the incident management system
: Define the fundamental components of the Incident Management System as they apply to the management of Weapons of Mass Destruction incidents. Must be in third person, and have a clear thesis introductory paragraph.
|
|
Partnership has been created to operate a law firm
: 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. Use the above spreadsheet to det..
|
|
Planning the financial aspects of a project
: 1. What are some of the obstacles that project managers need to overcome when developing a budget? 2. Illustrate how a balance sheet, income statement, and cash flow statement work together in planning the financial aspects of a project. 3. How can..
|
|
About the debt-to-equity ratio
: White Memorial Hospital has a debt-to-equity ratio of 0.67. What is the hospital's debt ratio? Commissions and other expenses for acquiring the shares are treated as part of the cost of the equity-is this true, and if so, what are the exceptions?
|
|
Determine the best meeting format
: Determine the best meeting format. For each of the following scenarios, identify which format-face-to-face, conference call, online meeting, or videoconference-would work best.
|