Reference no: EM131368464
Camp and Fevurly Financial Planners have forecasted revenues for the first six months of 2012, as shown in the following table.
The firm collects 60% of its sales immediately, 39% one month after the sale, and 1% are written off as bad debts two months after the sale. The firm assumes that wages and benefits paid to clerical personnel will be $7,000 per month while commissions to sales associates average 25% of collectable sales. Each of the two partners is paid $5,000 per month or 20% of net sales, whichever is greater. Commissions and partner salaries are paid one month after the revenue is earned. Rent expense for their office space is $3,500 per month, and lease expense for office equipment is $800. Utilities average $250 per month, except in May and June when they average only $150. The ending cash balance in December 2011 was $12,000.
a. Create a cash budget for January to June 2012, and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $10,000.
b. Camp and Fevurly are thinking of obtaining a line of credit from their bank. Based on their expectations for the first six months of the year, what is the minimum amount that would be necessary? Round your answer to the next highest $1,000 and ignore interest charges on short-term debt.
c. Create three scenarios (best case, base case, and worst case) assuming that revenues are 10% better than expected, exactly as expected, or 10% worse than expected. What is the maximum that the firm would need to borrow to maintain its minimum cash balance in all three cases? Use the Scenario Manager and create a summary of your results. Would this change your answer in part b?
|
What is the present value now of the whole income stream
: FIN700 - Financial Management Assignment. Orange Olives Ltd returns nothing to the owners in the first 4 years. In the following 3 years, the returns are $80,000, $130,000 and $180,000 respectively. What is the present value now of the whole income..
|
|
Particular parallel program computation
: A particular parallel program computation requires 100 seconds when executed ona single processor. If 40 percent of this computation is "inherently sequential" (i.e.,will not benefit from additional processors),
|
|
Discuss importance of having good plans to deal with crisis
: BU3016- Critically discuss the importance of having good plans to deal with Crisis and Risk, and what that entails, and consider the appropriateness of using Scenario Planning as a basis for developing Risk Management and Crisis Management plans.
|
|
Starvation-free job-scheduling policy guarantees
: A starvation-free job-scheduling policy guarantees that no job waits indefinitely forservice. Which of the following job-scheduling policies is starvation-free?
|
|
Create a cash budget for january to june 2012
: Create a cash budget for January to June 2012, and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $10,000.
|
|
Hacker point of view concerning electronic access
: How does the hacker point of view concerning electronic access to information differ from the law and from your point of view concerning access to information?
|
|
How is your product or service positioned in the market
: How is your product or service positioned in the market (What specific features and attributes define the product/service and how is its value reflected in its pricing, distribution, marketing communications, etc.?)?
|
|
Assignment on risk management
: It is an accepted truth that without risk there can be no gain. Every individual and organization who wants to succeed must take some risks. Risk management is not about not taking risks, but about taking risks in a controlled environment for whic..
|
|
Explain components of emergency management multi agency
: Write a paper in which you explain components of emergency management multi-agency interoperability, communication, and infrastructure needs for multi-agency preparedness.
|