Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Melanie Inc. provides you with the following budgeted information for two months in the current year. March April Sales $545,000 $635,000 Inventory Costs 160,000 380,000

Melanie Inc. provides you with the following budgeted information for two months in the current year. March April Sales $545,000 $635,000 Inventory Costs 160,000 380,000 Capital Expenditures 120,000 50,000 General and Administration Costs (including amortization) 80,000 85,000 Expectations: Cash sales represent 10% of total sales All sales on account are collected in the following month 55% of Marchs $120,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 $2,000 are expected to be declared in March and paid in April Melanie Inc. obtains the minimum financing needed to ensure at least a $7,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 $19,000 Accounts

Receivable* 192,000 Inventory 175,000 Long-Term Assets 120,000 Accumulated Depreciation 7,000 Accounts Payable 19,000 Dividends Payable (in March) 1,000 Notes Payable 265,000 Shareholder's Equity 109,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

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

Managerial Accounting

Authors: Ramji Balakrishnan, Konduru Sivaramakrishnan, Geoff B. Sprinkle

2nd edition

1118385381, 978-1118385388

More Books

Students also viewed these Accounting questions