Purchase Solution

Sirius XM Flexible budgeting

Not what you're looking for?

Ask Custom Question

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 for Sirius XM


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.

You are encouraged to use Excel or other compatible spreadsheet when computations are involved.

Income statements at three levels, flexible budgeting mean to estimate the likely scenario, the low end, and the high end. How fast did revenues grow in the past? Can the same be expected for the future? Why or why not? Did costs grow at the same rate as revenues in past years? Once you have the middle income statement, make assumptions as to worst and best case scenarios. Five, ten percent up or down?

Purchase this Solution

Solution Summary

I have created a flexible budget for three levels (see excel attached), separating the operations into three divisions and showing common costs separately. The growth and variable costs assumptions are noted on each line.

Solution Preview

What is the growth rate in sales for the past three years?

Growth rate was quite strong, an average of 22.5% over the three years ended 2011 (see excel for this). This reflects growing interest in commercial-free radio and the installation of satelite radio in new cars for six months free to get customers addicted to the service. Sales of new cars, however, is not strong right now and as customers replace their old cars, they will not be new subscribers anymore (transfer from old car ...

Solution provided by:
  • 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
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

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.