Reference no: EM131320874
Mr. "Great" Kid, an experienced budget analyst at ToysForAll Manufacturing company, has been charged with assessing the firm's financial performance during 2014 and its financial position at year end 2014.
To complete this assignment, he gathered the firm's 2014 financial statement (exhibit 1).
In addition, Mr. "Great" Kid obtained the firm's ratio value for 2013 and 2012, along with the 2014 industry average ratios (also applicable to 2013 and 2012). These are presented in exhibit 2. The income statement for 2014 has been summarized on the following Table.
Table 1.
ToysForAll Company
Income Statement
For the year ended December 31, 2014
Sales revenue $10,150,000
(-) Cost of goods sold 7,408,000
Gross profits 2,742,000
(-) Operating expenses
Selling expense 1,300,000
General & Adm. Exp. 832,000
Depreciation exp. 304,000
Total Operating exp. 2,436,000
Operating profits 306,000
(-) interest exp. 186,000
Net profits before taxes 120,000
(-) taxes (rate = 30%) 36,000
Net profits after taxes 84,000
(-) preferred stock dividends 6,000
Earnings available for common stockholders 78,000
Earnings per share (EPS) $0,78
To improve its competitive position ToysForAll is planning to implement a major equipment modernization program. Included will be replacement and modernization of key manufacturing equipment at a cost of $800.000 in 2015.
The planned program is expected to lower the variable cost per unit of finished product.
Mr. "Great" Kid, as one of the experienced budget analyst, has been charged with preparing a forecast of the firm's 2015 financial position, assuming replacement and modernization of manufacturing equipment. He plans to use the 2014 financial statements presented on exhibit 1 and 2, along with the key projected financial data summarized in the following table.
Table 2.
ToysForAll Company
Key projected financial data (2015)
Data item value
Sales revenue $13,000,000
Minimum cash balance 50,000
Inventory turnover (times) 7.0
Average collection period 50 days
Fixed assets purchases 800,000
Total dividend payments (preferred and common) 40,000
Depreciation expense 370,000
Interest expense 194,000
Accounts payable increase 20%
Accruals and long term debt unchanged
Notes payable, preferred and common stock unchanged
You have been asked to help Mr. "Great" Kid to calculate the firm's 2014 financial ratio (note: assume a year = 365 days) and then analyze the firm's current financial position from both a cross sectional and a time series view point, and finally summarize the firm's overall financial position on the basis of your findings in analysis and evaluation of the firm's profitability, liquidity, activity, solvability, and market.
After analyzing financial position of ToysForAll Company, Mr. "Great" Kid use the historical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2015 and the pro forma balance sheet at December 31, 2015. The Board of Directors also asked Mr. "Great" Kid to explain, why will ToysForAll company need to obtain external financing to fund the proposed equipment modernization program?
Meanwhile ToysKid, Inc., is a toys fabrication firm which manufactures toys spare parts for customers in a variety of models. The firm's motto is "If you need it, we can make it". The CEO of ToysKid recently held a board meeting during which he extolled the virtues of the corporation. The company, he stated confidently, had the capability to build any product and could do so using a lean manufacturing model.
The firm would soon be profitable, claimed the CEO, because the company used state of the art technology to build a variety of products while keeping inventory levels low.
As a Future Business Leader, you have calculated some ratio to analyze the financial health of the firm. ToysKid's current ratios and quick ratios for the past six years are shown in the table below:
|
2009
|
2010
|
2011
|
2012
|
2013
|
2014
|
|
Current ratio
|
1.2
|
1.4
|
1.3
|
1.6
|
1.8
|
2.2
|
|
Quick ratio
|
1.1
|
1.3
|
1.2
|
0.8
|
0.6
|
0.4
|
What do you think of the CEO's claim that the firm is lean and soon to be profitable?
After finishing analysis of company performance and preparation of pro forma budget, the Board of Directors ToysForAll also asking to Mr."Great" Kid and his Team to develop relevant cash flows for "SisterToys" Company's machine renewal or replacement decision (SisterToys is the sister company of ToysForAll)
Board of Directors expect the firm's net operating profit after taxes for the next 5 years to be as shown in the following table.
Mr. "Great" Kid is beginning to develop the relevant cash flows needed to analyze whether to renew or replace SisterToys only depreciable asset, a machine that originally cost $60,000, has a current book value of zero, and now be sold for $40,000.
He estimates that at the end of 5 years, the existing machine can be sold to net $4,000 before taxes. Mr. "Great" Kid plans to use the following information to develop the relevant cash flows for each of the alternatives.
Alternative 1.
Renew the existing machine at a total depreciable of $180,000. The renewed machine would have a 5 year usable life and would be depreciated under straight line depreciation method. Renewing the machine would result in the following projected revenues and expenses (excluding depreciation and interest):
|
Year
|
revenue
|
Expenses (excl.depr.and int.)
|
|
1
|
$2,000,000
|
$1,603,000
|
|
2
|
2,350,000
|
1,768,400
|
|
3
|
2,600,000
|
1,836,200
|
|
4
|
2,850,000
|
1,886,200
|
|
5
|
3,100,000
|
1,936,200
|
The renewed machine would result in an increased investment in net working capital of $30,000. At the end of 5 years, the machine could be sold to net $16,000 before taxes.
Alternative 2.
Replace the existing machine with a new machine that costs $200,000 and requires installation costs of $20,000. The new machine would have a 5 year usable life and would be depreciated under straight line depreciation method. The firm's projected revenues and expenses (excluding depreciation and interest), if it acquires the machine, would be as follows:
|
year
|
revenue
|
Expenses (excl.depr.and int.)
|
|
1
|
$2000,000
|
$1,529,000
|
|
2
|
2,350,000
|
1,679,600
|
|
3
|
2,600,000
|
1,829,800
|
|
4
|
2,850,000
|
1,979,800
|
|
5
|
3,100,000
|
1,997,800
|
The new machine would result in an increased investment in net working capital of $44,000. At the end of 5 years, the new machine could be sold to net $50,000 before taxes.
The firm has a 9% cost of capital and is subject to a 30% tax rate. As noted, the company uses straight line depreciation method. Mr. "Great" Kid has actually prepared that analyses, but he need your opinion about this decision, on the basis of your comparison of their relevant cash flows, which alternative appears to be better? Of course he needs also your recommendation based on the calculation the initial investment, the incremental operating cash flow, the terminal cash flow, and the relevant cash flow associated with each of the alternatives.