Steps necessary to financially plan and forecast

Task: Prepare a 700 to 1,050 word response for this Mini-case:

You will need to follow all assumptions in the Mini-case precisely and carefully to complete the following:

Q1. Identify the steps necessary to financially plan and forecast for 2005, 2006, and 2007,

Q2. Project future years using the growth rate assumptions in the Mini-case,

Q3. Determine what type and amount of financing may be required, taking into account the impact on leverage ratios,

Q4. Determine the impact of rising interest rates on future performance,

Q5. Assess alternative capital structures and impact on debt ratio and return on equity.

Q6. Separately, after completing (a) through (e) above, explain how outsourcing certain cost of goods sold items would impact this planning and budgeting process.


George Hedderwick finished his customary peanut butter and jelly sandwich, washed it down with a root beer, and turned back to his computer. His morning had been spent developing a financial planning model for Executive Fruit. Now he needed to run out the projections to 2007. In particular, he wanted to check what would happen if the firm continued to expand at 10 percent and relied on new issues of debt to make up any required external financing. Would the standard measures of leverage, such as the debt ratio and the interest cover start to spin out of control? Executive Fruit's bank had stipulated that the company's debt ratio should not exceed 60 percent, and George wanted to see whether there was any risk that this condition would be breached. It might be OK if interest rates stayed at their current level, but it looked as if the Fed could raise rates in the near future. George decided that he would also develop some projections assuming that the interest rate increased from 10 percent to 15 percent.

Although the CEO appeared reluctant to raise new equity, George thought he would take the opportunity to explore other financial strategies. In particular, he was interested to see how things might look if Executive Fruit kept to a constant 40 percent debt ratio. The return on equity might not look so good in this case, but it would certainly keep the company's bankers happy. George wiped the last piece of jelly from the keyboard and settled down to work.

Solution Preview :

Prepared by a verified Expert
Finance Basics: Steps necessary to financially plan and forecast
Reference No:- TGS01802313

Now Priced at $25 (50% Discount)

Recommended (91%)

Rated (4.3/5)

2015 ┬ęTutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.