Prepare three years of monthly cash budgets for company, Financial Accounting

1. Prepare three years of monthly cash budgets, yearly income statements, and yearly balance sheets for the jewelry business Daisy & Company.

General Information:

1. This is a family-run jewelry store.

2.  Assume it is a sole proprietorship, so there are no corporate taxes.  The income of the business is taxed as personal income to the business owner.

3. The physical location of the business is inside a shopping mall.  The company does not pay additional property taxes or any other associated fees except for monthly rent.  

Financial Information:

1. Sales forecasts for 2011 are listed below.


Sales [in thousands]

























2.  Assume sales are forecast to decrease by 5% annually from 2012 - 2013 due to the current economic climate. The seasonal sales pattern will still apply.

3.  An equity contribution of $100,000 cash was made at the start of the jewelry store.

4.  Employee Related Expenses: Assume that the jewelry store is open 12 hours each day X 363 days [4, 356 hours]. Daisy & Co. also employs individuals to work part-time at 6 hours each day X 363 days each year [2,178 hours].  Other employee related expenses are 5% of salaries and wages. Assume the total salaries and wages are paid on an equal monthly basis.

Owner's Salary


1 Floor Manager

4,356 x $22.75 = $99,099

1 Purchasing Manager

4,356 x $17.25 = $75,141

2 Full-Time Sales Clerks

4,356 x $11.00 x 2 = $95,832

2 Part-Time Sales Clerks

2,178 x $9.75 x 2 = $42,471

1 Part-Time Purchasing Clerk

2,178 x $12.50 = $27,225

1 Cleaning Lady


Total Salaries & Wages


5. Daisy & Co. was issued a $500,000, 15-year loan, issued at 12.65% interest that required monthly payments.  The loan proceeds were used for:

Rental space remodel


Initial inventory purchase


6. The rental space remodel is attributed to furniture and fixtures that are being depreciated on a 5-year, straight-line basis.

Other Information:

1.  Daisy & Co. wishes to maintain a $35,000 minimum cash balance.

2.  Advertising and marketing related expenses are 2% of sales.

3.  COGS are 35% of sales. The company pays cash for inventory in the month of sale.

4.  Insurance expense is 1.5% of sales.

5.  Administrative expenses are 1.75% of sales

6.  Utilities and telephone are included in the monthly rent of $9,000.

7.  Bank charges are 1% of sales.

8.  Daisy & Co. has a 60-day credit policy. Approximately 30% of their customers pay on credit and the remainder pay in cash. Assume half of all of the customers who purchased on credit will pay within one month and the remainder will pay the following month.

9.   Additionally, operating expenses are 4.5% of sales.

Posted Date: 2/19/2013 1:19:36 AM | Location : United States

Related Discussions:- Prepare three years of monthly cash budgets for company, Assignment Help, Ask Question on Prepare three years of monthly cash budgets for company, Get Answer, Expert's Help, Prepare three years of monthly cash budgets for company Discussions

Write discussion on Prepare three years of monthly cash budgets for company
Your posts are moderated
Related Questions
Equitable apportionments There are five leading cases where the courts have laid down rules to meet specific situations in which there is a conflict of interest between life tena

business is started with the objective of making profits but the conservatism concept says not to anticipate profit.... why so??

Provide a brief (one typed page) discussion of analysis of the ratios of your company versus the competitor and the industry, addressing your company's liquidity, solvency, profita

Q. Ownership and Control related issue of debt? Issuing equity is able to have ownership implications for a company particularly if the finance is raised by a placing or offer

Financial ratios have been categorized in a variety of manners. You may determine the subsequent broad bases having been utilized in current literature:  Primacy Criterion: Th

Data for 2013 were as follows: PBO, January 1, $244,000 and December 31, $274,000; pension plan assets (fair value) January 1, $190,000, and December 31, $233,000. The projected be

XYZ Inc. whose stock is currently valued at $125/share with an implied volatility of 40% has debt of $80/share. a. Assuming a global recovery rate of 50% and a standard deviatio

Q. Describe about Backdating? i) Exercise price is based on a lower share price prior to option grant date. Practice of marking a document with a date that precedes actual date

how do you record this transaction? May 18 Issues 30,000 additional shares of $2 common stock for $75 per share. May 25 Issue 8,000 shares of preferred stock for $125 per sha

The statement of comprehensive income for the year ended 31 December 2009 and its comparative is shown below: 2009 2008 $m