Bài tập chương 14
Các bạn ghi từng bước giải vào giấy, chụp lại và submit lên hệ thống.
Không chấp nhận bài tập chỉ ghi mỗi đáp án.
EX1: The financial statements in 2022 and 2023 of the company ABC included the following items. What was ABC’s cash cycle? The unit currency is dollar million.
|
2022 |
2023 |
|
|
Inventory |
$15,547 |
$12,625 |
|
Receivables |
$20,113 |
$18,729 |
|
Payables |
$14,969 |
$14,417 |
|
2023 |
|
|
Sales |
$55,656 |
|
Cost of good sold |
$41,454 |
EX2: A company has accounts receivable of $50,000, inventory of $65,000, sales of $450,000, and cost of goods sold of $330,000. How long does it take the company to sell its inventory and collect payment on the sale?
EX3: Construct a table sources of cash. Know that the sales in the last quarter of year 2022 were $150 million and receivables at the start of the 1st quarter in 2023 is $200 million. The sales (in millions) in 4 quarters of 2023 are expected to be $800; $900; $700; $500, respectively. Assume that 55% of sales are cashed in the immediate quarter and the remaining of sales are cashed in the following quarter.
EX4: A company has forecast sales in the first 3 months of the year as follows (figures in millions): January, $60; February, $80; March, $100. 60% of sales are usually paid for in the month that they take place and 40% in the following month. Receivables at the end of December were $24 million. What are the forecasted collections on accounts receivable in March?
EX5:
|
1st quarter |
2nd quarter |
3rd quarter |
4th quarter |
|
|
Receivables at start of period (mil VND) |
200 |
|||
|
Sales (mil VND) |
500 |
900 |
700 |
400 |
We assume that sales in the last quarter of the previous year were 100 mil VND.
Assume that 65% of sales are cashed in in the immediate quarter and 35% are cashed in the following quarter.
• Use of cash:
|
1st quarter |
2nd quarter |
3rd quarter |
4th quarter |
|
|
Payment on AP |
250 |
280 |
320 |
260 |
|
Increase in inventory |
150 |
150 |
170 |
180 |
|
Labor and other expenses |
110 |
110 |
110 |
110 |
|
Capital expenditures |
70 |
20 |
35 |
49 |
|
Taxes, interest and dividends |
66 |
66 |
66 |
66 |
|
Total uses |
646 |
626 |
701 |
665 |
a) Calculate receivables at the end of period?
b) Construct table showing cumulative financing requirement in this year.
We assume that minimum operating cash balance is 100 million VND and cash at start of the period is 110 million VND.
EX6: Complete the Cash Budgeting (Unit: dollar)
|
Sales |
|
|
Purchases |
|
|
May |
180 |
|
May |
50 |
|
Credit |
1 month |
|
Credit |
1 month |
|
Sales policy: + For cash: 60% + For credit: 40% |
||||
|
|
June |
July |
August |
|
|
300 |
320 |
280 |
|
|
|
|
|
|
|
+ For cash |
70 |
80 |
60 |
|
|
+ For credit |
40 |
30 |
40 |
|
|
30 |
30 |
30 |
|
|
10 |
10 |
10 |
|
|
100 |
0 |
0 |
|
Assume that minimum cash for each month is $100. The cash at start of June is $60.