Please see attached spreadsheet.
Zieber Corporation's 2010 financial statements are shown below. Forecast Zeiber's 2011 income statement and balance sheets. Use the following assumptions: (1) Sales grow by 6%. (2) The ratios of expenses to sales, depreciation to fixed assets, cash to sales, accounts receivable to sales, and inventories to sales will be the same in 2011 as in 2010. (3) Zeiber will not issue any new stock or new long-term bonds. (4) The interest rate is 9% for short-term debt and 11% for long-term debt. (5) No interest is earned on cash. (6) Dividends grow at an 8% rate. (6) Calculate the additional funds needed (AFN). If new financing is required, assume it will be raised as notes payable. Assume that any new notes payable will be borrowed on the last day of the year, so there will be no additional interest expense for the new notes payable. If surplus funds are available, pay a special dividend.
The solution explains how to calculate the additional funds needed
Oats 'R' Us: growth rate, debt equity ratio, full capacity, external financing
Growing Pains - External Financing
Case 4 Growing Pains
"We must plan for the future," said Vicky. "I think we've been
playing it by ear for too long." Mason immediately called the treasurer,
Jim Moroney. "Jim, I need to know how much additional funding we are
going to need for the next year," said Mason. "The growth rate of
revenues should be between 25% and 40%. I would really appreciate if
you can have the forecast on my desk by early next week."
Jim knew that his fishing plans for the weekend had better be put
aside since it was going to be a long and busy weekend for him. He
immediately asked the accounting department to give him the last three
years' financial statements (see Tables 1 and 2) and got right to work!
I attached the financial statements.
Need to see and understand each calculation and show all work
2. If Oats 'R' Us is operating its fixed assets at full capacity,
what growth rate can it support without the need for any
additional external financing?
3. Oats 'R' Us has a flexible credit line with the Midway Bank.
If Mason decides to keep the debt-equity ratio constant, up to
what rate of growth in revenue can the firm support? What
assumptions are necessary when calculating this rate of
growth? Are these assumptions realistic in the case of Oats
'R' Us? Please explain.
4. Initially Jim assumes that the firm is operating at full
capacity. How much additional financing will it need to
support revenue growth rates ranging from 25% to 40% per
5. After conducting an interview with the production manager,
Jim realizes that Oats 'R' Us is operating its plant at 90%
capacity, how much additional financing will it need to
support growth rates ranging from 25% to 40%?
6. What are some actions that Mason can take in order to
alleviate some of the need for external financing? Analyze
the feasibility and implications of each suggested action.
7. How critical is the financial condition of Oats 'R' Us? Is
Vicky justified in being concerned about the need for
financial planning? Explain why.
8. Given that Mason prefers not to deviate from the firm's 2004
debt-equity ratio, what will the firm's pro-forma income
statement and balance sheet look like under the scenario of
40% growth in revenue for 2005 (ignore feedback effects).