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 can a person tell whether an entry to an expense

how can a person tell whether an entry to an expense account is payment for a legitimate expenditure or a means of

  Why are sunk costs irrelevant

Why are sunk costs irrelevant in deciding whether to sell a product in its present condition or to make it into a new product through additional processing?

  Fabiano corporation makes a product whose direct labor

fabiano corporation makes a product whose direct labor standards are 0.5 hours per unit and 23.00 per hour. in february

  Variance amount-variance percentage

What is the variance amount? What is the variance percentage? Is the variance favorable orunfavorable?

  Statements regarding the taxation of c corporation

Which of the following statements is correct regarding the taxation of C corporation?

  Evaluation of inventory

Evaluation of Inventory

  The accrual basis four winds partnership owned and operated

the accrual basis four winds partnership owned and operated three storage facilities in milwaukee wisconsin. the

  How are paid-in capital and retained earnings different in

1. why is the balance sheet considered a point in time statement? 2. what is a fiscal year? why might an organization

  Simple rate of return on the new machine

The new machine would cost $20,000 per year to operate and maintain, but would save $100,000 per year in labor and other costs. The old machine can be sold now for scrap for $50,000. The simple rate of return on the new machine is closest to:

  Compute the amount of under- or overapplied overhead at

finlon upholstery inc. uses a job-order costing system to accumulate manufacturing costs. the companys work-in-process

  Which of following statements concerning users of

which of the following statements concerning users of accounting information is incorrect?management is considered an

  Compute cost assigned to ending inventory using fifl

Compute the cost assigned to ending inventory using(1) FIFL, (2) LIFO, (3) specific identification units sold consist of 95 unitsfrom beginning inventory, 175 from a February 10 purchase.

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