Question

Green Caterpillar Garden Supplies Inc. reported sales of $775,000 at the end of last year; but...

Green Caterpillar Garden Supplies Inc. reported sales of $775,000 at the end of last year; but this year, sales are expected to grow by 7%. Green Caterpillar expects to maintain its current profit margin of 20% and dividend payout ratio of 10%. The firm’s total assets equaled $400,000 and were operated at full capacity. Green Caterpillar’s balance sheet shows the following current liabilities: accounts payable of $70,000, notes payable of $30,000, and accrued liabilities of $70,000. Based on the AFN (Additional Funds Needed) equation, what is the firm’s AFN for the coming year?

-$163,831

-$137,618

-$131,065

-$170,384

A negatively-signed AFN value represents:

A point at which the funds generated within the firm equal the demands for funds to finance the firm’s future expected sales requirements

A surplus of internally generated funds that can be invested in physical or financial assets or paid out as additional dividends

A shortage of internally generated funds that must be raised outside the company to finance the company’s forecasted future growth

Because of its excess funds, Green Caterpillar is thinking about raising its dividend payout ratio to satisfy shareholders. What percentage of its earnings can Green Caterpillar pay to shareholders without needing to raise any external capital? (Hint: What can Green Caterpillar increase its dividend payout ratio to before the AFN becomes positive?)

89.0

75.6

84.6

62.3

Homework Answers

Answer #1

AFN = Total Assets*% increase in sales – Spontaneous Liabilities*% increase in sales – Forecasted Sales*Profit Margin Ratio*(1-Payout ratio)

= 400,000*7% - (70,000+70,000)*7% - 775000*1.07*20%*(1-10%)

= -$131,065

A negatively-signed AFN value represents:

A surplus of internally generated funds that can be invested in physical or financial assets or paid out as additional dividends

Let the % dividend be x

0 = 400,000*7% - 140,000*7% - 775000*1.07*20%*(1-x)

0 = 18200 – 165850*(1-x)

x = 89.03%

i.e. 89.0

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
More on the AFN (Additional Funds Needed) equation Green Caterpillar Garden Supplies Inc. reported sales of...
More on the AFN (Additional Funds Needed) equation Green Caterpillar Garden Supplies Inc. reported sales of $775,000 at the end of last year; but this year, sales are expected to grow by 6%. Green Caterpillarexpects to maintain its current profit margin of 20% and dividend payout ratio of 30%. The firm’s total assets equaled $475,000 and were operated at full capacity. Green Caterpillar’s balance sheet shows the following current liabilities: accounts payable of $60,000, notes payable of $25,000, and accrued...
More on the AFN (Additional Funds Needed) equation Green Caterpillar Garden Supplies Inc. reported sales of...
More on the AFN (Additional Funds Needed) equation Green Caterpillar Garden Supplies Inc. reported sales of $743,000 at the end of last year; but this year, sales are expected to grow by 7%. Green Caterpillar expects to maintain its current profit margin of 23% and dividend payout ratio of 15%. The firm’s total assets equaled $400,000 and were operated at full capacity. Green Caterpillar’s balance sheet shows the following current liabilities: accounts payable of $70,000, notes payable of $40,000, and...
Cold Duck Manufacturing Inc. reported sales of $775,000 at the end of last year, but this...
Cold Duck Manufacturing Inc. reported sales of $775,000 at the end of last year, but this year, sales are expected to grow by 9%. Cold Duck expects to maintain its current profit margin of 20% and dividend payout ratio of 30%. The following information was taken from Cold Duck’s balance sheet: Total assets: $475,000 Accounts payable: $65,000 Notes payable: $40,000 Accrued liabilities: $65,000 Based on the AFN equation, the firm’s AFN for the current year is _______ . A positively...
Bohemian Manufacturing Company reported sales of $720,000 at the end of last year; but this year,...
Bohemian Manufacturing Company reported sales of $720,000 at the end of last year; but this year, sales are expected to grow by 8%. Bohemian expects to maintain its current profit margin of 20% and dividend payout ratio of 15%. The firm’s total assets equaled $400,000 and were operated at full capacity. Bohemian’s balance sheet shows the following current liabilities: accounts payable of $70,000, notes payable of $30,000, and accrued liabilities of $60,000. Based on the AFN (Additional Funds Needed) equation,...
Fuzzy Button Clothing Company reported sales of $720,000 at the end of last year; but this...
Fuzzy Button Clothing Company reported sales of $720,000 at the end of last year; but this year, sales are expected to grow by 10%. Fuzzy Buttonexpects to maintain its current profit margin of 20% and dividend payout ratio of 15%. The firm’s total assets equaled $500,000 and were operated at full capacity. Fuzzy Button’s balance sheet shows the following current liabilities: accounts payable of $80,000, notes payable of $25,000, and accrued liabilities of $80,000. Based on the AFN (Additional Funds...
Last Tuesday, Green Caterpillar Garden Supplies Inc. lost a porion of its planning and financial data...
Last Tuesday, Green Caterpillar Garden Supplies Inc. lost a porion of its planning and financial data when its server and its backup server crashed. The company's CFO remembers that the internal rate of return (IRR) of project Gamma is 11.3%, but he can't recall how much Green Caterpillar originally invested in the project nor the project's net present value (NPV). However, he found a note that contained the annual net cash flows expected to be generated by Project Gamma. They...
uzzy Button Clothing Company has the following end-of-year balance sheet: Fuzzy Button Clothing Company Balance Sheet...
uzzy Button Clothing Company has the following end-of-year balance sheet: Fuzzy Button Clothing 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 and equipment $2,100,000 Total Debt $1,500,000 (cost minus depreciation) Common Equity Common stock 800,000 Retained earnings 700,000...
Your firm recorded sales for the most recent year of $10 million generated from an asset...
Your firm recorded sales for the most recent year of $10 million generated from an asset base of $7 million, producing a $500,000 net income. Current year accounts payable and accrued liabilities provided spontaneously generated funds of $200,000. Sales are projected to grow at 20%. In the most recent year, $200,000 was paid out as dividends, and the current payout ratio will continue in the upcoming years. What is your firm’s AFN?        $200,000        $600,000       ...
Quantitative Problem 1: Beasley Industries' sales are expected to increase from $5 million in 2017 to...
Quantitative Problem 1: Beasley Industries' sales are expected to increase from $5 million in 2017 to $6 million in 2018, or by 20%. Its assets totaled $3 million at the end of 2017. Beasley is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2017, current liabilities are $800,000, consisting of $170,000 of accounts payable, $350,000 of notes payable, and $280,000 of accrued liabilities. Its profit margin is forecasted to be 4%,...
Following is the balance sheet for the end of the year 2018 for Silver Spurs, Inc.:...
Following is the balance sheet for the end of the year 2018 for Silver Spurs, Inc.:                                                                  2018 2019             Current Assets                            $15,000    _______________             Net Fixed Assets                           20,000     _____________________________             Total Assets                                $35,000 __________________             Accounts Payable                        $ 2,000     ________________             Notes Payable                                1,000    ________________             Long-Term Debt                          10,000      ________________             Common Equity                     22,000                  Total Liabilities/Equity              $35,000 __________________    AFN    _________________             They have generated sales for 2018 of $35,000 resulting in net income of $15,000. Due to the difficulty associated with acquiring raw materials,...