Question

In: Accounting

3. CDE Ltd has provided the following budgeted Income Statement extract for the July-September quarter in...

3. CDE Ltd has provided the following budgeted Income Statement extract for the July-September quarter in 2020.

July             August       September
$,000               $’000               $’000

Sales (all on credit) 85                    88                    91
Purchases (43)                  (45)                 (47)
Depreciation expense (5)                    (5)                   (5)
Electricity expense (6)                    (6)                   (6)
Other expenses (25)                  (25)                 (25)

You are also given the following additional information:

  • All sales are collected in cash the month after sale.
  • All purchases are made on credit and paid for in cash the month after purchase.
  • Electricity is paid at the end of each quarter (i.e. on 30 September)
  • Other expenses are paid in cash in the same month they are incurred.
  • The business plans to buy a delivery van in August for $40,000 cash.
  • The cash balance is $17,000 on 31 July 2020.
  1. Prepare a cash budget for CDE Ltd for the month of August and September.
  2. Assess the cash position of CDE Ltd. Should CDE Ltd proceed with the purchase of delivery van as planned?
  3. Give your reasons and suggest alternatives if applicable.

Solutions

Expert Solution

Given information

All sales are collected in cash the month after sale.

All purchases are made on credit and paid for in cash the month after purchase.

Electricity is paid at the end of each quarter (i.e. on 30 September).

Other expenses are paid in cash in the same month they are incurred.

The business plans to buy a delivery van in August for $40,000 cash.

Data for preparing cash budget:

July August September
a. Sales $85,000 $88,000 $91,000
b. Collections from customers $85,000 $88,000
c. Purchases $43,000 $45,000 $47,000
d. Payment for purchases $43,000 $45,000
e. Electricity expense $6,000 $6,000 $6,000
f. Payment for electricity expense $18,000
g. Payments for other expenses $25,000 $25,000 $25,000
h. Total payments (d+f+g) $68,000 $88,000

a. Statement showing the cash budget for CDE Ltd for the month of August and September:

August September
a. Opening Cash balance $17,000 $34,000
b. Collections from customers $85,000 $88,000
c. Total Cash Available (a+b) $102,000 $122,000
d. Cash disbursements $68,000 $88,000
e. Ending Cash balance (c-d) $34,000 $34,000

b. Assessment of the cash position of CDE Ltd:

The business plans to buy a delivery van in August for $40,000 cash, but the company does not have the enough cash balance at the end of the August to pay for the purchase it needs to obtain a loan from the local bank to finance the funds. The shortfall of amount is $6,000 ($40,000 - $34,000).

c. Alternatives available is:

1. The company can raise the funds by issue of common stock.

2. Rising of bank loan

3. By issuing the long term debt (note).


Related Solutions

