Cash Disbursements Budget - Company A reports the following purchases and payments information: Dec. Jan. Feb....

Cash Disbursements Budget - Company A reports the following purchases and payments information:

	Dec.	Jan.	Feb.	Mar.	Apr.
Purchases . . .	$210,000	$150,000	$170,000	$180,000	$190,000

(a) Assume Company A makes cash payments of 40% of its purchases in the month of the purchase and pays the remaining 60% the following month. Compute the company's cash payments for each month from January through April. (Include formulas used to solve problem).

Cash Disbursements Budget - Company B reports the following purchases and payment information:

	Dec.	Jan.	Feb.	Mar.	Apr.
Purchases . . .	$350,000	$310,000	$330,000	$340,000	$300,000

(b) Assume Company B makes cash payments of 35% of its purchases in the month of the purchase and pays the remaining 65% the following month. Compute the company's cash payments for each month from January through April. (Include formulas used to solve problem).

Expert Solution

jeff jeffy answered 2 years ago

Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash...

Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash payments $25,000 $30,000 $22,000 $32,000 Nov. Dec. Jan. Feb. Mar. Apr. Sales $200,000 $325,000 $250,000 $240,000 $260,000 $270,000 Assume Company A collects 20% of its sales in the month of the sale, 50% the next month, 25% the following month, and 5% is never collected. Dec. Jan. Feb. Mar. Apr. Purchases $210,000 $150,000 $170,000 $180,000 $190,000 Assume Company A makes cash payments of 40%...

Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT...

Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC SALES 200,000 230,000 150000 210,000.00 220,000.00 170,000.00 160,000.00 150,000.00 180,000.00 210,000.00 220,000.00 210,000.00 COLLECTIONS: No cash Sales 30 days 50% 60 days 50% TOTAL CASH RECEIPTS CASH DISBURSEMENTS SUPPLIES 70% PAYABLES/SUPPLIES paid next month(in 30 days) SALARIES/OVER monthly 40000 INTEREST monthly 1000 DIVIDENDS monthly 1000 TAXES quarterly 1200 TOTAL DISBURSEMENT 42000 0 1200 0 0 0 0 0 0 0 0...

Cash disbursements may include all of the following EXCEPT rent payments. short-term loan payments. tax payments....

Cash disbursements may include all of the following EXCEPT rent payments. short-term loan payments. tax payments. depreciation expense.

Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for materials for the upcoming fiscal year.

The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 5,000 8,000 7,000 6,000 In addition, 6,000 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $2,880. Each unit requires 8 grams of raw material that costs $1.20...

Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of...

Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 32 28 25 22 20 20 a. Forty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $22 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)...

Purchases and Cash Payments Journals Transactions related to purchases and cash payments completed by Wisk Away...

Purchases and Cash Payments Journals Transactions related to purchases and cash payments completed by Wisk Away Cleaning Services Inc. during the month of May 20Y5 are as follows: May 1. Issued Check No. 57 to Bio Safe Supplies Inc. in payment of account, $345. May 3. Purchased cleaning supplies on account from Brite N’ Shine Products Inc., $200 . May 8. Issued Check No. 58 to purchase equipment from Carson Equipment Sales, $2,860. May 12. Purchased cleaning supplies on account...

text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements...

text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $290,000 $310,000 $280,000 Cash disbursements 270,000 350,000 290,000 The expected cash balance at January 1, 2016, is $72,000. Brewster wants to maintain a cash balance at the end of each month of at least $70,000. Short-term borrowings at...

Blackfish Company purchases 100% of Tautog Company on Jan 1, 2018 for $1,200,000 in cash. On...

Blackfish Company purchases 100% of Tautog Company on Jan 1, 2018 for $1,200,000 in cash. On the day of the purchase, Tautog had the following net assets: Book Value Fair Value Life Cash, received $100,000 $100,000 Equipment 375,000 450,000 3 years Land 200,000 150,000 Building (net) 500,000 580,000 5 years Payable $300,000 $200,000 1 year Blackfish Net Assets $875,000 1,080,000 Answer the following: A. Prepare a schedule showing how to allocate the difference in fair value given up by Blackfish and what is received from Tautog B. Determine the amount of excess amortization for 2018. C. Assume...

14. Natural gas futures prices are $6.85 (Oct), $7.50 (Nov), $8.15 (Dec), $8.20 (Jan), $8.25 (Feb),...

14. Natural gas futures prices are $6.85 (Oct), $7.50 (Nov), $8.15 (Dec), $8.20 (Jan), $8.25 (Feb), $8.20 (Mar), and $7.45 (Apr). The effective monthly interest rate is 1%. a. During which months is storage expected occur? b. What is your estimate of the expected monthly storage cost dur- ing those months?

ABC Company has the following projected sales: Month Sales Jan $5,000 Feb $14,000...

ABC Company has the following projected sales: Month Sales Jan $5,000 Feb $14,000 Mar $27,000 Apr $56,000 14% of the sales are collected in the same month. 26% of the sales are collected after one month, 42% of the sales are collected after two months, and the remainder are collected after three month. What is the amount of the April collections? Enter your answer rounded off to two decimal points. Do not enter $ or...

Question