The company can borrow on its operating loan in increments

Assignment Help Accounting Basics
Reference no: EM13581066

Company "A" a retailer that sells music systems. The company is planning its cash needs for the month of January, 2014. In the past, company has had to borrow money during the post-Christmas season to offset a significant decline in sales. The following information has been assembled to prepare a cash flow forecast for January.

  1. January 2014 forecasted income statement:

Sales                                                                                           $400,000

Cost of goods sold                                                                      300,000

Gross profit                                                                                 100,000

Variable selling expenses                                $10,000

Fixed administrative expenses                          80,000               90,000

Forecast net operating income                                                  $ 10,000

  1. Sales are 10% for cash and 90% on credit.

  2. Credit sales are collected over a three-month period with 40% collected in the month of sale, 30% in the following month, and 20% in the second month following sale. The remainder is never collected. November 2013 sales totaled $300,000 and December sales totaled $500,000.

  3. The company maintains its ending inventory levels at 60% of the cost of the merchandise to be sold in the following month. The merchandise inventory at December 31, 2013 was $180,000. February 2014 sales are budgeted at $200,000. Gross profit percentage is expected to remain unchanged.

  4. 40% of a month's inventory purchases are paid in the same month. The remaining 60% are paid in the following month. Accounts payable relate solely to inventory purchases. At December 31, accounts payable totaled $135,000.

  5. The company pays a $10,000 monthly cash dividend to shareholders.

  6. The cash balance at December 31, 2013 was $30,000; the company must maintain a cash balance of at least this amount at the end of each month.

  7. Fixed administrative expenses include depreciation expense of $2,000 per month.

  8. The company can borrow on its operating loan in increments of $1,000 at the beginning of each month, up to a total loan balance of $500,000. The interest rate on this loan is 1% per month. There is no operating loan at December 31, 2013.

Required: Calculate the amount that will need to be borrowed in January 2014. Required with calculations

Reference no: EM13581066

Questions Cloud

Flaming foliage sky tours is a small sightseeing tour : flaming foliage sky tours is a small sightseeing tour company in new hampshire. the firm specializes in aerial tours of
Critically analyze the benefits and limitations of ratio : critically analyze the benefits and limitations of ratio analysis explaining what factors impact the meaningfulness of
Determine the amount of indirect manufacturing costs : in the past the company a allocated indirect manufacturing costs based on direct labour hours. recently management has
Direct write-off method harrisburg company which began : direct write-off method. harrisburg company which began business in early 2007 reported 40000 of accounts receivable on
The company can borrow on its operating loan in increments : company a a retailer that sells music systems. the company is planning its cash needs for the month of january 2014. in
Allowance method analysis of receivables at a january 2002 : allowance method analysis of receivables. at a january 2002 meeting the presishydent of sonic sound directed the sales
Plants galre operates a commercial plant nursery where it : plants galre operates a commercial plant nursery where it propagates plants for garden centers throughout the region.
Controller youu2019ve got to stick with historical cost : southwestern corporation operates throughout texas buying and selling widgets. to expand into more profitable markets
Units of material are required for each unit of finished : chandler ltd. estimates sales for the second quarter of 2014 will be as follows.monthunitsapril2540may2450june2390the

Reviews

Write a Review

Accounting Basics Questions & Answers

  Determine the effect on ez accounting equation

What effect does the recognition of bad debt expense have on the net realizable value? What effect does the write-off of accounts have on the net realizable value?

  Stock price and tax advantage

The Carlton Corporation has $4 million in earnings after taxes and 1 million shares outstanding. The stock trades at a P/E ratio of 20. THE firm has $3 million in excess cash.

  Journal entries and conversion of bonds

Prepare the journal entries for the June 30, 2013, interest payment by Madison and the conversion of the bonds (book value method).

  1 darren corporation had net income of 250000 and paid

1. darren corporation had net income of 250000 and paid dividends of 50000 to common stockholders and 10000 to

  Paid in cash dividends during the year

The beginning balance of retained earnings was $137,000,while the end of the year balance of retained earnings was $175,000.Net income for the year was $63,000. How much was paid in cash dividends during the year?

  Assume you recently accepted a job with a company that

assume you recently accepted a job with a company that designs and builds helicopters for commercial and military use.

  When comparing various divisions within a company describe

when comparing various divisions within a company describe what problems can arise from evaluating divisions that have

  Non payment of loan

Last year, Abby loaned Pat $10,000 as a gesture of their friendship. Although Pat had signed a note payable that contained interest payments and a maturity date, the loan had not been repaid this year when Pat died insolvent.

  Variable overhead efficiency variance calculations

V Company's product has a labor standard of 2 hours per unit. For 2011, it estimates its production will be 200,000 units (400,000 DLHs). It budgets total overhead at $900,000, which results in a fixed overhead rate of $1.50 per hour.

  Compute the cash payback period for each project round

the three stooges partnership is considering three long-termcapital investment proposals. each investment has a useful

  Problem related to compounded semi-annually

If I invest $40,000 0n January 1, 2010 in a savings account that earns interest of 8% compounded semi-annually. What will be the amount in the fund on December 31, 2015?

  After-tax profit of falcon company

Compute the after-tax profit of Falcon.Com separately for both the (1) FIFO and (2) LIFO methods of inventory valuation assuming the company has no expenses other than cost of goods sold and its income tax rate is 50%. Taxes are accrued currently ..

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