Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Green Friends Ltd is a garden design and landscaping business that started operations on 1 September 2020. The following information has been provided by the

Green Friends Ltd is a garden design and landscaping business that started operations on 1 September 2020. The following information has been provided by the firm.

In September, cash sales were $5,000 and credit sales $45,000. Total expected sales in the following three months are: $70,000 in October; $78,000 in November; and $82,000 in December. The company expects 10% of the sales of each month to be cash sales and the remainder credit sales. Credit sales are expected to be collected 20% in the month of the sale, 50% in the next month, and 30% in the following month.

All purchases of inventory are on credit. Purchases of inventory in September were $18,000. The company estimates purchases in the following three months to be: $19,000 in October, $20,000 in November and $21,000 in December. Purchases are paid 80% in the month of purchase, and 20% in the following month.

Wages expense is estimated to be $15,000 in October, $18,000 in November and $19,000 in December, paid in cash.

Other operating expenses are budgeted to be $12,000 in October, $14,000 in November and $18,000 in December, paid in cash.

Depreciation expenses of $1,250 per month are expected.

The cost of sales is estimated as 25% of sales revenue each month.

In October, computers costing $8,000 will be purchased and paid in cash.

In December a cash dividend of $20,000 will be paid.

In November, it is expected to receive $400 cash from the sale of old equipment at its net book value.

The cash balance at 1st October 2020 was $7,500

Required:

  1. Prepare a Budgeted Income Statement for the period October December 2020.

Budgeted Income Statement

For the period October December 2020

October - December ($)

  1. Prepare a schedule of estimated receipts from debtors (accounts receivable) for the months of October, November and December 2020.

Month of cash collection

Month

Credit Sales

Oct

Nov

Dec

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Fraud Prevention And Detection

Authors: Joseph T. Wells

5th Edition

1119351987, 9781119351986

More Books

Students also viewed these Accounting questions

Question

What obstacles interfere with eff ective listening?

Answered: 1 week ago