Prepare a cash budget for each of the first three months, Financial Accounting

Assignment Help:

Question :

The subsequent data pertain to a shop. The owner has made following sales forecasts for the first 5 months of the coming year.
                                                       £.
January                                       40,000
February                                     45,000
March                                          55,000
April                                             60,000
May                                             50,000

Other data are as follows:

(a) Debtors and creditors' balances at the beginning of the year are £ 30,000 and £14,000 respectively. The balances of other relevant assets and liabilities are:
                                                       £.
Cash balance                              7,500
Stock                                          51,000
Accrued sales commission           3,500

(b) 40% sales are on cash basis. Credit sales are collected in the following month of sale.

(c) Cost of sales is 60% of sales.

(d) The only other variable cost is a 5% commission to sales agents. Sales commission is paid in the month after it is earned, i.e.,time-lag is one month.

(e) Inventory is kept equal to sales needs for the next two months' budgeted sales.

(f) Trade creditors are paid in the subsequent month after purchases.

(g) Fixed costs are £ 5,000 per month, including £ 2,000 depreciation.

Required:

Prepare a cash budget for each of the first three months of the coming year.


Related Discussions:- Prepare a cash budget for each of the first three months

Calculate the amount of profit or loss, On 1 January 2009, a company, Yeti,...

On 1 January 2009, a company, Yeti, granted an employee the right to choose between (i) 30,000 Yeti shares or (ii) a cash-payment equivalent to the price of 24,000 Yeti shares on 3

What do you mean by fiscal year, Q. What do you mean by Fiscal Year? Fi...

Q. What do you mean by Fiscal Year? Fiscal Year - Period of 12 consecutive months chosen by an entity as its ACCOUNTING period that may or may not be a calendar year. Fixed Ass

Cash budget, Beginning balance 24,000 cash Sales 250,000 Gross profit 45% o...

Beginning balance 24,000 cash Sales 250,000 Gross profit 45% of sales Accounts receivable increase by 24,000 Accounts payable increased by 51,000 Inventory increased by 98,000 Sell

Calculation of liquidity ratios current ratio and acid-test, Calculation of...

Calculation of Liquidity ratios Current Ratio and Acid-Test Ratio -               2008 2009 2010 A

Prepare a partial balance sheet, On December 31, 2014, Santana Company has ...

On December 31, 2014, Santana Company has $7,194,600 of short-term debt in the form of notes payable to Golden State Bank due in 2015. On January 28, 2015, Santana enters into a re

Determine pension expense for the year ended december 31, Part A: The follo...

Part A: The following information relates to Company A's defined benefit pension plan during the current fiscal year: Plan assets (beginning of the year) $400 (all number are in $m

Determine about the accounting information, Determine about the accounting ...

Determine about the accounting information Numerous user groups have an interest in accounting information relating to a business. Majority of these are outside the business ho

State the benefits of accounting information, State the Benefits of account...

State the Benefits of accounting information Benefits of accounting information ultimately decline. Cost of providing information, though, will rise with every additional piec

Prepare financial report for large accounting firm, Question: You are a...

Question: You are a member of a large accounting firm which is responsible for preparing financial reports, including statements and notes to the accounts; and for advising sta

UNDERSTANDING bUSINESS, I NEED HELP in business ratios for two company.Ido...

I NEED HELP in business ratios for two company.Ido not know how to do the formulas. Can you help.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd