Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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 April Receipts March Feb Jan 148 800 132 000 192 000 Cash sales 129 600 144 000 138 400 ? 7 Collection from debtors 7 194 370 188 700 0 0 0 Issue of shares 0 0 1 300 000 O 0 80 000 Sale of Factory Equip 0 0 0 ? Total Receipts ? 1 618 300 ?. 332 770 PAYMENTS Payments to creditors 201 563 185 625 182 250 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 Repurchase of Shares 0 O 0 ? O O Interim dividends paid 0 0 0 o 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 0 0 0 0 150 000 o Deposit on new Factory Equip Instalments on new factory Equip (incl finance charges) 0 0 0 0 0 16 000 Independent auditors fees 0 0 0 60 000 o 0 Total Payments ? ? ? ? ? ? Cash Surplus / Deficit 2 ? ? ? ? ? Cash Balance at the beginning of the period ? ? ? ? ? ? Cash Balance at the end of the period ? ? ? ? ? ? 7 Consider the shares and dividends. 7.1 Calculate the number of new shares that will be issued in January 2021. (2)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Taxation Of Individuals And Business Entities 2015

Authors: Brian Spilker, Benjamin Ayers, John Robinson, Edmund Outslay, Ronald Worsham, John Barrick, Connie Weaver

6th Edition

9780077862367

Students also viewed these Accounting questions