Question

I need help with this problem. I'm out of my depth with this. Thank you kindly....

I need help with this problem. I'm out of my depth with this. Thank you kindly.

Morton Mercado, the CFO of Kanton Company, carefully developed the estimates of the firm's total funds requirements for the coming year. These are shown in the following table:

Month

Total Funds

Month

Total Funds

January

$1,000,000

July

$6,000,000

February

$1,000,000

August

$5,000,000

March

$2,000,000

September

$5,000,000

April

$3,000,000

October

$4,000,000

May

$5,000,000

November

$2,000,000

June

$7,000,000

December

$1,000,000

In addition, Morton expects short-term financing costs of about 10% and long-term financing costs of about 14% during that period. He developed the three possible financing strategies that follow:

Strategy 1 - Aggressive: Finance seasonal needs with short-term finds and permanent needs with long-term funds.

Strategy 2 - Conservative: Finance an amount equal to the peak need with long-term funds and use short-term funds only in an emergency.

Strategy 3 - Tradeoff: Finance $3,000,000 with long-term funds and finance the remaining funds requirements with short-term funds.

Using data on the firm's total funds requirements, Morton estimated the average annual short-term and long-term financing requirements for each strategy in the coming year, as shown in the following table.

AVERAGE

ANNUAL

FINANCING

Type of Financing

Strategy 1 Aggressive

Strategy 2 Conservative

Strategy 3 Tradeoff

Short-term

$2,500,000

$0

$1,666,667

Long-term

$1,000,000

$7,000,000

$3,000,000

To ensure that, along with spontaneous financing from accounts payable and accruals, adequate short-term financing will be available, Morton plans to establish an unsecured short-term borrowing arrangement with its local bank, Third National. The bank has offered either a line-of-credit agreement or a revolving credit agreement. Third National's terms for a line of credit are an interest rate of 2.50% above the prime rate, and the borrowing must be reduced to zero for a 30-day period during the year. On an equivalent revolving credit agreement, the interest rate would be 3% above prime with a commitment fee of 0.50% on the average unused balance.

Under both loans, a compensating balance equal to 20% of the amount borrowed would be required. The prime rate is currently 7%. Both the line-of-credit agreement and the revolving credit agreement would have borrowing limits of $1,000,000. For purposes of his analysis, Morton estimates that Kanton will borrow $600,000 on the average during the year, regardless of which financing strategy and loan arrangement it chooses. (Note: assume a 365-day year.)

TO DO

1.       Determine the total annual cost of each of the three possible financing strategies.

2.       Assuming that the firm expects its current assets to total $4 million throughout the year, determine the average amount of net working capital under each financing strategy. (Hint: Current liabilities equal average short-term financing.)

3.       Using the net working capital found in part b as a measure of risk, discuss the profitability-risk trade-off associated with each financing strategy. Which strategy would you recommend to Morton Mercado for Kanton Company? Why?

4.       Find the effective annual rate under: 1) the line-of-credit agreement and 2) the revolving credit agreement. (Hint: Find the ratio of the dollars that the firm will pay in interest and commitment fees to the dollars that the firm will effectively have use of.)

5.       If the firm expects to borrow an average of $600,000, which borrowing arrangement would you recommend to Kanton? Why?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.Calculation of total annual cost Under each strategy : -

Aggressive Conservative Trade off
Short term@10% =$2500000*0.1=$250000 $0*0.1=$0 $1666667*0.1=$166667
Long term@14% =$1000000*0.14=$140000 =$7000000*0.14=$980000 $3000000*0.14=$420000
Total Cost $390000 $980000 $586667

2.Calculation of Net Working Capital : -

= Current Assets - Current liabilities

Aggressive Conservative Trade off
a)Current Assets $4000000 $4000000 $4000000
b)Current Liabilities $2500000 $0 $1666667
Net Working Capital(a)-(b) $1500000 $4000000 $2333333

3) Based on Networking capital Conservative strategy is Better strategy as it is Having high net working capital,as high net working capital is considered a sign of a well managed company with potential for growth.

Add a comment
Know the answer?
Add Answer to:
I need help with this problem. I'm out of my depth with this. Thank you kindly....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Aggressive versus conservative seasonal funding strategy Dynabase Tool has forecast its total funding requirements for the...

    Aggressive versus conservative seasonal funding strategy Dynabase Tool has forecast its total funding requirements for the coming year as shown in the following table: a. Divide the firm's monthly funding requirement into (1) a permanent component and (2) a seasonal component, and find the monthly average for each of these components b. Describe the amount of long-term and short-term financing used to meet the total funds requirement under (1) an aggressive funding strategy and (2) a conservative funding strategy. Assume...

  • Aggressive versus conservative seasonal funding strategy Dynabase Tool has forecast its total funding requirements for the...

    Aggressive versus conservative seasonal funding strategy Dynabase Tool has forecast its total funding requirements for the coming year as shown in the following table: FF a. Divide the firm's monthly funding requirement into (1) a permanent component and (2) a seasonal component, and find the monthly average for each of these components b. Describe the amount of long-term and short-term financing used to meet the total funds requirement under (1) an aggressive funding strategy and (2) a conservative funding strategy....

  • Calculate the ratio of the following: Marnus Inc Income Statement For the Financial Year ended 12/31/19...

    Calculate the ratio of the following: Marnus Inc Income Statement For the Financial Year ended 12/31/19 $150,000,000 ($130,000,000) $20,000,000 12/31/18 $140,000,000 ($123,000,000) $17,000,000 $9,000,000 $10,000,000 Statement values in 000's Period Ending: Total Revenue (Net Revenue) Cost of Revenue (COGS) Gross Profit Operating Expenses Sales, General and Admin. Other Operating Items Total Operating Exp Operating Income (or loss) Interest Expense Earnings Before Tax Income Tax Net Income (or loss) $0 $0 | ($9,000,000) $11,000,000 ($1,000,000) $10,000,000 ($5,000,000) $5,000,000 ($10,000,000) $7,000,000 ($800,000)...

  • Marnus Inc Income Statement For the Financial Year ended Statement values in 000's Period Ending: 12/31/19...

    Marnus Inc Income Statement For the Financial Year ended Statement values in 000's Period Ending: 12/31/19 12/31/18 Total Revenue (Net Revenue) $150,000,000 $140,000,000 Cost of Revenue (CoGS) ($130,000,000) ($123,000,000) $20,000,000 $17,000,000 Gross Profit Operating Expenses Sales, General and Admin. $9,000,000 $10,000,000 $0 $0 Other Operating Items Total Operating Exp ($9,000,000) ($10,000,000) $11,000,000 $7,000,000 Operating Income (or loss) Interest Expense ($1,000,000) ($800,000) $10,000,000 $6,200,000 Earnings Before Tax ($4,000,000) ($5,000,000) Income Tax Net Income (or loss) $5,000,000 $2,200,000 12/31/19 12/31/18 Dividends declared...

  • I need help with the cash flow spreadsheet for the debit and credit changes. Thank you....

    I need help with the cash flow spreadsheet for the debit and credit changes. Thank you. Use the following information for the Problems below. Forten Company, a merchandiser, recently completed its calendar-year 2017 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) Other Expenses are paid in...

  • Please read the introduction and respond to which financing option the firm should use. I believe...

    Please read the introduction and respond to which financing option the firm should use. I believe it will only take a second to complete, I am just confused! Thank you so much I am desperate for a quick response! CarGenie, an automobile manufacturer, wants to offer a one-time line of specialized vehicles. To produce the vehicles, CarGenie will need to invest $20 million upfront on January 1, 2019 in inventory (the only expense in producing the vehicles). CarGenie expects that...

  • SMPrime Holdings is a closely held corporation with a capital structure composed entirely of common stock...

    SMPrime Holdings is a closely held corporation with a capital structure composed entirely of common stock and retained earnings. The stockholders have an agreement with the company that states the company will purchase the stock of a shareholder should a shareholder want to sell his or her holdings in the company. The agreement states that the stock will be purchased at a price equal to the stock's previous year-end book value per share. Early in October 2017, Mrs Bean, a...

  • I need help with this question eBook Problem Walk-Through Effective Cost of Short-Term Credit Yonge Corporation...

    I need help with this question eBook Problem Walk-Through Effective Cost of Short-Term Credit Yonge Corporation must arrange financing for its working capital requirements for the coming year. Yonge can: (a) borrow from its bank on a simple interest basis (interest payable at the end of the loan) for 1 year at a 13% nominal rate; (b) borrow on a 3-month, but renewable, loan basis at an 11.2% nominal rate; (c) borrow on an installment loan basis at a 10%...

  • I need someone who help me to solve this problem but need to show works please....

    I need someone who help me to solve this problem but need to show works please. thanks Walmart Inc. Consolidated Balance Sheets As of January 31, 2019 2018 5 7.722 6.183 40269 6.756 5.614 43783 3 511 59664 3.613 61 897 CAR ASSETS Current assets: Cash and cash equivalents Receivables, net Twentones Prepaid expenses and other Tocal current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment bel Property under capital law and financing obligations: Property...

  • I need help on fillkng out this chart for my review pracfuce problem. please show me...

    I need help on fillkng out this chart for my review pracfuce problem. please show me how it works and put mumbers in correct spots. it will help me prepare for my test Problem 3-6 (Algo) Balance sheet preparation; disclosures (LO3-2, 3-3, 3-4) The following is the ending balances of accounts at December 31 2021. for the Vosburgh Electronics Corporation Credits Debits 85. 20. 141. Account Title Cash Short-term investments Accounts receivable Long-term investments Inventory Receivables from employees Prepaid expenses...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT