Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Highlighted in GREEN (the only entries that need to be changed) are: The eight finance-related decision entries revolve around the following issues: Borrowing money To

Highlighted in GREEN (the only entries that need to be changed) are: The eight finance-related decision entries revolve around the following issues:

Borrowing moneyTo finance operations the company may take out loans with 1-year, 5- years, and/or 10-year terms. One-year loans are granted at interest rates corresponding to the companys current credit rating; 5-year loans carry an additional 0.50% and 10-year loans carry a full 1% interest rate adder. In addition to a lower interest rate, a 1-year loan has the advantage of quicker debt pay-down and smaller total interest costs, but also has the disadvantage of having to re-finance the debt in the following year at perhaps less favorable interest rates should cash flows not be sufficient to fully fund a 1-year loan repayment. Longer 5 or 10-year loans have the advantages of locking in what may be an attractive long-term interest rate and lowering annual principal payments; however, 5-year or 10-year loans, in addition to their higher interest rates, have the further disadvantage of paying out bigger sums for interest over the life of the loan (which, in turn, depresses the companys interest coverage ratio over a longer period of time).

  • Issuing shares of stockAdditional capital may be raised by issuing new shares of common stock. New issues of common stock have the effect of diluting earnings per share and ROE and should be done cautiously. From time to time, you may determine that the company needs to raise additional equity capital to (1) help pay down a portion of the outstanding loans (because of burdensome interest costs or because lowering debt is the best way to improve the companys credit rating) or (2) help pay for added assembly capacity and/or robotics upgrades. The companys board of directors has established a 40-million share maximum on the total number of shares outstanding and theres an on-screen calculation showing the maximum number of shares that can be issued in any one year (given the companys financial condition). The company cannot issue new shares in the same year that it elects to buy back (retire) outstanding shares. At the end of Year 5 the company had 20 million shares outstanding. Each time you make an entry specifying how many shares are to be issued, there are accompanying calculations showing the total amount of new equity capital raised (see the cash inflows section) and the price at which investors will agree to buy the newly-issued shares (the price declines as more shares are issued because additional shares dilute earnings per share). In deciding how many shares to issue, you can try several what if entries and check out the effects on earnings per share, return on equity, and the amount of money raised.
  • Early repayment of long-term bank loansYou may accelerate debt retirement (or refinance high interest debt) by using excess cash on hand, new issues of stock, or proceeds from new loans to pay off the outstanding principal on up to 2 of the outstanding 5 and 10-year loans. This is accomplished by simply selecting the number of the loan you want to pay off (loan numbers are indicated in Note 8 to your companys balance sheet). All such loan repayments are considered end-of-year repayments; thus, the company will still make the current-year annual principal payment and interest payment on any long-term loan that is repaid early.
  • Paying dividendsThe company paid no dividend to shareholders in Year 5. You have the authority to declare a dividend, subject to certain conditions. The maximum allowable dividend entry is 2 times projected earnings per share; moreover, projected total shareholder equity must always remain at or above $100 million after any and all dividend payments. No dividend can be paid should projected total shareholder equity fall below the $100 million minimum established by the companys board of directors (a policy that won the enthusiastic approval of credit rating agencies). Higher dividends are welcomed by shareholders and have a positive effect on the companys stock price (unless dividend payments exceed earnings per share and cant be sustained at present levels).
  • Repurchasing shares of stockUsing cash on hand to repurchase and retire outstanding shares has the advantage of increasing earnings per share, returns on equity investment, and the companys stock price. While you have the authority to initiate stock repurchases, the Board of Directors has reserved the right to limit the number of shares repurchased in any given yearsuch limits vary from year to year and are shown on the Finance Decisions page just below the stock repurchase entry field. The company must maintain a minimum of 15 million shares outstanding and a minimum total shareholder equity of $100 million. The company cannot repurchase outstanding shares in the same year that it elects to issue new shares. Each time you enter a number for share repurchases, you are provided calculations showing the total cost of the repurchased shares (see the cash outlays listings) and the price at which investors will agree to sell the shares you want to buy back (the price rises as more shares are repurchased because of the upward impact on earnings per share and the bigger fraction of ownership that fewer shares represent).

NOTE:

Options for "Uses for EXCESS CASH ______ Early Repayment of L-T" : None

  • #1 $30,000k @ 7.5%
  • #2 $16,000k @ 8.5%
  • #3 $64,000k @ 8.5%

FOR NA :

One of:

  • #1 $30,000k @ 7.5%
  • #2 $16,000k @ 8.5%
  • #3 $64,000k @ 8.5%

BUT, whichever one was used for NONE will no longer be an option for N/A

image text in transcribed

