Prepare a cash budget for january and february

Assignment Help Accounting Basics
Reference no: EM13531040

Merrick Company expects to have a cash balance of $46,000 on January 1, 2012. These are the relevant monthly budget data for the first two months of 2012.

1. Collections from customers: January $71,000, February $146,000

2. Payments to suppliers: January $40,000, February $75,000

3. Wages: January $30,000, February $40,000. Wages are paid in the month they are incurred.

4. Administrative expenses: January $21,000, February $24,000. These costs include depreciation of $1,000 per month. All other costs are paid as incurred.

5. Selling expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred.

6. Sales of short-term investments in January are expected to realize $12,000 in cash. Merrick has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $20,000.

Instructions

Prepare a cash budget for January and February.

Reference no: EM13531040

Questions Cloud

Financial market measures : Using the list from the back of your textbook, for the following 6 diagnostic financial performance categories, decide which ratios (2-3 for each diagnostic category listed) you wish to use.
Explain the weakness in internal control : Explain the weakness in internal control and identify the control principle that is violated and suggest a change in the procedure that will result in good internal control.
What is the proper adjusted cash balance per books : What is the proper adjusted cash balance per books and prepare the adjusting journal entries necessary to determine the adjusted cash balance per books.
What balance should netzloff report : What balance should Netzloff report as its "Cash and cash equivalents" balance at April 30, 2012 and In what account(s) and in what financial statement(s) should the items not included in "Cash and cash equivalents" be reported?
Prepare a cash budget for january and february : The company wants to maintain a minimum monthly cash balance of $20,000 - Prepare a cash budget for January and February.
Compute the lower-of-cost-or-net realizable value : Franklin Company has the following four items in its ending inventory as of December 31, 2012. The company uses the lower-of-cost-or-net realizable value approach for inventory valuation following IFRS.
Highest inventory amount for the balance sheet : Determine the ending inventory and the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under each method. (Round cost per unit to three decimal places.)
Prepare comparative condensed income statements : Prepare comparative condensed income statements for 2012 under FIFO and LIFO and how much more cash will be available for management under LIFO than under FIFO? Why?
Determine the value of its ending inventory : For each of the above transactions, specify whether the item in question should be included in ending inventory, and if so, at what amount.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd