Prepare a collections schedule for the three-month period

Reference no: EM132706124

Question - The following information was extracted from ABC Ltd's financial statements for the year ended 31 December 2019.

a. Sales on 30 November 2019 were K100 million and K110 million on 31 December 2019. For the year 2020, sales are expected to double at a constant monthly rate.

b. 80% of the sales made are on account; the remainder on cash.

c. From past experience, 5% of the receivables have turned out to be irrecoverable.

d. Credit customers pay as follows:

i. 75% in the month following the sale;

ii. 15% two months after the sale month.

e. Inventory levels are maintained at 20% of the following month's sales.

f. Accounts payables are at settled at 30 days after purchase.

Required -

i. Prepare a collections schedule for the three-month period from January to March 2020.

ii. Prepare a cash forecast for the three-month period from January to March 2020.

iii. Assess the Operating Cycle ratios and their implication on the working capital requirements of the company for the forecast period.

Reference no: EM132706124

Questions Cloud

What are benefits of utilizing the negotiation process : What are the benefits of utilizing the negotiation process first? What are the ramifications of choosing the governing law? Explain.

Calculate their taxable income : They had deductions for adjusted gross income of $3,000 and itemized deductions of $12,000. Calculate their taxable income. Use 2019 tax law

Should request prior authorization of the company : Should request prior authorization of the company to be addressed to ensure that all students are working on unique companies.

Provide an idea for future research : Provide a brief summary of each article and outline key findings and Define and incorporate key concepts from the articles into your discussion of the movie

Prepare a collections schedule for the three-month period : Sales on 30 November 2019 were K100 million and K110 million on 31 December 2019. Prepare a collections schedule for the three-month period

About how congress works : Given what you now know about how Congress works and how a bill is passed, what is different about an omnibus bill?

Find what the profit margin would be : Find What the profit margin would be? Sales returns and allowances 3000. Cost of goods sold 87000. Sales revenue 200000. Sales discounts 9000

Describe how the rest of the paper will proceed : Introduce the theoretical perspective you will use and define its key concepts and Describe at least 3 examples from the TV show or movie

Discuss the edge is in cloud computing : Discuss the "Edge" is in cloud computing. What is it? Why is it important? What impact will it have on the industry? Alternatively, what are some of the areas.

User Account

All Pages