Prepare cash budget for june

Assignment Help Financial Accounting
Reference no: EM132583863

North Point Ltd.'s management has an estimated overdraft of $10,000 at 1 June. The following information has been taken from budgets for June.

Cash Sales : 53,000

Credit Sales: 92,000

Wages (gross): 22,000

Rent: 6,000

Credit purchases of trading stock: 18,000

Cash purchases of trading stock: 8,000

Loss on sales of asset: 3,000

  • 60% of sales credit sales are collected in the month of sale and 40% in the following month.
  • Credit sales for May was budgeted for $80,000
  • 90% of credit purchases are paid in the month of purchase and 10% in the following month.
  • Credit purchases for May was budgeted for $22,000
  • Wages for May was budgeted for $15,000.
  • PAYG tax deductions are calculated at 20% of gross wages and paid to ATO in the following month of wages paid.

Task:

Question 1: Prepare cash budget for June. (Note: For simplicity ignore GST in your calculations).

North Point Ltd.'s Policy and Procedures Manual requires Cash Budgets to be prepared in a spreadsheet package using the format on the following page.

Reference no: EM132583863

Questions Cloud

Message regarding the total rewards program : Does each the executives and employees get the same message regarding the total rewards program?
Record the transactions in the appropriate journals : Record the transactions in the appropriate journals. $2,500 was paid to the solicitors for the formation of the company on 2 June 2015.
Analyzes the motivational factors : What level(s) of Maslow's Hierarchy of Needs does each person exhibit? Suggest one or two levels and explain.
Program to executives and employees : How and what would you communicate on the total rewards program to executives and employees?
Prepare cash budget for june : Prepare cash budget for June. (Note: For simplicity ignore GST in your calculations). North Point Ltd.'s management has estimated overdraft of $10,000 at 1 June
Find what are the expected return for a portfolio comprised : Find what are the expected return and standard deviation for a portfolio comprised of 40 percent Asset A,If the correlation between A and B is 0.6
What is the most appropriate strategy for a leader : What is the most appropriate strategy for a leader when there is a decision that involves a conflict among the interests of different stakeholders?
What is the fair value hierarchy : How does a company go about determining the fair value at acquisition date? What is the fair value hierarchy? What is ADVANCED ACCOUNTING
Product appears as advertisement in your social media : You may have noticed that when you look at products on a search engine, that same product appears as an advertisement in your social media

Reviews

Write a Review

Financial Accounting Questions & Answers

  Becks earnings for the week are

Beck's earnings for the week are: -Is the hourly rate in violation of the FLSA? Explain. - If the hourly rate is in violation of the FLSA, the amount the shop should pay Beck is:

  What the amount that corsetti would have to invest today

What The amount that Corsetti would have to invest today, assuming an interest rate of 6% compounded semiannually, in order to reach her goal is

  What is the value of shareholder''s equity

Ernie Inc. has current assets of $60,000, net fixed assets of $212,000, current liabilities of $64,000, and long term debt of $135,000. What is the value of shareholder's equity for the firm?

  Question a what is the significance of the information

question a. what is the significance of the information about sales person compensation to the audit of receivables and

  Qsantana rey owner of business solutions realizes that she

qsantana rey owner of business solutions realizes that she requires to start accounting for bad debts expense. consider

  Which of the? true for nakuru inc

Nakuru Inc. sells its building with an original cost of? $500,000 for? $450,000 and makes a loss of? $50,000 on the sale. Which of the? true

  Joint production costs before and after the split off point

What do you think is the best way to account for joint production costs before and after the split off point? Give a specific example and explain why you think the method selected is the best

  Computation of earnings per sharemajor corporation has

computation of earnings per share.major corporation has 100000 shares of 10 par value common stock outstanding and no

  What is the maturity value of the note

On November 1, Alan Company signed a 120-day, 12% note payable, with a face value of $18,900. What is the maturity value of the note on March 1

  Find is the a case where npv might not be methodology

Find Is there a case where NPV might not be the best methodology to evaluate new investments? If so, how could the problem be overcome?

  Compute the labor price and quantity variances

Lewis Company’s standard labor cost of producing one unit of Product DD is 3.20 hours at the rate of $14.00 per hour. During August, 41,500 hours of labor are incurred at a cost of $14.12 per hour to produce 12,800 units of Product DD. Compute the la..

  Equipment was assigned an estimated life

On January 1, 2002, ABC Company purchased equipment for $100,000. The equipment was assigned an estimated life of 10 years and a residual value of $10,000. On January 1, 2005, ABC Company decided the life of the equipment should be revised from 10 to..

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