Cash Budget for Higgins and Griffin
Not what you're looking for?
Cash Budget for Higgins and Griffin Financial Planners
Higgins and Griffin Financial Planners have forecasted revenue for the first six months of 2005 as shown on the following table:
Month Nov. 2004 Dec-04 Jan-05 Feb Mar Apr May June
Revenue $48,000.00 $45,000.00 $25,000.00 $27,000.00 $30,000.00 $38,000.00 $40,000.00 $45,000.00
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 collectible sales.
Each of the two partners is paid $5,000 per month. Commissions and partner salaries are paid one month after the revenue is earned.
Rent expense for their office space is $2,500 per month, and lease expense for office equipment is $800.
Utilities average $175 per month, except in May and June when they average only $100
The ending cash balance in December 2004 was $12,000
Create a cash budget for January to June 2005 and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $8,000.
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation to create a cash budget for January to June 2005 and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $8,000.
Solution Preview
Cash Budget for Higgins and Griffin Financial Planners
Higgins and Griffin Financial Planners have forecasted revenue for the first six months of 2005 as shown on the following table:
Month Nov. 2004 Dec-04 Jan-05 Feb Mar Apr May June
Revenue $48,000.00 $45,000.00 $25,000.00 $27,000.00 $30,000.00 $38,000.00 $40,000.00 $45,000.00
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 ...
Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.