1. Imagine that you were hired recently as a financial analyst for a relatively
ID: 2718852 • Letter: 1
Question
1. Imagine that you were hired recently as a financial analyst for a relatively new, highly leveraged ski manufacturer located in the foothills of Colorado’s Rocky Mountains. Your firm manufactures only one product, a state-of-the-art snow ski. The company has been operating up to this point without much quantitative knowledge of the business and financial risks it faces.
Ski season just ended, however, so the president of the company has started to focus more on the financial aspects of managing the business. He has set up a meeting for the next week with the CFO, Maria Sanchez, to discuss matters such as the business and the financial risks faced by the company. Accordingly, Maria has asked you to prepare an analysis to assist her in her discussions with the president.
As a first step in your work, you compiled the following information regarding the cost structure of the company:
________________________________________________________
Output level 80,000 units
Operating assets $4,000,000
Operating asset turnover 8 times
Return on operating assets 32%
Degree of operating leverage 6 times
Interest expense $600,000
Tax rate 35%
_______________________________________________________
As the next step, you need to determine the break-even point in units of output for the company. One of your strong points has been that you always prepare supporting work papers, which show how you arrived at your conclusions. You know Maria would like to see these work papers to facilitate her review of your work. Therefore, you will have the information you require to prepare an analytical income statement for the company. You are sure that Maria would also like to see this statement. In addition, you know that you need it to be able to answer the following questions. You also know Maria expects you to prepare, in a format that is presentable to the president, answers to the following questions to serve as a basis for her discussions with the president.
a. What is the firm’s break-even point in sales dollars?
b. If sales should increase by 30% (as the president expects), 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 b.
2. 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 his next meeting with Tom Charles a week from today.
To make the required calculations, you have to 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 b.
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%
Explanation / Answer
a. interest is fixed cost
at break even point: total sales= total cost
total sales = operating asset turnover ratio*operating assets=8*4000000$=3,20,00,000$
total costs= fixed costs + variable costs=600000$+ variable
3,20,00,000=6,00,000+ variable
variable= 3,20,00,000-6,00,000=3,14,00,000
contribution =fixed cost + profit where at break even point there is no profit
contribution = 600000$
contribution pu= 600000/80000=7.5$per unit
break even point=fixed cost / contribution per unit=600000/7.5=80,000$
b. degree of operating leverage=change in EBIT / change in sales
6= change in EBIT/30%
change in EBIT= 6*30%= 180% increase
turnover =3,20,00,000+30%=4,16,00,000$
net income after tax= return*operating assets= 4000000*32%=12,80,000$
EBT=EAT/(1-tax rate)=1280000/(1-0.35)=1969230$
EBIT=1969230+600000=2569230
Changed EBIT = 2569230*180%=46,24,615
EBT=46,24,615-6,00,000/1969230=204%
net income=2616000/1280000=204%
c. return on operating assets= net income after tax / operating assets
Income Statement
EBIT 46,24,615
(- )Int (6,00,000)
EBT 40,24,615
(-) tax 14,08,615
net income =26,16,000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.