Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a coop student at Canada Fireworks and have been asked to prepare a cash budget for the month of April. The Balance Sheet

image text in transcribedimage text in transcribed

You are a coop student at Canada Fireworks and have been asked to prepare a cash budget for the month of April. The Balance Sheet for Canada Fireworks at March 31 is below. Balance Sheet March 31 Assets Cash $40,000 Accounts receivable 16,000 Inventory 69,100 Prepaid Insurance* 900 Property, Plant and Equipment (net) 10.900 Total Assets $136.900 Liabilities Accounts payable $26.500 Total liabilities 26,500 Shareholders' Equity Common shares 50,000 Retained earnings 60.400 Total shareholders' equity 110,400 Total Liabilities and Shareholders' Equity $136.900 *The company prepaid $1,200 of insurance at the start of January. Prepaid insurance is amortized (expensed) monthly at $100 per month. It is the company's policy to maintain a minimum cash balance of $10,000 per month. Information items pertaining to April's operations: a) The company purchases an asset for $80,000 in cash. b) April sales are expected to be $84,000, 70% of which are cash sales. The longstanding pattern of collection for credit sales is 60% in the month of sale and 40% in the following month. c) April purchases for merchandise inventory was $25,000, of which $10,000 was for cash and the balance on credit. The pattern of payment for credit purchases of inventory is 30% in the month of purchase and 70% in the month following purchase. Merchandise is the only item that is purchased on account. d) All other payments are made in the month incurred. e) Selling and Administration expenses totaled $14,000 in April. These expenses consist of the following items: a. Depreciation expense (includes depreciation on new asset) 2,000 b. Insurance expense 100 C. CEO's salary 4,900 d. Admin salaries 7,000 f) Cost of goods sold is 65% of sales. g) Ignore income taxes or interest expense Required: 1) List any information items appearing above that should not appear in the cash budget. No explanation for their exclusion is necessary. Simply list them

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

Audit Report Chavarria Dinne And Lamey LLC Contract Deliverables Office Of Inspector U.S Department Of The Interior

Authors: United States Department Of The Interior

1st Edition

1511678526, 978-1511678520

More Books

Students also viewed these Accounting questions

Question

citation information for each source

Answered: 1 week ago