The following information on actual and projected costs and revenues is available for Carson Enterprize. Dates Sales $ Purchases $ Oct. 2020 80 000 65 000 Nov. 2020 60 000 45 000 Dec. 2020 90 000 75 000 Jan. 2021 50 000 35 000 Feb. 2021 60 000 45 000 Mar. 2021 70 000 55 000 April 2021 60 000 45 000 You are given the following additional information: Based on past analysis, 20% of sales tend to be for cash while the remainder is normally settled as follows: 60% in the month following sales and 40% two months after sale. Carson enterprise normally pays 50% of the cost of purchases in the month of purchase and the remainder in the following month. New equipment will be purchased for $9,000 in January and this will be paid for in equal instalments in January, February and March. Old equipment is expected to be sold for $2,500 in February. Depreciation of the new equipment will be 10% per annum and will be charged to the accounts monthly. Salaries will be $3,000 per month and utilities is expected to be $7,000 in January and is expected to increase by 10% each month after. Selling expenses of 2% of sales will be paid in the month of sale and packing expenses of 3% of purchases will be paid in the month following the purchase date. The firm will obtain a loan of $40,000 in March at an interest rate of 15% per annum. Interest will be paid on an equal monthly basis commencing in March. The balance of cash on January 1, 2021 was $15,000. Required: Prepare a schedule of expected sales collections (Sales Budget) for January to April 2021 Prepare the Purchases budget for January to April 2021 Prepare a cash budget for January to April 2021

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

Question

The following information on actual and projected costs and revenues is available for Carson Enterprize.

Dates	Sales $	Purchases $
Oct. 2020	80 000	65 000
Nov. 2020	60 000	45 000
Dec. 2020	90 000	75 000
Jan. 2021	50 000	35 000
Feb. 2021	60 000	45 000
Mar. 2021	70 000	55 000
April 2021	60 000	45 000

You are given the following additional information:

Based on past analysis, 20% of sales tend to be for cash while the remainder is normally settled as follows: 60% in the month following sales and 40% two months after sale.
Carson enterprise normally pays 50% of the cost of purchases in the month of purchase and the remainder in the following month.
New equipment will be purchased for $9,000 in January and this will be paid for in equal instalments in January, February and March. Old equipment is expected to be sold for $2,500 in February.
Depreciation of the new equipment will be 10% per annum and will be charged to the accounts monthly.
Salaries will be $3,000 per month and utilities is expected to be $7,000 in January and is expected to increase by 10% each month after.
Selling expenses of 2% of sales will be paid in the month of sale and packing expenses of 3% of purchases will be paid in the month following the purchase date.
The firm will obtain a loan of $40,000 in March at an interest rate of 15% per annum. Interest will be paid on an equal monthly basis commencing in March.
The balance of cash on January 1, 2021 was $15,000.

Required:

Prepare a schedule of expected sales collections (Sales Budget) for January to April 2021
Prepare the Purchases budget for January to April 2021
Prepare a cash budget for January to April 2021

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions