Question: Collins Systems, Inc., is trying to develop an asset financing plan. The frim has $300,000 in temporary current assets and $200,000 in permanent current assets.

Collins Systems, Inc., is trying to develop an asset financing plan. The frim has $300,000 in temporary current assets and $200,000 in permanent current assets. Collins also has $400,00 in fixed assets. A) Construct two alternative financing plants for the firm. One of the plans should be conservative,with 80% of assets financed by long term sources and the rest financed by short term sources. The other plan should be aggressive,with only 30% of assets financed by short term sources.The current interest rate is 15% on long term funds and 10% on short term financing. Compute the annual interest payments under each plan. B) Given the Collin's earnings before interest & taxes are $180,000, calculate earnings after taxes for each of your alternatives. Assume a tax rate of 40 %. ***NEEDS TO BE DONE IN EXCEL *****

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Chapter 6 Problem 14 Guardian Inc is trying to develop an asset financing plan. the firm has $400,000 in temporary current assets and $300,000 in permanent current asset. Guardian also has $500,000...

Collins Systems, Inc., is trying to develop an asset-financing plan. The firm has $300,000 in temporary current assets and $200,000 in permanent current assets. Collins also has $400,000 in fixed...

Collins Systems Inc. is trying to develop an asset-financing plan. The firm has $300,000 in temporary current assets and $200,000 in permanent current assets. Collins also has $400,000 in capital...

Folton Systems Inc. is trying to develop an asset-financing plan. The firm has $250,000 in temporary current assets and $300,000 in permanent current assets. Folton also has $425,000 in capital...

Collins Systems, Inc., is trying to develop an asset-financing plan. The firm has $400,000 in temporary current assets and $300,000 in permanent current assets. Collins also has $500,000 in fixed...

Help Save Collins Systems Inc. is trying to develop an asset.financing plan. The firm has $300,000 in temporary current assets and $200,000 in permanent current assets. Collins also has $400,000 in...

Collins Systems Inc. is trying to develop an asset-financing plan. The firm has $300,000 in temporary current assets and $200,000 in permanent current assets. Collins also has $400,000 in capital...

A Collins Systems Inc. Is trying to develop an asset-financing plan. The firm has $300,000 In temporary current assets and $200,000 in permanent current assets. Collins also has $400.000 In capital...

just need the answer for items on subsection C. thanks Check Collins Systems Inc. is trying to develop an asset-financing plan. The firm has $300,000 in temporary current assets and $200,000 in...

(A) Welson Co. is being sued for illness caused to local residents as a result of negligence on the company's part in permitting the local residents to be exposed to highly toxic chemicals from its...

How might the short-term and long-term recruiting strategies differ?

Felix Ltd underwrites 4 5 % of an issue of 8 5 0 0 0 0 ordinary shares at R 1 0 each in Geltech Ltd . The underwriting commission is 8 , 5 % and the public takes up 7 2 0 0 0 0 shares. Required:...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

5. Work Rules. CCH, a Wolters Kluwer company, provides a business owners toolkit through their Tax and Accounting service. CCH is a leading provider of business, legal, and tax information. Locate...

3. What type of evidence are the e-mails received from employees about Gatess on-duty behavior? Should this evidence be considered by the arbitrator? Why or why not? Background On March 30, 2006,...

4. Should the Companys offer to pay back pay and to restore seniority and benefits if Gates is found not guilty be considered by the arbitrator? Why or why not? Background On March 30, 2006, David...