Calculate the amount that will need to be borrowed

Assignment Help Financial Accounting
Reference no: EM13495274

ABC Inc., is a retailer that sells sound systems. The company is planning its cash needs for the month of January, 2014. In the past, ABC Inc. 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.Show calculations.

Reference no: EM13495274

Questions Cloud

Determine current flows in the second wire : A vertical straight wire carrying an upward 26 A current exerts an attractive force per unit length of 9.0*10^-4 N/m on a second parallel wire 9.0 cm away
Estimate the translational speed at the top : A bowling ball encounters a 0.76 m vertical rise on the way back to the ball rack, as the drawing illustrates. find the translational speed at the top
Evaluate an organizations intangible assets : Committed costs are those that the organization agrees must be set aside to cover product costs through two stages of the life cycle.
Calculate the magnitude and direction of electrostatic force : Consider two points charges held fixed at locations along the x-axis. Charge q1= 5.00mC is located at x1= 1.00m. Charge q2= -5.00 mC is located at x2=4.00m. calculate the magnitude and direction of the electrostatic force
Calculate the amount that will need to be borrowed : Calculate the amount that will need to be borrowed in January 2014.Show calculations.
Find out the number of calories needed : A 100.0-g sample of copper is heated from 10.0°C to 100.0°C. a) Determine the number of calories needed. (The specific heat of copper is 0.0921 cal/goC).
Explain which of the following is a forbidden transition : Which of the following is a forbidden transition? please give a brief explanation why you chose your answer a) L=3 m=2; l=2 m=2 b)L=3 m=2 ;l=2m=0 c) L=3m=2; l=4 m=3 d) L=3 m=2; l=2m=1
Explain how many grams of iron were in the sample : A sample of iron was heated to 148.0°C, then placed into 368 g of water at 23.6°C. The temperature of the water rose to 27.2°C. How many grams of iron were in the sample
Evaluate the final temperature of the mixture : A 155-g piece of copper at 159oC is dropped into 250.0 g of water at 18.7oC. (The specific heat of copper is 0.385 J/goC.) Calculate the final temperature of the mixture.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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