Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Alberto Ltd is a dealer in electronic goods. The followinginformation relates to the period July 2021to September 2021.1.Thebank balance on 31 July 2021is expected to

Alberto Ltd is a dealer in electronic goods. The followinginformation relates to the period July 2021to September 2021.1.Thebank balance on 31 July 2021is expected to be Rs45000(credit).2.Sixty percent of all sales are for cash; the balance ison credit. Cash sales for June and July 2021are expected to be R240000 and R300 000 respectively. Cash sales are expected to increaseby 5% per month while credit sales are expected to increase by 10%per month. Sixty percent of credit customers are expected to payafter one month for a cash discount of 2%. The remaining customerswill pay after two months, but 5% of them are expected to be baddebts.3.Alberto Limited sells its electronic goods at cost plus100%. All goods that are sold each month are replaced in the samemonth. All purchasesare on credit and creditors are paid one monthafter the purchase.4.Salaries and wages are expected to costRs82500 for September 2021after a 10% increase takes effect from 01September 2021.5.Advertising expenses are expected to be 5% ofmonthly sales, and are paid one month later.6.Equipment costingR200 000 is expected to be purchased during August 2021. A depositof 10% will be paid in August and the balance payable in 6 equalinstalments commencing September 2021.7.A long-term loan of Rs180000 at 12% per annum interest is to be raised on 01 September 2021.Interest is payable quarterly in advance with the first interestpayment to be made on 01 September 2021.8.Other expenses, includingdepreciation of Rs4000, are expected to amountto Rs46000 each monthand payments are made monthly.9.An interim dividend of 6 cents pershare is expected to be paid on 31 August 2021. The authorisedshare capital of Alberto Limited consists of 800000 ordinary sharesof which 500000 shares were issued. REQUIREDUse the informationprovided to prepare a Cash Budget for Alberto Limited for Augustand September 2021(use separate columns for each month):

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

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

Managerial Accounting

Authors: Charles Horngren

2nd Edition

0558514847, 978-0558514846

More Books

Students also viewed these Accounting questions

Question

U11 Informing Industry: Publicizing Contract Actions 317

Answered: 1 week ago

Question

=+j Enabling a productive global workforce.

Answered: 1 week ago

Question

=+ Are you interested in creating or

Answered: 1 week ago