π Lecture 19 β Perform Break-Even Analysis Excel Functions Financial Analysis
π Overview: This lecture covers performing break-even analysis and introduces key MS Excel financial functions for depreciation and internal rate of return calculations. It also reviews solving linear equations with two variables, which is fundamental for cost-volume-profit analysis in merchandising mathematics.
ποΈ Topics Covered
The lecture reviews Lecture 18 content, then covers Excel financial functions including SLN (straight-line depreciation), SYD (sum-of-years' digits depreciation), VDB (variable declining balance depreciation), IRR (internal rate of return), and XIRR (internal rate of return for non-periodic cash flows). It also covers solving linear equations with two variables and their applications in break-even analysis.
π Lecture Summary
Perform Break-even Analysis Excel Functions Financial Analysis
SLN
Returns the straight-line depreciation of an asset for one period. Syntax: SLN(cost, salvage, life). Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset). Life is the number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
SYD
Returns the sum-of-years' digits depreciation of an asset for a specified period. Syntax: SYD(cost, salvage, life, per). Per is the period and must use the same units as life. SYD is calculated as follows: SYD = (cost - salvage) * (life - per + 1) * 2 / (life * (life + 1))
π Definition β Sum-of-Years' Digits Depreciation: An accelerated depreciation method where the depreciation amount is higher in the early years of an asset's life and decreases over time.
VDB
Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance. Syntax: VDB(cost, salvage, life, start_period, end_period, factor, no_switch). Start_period is the starting period for which you want to calculate the depreciation. End_period is the ending period for which you want to calculate the depreciation. Factor is the rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). No_switch is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation. If no_switch is TRUE, Excel does not switch to straight-line depreciation even when the depreciation is greater than the declining balance calculation. If no_switch is FALSE or omitted, Excel switches to straight-line depreciation when depreciation is greater than the declining balance calculation. All arguments except no_switch must be positive numbers.
IRR
Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods. Syntax: IRR(values, guess). Values is an array or a reference to cells that contain numbers. Values must contain at least one positive value and one negative value to calculate the internal rate of return. IRR uses the order of values to interpret the order of cash flows. Guess is a number that you guess is close to the result of IRR. Excel uses an iterative technique for calculating IRR. Starting with guess, IRR cycles through the calculation until the result is accurate within 0.00001 percent. If IRR can't find a result that works after 20 tries, the #NUM! error value is returned. In most cases you do not need to provide guess for the IRR calculation. If guess is omitted, it is assumed to be 0.1 (10 percent). If IRR gives the #NUM! error value, or if the result is not close to what you expected, try again with a different value for guess.
π Definition β Internal Rate of Return (IRR): The interest rate that makes the net present value of all cash flows from an investment equal to zero.
π‘ Why this matters: IRR is closely related to NPV, the net present value function. The rate of return calculated by IRR is the interest rate corresponding to a 0 (zero) net present value. The relationship is: NPV(IRR(values), values) = 0.
π IRR Example: In an Excel worksheet, an investment of 70,000 is entered in cell A97 with a minus sign to denote negative cash flow. Revenue per year (years 1 to 5) is entered in cells A98 to A102. In the first formula in cell A103, =IRR(A97:A101), only years 1 to 4 were selected for the revenue stream. The IRR is -2% in this case. In the next formula in cell A105, the entire revenue stream was considered. The IRR improved to 9%. Next, only the first 2 years of revenue stream were considered with an initial guess of 10%. The result was -44%.
XIRR
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function. If this function is not available and returns the #NAME? error, install and load the Analysis ToolPak add-in. Syntax: XIRR(values, dates, guess). Values is a series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. Dates is a schedule of payment dates that corresponds to the cash flow payments. The first payment date indicates the beginning of the schedule of payments. All other dates must be later than this date, but they may occur in any order. Dates should be entered by using the DATE function. Guess is a number that you guess is close to the result of XIRR.
π Definition β XIRR: The internal rate of return for a schedule of cash flows that is not necessarily periodic.
π XIRR Example: An investment is in cell A111. The revenue stream is in cells A112 to A115. The dates for each investment or revenue are given in cells B111 to B115. In cell A116, the formula =XIRR(A111:A115;B111:B115;0.1) is used β range A111:A115 is the cost and revenue stream, range B111:B115 is the stream for dates, and 0.1 is the initial guess for XIRR. The answer is given in cell B116: 37.34%.
Linear Equations
Linear equations have the following applications in Merchandising Mathematics: solving two linear equations with two variables; solving problems that require setting up linear equations with two variables; performing linear Cost-Volume-Profit and break-even analysis employing the contribution margin approach and the algebraic approach of solving the cost and revenue functions.
π Example of Solving Simultaneous Linear Equations:
Equations: 2x β 3y = β6 and x + y = 2
Solve for y:
- Multiply the second equation by 2:
2x + 2y = 4 - Subtract from the first equation:
2x β 3y = β6minus(2x + 2y = 4)givesβ5y = β10 - Therefore,
y = 2
Solve for x by substituting y=2 into the second equation:
x + 2 = 2x = 0
Check your answer by substituting the values into each equation:
- Equation 1: LHS =
2(0) β 3(2) = β6= RHS β - Equation 2: LHS =
0 + 2 = 2= RHS β
β Key Takeaways
The most critical concepts from this lecture include: understanding the three depreciation functions (SLN for straight-line, SYD for sum-of-years' digits, and VDB for variable declining balance) and their syntax requirements; mastering IRR for periodic cash flows and XIRR for non-periodic cash flows, including the guess parameter and iterative calculation process; remembering that IRR is the interest rate that makes NPV equal to zero; and being able to solve simultaneous linear equations through elimination and substitution methods for applications in break-even and cost-volume-profit analysis.
π§ Quick Revision Questions
- What is the syntax for the SLN function, and what does each argument represent?
- How is SYD depreciation calculated mathematically, and why is it considered an accelerated method?
- What is the difference between IRR and XIRR in terms of cash flow timing?
- In the IRR example, why did the IRR change from -2% to 9% when the revenue stream was expanded?
- Solve the following system of linear equations:
3x + 2y = 12andx - y = 1.
π Lecture 20 β Perform Break-Even Analysis Excel Functions for Financial Analysis
π Overview: This lecture introduces the concept of break-even analysis and cost-volume-profit (CVP) analysis, essential tools for business decision-making. It also reviews solving linear equations using substitution and demonstrates how to calculate break-even points in units, sales rupees, and as a percentage of capacity. Understanding these concepts helps managers set prices, prepare bids, and make informed production decisions.
ποΈ Topics Covered
The lecture begins by reviewing linear equations through a practical example of calculating weekly purchases of two commodities after price changes. It then proceeds to define key terminology for break-even analysis, including fixed costs, variable costs, and production capacity. The core of the lecture covers the calculation of break-even point (BEP) in units, sales rupees, and percent of capacity, along with contribution margin and contribution rate. A detailed contribution margin statement is presented with a numerical example, and the lecture concludes with Scenario 1, a break-even analysis problem for a new product.
π Lecture Summary
Review Lecture 18 β Linear Equations
This section reviews solving a system of two linear equations. A practical problem is presented where Zain purchases commodities 1 and 2 weekly. After price increases from Rs. 1.10 to Rs. 1.15 for commodity 1, and from Rs. 0.98 to Rs. 1.14 for commodity 2, the weekly bill rose from Rs. 84.40 to Rs. 91.70. The goal is to find the number of items of each commodity purchased each week.
Let x = number of commodity 1 and y = number of commodity 2. The equations are set up as follows: Equation 1: 1.10x + 0.98y = 84.40 Equation 2: 1.15x + 1.14y = 91.70
To solve by elimination, the lecture first eliminates x by dividing both sides of each equation by the coefficient of x. For equation 1: (1.10x + 0.98y)/1.10 = 84.40/1.10, resulting in x + 0.8909y = 76.73 (3). For equation 2: (1.15x + 1.14y)/1.15 = 91.70/1.15, resulting in x + 0.9913y = 79.74 (4).
Subtracting equation (4) from equation (3) gives: (x + 0.8909y) - (x + 0.9913y) = 76.73 - 79.74 -0.1004y = -3.01 y = 3.01 / 0.1004 = 29.98, approximately 30 items of commodity 2.
π Definition β Substitution: A method to solve equations by replacing a variable with its known value. π Formula: Substituting the value of y into equation (1): 1.10x + 0.98(29.98) = 84.40 π Example: Solving for x: 1.10x + 29.38 = 84.40 β 1.10x = 55.02 β x = 50.02, approximately 50 items of commodity 1. The solution is verified by computing the new weekly cost: (50 Γ 1.15) + (30 Γ 1.14) = 57.50 + 34.20 = Rs. 91.70, matching the given amount.
Terminology β Break Even Analysis
This section defines the core concepts used in break-even analysis. Break Even Analysis is a calculation to determine how much product a company must sell to reach its break-even point, which is the point where no profit is made and no losses are incurred. This analysis shows whether revenue can cover the relevant costs of production. Managers use this for setting prices, preparing bids, and applying for loans.
Cost-Volume-Profit (CVP) analysis expands on break-even analysis by examining how profits and costs change with volume. It considers the effects of changes in variable costs, fixed costs, selling prices, and volume on profits. CVP helps answer questions like: (1) What sales volume is needed to break even? (2) What volume is needed for a desired profit? (3) What profit is expected at a given sales volume? (4) How do changes in price, costs, and output affect profits? π‘ Why this matters: These analyses are fundamental for planning and decision-making in any business.
π Definition β Fixed Costs (FC): Costs that do not change if sales increase or decrease, e.g., rent, property taxes, depreciation. π Definition β Variable Costs (VC): Costs that change in direct proportion to sales volume, e.g., material costs, direct labor. π Definition β Production Capacity (PC): The number of units a firm can make in a given period.
Break Even Point
This section explains how the Break Even Point (BEP) is the point where revenue equals costs, resulting in neither profit nor loss. BEP can be expressed in three ways.
π Definition β BEP in units: The number of units that must be sold to break even. Selling more units yields a profit; fewer units yield a loss. π Formula: BEP in units = Fixed Costs / Contribution Margin per unit
π Definition β BEP in Rs: The revenue that must be obtained to reach the break-even point. π Formula: BEP in Rs = (Fixed Costs Γ Net Sales) / Contribution Margin OR BEP in Rs = (Fixed Costs Γ Selling Price per unit) / Contribution Margin per unit
π Definition β BEP as percent of capacity: The percentage of production capacity utilized to produce the number of units required to break even. π Formula: BEP as % of capacity = (BEP in units Γ 100%) / Production capacity
Contribution Margin
This section defines the Contribution Margin (CM) as the rupees amount found by deducting variable costs from sales or revenues. This amount 'contributes' to meeting fixed costs and making a net profit.
π Formula: Contribution Margin = Net Sales β Variable Cost = S β VC π Formula: Contribution Margin per unit (CM) = Sale price per unit β Variable cost per unit π Formula: Contribution Rate (CR) = (Contribution Margin / Net Sales) Γ 100% = (CM / S) Γ 100%
A Contribution Margin Statement
This section presents the structure of a Contribution Margin Statement, which organizes financial data to show the contribution margin and net income.
Structure of a Contribution Margin Statement:
| Item | Rs. | % |
|---|---|---|
| Net Sales (Price Γ # Units Sold) | x | 100 |
| Less: Variable Costs | x | x |
| Contribution Margin | x | x |
| Less: Fixed Costs | x | x |
| Net Income | x | x |
The net sales are calculated by multiplying price per unit by number of units sold. This figure is treated as 100%. Variable costs are deducted from net sales to obtain the Contribution Margin. Fixed costs are then deducted from the Contribution Margin to yield Net Income. The formula is Net Income = Contribution Margin β Fixed Costs.
Numerical Example of a Contribution Margin Statement:
| Item | Rs. | % |
|---|---|---|
| Net Sales | 462,452 | 100% |
| Less: Variable Costs (Cost of goods sold 230,934 + Sales Commissions 58,852 + Delivery Charges 13,984) | 303,770 | 65.7% |
| Contribution Margin (462,452 β 303,770) | 158,682 | 34.3% |
| Less: Fixed Costs (Advertising 1,850 + Depreciation 13,250 + Insurance 5,400 + Payroll Taxes 8,200 + Rent 9,600 + Utilities 17,801 + Wages 40,000) | 96,101 | 20.8% |
| Net Income (158,682 β 96,101) | 62,581 | 13.5% |
SCENARIO 1
This section introduces a break-even analysis problem for a new product. The problem is presented with all necessary data, and the solution is deferred to the next lecture.
A firm is planning to add a new item. Market research indicates the product can be sold at Rs. 50 per unit. The cost analysis provides:
- Fixed Costs (FC) per period = Rs. 8,640
- Variable Costs (VC) = Rs. 30 per unit
- Production Capacity (PC) per period = 900 units
The formulas to use are: π Formula: Contribution Margin per unit (CM) = S β VC π Formula: Contribution Rate (CR) = CM/S Γ 100% π Formula: BEP in Units = FC / CM π Formula: BEP in Sales Rs. = (FC / CM) Γ S π Formula: BEP in % of Capacity = (BEP in Units / PC) Γ 100%
π© Note: At the break-even point, Net Profit or Loss = 0.
Scenario 1 Summary:
- Selling price per unit (S) = Rs. 50
- Fixed Costs (FC) = Rs. 8,640
- Variable Costs (VC) = Rs. 30 per unit
- Production Capacity (PC) = 900 units
β Key Takeaways
The most critical concepts from this lecture are the ability to solve linear equations using substitution, a method that involves eliminating one variable to find the other. Understanding the definitions and calculations for break-even analysis is essential, including fixed costs, variable costs, and contribution margin. The key formulas to memorize are BEP in units (FC/CM per unit), BEP in rupees ((FC/CM) Γ S), and BEP as a percentage of capacity ((BEP units/PC) Γ 100%). Finally, being able to construct and interpret a Contribution Margin Statement, which shows how sales, variable costs, and fixed costs lead to net income, is a vital skill for business analysis.
π§ Quick Revision Questions
- A product sells for Rs. 80 per unit, with variable costs of Rs. 30 per unit and fixed costs of Rs. 20,000. What is the contribution margin per unit?
- Using the same product from question 1, what is the break-even point in units?
- If the production capacity is 1,000 units, what is the break-even point as a percentage of capacity?
- In a contribution margin statement, what is the formula to calculate net income?
- What three types of break-even points can be calculated for a product?
π Lecture 21 β Perform Linear Cost-Volume Profit and Break-Even Analysis Using the Contribution Margin Approach
π Overview: This lecture focuses on performing linear cost-volume-profit analysis and calculating the break-even point (BEP) using the contribution margin approach. It demonstrates how changes in fixed costs, variable costs, and selling price affect the break-even point, making it essential for business decision-making and profit planning.
ποΈ Topics Covered
The lecture reviews the contribution margin approach from Lecture 18, performs break-even analysis in units, rupees, and as a percentage of capacity, and examines how changes in fixed costs, variable costs, and selling price impact the break-even point through multiple scenarios. It also introduces MS Excel financial functions.
π Lecture Summary
SCENARIO 1
This scenario demonstrates the basic break-even analysis using the contribution margin approach. The contribution margin per unit (CM) is calculated as selling price minus variable cost. The contribution rate (CR) expresses this as a percentage of selling price. The break-even point (BEP) is found in three forms: in units, in rupees, and as a percentage of production capacity.
π Definition β Contribution Margin per unit (CM): Selling price per unit minus variable cost per unit. π Formula: CM = S β VC = Rs. 50 β Rs. 30 = Rs. 20 π Contribution Rate (CR) = (CM/S) Γ 100% = (20/50) Γ 100% = 40% π BEP in Units = FC / CM = Rs. 8640 / Rs. 20 = 432 Units π BEP in Rupees = (FC / CM) Γ S = (8640/20) Γ 50 = Rs. 21,600 π BEP as % of Capacity = (BEP in units / Production Capacity) Γ 100% = (432/900) Γ 100% = 48% π Example: By selling more than 432 units, the firm makes profit.
SCENARIO 2
The Lighting Division plans to introduce a new street light with: FC = Rs. 3136, VC = Rs. 157 per unit, S = Rs. 185 per unit, Production Capacity = 320 units. CM is calculated first, then BEP is found in all three forms.
π CM = S β VC = Rs. 185 β Rs. 157 = Rs. 28 π BEP in Units = FC / CM = 3136 / 28 = 112 Units π BEP in Rupees = (FC / CM) Γ S = (3136/28) Γ 185 = Rs. 20,720 π BEP as % of Capacity = (112/320) Γ 100% = 35% Capacity
SCENARIO 2-1 β Reduced Fixed Costs
FC is reduced to Rs. 2688 while other values remain the same. The BEP decreases because fixed costs are lower.
π CM = S β VC = Rs. 185 β Rs. 157 = Rs. 28 π BEP in Units = FC / CM = Rs. 2688 / Rs. 28 = 96 Units π BEP as % of Capacity = (96/320) Γ 100% = 30% of Capacity π‘ Why this matters: Reducing fixed costs lowers the break-even point, making it easier to achieve profitability.
SCENARIO 2-2 β Increased FC and Reduced VC
FC is increased to Rs. 4588, and VC is reduced to 80% of S (Rs. 148). The new VC is calculated first, then CM, followed by BEP.
π New VC = S Γ 80% = Rs. 185 Γ 0.8 = Rs. 148 π New FC = Rs. 4588 π CM = S β VC = Rs. 185 β Rs. 148 = Rs. 37 π BEP in Units = FC / CM = Rs. 4588 / Rs. 37 = 124 Units π BEP as % of Capacity = (124/320) Γ 100% = 39% of Capacity
SCENARIO 2-3 β Reduced Selling Price
S is reduced to Rs. 171 while FC and VC remain at original values. The CM decreases significantly, raising the BEP.
π CM = S β VC = Rs. 171 β Rs. 157 = Rs. 14 π BEP in Units = FC / CM = Rs. 3136 / Rs. 14 = 224 Units π BEP as % of Capacity = (224/320) Γ 100% = 70% of Capacity π‘ Why this matters: A drop in selling price dramatically increases the break-even point, meaning many more units must be sold just to cover costs.
β Key Takeaways
The break-even point is a critical metric calculated in units, rupees, and as a percentage of production capacity using the contribution margin approach. Changes in fixed costs, variable costs, or selling price directly impact the BEP: reducing fixed costs or variable costs lowers the BEP, while increasing fixed costs or reducing selling price raises the BEP. The contribution margin per unit (CM = S β VC) is the foundation for all BEP calculations. Managers can use this analysis to evaluate pricing strategies, cost control, and capacity utilization.
π§ Quick Revision Questions
- What is the formula for contribution margin per unit and how is it used to find BEP in units?
- In Scenario 1, what is the BEP in rupees if FC = Rs. 8640, S = Rs. 50, and VC = Rs. 30?
- In Scenario 2, if FC are reduced from Rs. 3136 to Rs. 2688, what is the new BEP as a percentage of capacity?
- In Scenario 2-2, how is new VC calculated when it is set to 80% of selling price?
- Why does reducing the selling price to Rs. 171 in Scenario 2-3 cause the BEP to increase to 70% of capacity?
π Lecture 22 β Perform Linear Cost-Volume Profit and Break-Even Analysis
π Overview: This lecture focuses on performing linear cost-volume-profit (CVP) and break-even analysis through various practical scenarios. It teaches how to calculate contribution margin, break-even point (BEP), net income, and net loss, and how to determine the number of units needed to achieve a target profit or loss.
ποΈ Topics Covered
The lecture reviews multiple scenarios for calculating contribution margin and net profit, including break-even point in rupees and as a percentage of capacity. It covers computing net income (profit) when units sold exceed BEP, determining units needed to generate a specific net income, calculating net loss when sales fall below BEP, and finding profit or loss at a given operating capacity percentage. A final case applies these concepts to company-wide data.
π Lecture Summary
SCENARIO 1
This scenario demonstrates a break-even point in rupees of Rs. 21,600, with the break-even point as a percentage of capacity being 48%.
π Definition β Break-Even Point (BEP): The level of sales at which total revenues equal total costs, resulting in zero profit or loss. π Example: BEP in Rs. = Rs. 21,600; BEP as % of capacity = 48%.
SCENARIO 2
The break-even point in rupees is Rs. 20,720, and the break-even point as a percentage of capacity is 35%.
SCENARIO 2-1
The break-even point in rupees is Rs. 17,760, and the break-even point as a percentage of capacity is 30%.
SCENARIO 2-2
The break-even point in rupees is Rs. 22,940, and the break-even point as a percentage of capacity is 39%.
SCENARIO 2-3
The break-even point in rupees is Rs. 38,304, and the break-even point as a percentage of capacity is 70%.
Net Income (NI) or Profit
Net income (NI) is the profit earned from sales made above the break-even point. It is calculated as: Net income = Number of units sold above BEP in units Γ Contribution Margin per unit
π Definition β Contribution Margin (CM): The amount each unit sold contributes toward covering fixed costs and generating profit, calculated as Selling Price per unit minus Variable Cost per unit. π Formula: Net Income (NI) = (Units Sold β BEP units) Γ CM per unit β Profit earned from sales exceeding the break-even quantity.
SCENARIO 2-4
Given: FC = Rs. 3136, VC = Rs. 157, S = Rs. 185, Capacity = 320 units. Determine the Net Income (NI) if 134 units are sold.
Step 1: Find CM per unit S = Rs. 185 per unit VC = Rs. 157 per unit CM = S β VC = 185 β 157 = Rs. 28 per unit
Step 2: Find BEP in units BEP in units = FC / CM = Rs. 3136 / Rs. 28 = 112 Units
Step 3: Find units sold over BEP Units Sold = 134 units BEP in units = 112 units Number of units sold above BEP = 134 β 112 = 22 units
Net Income = 22 units Γ Rs. 28 = Rs. 616 π Example: The company sold 22 units above its break-even point of 112 units, earning Rs. 28 profit on each of those units, for a total net income of Rs. 616.
SCENARIO 2-5
Given: FC = Rs. 3136, VC = Rs. 157, S = Rs. 185, Capacity = 320 units. How many units must be sold to generate NI of Rs. 2000?
Step 1: Find CM per unit S = Rs. 185 per unit, VC = Rs. 157 per unit CM = Rs. 28 per unit
Step 2: Find BEP in units BEP in units = FC / CM = Rs. 3136 / Rs. 28 = 112 Units
Step 3: Find units over BEP needed Number of units above BEP = NI / CM = Rs. 2000 / Rs. 28 = 71 Units
Total units sold = 71 units above BEP + 112 BEP units = 183 units π Example: To earn a net income of Rs. 2000, the company must sell 71 units above its break-even point of 112 units, for a total of 183 units.
Net Loss
Net loss occurs when sales are below the break-even point. Net loss = Number of units sold below BEP in units Γ Contribution Margin per unit
Alternatively, Net loss = β Net Income (when Net Income is negative). Number of units sold below BEP = β Number of units sold above BEP. Thus, Net loss = β Net Income = β (Number of units sold above BEP Γ CM per unit)
SCENARIO 2-6
Given: FC = Rs. 3136, VC = Rs. 157, S = Rs. 185, Capacity = 320 units. Find the number of units sold if there is a Net Loss (NL) of Rs. 336.
Step 1: Find CM per unit S = Rs. 185 per unit, VC = Rs. 157 per unit CM = Rs. 28 per unit
Step 2: Find BEP in units BEP in units = FC / CM = Rs. 3136 / Rs. 28 = 112 Units
Step 3: Find units below BEP Number of units below BEP = NL / CM = Rs. 336 / Rs. 28 per unit = 12 Units
Total Sold Units = BEP in units β Units below BEP = 112 β 12 = 100 units
Alternate Method: Number of units sold above BEP = β Net Loss / CM = β336 / 28 = β12 (negative indicates sales below BEP) Total sold units = BEP in units + Units above BEP = 112 + (β12) = 100 units π‘ Why this matters: When sales fall short of the break-even point, the company incurs a loss. The loss equals the contribution margin lost on each unit not sold relative to BEP.
SCENARIO 2-7
Given: FC = Rs. 3136, VC = Rs. 157 per unit, S = Rs. 185 per unit, Production Capacity = 320 units. The company operates at 85% of its capacity. Find the Profit or Loss.
Step 1: Find CM per unit S = Rs. 185 per unit, VC = Rs. 157 per unit CM = Rs. 28 per unit
Step 2: Find BEP in units BEP in units = FC / CM = Rs. 3136 / Rs. 28 = 112 Units
Step 3: Find units over BEP Units produced = 320 Γ 0.85 = 272 Units BEP in units = 112 units Number of units over BEP = 272 β 112 = 160 Units
Net Income = 160 units Γ Rs. 28 = Rs. 4,480 π Example: Operating at 85% capacity (272 units), the company sells 160 units above its BEP of 112 units, earning a net profit of Rs. 4,480.
CASE: Company Aβs Year-End Results
Given: Total Sales = Rs. 375,000; Operated at 75% of capacity; Total Variable Costs = Rs. 150,000; Total Fixed Costs = Rs. 180,000. What was Company Aβs BEP expressed in rupees of sales?
Step 1: Find Contribution Margin Ratio (CMR) Total Sales = Rs. 375,000 Total Variable Costs = Rs. 150,000 Total Contribution Margin = Sales β Variable Costs = Rs. 375,000 β Rs. 150,000 = Rs. 225,000 CMR = Total Contribution Margin / Total Sales = Rs. 225,000 / Rs. 375,000 = 0.60 (or 60%)
Step 2: Find BEP in rupees BEP in Rs. = Total Fixed Costs / CMR = Rs. 180,000 / 0.60 = Rs. 300,000 π Example: Company A must achieve sales of Rs. 300,000 to break even, meaning it covers all fixed and variable costs. Since its actual sales were Rs. 375,000 (75% of capacity), it operated above BEP and earned a profit. π‘ Why this matters: The contribution margin ratio (CMR) is crucial for calculating the break-even point in sales rupees, especially when per-unit data is not available.
β Key Takeaways
Break-even analysis is a fundamental tool for determining the sales level needed to cover all costs. The contribution margin (Selling Price β Variable Cost per unit) is the core driver: profit increases by the CM for each unit sold above BEP, and loss increases by the CM for each unit sold below BEP. Net income is calculated by multiplying the number of units sold above BEP by the CM per unit, while net loss is calculated using units sold below BEP. To find the units needed for a target profit, divide the target profit by the CM and add the BEP units. When using aggregate data, the contribution margin ratio (Total Contribution Margin / Total Sales) can be used to find the BEP in sales rupees by dividing total fixed costs by the CMR.
π§ Quick Revision Questions
- If a company has fixed costs of Rs. 5,000, a selling price of Rs. 50 per unit, and variable costs of Rs. 30 per unit, what is the break-even point in units?
- How do you calculate net income when the number of units sold exceeds the break-even point?
- If a company sells 80 units, its BEP is 60 units, and the contribution margin per unit is Rs. 15, what is its net income?
- A company has fixed costs of Rs. 10,000 and a contribution margin ratio of 40%. What is its break-even point in sales rupees?
- If a company has a net loss of Rs. 500 and a contribution margin per unit of Rs. 25, how many units is it selling below its break-even point?