50.1K

Verified Solution

Link Copied!

Melanie Inc. provides you with the following budgeted information for two months in the current year.

	March	April
Sales	$645,000	$635,000
Inventory Costs	180,000	310,000
Capital Expenditures	110,000	100,000
General and Administration Costs (including amortization)	80,000	85,000

Expectations:

Cash sales represent 20% of total sales

All sales on account are collected in the following month

60% of Marchs $110,000 worth of capital expenditures is to be paid at the end of March. The remainder is to be paid in the following month. April's capital expenditure will be paid in May.

Monthly amortization represents 10% of general and administration costs

Inventory costs and general and administration costs are to be paid in the month in which they are incurred

Dividends of $8,000 are expected to be declared in March and paid in April

Melanie Inc. obtains the minimum financing needed to ensure at least a $5,000 cash balance at the end of the month through a note payable. Assume that any amount taken out of the bank loan may be repaid only at year end.

As of March 1

Cash	$21,000
Accounts Receivable*	172,000
Inventory	100,000
Long-Term Assets	100,000
Accumulated Depreciation	9,000
Accounts Payable	10,000
Dividends Payable (in March)	4,000
Notes Payable	265,000
Shareholder's Equity	119,000
*Comprised only of sales on account incurred in February

Do not enter dollar signs or commas in the input boxes. Use the negative sign for any cash deficit. Prepare a cash budget for March and April.

Melanie Inc. Cash Budget for March and April
	March	April
Opening Cash Balance	$Answer	$Answer
Receipts:
Cash from sales	$Answer	$Answer
Collection from customers	$Answer	$Answer
Total cash available	$Answer	$Answer
Disbursements:
Inventory costs	$Answer	$Answer
General and admin. costs	$Answer	$Answer
Capital Expenditures	$Answer	$Answer
Dividend Payment	$Answer	$Answer
Total Cash Payments	$Answer	$Answer
Cash Excess (Deficit)	$Answer	$Answer
Financing Requirements:
Notes Payable	$Answer	$Answer
Loan Repayment
Ending Cash Balance	$Answer	$Answer

Answer & Explanation Solved by verified expert

See Answer