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

  Trust income to beneficiary

A trust has net accounting income of $15,000. In addition, the trust has a $10,000 capital gain, which is not included in net accounting income. The trust is required to distribute the trust income to the beneficiary. The beneficiary will receive:

  A company purchases equipment for 225000 on july 12009 with

a company purchases equipment for 225000 on july 12009 with an estimated useful life of 10 years and expected salvage

  Explain how the profitability of the company can be made

Explain how the profitability of the company can be made to look better if they were to produce more products, even if they are not all sold right away.

  What are cisco net income

Cisco system has total assets of $35.594 billion, total debt of $9.678 billion, and net sales of $22.045 billion, and net sales of $22.045 billion. Their net profit margin for the year is 20 percent, while the operating profit margin was 30 percen..

  Journal entries and accounting concepts

It is now July 31st. You are continuing to advise Dr. Leo Krusack on basic accounting procedures. His practice had the following transactions during July.

  Cash basis taxpayer of capital expenditures

Payments by a cash basis taxpayer of capital expenditures: a) must be expensed at the time of payment b) must be expensed by the end of the first year after the asset is acquired

  How should nissan respond in this situation

Suppose that on November 1, the U.S. Federal Reserve intervenes to rescue the dollar, and the exchange rate adjusts to ¥220:$1 by the following July. What problems and/or opportunities does this situation present for Nissan and for General Motors?

  Complete your income statement be sure that it contains all

the numo company which was acquired and renamed in 2003 by e. r. numo sells frigets to multinational firms. in 2012 a

  Accuracy of information included in footnotes

The accuracy of information included in footnotes accompanying the audited financial statements issued by a company whose shares are traded on a stock exchange is the primary responsibility of....

  Inventory account on the balance sheet

The cost of material that is not completely processed, would be found in which of the following inventory account on the Balance Sheet?

  Consider the following statement in order to maximize value

consider the following statement in order to maximize value all firms should maintain a 3070 debt to equity ratio. do

  Flood damage in the brush creek area

Flood damage in the Brush Creek area averages $7,000 annually. Civil engineers with floodplain expertise have designed a series of small dams to restrain the flow. They will cost $25,000 and will involve annual maintenance charges of $500.

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