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

You are provided with a Cash Budget of Mbatha Ltd for January to June 2021. The financial year- end is 28 February 2021. Show all

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

You are provided with a Cash Budget of Mbatha Ltd for January to June 2021. The financial year- end is 28 February 2021. Show all calculations. You are required to complete the questions in the answer booklet provided: Additional Information: 1. Total sales for the Budget period is expected to be as follows: January February March April May June 324 000 346 000 360 000 480 000 330 000 ? 2. Cash sales are expected to be 40% of total sales for the entire budget period. 3. Debtors are expected to pay as follows: 50% pay in the same month as the sales transaction (less 5% discount) 30% pay in the month after the sales transaction month 15% pay in the second month after the sales transaction month 5% are expected to be bad and are written off in the third month after the transaction 4. The current mark-up is 60% on cost. 5. A fixed base stock of raw materials is kept at all times. All raw materials are bought on credit. Creditors are paid in the month following the purchase of stock (i.e. within 30 days) to earn a 10% discount. 6. At the end of the financial year ended 28 February 2021, the return on total capital employed was 5% > Mbatha LTD Cash Budget for the six period January to June 2021 May June March April Receipts Jan Feb 132 000 148 800 192 000 Cash sales 129 600 138 400 144 000 ? ? ? Collection from debtors 188 700 194 370 0 0 0 Issue of shares 0 1 300 000 0 80 000 01 0 Sale of Factory Equip 0 0 0 ? ? Total Receipts 1 618 300 332 770 ? ? PAYMENTS Payments to creditors 201 563 182 250 185 625 A B Salary of Factory Manager 20 000 20 000 20 000 20 000 20 800 20 800 Wages for 20 Direct Labourers 150 000 150 000 150 000 150 000 161 250 161 250 Directors Fees 66 000 66 000 66 000 66 000 66 000 66 000 Interest on loan (8% p.a.) 5 600 5 600 4 200 4 200 4 200 2 700 Repayment of loan 0 0 D 0 0 E 2 Repurchase of Shares 0 0 o ? o 0 Repurchase of Shares 0 0 0 ? 0 0 Interim dividends paid 0 0 0 0 0 F Maintenance of Factory Equip 12 000 12 000 12 000 12 000 2 000 2 000 Electricity (80% for factory) 8 000 8 000 8 000 8 000 6 500 6 500 Deposit on new Factory Equip 0 0 0 0 150 000 0 Instalments on new factory Equip (incl finance charges) o O 0 0 0 16 000 Independent auditors fees 0 0 0 60 000 0 0 Total Payments ? ? ? ? ? ? Cash Surplus / Deficit ? ? ? ? ? ? Cash Balance at the beginning of the period ? ? ? ? ? ? Cash Balance at the end of the period ? ? ? ? ? ? 7.2 One of the current shareholder has requested that the business repurchase his shares in April 2021. The business has agreed to this request. Complete the table below to show how this repurchase will be treated by the business: Account DR Account CR Amount 7.3 Calculate the amount that is budgeted for Interim Dividends (labelled F)

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 Introduction To Concepts Methods And Uses

Authors: Clyde P. Stickney, Roman L. Weil

11th Edition

0324222971, 978-0324222975

More Books

Students explore these related Accounting questions