Clayton Industries is planning its operations for next year, and Ronnie Clayton, the CEO, wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions.
Last year's sales = S0 $350 Last year's accounts payable $40
Sales growth rate = g 30% Last year's notes payable (to bank) $50
Last year's total assets = A0 $500 Last year's accruals $30
Last year's profit margin = M 5% Target payout ratio 60%
Increase in Assets= 500*30%=$150
Increase in Notes payable= 50*30%=$15
Increase in retained earnings= 350*1.3*5%-Dividend
AFN= Increase in ...
This provides the steps to calculate the AFN for the coming year