Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The below provided details are for the ABC Company Actual Sales-Month 01 $30,000 Actual Sales-Month 02 $40,000 Forecasted Sales-Month 03 $50,000 Forecasted Sales -

  

The below provided details are for the ABC Company Actual Sales-Month 01 $30,000 Actual Sales-Month 02 $40,000 Forecasted Sales-Month 03 $50,000 Forecasted Sales - Month 04 $65,000 Forecasted Sales-Month 5 $75,000 . . The Opening Cash Balance is $5,000 and the company wishes to maintain this balance. The ABC Company's policy and past pattern indicate the following for every month . Cash sales in the month of sale 30% Collected in the 1st month after sale 40% Collected in the 2nd month after sale 30% Other income is $1,00 per month received in cash. ABC companies puthases are made all paid fully in the month of sale and are $30,000 for Month 03, $50,000 for Month 04 and $60,000 for Month 05. Rent amounts to $2,000 per month. Wages are 10% of the current month's sales. A dividend of $4,000 will be paid in Month 04. A capital expenditure on Machinery is budgeted for Month 05, amounting to $10,000. Taxes are $1,000 and are due to be paid in Month 05. a. Prepare the cash budget for Month 03, 04 & 05 using the template provided below. (20 marks) b. Recommend 5 strategies the company could adopt to improve the cash position that you have calculated (5 marks) Sales Cash Sales (30%) Lag 1 month (40%) Lag 2 months (30 %) Other Income Total Cash Receipts Disbursements Purchases Rent Wages & Salaries Dividends Capital Expenditure Taxation Total Cash Disbursements Total Cash Receipts. Total Cash Disbursements Net Cash Flow Add: Beginning Cash Ending Cash Minimum Balance Required Funding (Notes Payable) Excess Cash (Marketable Securities)

Step by Step Solution

3.44 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Month 1 Month 2 Month 03 Month 04 Month 05 Sales 30000 40000 50000 65000 75000 Cash Sales 30 9000 12... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Forecasting With Forecast X

Authors: Holton Wilson, Barry Keating, John Solutions Inc

6th Edition

73373648, 978-9339220426, 9339220420, 978-0073373645

More Books

Students also viewed these Accounting questions

Question

What is the function of an income statement?

Answered: 1 week ago

Question

Describe Hartleys seven varieties of pleasure.

Answered: 1 week ago