Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Candice Inc. provides you with the following budgeted information for two months in year 2019: March April Sales $535,000 $715,000 Manufacturing Costs 220,000 310,000 Capital

Candice Inc. provides you with the following budgeted information for two months in year 2019:

March April
Sales $535,000 $715,000
Manufacturing Costs 220,000 310,000
Capital Expenditures* 90,000 75,000
General and Administration Costs (including amortization) 80,000 110,000
*includes training programs, machines and buildings

Expectations:

  • Cash sales represent 10% of total sales
  • All sales on account are collected in the following month
  • 55% of Marchs $90,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 15% of general and administration costs
  • Manufacturing costs and general and administration costs are to be paid in the month in which they are incurred
  • Dividends of $7,000 are expected to be declared in March and paid in April
  • Candice Inc. obtains the minimum financing needed to ensure at least a $7,000 cash balance at the end of the month through a bank loan. Assume that any amount taken out of the bank loan may be repaid only at year end.

As of March 1

Cash $27,000
Accounts Receivable* 164,000
Inventory 50,000
Long-Term Assets 110,000
Accumulated Depreciation 8,000
Accounts Payable 16,000
Dividends Payable (in March) 5,000
Notes Payable 265,000
Stockholder's Equity 108,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 negative values. Prepare a cash budget for March and April.

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

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

Industrial Organizational Psychology An Applied Approach

Authors: Michael Aamodt

7th Edition

1111839972, 9781111839970

More Books

Students also viewed these Accounting questions

Question

What is the role of reward and punishment in learning?

Answered: 1 week ago

Question

is particularly relevant to these issues.)

Answered: 1 week ago