Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The finance group at CATS is working on forecasting its financial statements for 20Y5. They are working with the following assumptions: CATS will invest $180,000

The finance group at CATS is working on forecasting its financial statements for 20Y5. They are working with the following assumptions:

CATS will invest $180,000 in fixed assets in 20Y5; depreciation expense will increase by $17,469 in 20Y5 over the 20Y4 amount.

CATS will fund the investment in fixed assets with a long-term loan of $180,000. Interest expense will increase by $16,300 in 20Y5 over the 20Y4 amount. There will no change in the number of shares of common stock.

CATS will increase its common dividend by 5%.

The marketing group estimates that sales will increase 12.5% in 20Y5.

All NOWC accounts, except cash, will increase by 10% over the 20Y4 amounts. The ending cash balance for 20Y5 is expected to increase 22% over the 20Y4 amount. ST investments will remain constant.

The ratio of operating expenses (excluding other expenses and depreciation) to sales will decline from ~85.4% to 83%. The other expenses item on the income statement will increase 3%. The tax rate will remain at 40%.

The WACC for CATS is expected to remain at 10% for 20Y5.

Any additional funds needed (AFN) will come from a short-term borrowing, i.e., an increase in notes payable. Similarly, any funds released would be used to reduce notes payable. In other words, notes payable is a plug variable which will be used to balance the balance sheet.

c. Compute the free cash flow (FCF) and the return on invested capital (ROIC) for CATS in 20Y5. Explain any changes in ROIC, i.e., were changes due to changes in operating profitability or capital utilization?

image text in transcribedimage text in transcribed

INCOME STATEMENTS FOR CATS Sales Cost of goods sold (excluding depreciation) Other expenses Depreciation and amortization Total operating costs EBIT Interest expense Pre-tax earnings Taxes (40%) Net income 2013 $ 3,432,000 2,864,000 340,000 18,900 $3,222,900 $ 209,100 62,500 $ 146,600 58,640 $ 87,960 2014 $5,834,400 4,980,000 720,000 116,960 $ 5,816,960 17,440 176,000 ($ 158,560) (63,424) ($ 95,136) ADDITIONAL DATA $ $ Stock price Shares outstanding Earnings per share (EPS) Dividends per share (DPS) Tax rate 2013 8.50 100,000 0.880 0.220 40% 2014 6.00 100,000 0.951 0.110 40% $ $ $ ta BALANCE SHEETS FOR CATS 2013 2014 $ 9,000 48,600 351,200 715,200 $ 1,124,000 491,000 146,200 $ 344,800 $ 1,468,800 7,282 20,000 632,160 1,287,360 $ 1,946,802 1,202,950 263,160 $ 939,790 $ 2,886,592 Assets: Cash Short-term investments Accounts receivable Inventories Total current assets Gross fixed assets Less: Accumulated depreciation Net fixed assets Total assets Liabilities and Equity: Accounts payable Notes payable Accruals Total current liabilities Long-term debt Common stock (100,000 shares) Retained earnings Total equity Total liabilities and equity $ 145,600 200,000 136,000 $ 481,600 323,432 460,000 203,768 $ 663,768 $ 1,468,800 $ 324,000 720,000 284,960 $ 1,328,960 1,000,000 460,000 97,632 $ 557,632 $ 2,886,592

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

Students also viewed these Accounting questions

Question

I am paid fairly for the work I do.

Answered: 1 week ago

Question

I receive the training I need to do my job well.

Answered: 1 week ago