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 |