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

  Direct material costs be incurred after split off point

What exact labor and overhead costs would be incurred, both before and after split off point? Again, be precise here in terms of what you believe would need to be incurred.

  You are a audit partner with feeble and stressed cpas one

you are a audit partner with feeble and stressed cpas. one of your audit clients is greasy oil inc. the company is a

  Paula purchased a bakery from gianni fiorithe purchase

paula purchased a bakery from gianni fiori.the purchase agreement included a provison that required paula to pay gianni

  Determine the amount of gain or loss

Determine the amount of gain or loss that would be recorded due to the change in the Allowance to Reduce Inventory to Market account.

  For the bakfirn corporation an accounting audit of accounts

for the bakfirn corporation an accounting audit of accounts payable vendor invoices and inventory material acceptance

  What is the balance of the fund at the end

The fund pays interest at 5% compounded annually. What is the balance of the fund at the end of 2010 (after the 2010 deposit)? Show your work.

  Question one of the characteristics unique to governmental

question one of the characteristics unique to governmental and not-for-profit organizations is the inability to remove

  Is it appropriate for us to be considering this expansion

What are the advantages and disadvantages to our company of financing the expansion by issuing bonds? By issuing common stock?

  Capital budgeting with staged entry kereru fisheries ltd is

capital budgeting with staged entry kereru fisheries ltd is a leading seafood fishing and processing company. the board

  S a harrington company is a us-based company that prepares

s. a. harrington company is a u.s.-based company that prepares its consoli- dated financial statements in accordance

  Why normal floors available to the tax payer

A taxpayer suffers a casualty loss on personal use property for which he has insurance coverage. However, to avoid a premium adjustment, the taxpayer fails to make a timely claim. In this situation is the full deduction for the casualty, after th..

  Calculate the total interest paid over the life of the loan

Increase the mortgage amount to include the $18,000, bringing the total amount financed to $187,100. Calculate the total interest paid over the life of the loan for each of these options.

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