Make a cash receipts budget for April, May and June

Assignment Help Accounting Basics
Reference no: EM132693912

Question - Veronica's Cakes cooks and distributes cakes for every imaginable occasion. Veronica started the company in her house three years ago and has been surprised at her success. She is considering expanding her business and needs to prepare cash budgeting information to present to Westpac Bank to secure a loan. Veronica is not an accountant, so she has asked you to help her to prepare the necessary reports. Veronica's Cakes began the month with a bank balance of $20 000. The budgeted sales for March to June are as follows:

 

March

April

May

June

Cash sales

$28,000

$33,000

$31,000

$35,000

Sales on account

58,000

60,000

80,000

100,000

Total sales

$86,000

$93,000

$111,000

$135,000

Veronica has found that she generally collects payment for credit sales over a two-month period. Typically, 70 per cent is collected in the month of sale and the remainder is collected in the next month. Her policy is to purchase inventory each month equivalent to 60 per cent of that month's budgeted sales. She thinks this provides her sufficient inventory levels to manage unanticipated changes in demand. Veronica's Cakes pays for inventory purchases in the month following purchase. Selling and administrative expenses are budgeted to be 40 per cent of each month's sales. One-half of the selling and administrative expenses is accounted for by depreciation on Veronica's manufacturing equipment.

The company purchased additional manufacturing equipment in April at a cost of $28 000. Veronica does not receive a salary, but she does pay herself dividends as company performance allows. The first quarter of the year was very profitable, so Veronica paid herself a dividend of $17 800 in April. Veronica wants to maintain a minimum cash balance of $10 000 and has established a line of credit so she can borrow enough money to make up any shortfall. If the company has excess cash on hand at the end of a month (in excess of $10 000), the line of credit will be paid back. Interest on the line of credit will not be paid until the end of the year. (Ignore any interest payments that the company would make on their borrowings.)

Required -

A. Make a cash receipts budget for April, May and June.

B. Make a cash disbursements budget for April, May and June.

C. Make a summary cash budget for April, May and June.

Reference no: EM132693912

Questions Cloud

How to earn participation marks for the remaining chapters : Please listen closely to the Oct. 27 Zoom session to find the full discussion on how to earn participation marks for the remaining weekly chapters.
Determine what is the effective labor cost per unit : A worker earns P10,000 per month on the average, Assuming that there are 330 working days in one year, what is the effective labor cost per unit?
Determine how much saving in fixed factory overhead per unit : Determine How much savings in fixed factory overhead per unit was effected assuming that additional output is due to the incentive given?
Why do firms look to such approaches as cpfr : If forecasting is so important, why do firms look to such approaches as CPFR (Collaborative, Planning, Forecasting, Replenishment) as a way to reduce the need f
Make a cash receipts budget for April, May and June : Veronica has found that she generally collects payment for credit sales over a two-month period. Make a cash receipts budget for April, May and June
Calculate the equivalent units for the year : The company completed and transferred out 400,000 units during the year. Using weighted-average process costing calculate the equivalent units for the year.
Advantages and disadvantages of standardization : 1. Discuss the advantages and disadvantages of standardization. Is it applicable to all business types? Why or why not?
What is the weighted three-period : Given the following historical data and weights of .5 for the most recent period, .3 for the next most recent, and .2 for the next after that, what is the weigh
What is the necessary conditions for the implementation : What is the necessary conditions for the successful implementation of yield manangement? advanced reservations. / relatively fixed capacity

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