You are presented with the budgeted data for the period November 20X1 to June 20X2 by...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are presented with the budgeted data for the period November 20X1 to June 20X2 by your firm. It has been extracted from the other functional budgets that have been prepared. You are also told the following: Sales are 40% cash, 60% credit. Credit sales are paid two months after the month of sale. Purchases are paid the month following purchases. 75% of wages are paid in the current month and 25% the following month. Overheads are paid the month after they are incurred. Dividends are paid three months after they are declared. Capital expenditure is paid two months after it is incurred. The opening cash balance is £15,000. Nov X1 Dec X1 Jan X2 Feb X2 Mar X2 Apr X2 May X2 June X2 £ £ £ £ £ £ Sales 80,000 100,000 110,000 130,000 140,000 150,000 160,000 180,000 Purchases 40,000 60,000 80,000 90,000 110,000 130,000 140,000 150,000 Wages 10,000 12,000 16,000 20,000 24,000 28,000 32,000 36,000 Overheads 10,000 10,000 15,000 15,000 15,000 20,000 20,000 20,000 Dividend 20,000 40,000 Сapital 30,000 40,000 expenditure What is the net cash balance carried forward at the end of June 20X2? You are presented with the budgeted data for the period November 20X1 to June 20X2 by your firm. It has been extracted from the other functional budgets that have been prepared. You are also told the following: Sales are 40% cash, 60% credit. Credit sales are paid two months after the month of sale. Purchases are paid the month following purchases. 75% of wages are paid in the current month and 25% the following month. Overheads are paid the month after they are incurred. Dividends are paid three months after they are declared. Capital expenditure is paid two months after it is incurred. The opening cash balance is £15,000. Nov X1 Dec X1 Jan X2 Feb X2 Mar X2 Apr X2 May X2 June X2 £ £ £ £ £ £ Sales 80,000 100,000 110,000 130,000 140,000 150,000 160,000 180,000 Purchases 40,000 60,000 80,000 90,000 110,000 130,000 140,000 150,000 Wages 10,000 12,000 16,000 20,000 24,000 28,000 32,000 36,000 Overheads 10,000 10,000 15,000 15,000 15,000 20,000 20,000 20,000 Dividend 20,000 40,000 Сapital 30,000 40,000 expenditure What is the net cash balance carried forward at the end of June 20X2?
Expert Answer:
Answer rating: 100% (QA)
Solution All the amounts are in Particulars Nov X1 Dec X1 Jan X2 Feb X2 Mar ... View the full answer
Related Book For
Financial Accounting Tools for Business Decision Making
ISBN: 978-1118644942
6th Canadian edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine
Posted Date:
Students also viewed these accounting questions
-
The following information has been extracted from the draft financial statements of TEX, a manufacturing entity: TEX - Income statement for the year ended 30 September 2003 September 2003...
-
The following information has been extracted from the accounting records of the Atwood Corporation: 1. Cash on hand (undeposited sales receipts) ............ $ 1,020 2. Certificates of deposit...
-
The following information has been extracted from Atwood Corporations accounting records: Cash on hand (undeposited sales receipts) ..............$1,535 Certificates of deposit...
-
Is CSCH3CO2 ionic or covalent ? Name it QUESTION 7 Is rubidium dichromate ionic or covalent ? Write its formula QUESTION 8 s copper m suhde soric or covaent write its formula QUESTION 9 Is vanadium...
-
Give the technical name of a microbiologist who researches or works with: protozoa in a termites gut, bacteria that live in volcanoes, the tapeworms of dogs, molds that cause food poisoning, emerging...
-
The nylon Nomex®, a condensation polymer, has the following structure: Draw the structures of the two monomers that yield Nomex®. NH NH
-
Consider the multiple linear regression model for the rental price data in Problem 3.42. Problem 3.42 Table B.24 contains data on median family home rental price and other data for 51 US cities. Fit...
-
Bergamo Bays computer system generated the following trial balance on December 31, 2015. The companys manager knows something is wrong with the trial balance it does not show any balance for work in...
-
Image transcription text 22 21.9615 0.6588 4.0606 0.3248 0.4648 35.1371 0./891 16 15.7412 0.4739 2.6706 0.3107 0.4507 35.1685 0.0258 10 9.9197 0.2982 1.4440 0.2890 0.4291 35.2908 0.0166 6 6.6168...
-
A heat engine running backward is called a refrigerator if its purpose is to extract heat from a cold reservoir. The same engine running backward is called a heat pump if its purpose is to exhaust...
-
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that...
-
What is the FIRST key step you can take in addressing concerns about SSDI and reporting earnings? Provide information about SSDI and SSDI work rules Remind the person to report their earnings Refer...
-
Answer each question thoroughly using examples from the film(s) and writing(s) they reference. Please cite your sources - you may paraphrase or use quotation, but please be sure to cite if even...
-
If the Nostromo and the Alien Ship on the planet are both figured as 'monstrous mothers' which is figured as more terrible or terrifying the android mother or alien mother? Why?
-
Why is goal setting important in the financial planning process? Responses To identify the influence of marketing strategies To identify the influence of marketing strategies To establish spending...
-
During the month of July, the Town of Lynton recorded the following information related to purchases: General government Amount of Purchase Order Actual Cost $ 561,000 $ 501,000 Public safety 746,200...
-
Discuss interpretivism resea philpsophy in supply chain management in mining construction and projects using appropriate literature and explain why you chose it , , and add sources
-
What is the order p of a B + -tree? Describe the structure of both internal and leaf nodes of a B + -tree.
-
Tibble Corporation uses straight-line depreciation, prepares adjusting entries annually, and has a December 31 year end. It purchased equipment on January 1, 2014, for $200,000. The equipment had an...
-
The following ratios are available for fast-food competitors and their industry, for a recent year: Instructions (a) Which company is more liquid? Explain. (b) Which company is more solvent? Explain....
-
When faced with labour shortages and high staff turnover, most retail stores do not bother with criminal record checks when hiring employees. Explain what internal control activity is missing from...
-
The following equity accounts are in the ledger of Eudaley Group at December 31, 2025. Instructions Prepare the equity section of the statement of financial position at December 31, 2025. Share...
-
The equity section of Atrio Ltd. showed the following: share premium 6,101, share capitalordinary 925, share capitalpreference 58, retained earnings 7,420, and treasury shares 2,828. (All amounts are...
-
Travis Mordica asks, Since share dividends dont change anything, why declare them? What is your answer to Travis?
Study smarter with the SolutionInn App