Purchase Solution

Preparing a Flexible budget: Home Depot

Not what you're looking for?

Ask Custom Question

Prepare a flexible budget for next year for the company of your choice. The budget needs to be realistic and based on corporate and economic trends.

Set up the flexible budget at three levels for the income statement. Companies prepare budgets based on absorption and/or variable costing. Due to lack of information, we're limiting our budgeting to the absorption approach. You still need to estimate cost behavior based on trends.

Information to consider in determining the three levels.

What is the growth rate in sales for the past three years?
What is the current growth rate in the economy?
How are the competitiors doing?
Current interest rates and tax burdens.

Purchase this Solution

Solution Summary

Your tutorial is in Excel, attached. I have presumed three levels for sales based on the range over the past five years and expected economic recovery next year. COGS and operating costs are tied to a percent of sales and depreciation is presumed fixed. Interest rates are based on studying interest-bearing debt and average interest rates. Taxes are based on an effective tax rate on operating income in the latest year. Notes about these assumptions are on the spreadsheet tab for you.

Solution Preview

Your tutorial is in Excel, attached. I have presumed three levels for sales based on the range over the past five years ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.