Ch12 P10 Build a Model - Chapter 12. Ch 12-10 Build a Model...

Ch12 P10 Build a Model
Download Document
Showing pages : 1 of 1
This preview has blurred sections. Sign up to view the full version! View Full Document
Chapter 12. Ch 12-10 Build a Model a. What are the forecasted levels of notes payable and special dividends? Key Input Data: Used in the forecast Tax rate 40% Dividend growth rate 8% 9% 11% December 31 Income Statements: (in thousands of dollars) Forecasting 2010 2011 2011 2010 basis Ratios Inputs Forecast Sales $455,150 Growth $386,878 % of sales EBITDA $68,273 Depreciation and Amortization $14,565 % of fixed assets EBIT $53,708 Net Interest Expense $11,880 Interest rate x beginning of year debt EBT $41,828 Taxes (40%) $16,731 Net Income $25,097 Common dividends (regular dividends) $12,554 Growth 8.00% Special dividends Addition to retained earnings (DRE) $12,543 December 31 Balance Sheets (in thousands of dollars) Forecasting 2010 2011 2011 2010 basis Ratios Inputs Without AFN AFN Assets: Cash $18,206 % of sales Accounts Receivable $100,133 % of sales Inventories $45,515 % of sales Total current assets $163,854 Fixed assets $182,060 % of sales Total assets
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Create a FREE account now to get started. Log In

The email address you entered is not valid. The email address you provided is already in use.
Your username must be at least 5 characters. Your username must consist of only alphanumeric characters. Your username must contain at least one letter. Your username contains inappropriate language. Another user has already claimed this username.
Your password must be at least 6 characters in length.
{[ $select.selected.label ]} Please select a valid school.
By creating an account you agree to our Privacy Policy, Terms of Use, and Honor Code.
Create my FREE account Processing...
Sign Up with Facebook

We will never post anything without your permission.

Already on Course Hero? Log In