BREAK-EVEN ANALYSIS An advantage of the contribution margin approach is that we can quickly and easily...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
BREAK-EVEN ANALYSIS An advantage of the contribution margin approach is that we can quickly and easily estimate breakeven sales. Breakeven is simply the amount of sales required to generate a net income of zero; i.e.: to exactly cover total costs (both variable and fixed). Sales above breakeven will generate a profit and sales below breakeven will generate a loss. For example: for 2011, fixed costs were $5,000 and the contribution margin was 43.75% (see table 6). For every dollar sold, fifty-six cents of variable costs are incurred, resulting in a forty-four-cent contribution to fixed costs. Therefore, the $5,000 fixed costs divided by 43.75% results in breakeven sales of $11,428.57. Note that every dollar sold over breakeven will generate forty-four cents of profit and every dollar less than breakeven will generate forty-four cents of loss. Total Fixed Costs / Contribution Margin Percentage = Breakeven Sales $5,000/43.75%= $11,428.57 5. Using Table 7 (Appendix) as a guide, perform a breakeven analysis for 2012 through 2017. Please perform this in the first tab of the Excel document included with this case study. Complete the yellow boxes under Table 7 for "Breakeven Sales" and "Breakeven Analysis". Please use formulas and do not "fat finger" any numbers in the cells. (Excel) 6. What impact did changes in breakeven sales have on company profitability? Table 7. Income Statements-Breakeven Sales Fixed Costs Contribution Margin Breakeven Sales Breskeves Analysis Sales Revenue Variable Costs Contribution Margin Fixed Costs Net Income 2011 $5,000 $ 43.75% $ 11,429 2011 24,000 $ 13,500 $ 10,500 $5,000 $ 5,500.00 2012 16,000 2012 2013 2013 2014 2014 2015 2015 2016 2017 2016 CHIVAMAKS Z MURENING 2017 4 BREAK-EVEN ANALYSIS An advantage of the contribution margin approach is that we can quickly and easily estimate breakeven sales. Breakeven is simply the amount of sales required to generate a net income of zero; i.e.: to exactly cover total costs (both variable and fixed). Sales above breakeven will generate a profit and sales below breakeven will generate a loss. For example: for 2011, fixed costs were $5,000 and the contribution margin was 43.75% (see table 6). For every dollar sold, fifty-six cents of variable costs are incurred, resulting in a forty-four-cent contribution to fixed costs. Therefore, the $5,000 fixed costs divided by 43.75% results in breakeven sales of $11,428.57. Note that every dollar sold over breakeven will generate forty-four cents of profit and every dollar less than breakeven will generate forty-four cents of loss. Total Fixed Costs / Contribution Margin Percentage = Breakeven Sales $5,000/43.75%= $11,428.57 5. Using Table 7 (Appendix) as a guide, perform a breakeven analysis for 2012 through 2017. Please perform this in the first tab of the Excel document included with this case study. Complete the yellow boxes under Table 7 for "Breakeven Sales" and "Breakeven Analysis". Please use formulas and do not "fat finger" any numbers in the cells. (Excel) 6. What impact did changes in breakeven sales have on company profitability? Table 7. Income Statements-Breakeven Sales Fixed Costs Contribution Margin Breakeven Sales Breskeves Analysis Sales Revenue Variable Costs Contribution Margin Fixed Costs Net Income 2011 $5,000 $ 43.75% $ 11,429 2011 24,000 $ 13,500 $ 10,500 $5,000 $ 5,500.00 2012 16,000 2012 2013 2013 2014 2014 2015 2015 2016 2017 2016 CHIVAMAKS Z MURENING 2017 4
Expert Answer:
Answer rating: 100% (QA)
Here are the detailed workings for the breakeven analysis 2012 Fixed costs from Table 7 65000 C... View the full answer
Related Book For
Corporate Finance
ISBN: 978-0077861759
10th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe
Posted Date:
Students also viewed these accounting questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
One joule of work is done on a system, raising its temperature by one degree centigrade. Can this increase in temperature be harnessed to do one joule of work? Explain.
-
CTT Inc. reported the following business activities during 2019: a. Purchased property, plant, and equipment for cash b. Purchased merchandise inventory for cash c. Recorded depreciation on property,...
-
On August 3, 2019, the date of incorporation, Quinn Company accepts separate subscriptions for 1,000 shares of $100 par preferred stock at $104 per share and 9,000 shares of no-par, no-stated-value...
-
Refer to the information in QS 13-4. Use that information for Tide Corporation to determine the 2016 and 2017 common-size percents for cost of goods sold using net sales as the base. Data From QS...
-
You hold an auction on eBay and expect two bidders to show up. You estimate that each bidder has a value of either $5 or $8 for the item, and you attach probabilities to each value of 50%. Your own...
-
What should you do if you are on the coast and hear a tsunami siren?
-
Aijla suggested her company that they should consider financial statement analysis to identify potential fraud by comparing changes in items between different financial periods. What kind of analysis...
-
For the polynomial, determine its standard form, degree, coefficients, leading coefficient, and terms. 4x + x^(2) - 6
-
Find the derivative of the following function. list y=(ln|x+8|)^(7) (dy)/(dv)
-
Assume that you had total assets = $ 5 0 0 , total liabilites equal to $ 3 0 0 , and stockholders' equity to $ 2 0 0 . If total assets increased by 1 0 0 % and stockholders equity increased by 5 0 %...
-
Marie is thinking of two numbers. When she adds, she gets 40. When she multiplies them, she gets 351. She Helps her younger sister, Enya, calculate the numbers.
-
For the tax year 2 0 2 3 / 2 4 Keith has net income of 1 1 2 6 7 5 and paid 8 1 5 to charity under the gift aid scheme. What will be his personal allowance for the year? Enter a whole number, without...
-
For given the function f(r) using the Horner algorithm. 3r + 2r" -1 calculate the Taylor series expansion at r= 1
-
Solve each equation. x 3 - 6x 2 = -8x
-
Use the BlackScholes model for pricing a call, putcall parity, and the previous question to show that the BlackScholes model for directly pricing a put can be written as follows: P = E e Rt N(d 2 )...
-
Ted and Alice Hansel have a son who will begin college 10 years from today. School expenses of $30,000 will need to be paid at the beginning of each of the four years that their son plans to attend...
-
The Green Hills Co. has just gone public. Under a firm commitment agreement, Green Hills received $26.04 for each of the 7 million shares sold. The initial offering price was $28 per share, and the...
-
Xenon oscillations are a phenomenon at higher levels of power where xenon-135 loss due to neutron capture is dominant. For example, in a typical large thermal environment, if Xe-135 burnup is 10...
-
Explain the plant states considered for safety analysis and the advantages of new states.
-
Explain the relative criteria that can provide relative safety in nuclear reactors.
Study smarter with the SolutionInn App