Prepare a cash budget for the month of september and october

Assignment Help Accounting Basics

Reference no: EM131912803

Problem

Marshall Department Stores has budgeted sales revenues as follows:

Credit sales July $250,000

August 190,000

September 150,000

October 140,000

In the past, 75% of the credit sales were collected in the month of sale, 20% were collected in the first month following the sale and 5% in the second month following the sale. Purchases of inventory are all on credit and 28% is paid in the month of purchase and 72% in the month following purchase. Budgeted inventory purchases are:

July $200,000

August 100,000

September 125,000

October 150,000

Other cash disbursements budgeted: (a) selling and administrative expenses of $20,000 each month, (b) dividends of $50,000 will be paid in September, and (c) purchase of a van in October for $45,000 cash.

The company wishes to maintain a minimum cash balance of $50,000 at the end of each month. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on September 1 was $50,000.

If money is borrowed, ignore interest

INSTRUCTIONS

(a) Prepare separate schedules for (1) expected collections from customers and (2)expected payments for purchases of inventory.

(b) Prepare a cash budget for the months of September and October.

Reference no: EM131912803

Questions Cloud

What is he initial investment outlay : The company spent and expensed 4150,000 on research related to the new product last year. would this change your answer? Explain.

What is the corporate veil : It is called lifting of corporate veil. what is the corporate veil and under what circumstance can the corporate veil be pierced

Distinction between statistical and practical significance : 1. Every user of statistics should understand the distinction between statistical significance and practical (or clinical) significance.

Determine the purpose of your presentation : Pick a professional or career topic that is of personal interest to you (e.g., becoming a manager, criminal justice careers, programming, interview tips.

Prepare a cash budget for the month of september and october : Prepare separate schedules for expected collections from customers. Prepare a cash budget for the months of September and October.

Evaluate current operating system : Lander Corporation used the data to evaluate their current operating system. The company sells items for $18 each and used a budgeted selling price

Compute the proportion in the optimal risky portfolio : Calculate expected excess returns, alpha values, and residual variances for these stocks. (Negative values should be indicated by a minus sign.

A bank account has an infinite number of compounding periods : You have calculated the present value of a lump sum to be received in ‘ n ' years using a discount rate of r assuming annual compounding periods.

Discuss different depreciation methods for plant assets : In this Chapter, you will learn three different depreciation methods for plant assets: Units-of-production method.

User Account

All Pages