Documents

17

Categories
Published
of 4
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Related Documents
Share
Description
17
Transcript
  17-1 Carter corporations sales are expected to increase from $5 million in 2004 to $6 million in 2005 , or by 20 percent. Its assets totaled $3 million at the end of 2004. Carter is at full capacity<so its assets must grow at same rate as pro- Rejected sales. At the end of 2004, current liabilities were $1 million, consisting of $250.000 of accounts payable, $500.000of notes payable, and $250.000 of accruals. The after-tax profit margin is forecasted to be 5 percent. (17-1) Use the AFN formula to forecast Carter's additional funds needed for the coming year. 17-1 AFN = (A * /S 0 )∆S - (L * /S 0 )∆S - MS 1 (1 - d) =      000,000,5$ 000,000,3$ $1,000,000 -      000,000,5$ 000,500$ $1,000,000 - 0.05($6,000,000)(1 - 0.7) = (0.6)($1,000,000) - (0.1)($1,000,000) - ($300,000)(0.3) = $600,000 - $100,000 - $90,000 = $410,000. (17-2) What would be the additional funds needed if the company's year-end 2004 assets had been $4 million ? Assume that all other numbers are the same . Why is this AFN different from the one you found in problem 14-1? Is the company's capital intensity the same or different? 17-2 AFN =      000,000,5$ 000,000,4$ $1,000,000  –  (0.1)($1,000,000)  –  ($300,000)(0.3) = (0.8)($1,000,000) - $100,000 - $90,000 = $800,000 - $190,000 = $610,000. (17-3) return to the assumption that the company had $3 million in assets at the end of 2004, but now assume that the company pays no dividend. Under these assumption. What would be additional funds needed for the coming year? Why is this AFN different from the one you found in problem 14-1? 17-3 AFN = (0.6)($1,000,000) - (0.1)($1,000,000) - 0.05($6,000,000)(1 - 0) = $600,000 - $100,000 - $300,000 = $200,000. Under this scenario the company would have a higher level of retained earnings which would reduce the amount of additional funds needed. 17-4 PRO FORMA INCOME STATEMENT: Austin Grocers recently reported the following 2008 income statement (in millions of dollars): Sales $700 Operate ring cost including depreciation 500   EBIT 200 Interest 40 EBT $160  Taxes (40%) 64 Net Income $ 96 Dividends 32 Additional to retained earning $ 64 This year the company is forecasting a 25% increase in sales; and it expects that its year-end operating cost, including depreci ation, will equal 70% of sales. Austin’s tax rate, interest expense, and dividend payout ratio are all expected to remain constant. a. What is Austin’s projected 2009 net income?   b. What is the expected growth rate in Austin’s dividends?  a. (Calculations in millions of dollar) Net income 2009 = Sales - operating cost - interest espenses - taxes EBIT = $875 (120% of $700) - $612.50 - $40 = $222.50 Net income = $222.50 - $89 (40% tax) = $133.5 b. Since dividend payout ratio is same 33.33% ($32 / $96 in the year 2008), current year dividend is $44.49 (33.3333% of $133.5). Hence growth in dividend = ($44.49 - $32) / $32 = 39.02% 17-5 Walter industries has $5 billion in sales and $1.7 billion in fixed assets. Currently, the company's fixed assets are operating at 90% of capacity. a) What level of sales would Walter Industries have obtained if it had been operating at full capacity? b) What is Walter's Target fixed assets/Sales ratio? c) If Walter's sales increase 12%, how large of an increase in fixed assets will the company need to meet its Target fixed assets/sales ratio? a) x(0.90) = $5 billion, where x equal sales if operating at full capacity Divide $5 billion by 0.90 to obtain the answer = $5,555,555,555.56 b) Fixed assets/Sales = $1.7/5.0 = 0.34 c) Sales increase by 12% = $5.0 billion (1.12) = $5.6 billion x/5.6 = 0.34 Solve for x = 0.34*5.6 = $1.904B The question, however, asks for how large of an increase you will need in fixed assets. Currently you have $1.7 billion, so find the difference $1.904 - $1.7 = $0.204B, or $204M increase in fixed assets 17-6 Jasper Furnishings has $300 million in sales. The companyexpects that its sales w ill increase 12 percent this year.Jasper’s CFO uses a simple linear regression to forecast thecompany’s inventory level for a given level of projectedsales. On the basis of   recent history, the estimated relationshipbetween inventories and sales (in millions of dollars) is Inventories = $25 +0.125 (Sales) Given the estimated sales forecast and the estimatedrelationship between inventories and sales, what are your forecastsof the company’s year  -end inventory level and the inventoryturnover ratio? 17-7  Pro forma income statement - At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation $250 EBIT $300 Interest $125 EBT $175 Taxes (40%) $70 Net income $105 Looking ahead to the following year, the company's CFO has assembled the following information: ã Year -end sales are expected to be 10 percent higher than the $3 billion in sales generated last year. ã Year -end operating costs, excluding depreciation, are expected to equal 80 percent of year-end sales. ã Depreciation is expected to increase at the same rate as sales.   ã Interest costs are expected to remain unchanged.   ã The tax rate is expected to remain at 40 perce nt. On the basis of this information, what will be the forecast for Robert's year-end net income? Pro-forma income statement (forecast) PRO FORMA INCOME STATEMENT In million Sales 3,300 Operating Cost 2,640 EBITDA 660 Depreciation 275 EBIT 385 Interest Cost 125 EBT 260 Taxes 104 Net Income 156 Sales $3,300 (3000 x 110%) Operating costs excluding depreciation 2,640 (3300 x 80%) EBITDA $660 Depreciation $275 (250 x 110%) EBIT $385 Interest $125 EBT $260 Taxes (40%) $104 Net income $156 17-10: Regression and receivables: Edwards Industries has $320 million in sales. The company expects that its sales will increase 12% this year. Edwards CFO uses a simple linear regression to forecast the company ‘s recievables level for a given level of projected sales. On the basis of recent history, the estimated relationship between receivables and sales (in millions of dollars) is as follows: receivables=$9.25+0.07(sales) Given the estimated sales forecast and the estimated relationship between receivables and sales, what are your forecasts of the compan y’s year end balance for receivables and it year end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basis of a 365 day year. Please make both problems srcinal and in excel if possible. YEAR END BALANCE OF RECEIVABLE Sales = 320 X 1.12 336    Receivables = $9.25+0.07(sales) 32.77 YEAR END DAYS SALES OUTSTANDING DSO = 365 / Sales / Receivable 36 17-11 Charlie’s Cycles Inc. has $110 million in sales. The company expects that its sales will increase 5% this year. Charlie’s CFO uses a simple linear regression to forecast the company’s inventory level for a given level of projected sales. On the basis of rece nt history, the estimated relationship between inventories and sales (in millions of dollars) is as follows: Inventories = $9 $ 0.0875(Sales) Given the estimated sales forecast and the estimated relationship between inventories and sales, what are your forecasts of the company’s year  -end inventory level and its inventory turnover ratio?
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks