Indicate a cash budget on a monthly basis

Assignment Help Accounting Basics
Reference no: EM132562321

Question - Kerrydale Ltd is in the process of preparing budgets for the period October to December 2019. The following information has been provided by the accounting department to assist in the budgeting process:

(i) Budgeted monthly sales revenue is as follows:

£

October 2019 50,000

November 2019 80,000

December 2019 60,000

January 2020 55,000

Sales are 20% cash and 80% on credit. 5% of the credit sales will not be received. The remainder of the credit sales are collected over a 3 month period: 15% in the month of sale, 70% in the month following sale and 15% in the second month following sale.

Total sales revenue in August is expected to amount to £40,000 and in September to £46,000.

(ii) Purchases are expected to amount to £47,500 in October, £43,000 in November, and £27,750 in December. 50% of purchases are paid in the month of purchase. The remaining 50% is paid for in the month following purchase. At 30 September, the amount owed for purchases was £11,700.

(iii) A grant of £20,000 from Glasgow City Council is expected to be received in mid-October.

(iv) A van which cost £8,000 when purchased 5 years ago, is expected to be sold in December for £3,000. The net book value of the van is £1,800.

(v) Equipment costing £4,500 will be purchased in November. The equipment will be depreciated on a straight line basis over 4 years.

(vi) Operating expenses are paid as incurred. These have been estimated to be £12,800 in October, £18,900 in November, and £14,600 in December. Each of these figures includes depreciation on existing assets amounting to £2,000 per month.

(vii) The cash balance on 1 October 2019 is expected to be £8,000.

Required -

(a) Indicate a cash budget on a monthly basis for the period between October 2019 and December 2019.

(b) Outline three items which would be included in a cash budget but not in a budgeted statement of profit and loss.

(c) Briefly explain three potential issues associated with the traditional budgeting process.

Reference no: EM132562321

Questions Cloud

What was the pax britannica : What was the Pax Britannica? what ways did it mark a significant change from t he previous global economic order?
What is the sales level in dollar required to equal the year : If the firm spends the additional $299,000 for advertising in year 2, what is the sales level in dollars required to equal the year 1 after-tax operating profit
Explain the factors for multi-factor authentication : Explain the three different types of factors for multi-factor authentication. Remember to cite at least one scholarly peer-reviewed article.
One ket criticism of global civil society : One ket criticism of global civil society is that it is not representative. What do critics mean when they suggest this?
Indicate a cash budget on a monthly basis : Total sales revenue in August is expected to amount to £40,000 and in September to £46,000. Indicate a cash budget on a monthly basis
Discuss factors that contribute to the abuse of alcohol : The factors that contribute to the abuse of alcohol, tobacco, and other drugs are many, and the decision to use drugs lies ultimately with the individual.
Power of vision as relates to leadership effectiveness : Discuss the power of vision as it relates to leadership effectiveness. What forces, people, and events have influenced current attitudes towards leadership
What you feel to be the status of mental health care : Identify (using the Internet) an organization in your community or a community of your choice that you believe provides mental health services.
Compute and identify the npv : Identify the NPV. initial cost $100,000, which depreciated straight-line to a zero book value over three years. The required rate of return is 16 percent

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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