Assessment Brief

1. The term “spontaneously generated funds” generally refers to increases in the cash account that result from growth in sales, assuming the firm is operating with a positive profit margin. a. True b. False 2. The most critical step in constructing a set of pro forma financial statements is the sales forecast. a. True b. False 3. If your sales this year were $37,250,000 and you were forecasting 17 percent growth for next year, then your next year’s sales would be $54,250,000. a. True b. False 4. If ratios computed on forecasted “pro forma” financial statements are out of acceptable tolerances, it is an indication that the forecast is faulty and must be redone. a. True b. False 5. Consider the following financial data: Year Sales 2005 $3,892 2006 3,904 2007 6,094 2008 6,337 2009 5,075 The company’s average annual sales growth rate from 2005 through 2009 was: a. 10.1% b. 30.4% c. 6.9% d. 5.5% 6. Assume that your firm wants its Inventory Turnover ratio next year to be 7x. Cost of goods Sold is forecasted to be $6,992. What will the forecasted inventory balance have to be to achieve a Turnover ratio of 7x? a. $999 b. $6,985 c. $48,944 d. Can’t tell without further information 7. Kenney Corporation recently reported the following income statement for 2009 (numbers are in millions of dollars): 2010 Sales $7,000 x 1.10 = $7,700 Total operating costs 3,000 x 1.10 = 3,300 EBIT 4,000 4,400 Interest 200 200 Earnings before tax (EBT) 3,800 4,200 Taxes (40%) 1,520 1,680 Net income $2,280 $2,520 Dividends (50%) 1,260 Addition to retained earnings $1,260 The company forecasts that its sales will increase by 10 percent in 2010 and its operating costs will increase in proportion to sales. The company’s interest expense is expected to remain at $200 million, and the tax rate will remain at 40 percent. The company plans to pay out 50 percent of its net income as dividends, the other 50 percent will be additions to retained earnings. What is the forecasted addition to retained earnings for 2010? a. $1,140 b. $1,260 c. $1,440 d. $1,790 e. $1,810 8. If you constructed a set of pro forma financial statements for 2010 and found that projected Total Assets exceeded projected Total Liabilities and Equity by $11,250, you would know that: a. your forecasting method is inaccurate b. your forecasting assumptions or calculations must be in error, because projected Assets and projected Liabilities and Equity must always balance c. you must arrange for $11,250 in additional financing d. your firm will have $11,250 of excess funds available in 2010 9. Consider the following condensed Income Statement: 2009 2010 Sales $8,000,000 x 1.15 = $9,200,000 COGS 6,500,000 x 1.15 = 7,475,000 Gross Profit 1,500,000 $1,725,000 Sales growth in 2010 is expected to be 15% If COGS is assumed to vary directly with sales, then Gross Profit for 2010 will be: a. $7,475,000 b. $1,725,000 c. $1,200,000 d. $1,500,000 10. Jill’s Wigs Inc. had the following balance sheet last year: Forecast this year Cash $ 800 x 2 = $1,600 Accounts receivable 450 x 2 = 900 Inventory 950 x 2 = 1,900 Net fixed assets 34,000 34,000 Total assets $36,200 $38,400 Accounts payable $ 350 x 2 = $ 700 Accrued wages 150 x 2 = 300 Notes payable 2,000 2,000 Mortgage 26,500 26,500 Common stock 3,200 3,200 Retained earnings 4,000 + $1,000 = 5,000 Total liabilities & equity $36,200 $37,700 AFN = $38,400 – $37,700 = $700 Jill has just invented a non-slip wig for men which she expects will cause sales to double from $10,000 to $20,000, increasing net income to $1,000. On Jill’s balance sheet the cash, accounts receivable, and inventory accounts, and the accounts payable and accrued wages accounts all vary directly with sales (that is, when sales changes these accounts change by the same percentage). Jill also feels that she can handle the increase in sales without adding any fixed assets. (1) Will Jill need any outside capital if she pays no dividends? (2) If so, how much? a. No; zero b. Yes; $7,700 c. Yes; $1,700 d. Yes; $700 e. No; there will be a $700 surplus.