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.
Your tutorial is in Excel, attached. I have presumed three levels for sales based on the range over the past five years ...
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.