Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

table [ [ Month , Sales,Purchases,Wages,Exp ] , [ , , , , ] , [ Jan . ( actual ) , 8 0

\table[[Month,Sales,Purchases,Wages,Exp],[,,,,],[Jan.(actual),80000,00,47000,00,23000,00,6200,00],[Feb.(Actual),78000,00,48000,00,17500,00,6800,00],[Mar.(actual),82500,00,50000,00,25500,00,6750,00],[Apr. Budget,78000,00,61000,00,26500,00,6100,00],[May.Budget,72500,00,56000,00,24750,00,6450,00],[Jun. Budget,79000,00,37000,00,23000,00,6800,00]]
ou are further informed that:
10% of purchases and 20% of sales are for cash.
The average collection period of the company is half a month and credit purchases are paid off regularly after one month.
Wages are paid half monthly and the rent, excluded in expenses, is paid monthly.
Cash and bank balance on April 1 was 15000 and the company aims to keep it below this figure at the end of every. The excess cash is placed in fixed deposits.
1- With all theses information, please prepare a cash budget for a company for April, May and June.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Financial Accounting

Authors: Robert F. Meigs, Jan R. Williams, Mark S. Bettner, Susan F. Haka, Sue Haka

11th Edition

0072516682, 978-0072516685

More Books

Students explore these related Accounting questions