0 Sources of Additional cash Uses for Excess cash Early repayment of L-T Loans (Balance sheet note 8) None N/A 1-Year bank loan (5.50% interest) 5-Year bank loan (6.00% interest) 10-Year bank loan (6.50% interest) Stock Issue (000s of shares at $12.00) Max share issue in year 6 = 5000k 0 0 0 0 Dividend ($/share) (Year 5 dividend was $0.00) Stock repurchase (000s ofshares at $12) (Max share repurchase in Year 6 = 200k) Shares of stock outstanding at the beginning of year 6 20,000 k Shares of stock outstanding at the end of year 6 20,000 k Projected Cash Available in Year 6 Projected Cash Outlays in Year 6 $144,174 $106,176 $58,248 Beginning Cash Balance (carried over from year 5) Cash inflows ------ Receipts from sales Bank Loans -------- 1-year 5-year 10-year Stock issue (0 shares $12.00) Loan to cover overdraft (1year loan) Interest on year 5 cash balance Cash refund $5,000 $366,494 $0 $0 $0 SO so $50 $0 $0 $0 $0 $0 Cash available from All sources $371,544 Cash outlays - Payments to component suppliers Production and assembly expenses Delivery/marketing/admin expenses Capital outlays -- New workstations Robotics upgrades Facilities expansion Facilities improvement Loan principal repayment ------- 1-year loans 5-year loans 10-year loans Interest payments -------- Bank loans Year 5 overdraft Stock repurchases (0 shares @ $12.00) Income tax payments Dividend payments Charitable contributions Cash fine $0 $0 $16,000 1828 **} {**3*2* | $10,350 $0 $0 $11,143 $0 $0 $0 Total cash outlays $346,091 Projected Cash Balance at the end of year 6 (5000s) $25,453 Could generate interest income of $255k in year 7 Other Important Financial Statistics Performance on Credit Rating Measures Interest paid on overdraft loans Interest rate received on cash balances Shareholder equity (mandted minimum = $100 mil) Last Year Year 6 (Projected) 8.50% 7.50% 1.00% 1.00% 114.5 mil 140.5 mil Debt / equity percentage (D:E) Interest Coverage ratio (operating profit/ interest exp) Current ratio (current assets/current liabilities) Last year Year 6 (Projected 59; 41 52; 48 2.73 4.61 1.42 1.79 0 Sources of Additional cash Uses for Excess cash Early repayment of L-T Loans (Balance sheet note 8) None N/A 1-Year bank loan (5.50% interest) 5-Year bank loan (6.00% interest) 10-Year bank loan (6.50% interest) Stock Issue (000s of shares at $12.00) Max share issue in year 6 = 5000k 0 0 0 0 Dividend ($/share) (Year 5 dividend was $0.00) Stock repurchase (000s ofshares at $12) (Max share repurchase in Year 6 = 200k) Shares of stock outstanding at the beginning of year 6 20,000 k Shares of stock outstanding at the end of year 6 20,000 k Projected Cash Available in Year 6 Projected Cash Outlays in Year 6 $144,174 $106,176 $58,248 Beginning Cash Balance (carried over from year 5) Cash inflows ------ Receipts from sales Bank Loans -------- 1-year 5-year 10-year Stock issue (0 shares $12.00) Loan to cover overdraft (1year loan) Interest on year 5 cash balance Cash refund $5,000 $366,494 $0 $0 $0 SO so $50 $0 $0 $0 $0 $0 Cash available from All sources $371,544 Cash outlays - Payments to component suppliers Production and assembly expenses Delivery/marketing/admin expenses Capital outlays -- New workstations Robotics upgrades Facilities expansion Facilities improvement Loan principal repayment ------- 1-year loans 5-year loans 10-year loans Interest payments -------- Bank loans Year 5 overdraft Stock repurchases (0 shares @ $12.00) Income tax payments Dividend payments Charitable contributions Cash fine $0 $0 $16,000 1828 **} {**3*2* | $10,350 $0 $0 $11,143 $0 $0 $0 Total cash outlays $346,091 Projected Cash Balance at the end of year 6 (5000s) $25,453 Could generate interest income of $255k in year 7 Other Important Financial Statistics Performance on Credit Rating Measures Interest paid on overdraft loans Interest rate received on cash balances Shareholder equity (mandted minimum = $100 mil) Last Year Year 6 (Projected) 8.50% 7.50% 1.00% 1.00% 114.5 mil 140.5 mil Debt / equity percentage (D:E) Interest Coverage ratio (operating profit/ interest exp) Current ratio (current assets/current liabilities) Last year Year 6 (Projected 59; 41 52; 48 2.73 4.61 1.42 1.79

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Routledge Handbook Of FinTech

Authors: K. Thomas Liaw

1st Edition

0367263599, 978-0367263591

More Books

Students also viewed these Finance questions

Question

How does CRC work?

Answered: 1 week ago

Question

Demonstrate three aspects of assessing group performance?

Answered: 1 week ago