Use the following information to answer questions 23 to 30. In order to ascertain clarity on how much cash Musa (Pty) Ltd needs each month, complete the cash budget using the information below. Sales (in rand) are as follows:
|
:June |
July |
August |
September |
October |
November |
|
950 000 |
1 100 000 |
1 300 000 |
1 450 000 |
1 600 000 |
1 850 000 |
Of the company’s sales, 40% are done in cash. Credit sales are collected as follows:
40% during the month of sale
20% during the first month following the month of sale
20% during the second month following the month of sale
20% during the third month following the month of sale
Purchases are as follows:
|
June |
July |
August |
September |
October |
November |
|
530 000 |
600 000 |
300 000 |
715 000 |
880 000 |
1 000 000 |
All purchases are on credit and are paid as follows:
40% during the month of purchase
30% during the first month following the month of purchase
15% during the second month following the month of purchase
15% during the third month following the month of purchase
Other information
Salaries and wages of R100 000 are paid monthly
Rent of R50 000 on a monthly basis
Interest on debt of R4 000 each month
Major maintenance on machines and plant amounting to R1 500 000 in October was undertaken.
Depreciation costs of R20 000 is charged on a monthly basis
At the beginning of September, the business will have R50 000 in cash
The management of the company has a policy of maintaining R50 00 minimum cash balance.
Requirements:
Compile the cash budget for Musa (Pty) Ltd for the months of September, October and November. Also indicate the financing needed to maintain the minimum cash balance and meet the operational requirements.
Question 23
Calculate the total credit sales collected for October.
1. R846 000
2. R896 000
3. R950 000
4. R986 000
Question 24
Calculate the opening balance for October.
1. R430 000
2. R585 800
3. R680 500
4. R720 200
Question 25
Calculate the total credit purchases collected for September.
1. R360 000
2. R460 000
3. R520 500
4. R545 500
Question 26
Calculate the total credit sales collected for November.
1. R566 000
2. R700 000
3. R966 000
4. R975 000
Question 27
Calculate the financing required for October.
1. R239 000
2. R397 500
3. R405 000
4. R515 000
Question 28
Calculate the financing required for November.
1. R154 000
2. R297 500
3. R496 750
4. R515 000
Question 29 Calculate the cash sales for September. 1. R340 000 2. R580 000 3. R650 000 4. R700 000 .
Question 30 Calculate the credit purchases for June that were collected in September. 1. R114 000 2. R140 000 3. R160 000 4. R170 000
In: Finance
Natalie has prepared the balance sheet and income statement of
Cookie & Coffee Creations Inc. and would like you to prepare
the cash flow statement. The comparative balance sheet of Cookie
& Coffee Creations Inc. at October 31, 2023 for the years 2023
and 2022 and the income statement for the year ended October 31,
2023, are presented below.
| COOKIE &
COFFEE CREATIONS INC. Balance Sheet October 31, |
||||||
|---|---|---|---|---|---|---|
| Assets | 2023 | 2022 | ||||
|
Cash |
$29,074 | $11,550 | ||||
|
Accounts receivable |
3,250 | 2,710 | ||||
|
Inventory |
7,897 | 7,450 | ||||
|
Prepaid expenses |
5,800 | 6,050 | ||||
|
Equipment |
102,000 | 75,500 | ||||
|
Accumulated depreciation— equipment |
(25,200) | (9,100) | ||||
|
Total assets |
$122,821 | $94,160 | ||||
| Liabilities and Stockholders’ Equity | 2018 | 2017 | ||||
|
Accounts payable |
$1,150 | $2,450 | ||||
|
Income taxes payable |
9,251 | 7,200 | ||||
|
Dividends payable |
27,000 | 27,000 | ||||
|
Salaries and wages payable |
7,250 | 1,280 | ||||
|
Interest payable |
188 | 0 | ||||
|
Note payable |
10,000 | 0 | ||||
|
Preferred stock, no par, $6 cumulative, 3,000 and 2,800 shares issued, respectively |
15,000 | 14,000 | ||||
|
Common stock, $1 par—25,930 shares issued and outstanding |
25,930 | 25,930 | ||||
|
Additional paid-in capital—treasury stock |
250 | 0 | ||||
|
Retained earnings |
26,802 | 16,800 | ||||
|
Less: Treasury stock |
0 | (500) | ||||
|
Total liabilities and stockholders’ equity |
$122,821 | $94,160 | ||||
| COOKIE &
COFFEE CREATIONS INC. Income Statement Year Ended October 31, 2023 |
||||
|---|---|---|---|---|
|
Sales |
$485,625 | |||
|
Cost of goods sold |
222,694 | |||
|
Gross profit |
262,931 | |||
|
Operating expenses |
||||
|
Salaries and wages expense |
$147,979 | |||
|
Depreciation expense |
17,600 | |||
|
Other operating expenses |
48,186 | 213,765 | ||
|
Income from operations |
49,166 | |||
|
Other expenses |
||||
|
Interest expense |
$413 | |||
|
Loss on disposal of plant assets |
2,500 | 2,913 | ||
|
Income before income tax |
46,253 | |||
|
Income tax expense |
9,251 | |||
|
Net income |
$37,002 | |||
Additional information:
| 1. | Equipment (cost $4,500 and book value $3,000) was disposed of at the beginning of the year for $500 cash and replaced with new equipment purchased for $4,000 cash. | |
| 2. | Additional equipment was bought for $14,000 on November 1, 2022. A $12,000 note payable was signed. The terms provide for equal semi-annual installment payments of $2,000 on May 1 and November 1 of each year, plus interest of 5% on the outstanding principal balance. | |
| 3. | Other equipment was bought for $13,000 cash. | |
| 4. | Dividends were declared on the preferred and common stock on October 15, 2023, to be paid on November 15, 2023. | |
| 5. | Accounts payable relate only to merchandise creditors. | |
| 6. | Prepaid expenses relate only to other operating expenses. |
Prepare a statement of cash flows for Cookie & Coffee Creations Inc. for the year ended October 31, 2023, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)Partially correct answer iconYour answer is partially correct.
Prepare a statement of cash flows for Cookie & Coffee Creations Inc. for the year ended October 31, 2023, using the direct method. (Show amounts in the investing and financing sections that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)
|
$Enter a dollar amount |
In: Accounting
Bank Reconciliation and Entries
The Coins, currency (paper money), checks, money orders, and money on deposit that is available for unrestricted withdrawal from banks and other financial institutions.cash account for Collegiate Sports Co. on November 1 indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The A summary of all transactions mailed to the depositor or made available online by the bank each month.bank statement indicated a balance of $112,675 on November 30. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:
Required:
1. Prepare a bank reconciliation as of November 30.
| Collegiate Sports Co. | ||
| Bank Reconciliation | ||
| November 30 | ||
| Cash balance according to bank statement | $ | |
|
||
| $ | ||
|
$ | |
|
||
| Adjusted balance | $ | |
| Cash balance according to company's records | $ | |
|
$ | |
|
||
| $ | ||
|
$ | |
|
||
| Adjusted balance | $ | |
Feedback
2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. For a compound transaction, if a box does not require an entry, leave it blank.
| a. Nov. 30 |
|
||
|
|||
|
|||
|
|||
| b. Nov. 30 |
|
||
|
|||
|
3. If a balance sheet is prepared for
Collegiate Sports Co. on November 30, what amount should be
reported as cash?
$
In: Accounting
A study indicates that 90% of American teenagers have tattoos. You randomly sample 25 teenagers. Find the probability that less than 19 will have tattoos. Round your answer to 4 decimal places.
In: Statistics and Probability
According to AMA (American Medical Association) give me the information about the Evaluation and Management (E/M) changes coming for 2021? How many new codes coming, deleted codes, and revision codes?
In: Nursing
Which of the following would be studied in Microeconomics?
a. The level of prices in the American economy
b. The fixed costs of the Mxyzptlk Corporation
c. Aggregate demand in the second quarter of 2020
d. The balance of trade differential with China
In: Economics
Describe the attitudes of employers and other workers toward immigrant, African American, and female workers. Why were these workers seen as “taking” the jobs of others, and how did this view affect their opportunities and working experiences?
In: Psychology
Many of the causes were linked to irresponsible behaviors throughout the 1920s by companies, banks, governments, and American consumers. Please discuss 1 of these irresponsible behaviors and describe in detail how this behavior contributed to the Great Depression.
In: Economics
1. Why did the United States go to war with Britain in 1812? Which groups of people supported and opposed the war? Why?
2. Examine the impact the War of 1812 had on American industrial development.
In: Economics
John Ford's The Searchers is a classic American Western. Discuss how the cinematographer's choice of film stock affected the film’s overall look and feel. How did this differ from the traditional Western genre film?
In: Economics