Prepare a cash budget for the month of december 2021

Assignment Help Financial Accounting
Reference no: EM133254238

Safe@Work Pty Ltd a wholesaler of work safety products is in the process of preparing a cash budget for December 2021.  The following sales and purchases data have been compiled for the preparation of the budget:        

 

September

October

November

December

 

$

$

$

$

Sales

1,010,000

1,020,000

1,080,000

1,000,000

Purchases

560,000

480,000

540,000

500,000

Additional Information

  • All sales are on credit. The company collects 70% in the month of sale, 20% in the month following the sale and 10% two months following the sale.
  • 30% of all purchases are paid for in the following month they are purchased, with the remaining 70% paid for two months following the purchases.
  • Warehouse equipment costing $134,000 is expected to be acquired and paid for in December. 
  • The company will repay the whole amount of its short-term loan $124,000 in December. 
  • The selling and distribution expenses are $97,000 each month. Administrative expenses are $112,000 per month, included $13,000 of assets depreciation expense. Expenses are paid in the month they are incurred. 
  • The cash balance on 1st December 2021 is $17,000.

Required:

1. Prepare a cash budget for the month of December 2021.

2. Safe@Work Pty Ltd is considering changing its depreciation method from straight-line to reducing balance. What will be the effect of any increased depreciation expense on the cash balance?

Reference no: EM133254238

Questions Cloud

Rupinder past and present medical history : Relating to Rupinder's past and present medical history, explain the rationale for why you will administer metoprolol.
Critical in spiritual development of each child : The first year of life is critical in the spiritual development of each child. This is the window of opportunity for all foundational learning,
Aquaporins shut down, what imbalance will occur : If aquaporins shut down, what imbalance will occur? Why?
Somatic nervous system motor neuron function : You have been asked to design a drug that will impair somatic nervous system motor neuron function,
Prepare a cash budget for the month of december 2021 : Safe@Work Pty Ltd a wholesaler of work safety products is in the process of preparing a cash budget for December 2021.
What you think audiogram of normal hearing sensitivity : What you think an audiogram of normal hearing sensitivity would look like across a frequency range of 16 Hz to 20 kHz.
What role do organised interests play in immigration policy : What role do organised interests play in immigration policy?
Calculate the breakeven point in units and sales amount : Digi Tools Pty Ltd plans to launch a new type of gadget. The company provided the following information:
Drumming and flute playing : Aponi is a gifted musician. Her father was also a talented musician, recognized for his vocals, drumming and flute playing.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Find what amount of gain yellow corporation recognize

YELLOW Corporation acquired investment at amortized cost in GREEN Company. What amount of gain should YELLOW corporation recognize as a result of the disposal?

  Explain the meaning of fraud to randal

Randal Smith is not clear on what is meant by an "employee fraud." Explain the meaning of fraud to Randal and give an example of frauds that might occur at a ba

  Electronic data gathering analysis and retrieval data base

The Electronic Data Gathering Analysis and Retrieval Data Base may be found one the website of which of the entities?

  What is the portfolio expected shortfall

On the big loss days, there is a 30% chance the portfolio will lose $50,000 and a 70% chance it will lose $75,000. What is the portfolio's expected shortfall

  Compute the value of the synergy as estimated by the analyst

Compute the value of the synergy as estimated by the analyst. Does the estimate of synergies in justify the premium that company A offered to company B?

  Donovan company incurred

donovan company incurred the following cost while producing 500 unit.

  How the inventory costing method shows cost of goods sold

How This inventory costing method shows cost of goods sold on the income statement at the most current inventory costs during a period of inflation

  Prepare all journal entries for Harper

Prepare all journal entries for Harper for 2020 and 2021 in connection with this investment. Assume that the equity method is applied

  Compute the number of golf shirts available for sale

Crater started the month with a stock of 20 golf shirts valued at $26 per shirt. Compute the number of golf shirts available for sale during month of February

  What amount should adams company report as total accounts

The balance in Adams Company's accounts payable on December, What amount should Adams Company report as total accounts payable as of December 31, 2021?

  How could capture company exposure to country risk

It is true that investors do have concerns about country risk, Discuss the three determinants and how could capture company's exposure to country risk.

  What is the total number of commercial copiers sold

Below is the December 2009 sales data bysales representative for Papier Nouveau, a distributor of commercial printing supplies. As the Director of HR for Papier Nouveau, you are responsible for calculating monthly incentives.

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