What is the minimum line of credit to request from a lender

Assignment Help Finance Basics
Reference no: EM132614172

Excel spreadsheet is needed

Good cash management is an essential job of the financial manager! You own a small auto sales business called King Kars. You stock up on inventory in February, April, June, and September. Your annual cash budget indicates that your MONTHLY NET CASH for the year will be the following:

JAN $5,000

FEB -$30,000

MAR $20,000

APRIL -$35,000

MAY $25,000

JUNE -$10,000

JULY $25,000

AUG  $25,000

SEPT -$30,000

OCT $15,000

NOV $15,000

DEC $25,000

You begin the year with a cash balance of $50,000, and the minimum cash balance desired must be $50,000 every month.

Cash flow summary and external financing summary as noted in the Excel spreadsheet assigned to this submission. 

  1. Do you believe that the company needs outside financing? 
  2. What is the minimum line of credit to request from a lender? 
  3. Do you think you are a good candidate for the line of credit? Why?

Reference no: EM132614172

Questions Cloud

Compute the balance at December : Harrison Co. owns 20,000 of the 50,000 outstanding shares of Taylor, Inc. common stock. Compute the balance at December 31, 2013
What is opinion on the insider trading debate : What is your opinion on the insider trading debate? In other words, should insider trading be illegal or legal?
What is the company wacc-lightning power co : You are given the following information for Lightning Power Co. Assume the company's tax rate is 21 percent.
Write two or more specific audit procedures designed : Write two or more specific audit procedures designed to produce appropriate evidence about Violet's trade accounts payable balance
What is the minimum line of credit to request from a lender : Cash flow summary and external financing summary as noted in the Excel spreadsheet assigned to this submission.
Analyzing making new decision : Comment on the importance of analyzing your results before making new decisions. Feel free to comment on any of the following areas
Basic for economic questions : Does an individual consumer really have a voice and answering the basic for economic questions described in types of economic systems?
What is the minimum price Carla should accept : Dick Button has offered to buy Carla's vineyard business by assuming the 40-year lease. What is the minimum price Carla should accept
Identify procedure is primarily a test of control : Compare the client's count of physical inventory at an interim. Identify whether each procedure is primarily a test of control or a substantive test.

Reviews

Write a Review

Finance Basics Questions & Answers

  Savings available for investment

Investment stream 2A: Currently you have $80,000 of savings available for investment. There is a 10 years investment project available. If you invest your money in this project, it will go through 4 following phases. At the end of phase 1, 2 and 3 th..

  Determine largest current assets

Choose a corporation for analysis that has been profitable for the last three fiscal years, is not a bank or financial institution, and is on a major United State Stock Exchange.

  A project produces a cash flow of 432 in year 1 137 in

a project produces a cash flow of 432 in year 1 137 in year 2 and 797 in year 3. if the cost of capital is 15 what is

  Computation of wacc-npv-weighted average flotation cost

Mustard Patch Doll Company needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $100,000.

  Probability that javier volunteers for less

Find the probability that Javier volunteers for less than three events each month. (Enter an exact number as an integer, fraction, or decimal.) P(x

  Describe the techniques available to a firm for slowing

Describe the techniques available to a firm for slowing disbursements.

  What is the annual total costs of post card inventory

Post Card Depot, an large retailer of post cards, orders 3,116,810 post cards per year from its manufacturer. Post Card Depot plans on ordering post card.

  If the clinic accepts this bid and contracts with the high

zack millman clinic is seeking to provide sports-related health care services to high schools in the area. zack millman

  What will the market price per share be after the split

The Peanut Shack has 6,5000 shares of stock outstanding with a par value of $1 per share. The current market value of the firm is $145,600. The company just announced a 3-for-2 stock split. What will the market price per share be after the split?

  What are the three ways of purchasing health insurance

Why is it important to work with your parent's doctor to provide the information the insurer needs for long-term-care benefits?

  What is the pv of only the costs to salerino

What is the PV of only the costs to Salerino if the cost of capital is 0.09?

  Formulate a linear programming model to solve this problem

Formulate a linear programming model to solve this problem. List the extreme points and determine the solution graphically. You do not need to submit your graph

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