Question

Bohemian Manufacturing Company has the following end-of-year balance sheet:

Answer 1

Answer:

Bohemian Manufacturing Company

1. Increase in Assets:

d. $540,00

2. Spontaneous Liabilities:

d. $72,000

3. Given the preceding information, Bohemian Manufacturing Company is expected to generate__$318,458 income from operations that will be added to retained earnings from the total net income of $513,000 ($450,000 x 1.18).

4. According to the AFN equation and projections for Bohemian Manufacturing Company, the firm's AFN is $__149,542__.

Explanation:

Solution

1. Additional Funds Needed = Increase in Assets − Increase in Liabilities – Increase in Retained Earnings, according to xplaind.com.

a) Increase in Assets

= Assets × sales growth rate

= $3,000,000 × 18%

= $540,000

Spontaneous Increase in Liabilities

= Liabilities × sales growth rate

= $400,000 × 18%

= $72,000

Increase in Retained Earnings

= Current sales × profit margin × retention rate

= Current sales × (1 + sales growth rate) × profit margin × retention rate

= $13,000,000 × (1 + 18%) × 3.46% × 60% = $318,458

Additional Funds Needed

= $540,000 - $72,000 - $318,458

= $149,542

2. Data:

Bohemian Manufacturing Company

Balance Sheet

For the Year Ended on December 31

Assets Liabilities

Current Assets:                                   Current Liabilities:

Cash and equivalents $150,000      Accounts payable            $250,000

Accounts receivable     400,000      Accrued liabilities               150,000

Inventories                    350,000      Notes payable                    100,000

Total Current Assets $900,000       Total Current Liabilities $500,000

Net Fixed Assets:                               Long-Term Bonds         1,000,000

Net plant & equipment $2,100,000 Total Debt                    $1,500,000

                                                           Common Equity

                                                           Common stock               800,000

                                                           Retained earnings          700,000

                                                         Total Common Equity $1,500,000

Total Assets         $3,000,000   Total Liabilities & Equity $3,000,000

3. Current profit margin = Net Income/Sales x 100 = $450,000/$13,000,000 x 100 = 3.46%

4. Retention Rate = (1 - dividend payout ratio) = (1 - 40%) = 60%

5. AFN = Additional Funds Needed.  AFN is the financial resources obtained from external sources to finance the increase in assets which supports the increased sales level.  Note that "Bohemian Manufacturing Company's assets are fully utilized," so we do not envisage the acquisition of more fixed assets.  In view of this, the liabilities that are expected to increase are only the Accounts Payable and Accrued Liabilities, two vital sources of supply chain funding.