Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[Question] The following information on actual and projected costs and revenues is available for Carson Enterprize. Dates Sales Purchases $ $ Oct. 2020 80 000

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
[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:You are given the following additional information: i. ii. iii. iv. the and is 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 accounts monthly. Salaries will be $3,000 per month and utilities is expected to be $7,000 in January expected to increase by 10% each month after. vi. 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. vii. 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. viii. The balance of cash on January 1, 2021 was $15,000. Required: 1. Prepare a schedule of expected sales collections (Sales Budget) for January to April 2021 2. Prepare the Purchases budget for January to April 2021 a. Prepare a cash budget for January to April 2021

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

Fraud Examination

Authors: W. Steve Albrecht

6th Edition

1337619671, 978-1337619677

More Books

Students also viewed these Accounting questions