Question

YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT.

                                                                        2016                            2017

BALANCE SHEETS:

Accounts Receivable520,000620,000

                        Fixed Assets, net                     410,000                       510,000

Total Assets1,355,0001,580,000

Liabilities and Equity:

Accounts Payable350,000$375,000

Long-term Debt500,000625,000

Common Stock50,00075,000

                        Retained Earnings                   455,000                       505,000

Total Liabilities and Equity1,355,0001,580,000

INCOME STATEMENT:

            Revenue                                                                                  3,500,000

            Cost of Goods Sold                                                                2,275,000

            General and Administrative                                                     515,000

            Depreciation Expense                                                              120,000

            Earnings Before Interest and Taxes                                         590,000

            Interest Expense                                                                      40,000

            Pretax Net Income                                                                   550,000

            Income Taxes                                                                          167,000

            Net Income                                                                              383,000

           

What was Gannon’s total current assets at the end of 2017?

What was Gannon’s net working capital at the end of 2017?

What was Gannon’s shareholders’ equity at book value at the end of 2017?

An appraiser recently valued Gannon’s fixed assets at $600,000 and determined that $40,000 of their accounts receivable was noncollectible. Based on only this information and the balance sheet above, what was the market value of Gannon’s shareholders’ equity at the end of 2017?

Assuming that Gannon did not buy back or redeem any of its shares, how much new common stock did it issue in 2017?

How much dividends did Gannon pay out to its shareholders in 2017?

What was Gannon’s effective annual average tax rate in 2017?

If Gannon had 18,000 shares of common stock outstanding throughout 2017, what was its Earnings per Share (EPS) in 2017?

Assuming that Gannon didn’t dispose of any of its fixed assets, how much new capital spending did it incur in 2017?

What was Gannon’s Operating Cash Flow (OCF) in 2017?

What was Gannon’s investment in net working capital for 2017?

What was Gannon’s Cash Flow to Creditors in 2017?

What was Gannon’s Cash Flow to Stockholders in 2017?

For questions #19-20, assume that a corporation’s pretax net income is taxable (Federal + State) based on 21% of the first $300,000, 30% of the next $400,000, and 34% of anything beyond that.

Answer 1

Solution:

1) Current Assets = 160,000 Cash + 620,000 Accounts Receivable + 290,000 Inventory $1,070,000

2) Net Working Capital = 1,070,000 Current Assets - 375,000 Accounts Payable $695,000

3) Book Value Stockholders Equity = 75,000 Common Stock + 505,000 Retained Earnings $580,000

4) Market Value Stockholders Equity = 160,000 Cash + 580,000 Accounts Receivable + $290,000 Inventory + $600,000 Fixed Assets - $375,000 Accounts Payable - $625,000 Debt $630,000

5) How Much new common stock did it issue in 2017:

$75,000 - $25,000 = $25,000

6) Ending Retained Earnings = Beginning Retained Earnings + Net Income - Dividends

505,000 = 455,000 + 383,000 - Dividends;

Solve for Dividends,

Dividends = 455,000 + 383,000 - $505,000 $333,000

7) Average tax rate = 167,000 / 550,000 = 30.4%

8) Earnings Per Share = $383,000 / 18,000 = $21.277777 (or) $21.28

9) Net Capital Spending = $510,000 Ending Fixed Assets - ($410,000 Beginning Fixed Assets - $120,000 Depreciation)

= $510,000 - $290,000

= $220,000

10) OCF = 590,000 EBIT + 120,000 depreciation - 167,000 taxes 543,000

11) NWC (2017) = 160,000 Cash + 620,000 Accounts Receivable + 290,000 Inventory - $375,000 Accounts Payable $695,000

NWC (2016) = 120,000 Cash + 520,000 Accounts Receviable + 305,000 Inventory - $350,000 Accounts Payable $595,000

Investment in NWC = 695,000 - 595,000 $100,000

12) Net New Borrowing = 625,000 - 500,000 125,000

CFC = 40,000 Interest Expense - 125,000 Net New Borrowing -$85,000

13) Net New Equity = 75,000 - 50,000 25,000

CFS = 333,000 Dividends - 25,000 Net New Equity $308,000