Analysis in Excel of financial risks, breakeven point, ratio
Not what you're looking for?
Camping USA Inc. has only been operating for 2 years in the outskirts of Albuquerque, New Mexico, and is a new manufacturer of a top-of-the-line camping tent. You are starting an internship as assistant to the chief financial officer of the company, and the owner and CEO, Tom Charles, has decided that this is the right time to know more about the business and financial risks his company must deal with. For this, the CFO has asked you to prepare an analysis to support him in his next meeting with Tom Charles a week from today. To make the required calculations, you have put together the following data regarding the cost structure of the company:
Output level
120,000 units
Operating assets
$6,000,000
Operating asset turnover
12 times
Return on operating assets
48%
Degree of operating leverage
10 times
Interest expense
$720,000
Tax rate
42%
The CFO has instructed you to first determine the break-even point in units of output for the company. He requires that you prepare supporting documents, which demonstrate how you arrived at your conclusion and can facilitate his review of your work. Accordingly, you are required to have the information needed to prepare an analytical income statement for the company to be presented to the CFO. In a format that is acceptable for a meeting discussion with the CEO, you also need to prepare answers to the following questions:
* a. What is the firm's break-even point in sales dollars?
* b. If sales should increase by 40 percent, by what percentage would EBT (earnings before taxes) and net income increase?
* c. Prepare another income statement, this time to verify the calculations from part d.
Purchase this Solution
Solution Summary
The solution computes the firm's break-even point in sales dollars and analysis effect of change in variables on income, breakeven point along with proof
Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Motivation
This tests some key elements of major motivation theories.
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.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Lean your Process
This quiz will help you understand the basic concepts of Lean.