Bryant Corporation has provided the following information for the most recent quarter, July 1 through September...
Bryant Corporation has provided the following information for the most recent quarter, July 1 through September 30 of 2020. Prepare a multiple-step Income Statement and the Asset section of a classified Balance Sheet, including the correct headings. Specific Account Balance Specific Account Balance Accounts Payable $30 Insurance Payable $1 Accounts Receivable        136 Interest Expense 17 Accumulated Depreciation (Buildings)     30 Interest Payable 4 Accumulated Depreciation (Equipment) 7 Inventory     75 Allowance for Doubtful Accounts 13 Land 145 Bad Debt...
CDE Ltd has provided you with the following data relating to the product manufactured by his...
CDE Ltd has provided you with the following data relating to the product manufactured by his factory: Selling price per unit $ 100 Variable manufacturing costs per unit 48 Fixed manufacturing costs per annum 250,000 Variable marketing, distribution and administration costs per unit 16 Fixed non-manufacturing costs per annum 182,000. CDE Ltd has spare capacity and receives a special order from an interstate retailer for 1,000 units at a price of $80 per unit. Briefly explain why CDE Ltd should...
Use the following information to answer questions 40 to 41: CDE Ltd has provided the following...
Use the following information to answer questions 40 to 41: CDE Ltd has provided the following budgeted Income Statement extract for the July-September quarter in 2020.                                               July August September                                             $,000 $’000 $’000 Sales (all on credit) 85 88 91 Purchases (43) (45) (47) Depreciation expense (5) (5) (5) Electricity expense (6) (6) (6) Other expenses (25) (25) (25) You are also given the following additional information: All sales are collected in cash the month after sale. All purchases are made...
Use the following information to answer questions 31 to 36: CDE Ltd has provided you with...
Use the following information to answer questions 31 to 36: CDE Ltd has provided you with the following data relating to the product manufactured by his factory: Selling price per unit $ 100 Variable manufacturing costs per unit 48 Fixed manufacturing costs per annum 250,000 Variable marketing, distribution and administration costs per unit 16 Fixed non-manufacturing costs per annum 182,000 What is the contribution margin per unit? Show your workings. Calculate quantity to produce to break even in both units...
Harrti Corporation has budgeted for the following sales: July $ 449,000 August $ 584,000 September $...
Harrti Corporation has budgeted for the following sales: July $ 449,000 August $ 584,000 September $ 617,000 October $ 892,000 November $ 750,000 December $ 710,000 Sales are collected as follows: 15% in the month of sale; 65% in the month following the sale; and the remaining 20% in the second month following the sale. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?
r supervisor has provided you with the following draft statement of income: Smoking’ Hot Ltd. Statement...
r supervisor has provided you with the following draft statement of income: Smoking’ Hot Ltd. Statement of Income Year Ended October 31, 2020 Sales $76,445,500 Gain on sale of building 975,000 77,420,500 Expenses    Cost of goods sold 48,542,900    Depreciation 660,100    Interest 93,200    Other operating 313,700    Rent 1,800,000    Salaries and wages 8,452,900 59,862,800 Income before income taxes 17,557,700 Income tax expense 5,267,000 Net income $12,290,700 Your supervisor has asked you to INDICATE whether the statement of income was prepared in the...
An extract from the income statement of PoMA Ltd for the previous year is given below:                            &
An extract from the income statement of PoMA Ltd for the previous year is given below:                                                                                                                                                                                             Rs.                          Sales (50,000 units)                                         1,000,000 Direct materials                                                350,000                 Direct labor cost (50,000 hours)                 200,000                 Fixed manufacturing overhead                  190,000 Variable manufacturing overhead            50,000 Administration overheads                           180,000                 Selling and distribution overhead             120,000                                                                                                                                 The directors are keen to improve revenue and productivity and are considering various options.             You are the management accountant and are requested to compute the following:                                                                                                ...
(URGENT) An extract from the income statement of PoMA Ltd for the previous year is given...
(URGENT) An extract from the income statement of PoMA Ltd for the previous year is given below:                                                                                                                                                                                             Rs.                          Sales (50,000 units)                                         1,000,000 Direct materials                                                350,000                 Direct labor cost (50,000 hours)                 200,000                 Fixed manufacturing overhead                  240,000 Variable manufacturing overhead            50,000 Administration overheads                           180,000                 Selling and distribution overhead             120,000                                                                                                                                 The directors are keen to improve revenue and productivity and are considering various options.             You are the management accountant and are requested to compute the following:                                ...
URGENT An extract from the income statement of PoMA Ltd for the previous year is given...
URGENT An extract from the income statement of PoMA Ltd for the previous year is given below:                                                                                                                                                                                              Rs.                           Sales (50,000 units)                                         1,000,000 Direct materials                                                350,000                  Direct labor cost (50,000 hours)                 200,000                  Fixed manufacturing overhead                  210,000 Variable manufacturing overhead            50,000    Administration overheads                           180,000                  Selling and distribution overhead             120,000                                                                                                                                   The directors are keen to improve revenue and productivity and are considering various options.             You are the management accountant and are requested to compute the...
Razz Corporation has budgeted for the following sales: July $425,000 August $510,000 September     $605,000 October $860,000...
Razz Corporation has budgeted for the following sales: July $425,000 August $510,000 September     $605,000 October $860,000 November $715,000 December $680,000 Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale; and the remaining 30% in the second month following the sale. 1. What is the budgeted total cash collected in December? 2. In Razz's budgeted balance sheet at December 31, at what amount will accounts receivable be shown?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT