In: Accounting
From the Income Statement, Balance Sheet, and Statement of
Changes in Owners’ Equity, and Statement of Cash flows for 2017
(you prepared in Tandy #1).
Calculate (and show your work) for the following
Earnings per Share (EPS)
Dividends per share (DPS)
Book Value per Share
Net Operating Profit after Tax (NOPAT)
EBIT (1 - Tax
rate)
Net Operating Working Capital (NOWC)
Current
assets – (Current liabilities – Notes Payable
Net Plant and
Equipment (NFA)
Operating Capital (OC)
NOWC +
NFA
Net Cash Flow (NCF)
Operating Cash Flow (OCF)
Free Cash Flow (FCF)
Cash Flow from Assets (CFA)
Cash Flow to Debtors (CFD)
Cash Flow to Equity Holders (CFE)
TANDY COMPANY |
Year Ending |
||||
6/30/2017 |
6/30/2016 |
6/30/2015 |
|||
Common Stock 100,000 shares outstanding |
$460,000 |
$460,000 |
$460,000 |
||
Net Receivables |
632,160 |
351,200 |
315,000 |
||
Cost of Goods Sold |
5,528,000 |
2,864,000 |
2,706,000 |
||
Expenses |
519,988 |
358,672 |
330,000 |
||
Interest Expense |
136,012 |
43,828 |
42,500 |
||
Property Plant and Equipment |
1,202,950 |
491,000 |
476,000 |
||
Less Accumulated Depreciation |
263,160 |
146,200 |
127,300 |
||
Income Taxes (40%) |
?? |
58,640 |
80,680 |
||
Cash And Cash Equivalents |
7,282 |
57,600 |
37,500 |
||
Sales |
6,034,000 |
3,432,000 |
3,300,000 |
||
Accounts Payable |
524,160 |
145,600 |
166,000 |
||
Notes Payable |
636,808 |
200,000 |
200,000 |
||
Accrued Liabilities |
489,600 |
136,000 |
122,000 |
||
Depreciation Expense |
116,960 |
18,900 |
19,800 |
||
Long Term Debt |
723,432 |
323,432 |
323,432 |
||
Inventory |
1,287,360 |
715,200 |
675,000 |
||
Dividends |
11,000 |
22,000 |
22,000 |
||
Retained Earnings |
32,592 |
203,768 |
104,748 |
||
Other Information |
|||||
The firm had sufficient taxable income in 2016 and 2015 to obtain a full refund in 2017 |
|||||
Net Income for 2016 |
$87,960 |
TANDY COMPANY |
Year Ending |
||||
6/30/2017 |
6/30/2016 |
6/30/2015 |
|||
Common Stock 100,000 shares outstanding |
$460,000 |
$460,000 |
$460,000 |
||
Net Receivables |
632,160 |
351,200 |
315,000 |
||
Cost of Goods Sold |
5,528,000 |
2,864,000 |
2,706,000 |
||
Expenses |
519,988 |
358,672 |
330,000 |
||
Interest Expense |
136,012 |
43,828 |
42,500 |
||
Property Plant and Equipment |
1,202,950 |
491,000 |
476,000 |
||
Less Accumulated Depreciation |
263,160 |
146,200 |
127,300 |
||
Income Taxes (40%) |
?? |
58,640 |
80,680 |
||
Cash And Cash Equivalents |
7,282 |
57,600 |
37,500 |
||
Sales |
6,034,000 |
3,432,000 |
3,300,000 |
||
Accounts Payable |
524,160 |
145,600 |
166,000 |
||
Notes Payable |
636,808 |
200,000 |
200,000 |
||
Accrued Liabilities |
489,600 |
136,000 |
122,000 |
||
Depreciation Expense |
116,960 |
18,900 |
19,800 |
||
Long Term Debt |
723,432 |
323,432 |
323,432 |
||
Inventory |
1,287,360 |
715,200 |
675,000 |
||
Dividends |
11,000 |
22,000 |
22,000 |
||
Retained Earnings |
32,592 |
203,768 |
104,748 |
||
Other Information |
|||||
The firm had sufficient taxable income in 2016 and 2015 to obtain a full refund in 2017 |
|||||
Net Income for 2016 |
$87,960 |
Sr. No. |
Particulars |
2017 |
2016 |
2015 |
1 |
Earnings per share (EPS) – (b/a) |
4.60 |
4.60 |
4.60 |
Number of shares (a) |
100000 |
100000 |
100000 |
|
Share capital (b) |
460000 |
460000 |
46000 |
|
2. |
Dividends per share (DPS) – (b/a) |
0.11 |
0.22 |
0.22 |
Number of shares (a) |
100000 |
100000 |
100000 |
|
Dividends (b) |
11000 |
22000 |
22000 |
|
3. |
Book Value per share (a/ No. of shares) |
4.925 |
6.637 |
5.647 |
Calculation of networth |
||||
Net Receivables |
632160 |
351200 |
315000 |
|
Property, plant & equipment |
1202950 |
491000 |
476000 |
|
(-) accumulated depreciation |
263160 |
146200 |
127300 |
|
Cash & cash equivalents |
7282 |
57600 |
37500 |
|
Inventory |
1287360 |
715200 |
675000 |
|
Current Assets |
1784592 |
1468800 |
1376200 |
|
(-) Accounts payable |
524160 |
145600 |
166000 |
|
(-) notes payables |
636808 |
200000 |
200000 |
|
(-) Accrued liabilities |
489600 |
136000 |
122000 |
|
(-) Long term debt |
723432 |
323432 |
323432 |
|
Net worth (a) |
492592 |
663768 |
564768 |
|
4. |
Net Operating Working Capital |
770832 |
987200 |
888200 |
Current assets |
1784592 |
1468800 |
1376200 |
|
(-) Current Liabilities |
||||
Accounts payable |
524160 |
145600 |
166000 |
|
Accrued liabilities |
489600 |
136000 |
122000 |
|
(-) notes payables |
636808 |
200000 |
200000 |
|
5. |
Net Plant & Equipment |
939790 |
344800 |
348700 |
Property, plant & equipment |
1202950 |
491000 |
476000 |
|
(-) accumulated depreciation |
263160 |
146200 |
127300 |
|
6. |
Operating Capital (4+5) |
1710622 |
1332000 |
1236900 |