Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started