Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Engli Take me to the text Candice Inc. provides you with the following budgeted information for two months in year 2019: March April Sales $545,000
Engli Take me to the text Candice Inc. provides you with the following budgeted information for two months in year 2019: March April Sales $545,000 $615,000 Manufacturing Costs 150,000 310,000 Capital Expenditures* 110,000 25,000 General and Administration Costs (including amortization) 50,000 100,000 *includes training programs, machines and buildings Expectations: Cash sales represent 20% of total sales All sales on account are collected in the following month 65% of March's $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 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 $5,000 are expected to be declared in March and paid in April . Candice Inc. obtains the minimum financing needed to ensure at least a $35,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 Accounts Payable 13,000 Dividends Payable in March) 2,000 Notes Payable 265,000 stockholder's Equity 106,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 $ 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 $ LA $ Capital Expenditures $ $ $ Dividend Payment LA $ Total Cash Payments $ $ Cash Excess (Deficit) $ Financing Requirements: Cash from sales Collection from customers $ Total cash available Disbursements: Manufacturing costs $ $ General and admin. costs $ $ $ Capital Expenditures $ $ Dividend Payment $ A Total Cash Payments $ Cash Excess (Deficit) Financing Requirements: Notes Payable $ Loan Repayment Ending Cash Balance $ $ Check 65% of March's $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 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 $5,000 are expected to be declared in March and paid in April Candice Inc. obtains the minimum financing needed to ensure at least a $35,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 $28,000 Accounts Receivable 155,000 Inventory 130,000 Long-Term Assets 90,000 Accumulated Depreciation 6,000 Accounts Payable 13,000 Dividends Payable in March) 2,000 Notes Payable 265,000 Stockholder's Equity 106,000 *Comprised only of sales on account incurred in February
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started