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.
Required
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 this spreadsheet to determine the 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, and 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 spreadsheet a second time but make these 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 allocation of the $200,000?
Welcome to one of the most trusted essay writing services with track record among students. We specialize in connecting students in need of high-quality essay writing help with skilled writers who can deliver just that. Explore the ratings of our essay writers and choose the one that best aligns with your requirements. When you rely on our online essay writing service, rest assured that you will receive a top-notch, plagiarism-free A-level paper. Our experienced professionals write each paper from scratch, carefully following your instructions. Request a paper from us and experience 100% originality.
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
From stress to success – hire a pro essay writer!
