BALANCE SHEET
The balance sheet of the company reads a similar image as that of the Income Statement of the company. The company’s total assets increase in the first three years, but subsequently that they go down drastically in the following two years as the receivables and the amount of cash of the company are decreasing simultaneously that is bringing down total current assets, which is causing a precipitous fall in the total assets.
In the other half of the balance sheet, the current liability seems to come to a stop; this is mainly because current liability is taken as 0.62% of sales of that year. Moreover, reduction in sales had brought a reduction in liability, but the society is not profiting from it, which is a clear reflection in the return on equity of the fellowship that is decreasing by a steep pace in the final three years. This decrease indicates that with the passing of time, the investment starts to lose its value and the return on it begins to contract until the market completely rejects the product.
Forecasted Balance Sheets, 2010–2012 ($000s) |
|||||
2010 |
2011 |
2012 |
2013 |
2014 |
|
Cash |
3,960 |
4,752 |
4,752 |
4,224 |
3,465 |
Accounts receivable |
19,726 |
23,671 |
23,671 |
21,041 |
17,260 |
Inventories |
13,865 |
16,638 |
16,638 |
14,789 |
12,132 |
Prepaid expenses |
480 |
576 |
576 |
512 |
420 |
Total current assets |
38,031 |
45,637 |
45,637 |
40,566 |
33,277 |
Property, plant & equipment at cost |
8,182 |
9,082 |
9,982 |
10,882 |
11,782 |
Less: Accumulated depreciation |
2,179 |
2,793 |
3,474 |
4,223 |
5,039 |
Net property, plant & equipment |
6,003 |
6,289 |
6,508 |
6,659 |
6,743 |
Total assets |
44,034 |
51,926 |
52,145 |
47,226 |
40,020 |
Accounts payable |
4,799 |
5,759 |
5,759 |
5,119 |
4,199 |
Notes payable (Balancing Figure) |
14,320 |
16,930 |
13,341 |
13,342 |
13,343 |
Accrued expenses |
876 |
1,051 |
1,051 |
934 |
767 |
Income taxes payable |
226 |
264 |
254 |
219 |
168 |
Other current liabilities |
744 |
893 |
893 |
794 |
651 |
Total current liabilities |
20,966 |
24,897 |
21,299 |
20,408 |
19,128 |
Common stock at par value |
15 |
15 |
15 |
15 |
15 |
Paid in capital in excess of par value |
7,980 |
7,980 |
7,980 |
7,980 |
7,980 |
Retained earnings |
15,087 |
19,049 |
22,866 |
26,151 |
28,672 |
Total shareholders' equity |
23,067 |
27,029 |
30,846 |
34,131 |
36,652 |
Total liabilities & shareholders' equity |
44,034 |
51,926 |
52,145 |
54,540 |
55,780 |
Number of shares outstanding |
1,492 |
1,492 |
1,492 |
1,492 |
1,492 |
ROE | 0.15 | 0.15 | 0.12 | 0.10 | 0.07 |
Book Value per Share | 15.5 | 18.1 | 20.7 | 22.9 | 24.6 |
INVESTMENT APPRAISAL
The demand for continuous updating and innovation in the company has up taken a project for a major new product line, which will increase sales, earnings and cash flows. The company needs $2.2 million of finance to up hold this project; the society has two alternatives to finance this project that us either to take on debt finance by taking further loan notes and pledging 90% value of the receivables or the society can trade its shares privately.
Under both conditions, Discounted Cash Flow has to be brought forth as both finance options have different risk profiles; both choices will contribute to different cost of capital of the company calculated through WACC. Below each option, net present value has to be computed and the option that has a greater NPV will be the most viable choice for the company.
The discounted cash flow is conducted through data supplied as per the example,
Discounted Cash Flow |
|||||||
Investment In New Product Line (USD millions) |
|||||||
Year |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
2016 |
Initial Investment |
(2.20) |
|
|
|
|
|
|
Sales revenue |
|
21.60 |
28.00 |
28.00 |
11.00 |
5.00 |
|
Gross Profit Margin |
- |
4.54 |
5.88 |
5.88 |
2.31 |
1.05 |
- |
Advertising |
|
(0.30) |
|
|
|
|
|
Taxable Profit |
(2.20) |
4.24 |
5.88 |
5.88 |
2.31 |
1.05 |
- |
Taxation |
|
|
(1.69) |
(2.35) |
(2.35) |
(0.92) |
(0.42) |
Profit After Taxation |
(2.20) |
4.24 |
4.19 |
3.53 |
(0.04) |
0.13 |
(0.42) |
Working Capital |
|
(5.65) |
(7.32) |
(7.32) |
(2.88) |
(1.31) |
- |
Add Back Depreciation Expense |
|
0.44 |
0.44 |
0.44 |
0.44 |
0.44 |
- |
Working Capital – Recovered |
|
|
|
|
|
24.49 |
|
Net Cash Flows |
(2.20) |
(0.97) |
(2.70) |
(3.36) |
(2.48) |
23.74 |
(0.42) |
WACC & CAPM
For the calculation of CAMP, equity risk premium is taken as 6% that is given in the case. The risk free return is taken as a 10-year treasury bond that is 3.70% as provided in the exhibit, but for the calculation of beta, the beta of competing companies have been taken un-geared to calculate beta asset. The average of the beta asset of the competitive companies is assumed to be the beta asset of the industry, which is then geared by the data of the Flash Drive company that gives a beta equity of 1.38 (Calculation of beta asset/ industry beta is conducted in exhibit-4).................................
This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.