Use the excess to reduce its short-term borrowing

Assignment Help Financial Management
Reference no: EM131975038

At the beginning of January, the South Carolina sportsplex has $150,000 of cash on hand. The firm's forecasts of cash flows for the first six months of the year are given here in ($1,000's). The S.C. Sportsplex wants to maintain a cash balance of at least $100,000 at all times. If the balance falls below that level, the firm will borrow to bring its balance up to $100,000. If more than $100,000 of cash is available, it will use the excess to reduce its short-term borrowing. Show the monthly net cash flow, borrowing (if any), loan repayments, cash balance, and cumulative borrowing balance.

January - June

Cash Inflows: 100,120,150, 320, 350, 240

Cash Outflows: 150, 180, 200, 290, 240, 180

At the end of June:

a. borrowing will be $30,000 and the cash balance will be $100,000

b. borrowing will be $10,000 and the cash balance will be $100,000

c. borrowing will be $0 and the cash balance will be $110,000

d. borrowing will be $0 and the cash balance will be $130,000

e. borrowing will be $0 and the cash balance will be $150,000

f. borrowing will be $0 and the cash balance will be $170,000

g. borrowing will be $0 and the cash balance will be $190,000

Reference no: EM131975038

Questions Cloud

How might the results influence the decision to hedge : A firm has just begun to do business in Japan and the financial manager anticipates approximately 10,000,000 japanese yen sales per month outstanding.
Calculate the conversion price in dollars : Calculate the conversion price in dollars and the premium as a percentage
Determine the cost recovery deduction : Question - Cora purchased an apartment building on May 17, 2015 for $3,000,000. Determine the cost recovery deduction for 2016
Amount of capital the bank needs to have to buffer : Find the value-at-risk at the confidence level 95%, that is, the amount of capital the bank needs to have to buffer its possible losses with probability 95%
Use the excess to reduce its short-term borrowing : If more than $100,000 of cash is available, it will use the excess to reduce its short-term borrowing.
What should be the current share price for the firm : A firm has just announced that because of a new joint venture, its earnings will likely grow at a rate of 12% for the next five years, after which the earnings.
Find the expectation-variance and moment generating : Consder the random variable U:= 2X - 4Y - Z + 5. Find the expectation, variance, and the moment generating function for U.
Develop applications involving complex component technology : Develop applications involving complex component technology. Design and implement technical solutions addressing connectivity between components.
Calculate the budgeted cash receipts for december : Selling and administrative expenses are budgeted at $99,000 for December and are paid in cash. Calculate the budgeted cash receipts for December

Reviews

Write a Review

Financial Management Questions & Answers

  Project valuation for healthcare

Your senior design project is sponsored by a hospital. As part of the project, you are studying patient flow and utilization of an MRI machine.

  What is the most you would invest today

What is the most you would invest today?

  Market is in equilibrium with the required return

Simpkins Corporation does not pay any dividends because it is expanding rapidly and needs to retain all of its earnings. However, investors expect Simpkins to begin paying dividends, with the first dividend of $1.00 coming 3 years from today. what is..

  What percentage of the time did the experts actually beat sp

Let's do something boring just to drive home a point: Count up the number of years in Figure in which more than half of the mutual funds managed.

  You must perform an after-tax analysis

You must perform an after-tax analysis. Let MARR be 15% and tax rate be 34%. Y

  Describe the strategic implications

Describe the strategic implications that would need to be considered in setting a price for a Campbell soup product (Any Soup).

  What is the yield to call for these bonds

Using semiannual compounding, what is the yield to call for these bonds?

  Issued debt-preferred stock and common stock

Executive Fruit has issued debt, preferred stock and common stock.

  Industry and sector ratios

What does it mean if a company has a capital spending 5 year growth rate ratio of 24.22 while the industry and sector ratios are 12.72 and 9.18? How are they performing against the industry and sector ratios? Why are they performing as such?

  What is its free cash flow

This year, FCF Inc. has earnings before interest and taxes of $9,330,000, If its tax rate is 35%, what is its free cash flow?

  Cause company beta to be high

Which of the following will cause a company’s Beta to be high?

  Calculate the firms quick ratio

Earth’s Best Company has sales of $200,000, Cost of Goods Sold of 100,000, a net income of $15,000, and the following balance sheet: Calculate the firm’s Quick Ratio?

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