Prepare the cash budget by month and in total

Assignment Help Accounting Basics
Reference no: EM132955272

Question - ABC Limited is planning to start operations on the first of July 2021 selling different types of electronic devices. The following details were made available for you to assist the company's management in planning its cash needs.

The following additional information is also available:

-It is estimated that approximately 70% of the sales is going to be received in cash at the time of the sale and 30% is going to be received one month later.

-The full cost of purchases is paid to the suppliers in the month following the purchase.

-Staff salaries are budgeted at £900,000 per year payable every month.

-ABC management is planning to rent a property for which it will pay £50,000 monthly. The rent is due on the first day of each month. According to the rental agreement, the company will have to pay an initial deposit of £75,000.

-ABC aims at commencing the promotion of its products through running an advertising campaign starting July 2021. It is expected that the monthly cost of the campaign will be £60,000.

-Administration expenses are budgeted to be £60,000 per month, 50% of which is paid in the same month and the rest is paid the following month.

-The company is planning to purchase new equipment to meet the increase in demand on their products costing £480,000. The equipment will be paid for in twelve equal instalments beginning in July 2021.

-On the first of July 2021, management intends to have £20,000 cash in the company's bank account.

Required -

a) Prepare the cash budget by month and in total for the three months period July to September of 2021.

b) Make suggestions to ABC's management to help it deal with any shortfalls in cash in any of the three months included in the budget.

Reference no: EM132955272

Questions Cloud

Critically review the concept of postmodernism : Critically analyse the organisational choices that Dell has made using two of the four main analytical models that are presented in this Module
Purpose of a purpose statement in a research study : Describe the purpose of a purpose statement in a research study?
How do users of financial statements have opinion swayed : How do users of financial statements have their opinion swayed with the way amounts are booked to distort financial statement results for personal gain?
Assumptions and limitations in a research study : Describe the purpose of assumptions and limitations in a research study and provide citations to support the explanation.
Prepare the cash budget by month and in total : Staff salaries are budgeted at £900,000 per year payable every month. Prepare the cash budget by month and in total
How much would get if want to sell such a t-bill to dealer : 0.73 on a T-Bill with a maturity of 125 days. If you want to sell such a T-Bill to the dealer with a face value of $1M, how much would you get for it?
Purpose of providing the significance of the study : Describe the purpose of providing the "significance of the study" in a research paper and provide citations to support content.
Describe the purpose of a literature review : Describe the purpose of a literature review in a research paper and provide citations to support content.
Describe the purpose of including a ethical research : Describe the purpose of including a "ethical research" within a research paper and provide citations to support the explanation.

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