Peters has asked you to prepare a cash budget for the six months from 1 July 2021 to31 December 2021 and has provided you with the following information:1) Trade debtors and trade creditors at 30 June 2021 were N$80,000 and N$84,000respectively.2) Peters expects to sell 700 units in each of July and August, 900 units in each ofSeptember and October, 1,200 units in November and 800 units in each ofDecember 2021 and January 2022. The selling price of each unit is calculated byadding a markup of 50% to the unit cost price of N$120.3) 20% of each month's sales will be for cash and will be subject to a 5% cashdiscount. The remainder will be sold on credit and be paid for in the monthfollowing the month of sale.4) Purchases in each month will be sufficient to meet the next month's sales. Theywill be paid for in the month following the month of purchase and be subject to a2% settlement discount. No other stocks will be held.5) Bank overdraft interest will be paid at 1% per month based upon the previousmonth's closing balance.Required:a) Prepare the cash budget (All workings must be clearly shown)

Budgeting is the process of estimating or forecasting for future period. Cash budget shows expected…

Answered: Peters has asked you to prepare a cash…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Adeline Sdn Bhd has engaged you to prepare its cash budget for July 2021. The following is the information extracted from its management report: May 2021 June 2021 July 2021 Credit sales 500,000 450,000 600,000 Purchases of direct material 300,000 500,000 550,000 Expenses 80,000 Other receipts: Sale of investments 30,000 Other payments: Purchase of van 60,000 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Of direct material purchases, 40% are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items and expenses above are paid in the month incurred. The cash balance on 1 July 2021 is expected to be RM60,000. Adeline wants to maintain a minimum cash balance of RM50,000. Required: How much will Adeline receive in…
Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
From the following information, prepare a monthly cash budget for the three months ending 31st December 2023. Month June July August September October November December Materials Wages 1,800 650 2,000 750 2,400 750 2,250 750 2.300 800 2,500 2,600 900 1,000 The credit terms are as follows: 10% of sales are in cash. 3 months to debtors. 2 months from Creditors. Sales 3,000 3,250 3,500 3,750 4,000 4,250 4,500 The lag in payment for wages is 1/4 month and 1/2 month for overheads. The cash and bank balance on 1st October is expected to be RO 1,500. Other information is given as follows: Admin. Selling, etc 160 160 175 175 200 200 225 Production 225 225 250 300 300 350 350 Preference share dividends @ 5% on RO 50,000 are to be paid on 1st December. Calls on 250 equity shares @RO 2 per share are expected on 1st November. Dividends from investments amounting to RO 250 are expected on 31st December. Income tax (advance) is to be paid in December RO 1,500 Plant and machinery are to be installed…
The accountant of Turn Key (Pty) Ltd instructs you to prepare a monthly cash budget for August. You are presented with the following budget information for July and August 2020. July August Sales. R590 000. R650 000 Manufacturing costs. R300 000. R340 000 Selling and administrative expenses R150 000. R170 000 Capital expenditures R120 000 (August) 1. The company expects to sell 10% of its merchandise for cash. 2. Credit sales will be collected as follows: 60% are expected to be collected in the month following the month of sale, and the remainder, in the second month following the month of sale. 3. On August 1 Cash balance was R55 000. 4. Accounts receivable as a result June credit sales was R442 000. 5. It is expected that R1 500 in dividends will be received in August. 6. All selling and administrative expenses are paid in cash in the period in which they are…
B. Mahmoud Repair Company is preparing its budget for the first quarter of 2021. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2021 are: November 2020, $120,000; December 2020, $110,000; January 2021, $140,000; February 2021, $160,000; March 2021, $170,000. Purchases on landscaping supplies (direct materials) are paid 40% in the month of purchase and 60% the following month. Actual purchases for 2020 and expected purchases for 2021 are: December 2020, $21,000; January 2021, $20,000; February 2021, $22,000; March 2021, $27,000. Instructions (a) Prepare the following schedules for each month in the first quarter of 2021 and for the quarter in total: (1)…
Sunland Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2019 and expected service revenues for 2020 are November 2019, $93,620; December 2019, $83,630; January 2020, $102,120; February 2020, $123,950; and March 2020, $133,630.Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2019 and expected purchases for 2020 are December 2019, $16,410; January 2020, $13,540; February 2020, $18,970; and March 2020, $23,150.(a)Prepare the following schedules for each month in the first quarter of 2020 and for the quarter in total:(1) Expected collections…
You are required to prepare the cash budget for the two months of January and February 2021. The following is the projected information: December 2020 January 2021 February 2021 Cash sales R221,866 R239,058 R249,441 Receivables collection R188,565 R194,354 R206,276 Cash purchases R8,949 R10,443 R13,354 Operating expenses R47,858 R54,026 R66,970 Credit purchases R76,504 R82,520 R94,445 Operating expenses are paid in the month they are incurred and credit purchases are paid within 30 days of purchase (ie. in the following month). The bank balance on 1 January 2021 is expected to be R62,819 favourable. Equipment to the value of R239,357 is to be purchased on credit in January 2021 and will be paid for in 8 equal instalments, commencing on 1 February 2021. The expected payments total for February 2021 will be:
NUBD Company has budgeted its activity for October 2021 based on the following information:i. Sales are budgeted at P300,000. All sales are credit sales and a provision for doubtful accounts is made monthly at the rate of 3% of sales. ii. Merchandise inventory was P70,000 at September 30, 2021 and an increase of P10,000 was planned for the month. iii. All merchandise is marked-up to sell at invoice cost plus 50%. (Gross profit rate based on cost) iv. Estimated cash disbursements for selling and administrative expenses for the month are P40,000. v. Depreciation for the month is projected at P5,000. NUBD is projecting operating income for the month of October 2021 in the amount of A. P96,000 B. P56,000 C. P55,000 D. P46,000
NUBD Company has budgeted its activity for October 2021 based on the following information:i. Sales are budgeted at P300,000. All sales are credit sales and a provision for doubtful accounts is made monthly at the rate of 3% of sales. ii. Merchandise inventory was P70,000 at September 30, 2021 and an increase of P10,000 was planned for the month. iii. All merchandise is marked-up to sell at invoice cost plus 50%. (Gross profit rate based on cost) iv. Estimated cash disbursements for selling and administrative expenses for the month are P40,000. v. Depreciation for the month is projected at P5,000. NUBD is projecting operating income for the month of October 2021 in the amount of P96,000 P56,000 P55,000 P46,000
NUBD Company has budgeted its activity for October 2021 based on the following information:i. Sales are budgeted at P300,000. All sales are credit sales and a provision for doubtful accounts is made monthly at the rate of 3% of sales. ii. Merchandise inventory was P70,000 at September 30, 2021 and an increase of P10,000 was planned for the month. iii. All merchandise is marked-up to sell at invoice cost plus 50%. (Gross profit rate based on cost) iv. Estimated cash disbursements for selling and administrative expenses for the month are P40,000. v. Depreciation for the month is projected at P5,000. NUBD is projecting operating income for the month of October 2021 in the amount of:a. 96,000 b. 56,000 c. 55,000 d. 46,000
REQUIRED Use the information given below to prepare the Cash Budget for each of the first three months of operations (i.e. January, February, March 2024). Use separate monetary columns for each month. INFORMATION The following information relates to Baby Manufacturers which will commence business on 01 January 2024 with R750 000 cash: 1. New machinery and equipment will be purchased on 02 January 2024 for R300 000. A deposit of 20% will be paid immediately. The balance of the debt as well as finance charges of R18 000 will be paid in 12 equal instalments commencing February 2024. 2. Production will commence on 05 January 2024 and 30% of the sales for February's will be manufactured in January. Each month thereafter the production will consist of 70% of the current month's sales and 30% of the following month's sales. 3. Estimated sales at R72 per unit are as follows: January February March April Units 0 8 500 11 000 10 500 4. Cash sales are expected to comprise 60% of the total sales.…
An entity is budgeting its cash payments for the last quarter of 2020. All purchases are made on account with 2% discount for early payments. The October purchases is set at P150,000, and purchases increase by 20% based on the previous month. 50% of purchases are paid on the month of purchase, availing of the purchase discount; 45% are paid the next month; and 5% are paid after 2 months from date of purchase. How much is the total cash payment to be made in December 2020?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS