In: Finance
Income statement for the fiscal year ending January 1 (Millions of dollars)
| 
 2017 (Actual)  | 
 2018 (Projected)  | 
||
| 
 Net Sales  | 
 $400.0  | 
 $430.0  | 
|
| 
 Costs  | 
 260.0  | 
 283.5  | 
|
| 
 Depreciation  | 
 37.5  | 
 42.5  | 
|
| 
 Earnings before interest and taxes  | 
 102.5  | 
 104.0  | 
|
| 
 Interest expense  | 
 14.1  | 
 16.0  | 
|
| 
 Earnings before taxes  | 
 88.4  | 
 89.9  | 
|
| 
 Taxes (40%)  | 
 35.36  | 
 35.2  | 
|
| 
 Net income before preferred dividends  | 
 53.04  | 
 52.8  | 
|
| 
 Preferred dividends  | 
 6.0  | 
 6.5  | 
|
| 
 Net income  | 
 47.04  | 
 46.3  | 
|
| 
 Common dividends  | 
 37.632  | 
 38.2  | 
|
| 
 Addition to retained earnings  | 
 9.0408  | 
 8.1  | 
|
Balance sheets for the fiscal year ending January 1 (Millions of dollars)
| 
 2017 (Actual)  | 
 2018 (Projected)  | 
||
| 
 Cash  | 
 $6.3  | 
 $6.6  | 
|
| 
 Marketable Securities  | 
 40.9  | 
 37.128  | 
|
| 
 Accounts Receivable  | 
 62.0  | 
 66.0  | 
|
| 
 Inventories  | 
 107.0  | 
 115.5  | 
|
| 
 Net plant & equipment  | 
 391.0  | 
 415.36  | 
|
| 
 Total Assets  | 
 607.2  | 
 640.58  | 
|
| 
 Accounts payable  | 
 9.6  | 
 12.1  | 
|
| 
 Accruals  | 
 25.5  | 
 29.1  | 
|
| 
 Long-term bonds  | 
 210.7  | 
 227.78  | 
|
| 
 Preferred Stock  | 
 55  | 
 57.1  | 
|
| 
 Common Stock (Par plus PIC)  | 
 160.0  | 
 160.0  | 
|
| 
 Retained earnings  | 
 146.4  | 
 154.5  | 
|
| 
 Total Liabilities & Equity  | 
 607.2  | 
 640.58  | 
|
Free cash Flow to Firm (FCFF) = 
EBIT= Earning Before Interest and Tax
t= tax rate
Cap.Ex = Capital Expenditure
= Change in working capital
calculating capital expenditure in 2018-
- Net plant and equipment in 2018 end = Net plant and equipment in 2017 end+ capital expenditure in 2018-depreciation in 2018.
| Particulars | Amount($Million) | 
| Net plant & equipment in 2018 | 415.36 | 
| Add-Dereciation of 2018 | 42.5 | 
| Less-Net plant & equipment in 2017 | 391 | 
| Addition of plant & equipment or Capital expenditure in 2018 | 66.86 | 
calculating working capital change in 2018-
working capital = Curremt assets-Current liabilities
Working capital chahnge in 2018 = Net working capital in 2018- Net working capital 2017
| 2018 | 2017 | Changes | |
| Current assets | $MILLION | $MILLION | |
| Cash | 6.6 | 6.3 | |
| Marketable Securities | 37.128 | 40.9 | |
| Accounts Receivable | 66 | 62 | |
| Inventories | 115.5 | 107 | |
| Total current assets(A) | 225.228 | 216.2 | |
| Current liabilties | |||
| Accounts payable | 12.1 | 9.6 | |
| Accruals | 29.1 | 25.5 | |
| Total Current liabilities(B) | 41.2 | 35.1 | |
| Net working capital(A-B) | 184.028 | 181.1 | 2.928 | 
hence net working capital change is $2.928 million
Free cash Flow to Firm (FCFF) = 
=>FCFF of 2018 = 104(1-0.40)+ 42.5 -66.86-2.928 = $35.112 MILLION
FCFF of 2019 = FCFF of 2018*(1+growth) = $35.112*(1+8%) = $35.112*1.08 = $37.92096 million
FCFF of 2020 = FCFF of 2019*(1+growth) = 37.92096*(1+6%) = 37.92096*1.06 = $40.1962176 million
FCFF of 2021 = FCFF of 2020*(1+growth) = 40.1962176*1.04 = $41.8040663 million

v0 = value of firm at year 0
FCFF1 = Next year Free cash flow
Ke = cost of capital
g =growth rate

=>value of firm at year 2020 end = FCFF at 2021/(12.01%-4%) = $41.8040663 million / 0.0801 = $521.8984557 million
value of Firm at 2017 = PV of FCFF till 2020+ PV of value of firm at the end of 2020
| sl no | year | Amount($million)(A) | [email protected]%(B) | 
 pv of FCFF(A*B)  | 
|
| 1 | 2018 | FCFF | 35.112 | 0.8927774306 | 31.34720114 | 
| 2 | 2019 | FCFF | 37.92096 | 0.7970515406 | 30.22495959 | 
| 3 | 2020 | FCFF | 40.1962176 | 0.7115896264 | 28.60321147 | 
| 3 | 2020 | Value of firm | 521.8984557 | 0.7115896264 | 371.3775271 | 
| Total | 461.5528993 | 
hence value of firm at 2017 = $461.5528993 million or $461.553 million (Round off)
value of firm = value of shares+value of debt+value of preferred stock
=>value of share = value of firm-value of debt-value of preferred stock
=>value of share at 2017 = $461.553 million-$210.7 million-$55 million = $195.853 million
estimate share price = value of share/ number of shares outstanding
=>Esimated share price today = $195.853 million/ 10 million share = $19.5853 per share or $19.59 per share approx