MTH302 — Midterm Summary (Lectures 1–22)

📘 Lecture 1 — COURSE OVERVIEW

📖 Overview: This first lecture introduces the entire MTH 302 course—its purpose, structure, modules, evaluation, and expected outcomes. It serves as a roadmap for students, explaining what topics will be covered across 45 lectures, how grades are calculated, and what resources are needed, with a strong emphasis on using Microsoft Excel for business problem-solving.

🗂️ Topics Covered

This lecture covers the course title and instructor background, the overall objective of applying mathematics to business decisions, eight course modules spanning basic mathematics, algebra, ratio and proportion, merchandising, break-even analysis, statistics, probability, and linear programming, as well as the marking scheme, required resources (including Excel), evaluation criteria, and detailed topic breakdowns for all 45 lectures.

📝 Lecture Summary

COURSE TITLE

The title of this course is “BUSINESS MATHEMATICS AND STATISTICS”. The instructor is Dr. Zahir Fikri, who holds a Ph.D. in Electric Power Systems Engineering from the Royal Institute of Technology, Stockholm, Sweden. His thesis title was “Statistical Load Forecasting for Distribution Network Planning.”

Objective

The purpose of the course is to provide the student with a mathematical basis for personal and business financial decisions through eight instructional modules. The course stresses business applications using arithmetic, algebra, ratio-proportion, and graphing. Applications include payroll, cost-volume-profit analysis, and merchandising mathematics. The course also includes Statistical Representation of Data, Correlation, Time Series and Exponential Smoothing, Elementary Probability, and Probability Distributions. This course stresses logical reasoning and problem solving skills. Access to Microsoft Excel software is required for the course.

Course Outcomes

Successful completion of this course will enable the student to:

1. Apply arithmetic and algebraic skills to everyday business problems.
2. Use ratio, proportion and percent in the solution of business problems.
3. Solve business problems involving commercial discount, markup and markdown.
4. Solve systems of linear equations graphically and algebraically and apply to cost volume-profit analysis.
5. Apply Statistical Representation of Data, Correlation, Time Series and Exponential Smoothing methods in business decision making
6. Use elementary probability theory and knowledge about probability distributions in developing profitable business strategies.

COURSE MODULES

The following are the main eight modules of this course:

• Module 1 (Lectures 1-6): Applications of Basic Mathematics – Overview, arithmetic operations, fractions/percent/base, gross earnings, averages, commission, brokerage, discount, simple and compound interest, average due date.
• Module 2 (Lectures 7-11): Applications of Basic Algebra & Ratio – Exponents and radicals, linear equations, rearranging formulas, compounding percent changes, investment returns, matrices, ratios, proportions, prorata allocation.
• Module 3 (Lectures 12-16): Merchandising and Financial Mathematics – Trade discounts, equivalent single discount rates, markup and markdown, financial mathematics parts 1-3.
• Module 4 (Lectures 17-22): Break-Even Analysis – Graphing linear equations, solving two linear equations, cost-volume-profit analysis, break-even charts, algebraic approach, contribution margin, Microsoft Excel applications.
• Module 5 (Lectures 23-27): Statistical Representation of Data – Statistical data, measures of central tendency (parts 1 & 2), measures of dispersion and skewness (parts 1 & 2).
• Module 6 (Lectures 28-33): Correlation, Time Series and Exponential Smoothing – Correlation (parts 1 & 2), line fitting (parts 1 & 2), time series and exponential smoothing (parts 1 & 2).
• Module 7 (Lectures 34-40): Elementary Probability – Factorials, permutations and combinations, elementary probability (parts 1 & 2), binomial, Poisson, and normal distributions (parts 1-4).
• Module 8 (Lectures 41-45): Probability Distributions & Linear Programming – Estimating from samples (inference parts 1 & 2), hypothesis testing (Chi-Square distribution parts 1 & 2), production planning (linear programming).

MARKING SCHEME

As per VU Rules, the grading breakdown is:

• Mid Term Exam: 35%
• Final Exam: 50%
• 4 Assignments: 15% Note: The course modules are subject to change.

DESCRIPTION OF TOPICS

The document provides a detailed table mapping all 45 lectures to their main module, lecture topics, and recommended reading references. Key highlights include:

• Module 1 covers basic mathematics (Lectures 1-6)
• Module 2 covers basic algebra (Lectures 7-9) and ratio/proportion (Lectures 10-11)
• Module 3 covers merchandising/finance (Lectures 12-16)
• Module 4 covers break-even analysis (Lectures 17-22) with an assignment and mid-term examination
• Module 5 covers statistics (Lectures 23-27)
• Module 6 covers correlation/time series (Lectures 28-33) with an assignment
• Module 7 covers probability (Lectures 34-40)
• Module 8 covers inference, hypothesis testing, and linear programming (Lectures 41-45) with an assignment and end-term examination

Methodology

There will be 45 lectures each of 50 minutes duration as indicated above. The lectures will be delivered in a mixture of Urdu and English. The lectures will be heavily supported by slide presentations. The slides for a lecture will be made available on the VU website for the course a few days before the actual lecture is televised. This will allow students to carry out preparatory reading before the lecture. The course will be provided its own page on the VU’s web site, which will be used to provide lecture and other supporting material. The page will have a link to a web-based discussion and bulletin board for the students. Teaching assistants will be assigned by VU to provide various forms of assistance such as grading, answering questions posted by students and preparation of slides.

Text and Reference Material

The course is based on material from different sources. The following material will be used by the students as reference:

• Reference 1: Course Outline
• Reference 2: Instructor’s Power Point Slides
• Reference 3: Business Mathematics & Statistics by Prof. Miraj Din Mirza
• Reference 4: Elements of statistics & Probability by Shahid Jamal
• Reference 5: Quantitative Approaches in Business studies by Clare Morris
• Reference 6: Microsoft Excel Help File

⭐ Key Takeaways

This lecture lays the foundation for the entire course. Students must understand that MTH 302 is divided into eight modules spanning 45 lectures, covering basic math through to advanced topics like linear programming and hypothesis testing. The course places heavy emphasis on Microsoft Excel as a required tool for nearly every topic. The grading scheme is critical: the mid-term exam is worth 35%, the final exam is worth 50%, and four assignments contribute 15%. Students should note that lectures mix Urdu and English with heavy slide support, and all materials are available online. Finally, the course is designed to be accessible to students with no prerequisite mathematical skills, with Excel proficiency being an advantage but not a requirement.

🧠 Quick Revision Questions

1. What are the three components of the grading scheme for MTH 302, and what percentage does each contribute to the final grade?
2. Name at least three of the eight course modules listed in this lecture.
3. Which software application is mandatory for the successful completion of this course?
4. How many lectures are there in the entire course, and what is the duration of each lecture?
5. What is the main objective of the course "Business Mathematics and Statistics"?

📘 Lecture 2 — Applications of Basic Mathematics

Part 1

📖 Overview: This lecture introduces the foundational arithmetic operations essential for business mathematics and statistics, and demonstrates how to perform these operations using Microsoft Excel. It covers the five basic arithmetic operations and provides step-by-step guidance on starting Excel and using formulas for addition, subtraction, multiplication, division, percentages, and exponentiation.

🗂️ Topics Covered

The lecture begins by outlining the eight course modules (Mathematics Modules 1-4 and Statistics Modules 5-8). It then explains the five basic arithmetic operations: addition, subtraction, multiplication, division, and exponents. The core of the lecture focuses on starting Microsoft Excel 2000 XP, understanding the Excel interface (workbooks, sheets, cells, ranges), entering and editing data, and using Excel formulas with arithmetic operators (+, -, *, /, %, ^) to perform calculations. Detailed examples show how to write formulas for each operation, including using the SUM function and cell references.

📝 Lecture Summary

COURSE MODULES

This course is divided into 8 modules. Modules 1-4 cover Mathematics, and Modules 5-8 cover Statistics. Details of these modules are provided in the lecture 01 handout.

BASIC ARITHMETIC OPERATIONS

Five arithmetic operations form the foundation for all mathematical operations. These are: addition, subtraction, multiplication, division, and exponents.

📌 Example - Addition: 12 + 5 = 17
📌 Example - Subtraction: 12 - 5 = 7
📌 Example - Multiplication: 12 x 5 = 60
📌 Example - Exponent: (4)^2 = 16; (4)^1/2 = 2; (4)^-1/2 = 1/(4)^1/2 = 1/2 = 0.5

MICROSOFT EXCEL IN BUSINESS MATHEMATICS & STATISTICS

Microsoft Excel is a spreadsheet software widely used in business mathematics and statistical applications. This course is based on EXCEL 2002 XP, though earlier versions like EXCEL 2000 or EXCEL 97 can also be used for the intended applications.

Starting EXCEL 2000 XP
To start Excel, click Start on your computer, then click All Programs, then click Microsoft Excel.

The Excel window opens showing a blank workbook (by default named book1) with three sheets: Sheet1, Sheet2, and Sheet3. The Excel Window has column numbers starting from A and row numbers starting from 1. The intersection of a row and column is called a Cell. The first cell is A1, which is the intersection of column A and row 1. All cells in a Sheet are referenced by a combination of Column name and row number.

📌 Example 1: B15 means the cell in column B and row 15.
📌 Example 2: A cell in row 12 and column C has reference C12.

A Range defines all cells starting from the leftmost corner where the range starts to the rightmost corner in the last row. The range is specified by the starting cell, a colon, and the ending cell.

📌 Example 3: A Range starting from A1 and ending at D15 is referenced by A1:D15 and includes all cells in columns A to D up to and including row 15.

A value can be entered into a cell by clicking that cell. The mouse pointer moves to the selected cell. Simply enter the value followed by the Enter key. The mouse pointer moves to the cell below. If you make a mistake, select the cell again and enter the new value. To change only specific digits, double-click the cell to see the blinking cursor, then use arrow keys to move to the digit and edit it.

💡 Why this matters: Understanding cell references, ranges, and data entry is fundamental before performing any calculations in Excel.

About Calculation Operators in Excel
In Excel, there are four different types of operators: Arithmetic operators, Comparison operators, Text concatenation operator, and Reference operators. This lecture focuses on arithmetic operators. The Excel arithmetic operators are:

🔑 Definition — Arithmetic Operators:

• Addition: Symbol: + (Example: =5+4 Result: 9)
• Subtraction: Symbol: - (Example: =5-4 Result: 1)
• Multiplication: Symbol: * (Example: =5*4 Result: 20)
• Division: Symbol: / (Example: =12/4 Result: 3)
• Percent: Symbol: % (Example: =20% Result: 0.2)
• Exponentiation: Symbol: ^ (Example: =5^2 Result: 25)

Excel Formulas for Addition
All calculations in Excel are made through formulas written in cells where the result is required. To add two numbers (e.g., 10 and 5):

1. Open a blank worksheet.
2. Enter 10 in cell A15.
3. Enter 5 in cell B15.
4. Click cell where you want the sum (e.g., C15).
5. Start the formula by writing = in cell C15.
6. Write ( in cell C15.
7. Click on cell A15 (the formula shows A15).
8. Write + in cell C15.
9. Click on cell B15 (the formula shows B15).
10. Write ) in cell C15.
11. Press Enter. The answer 15 is shown in cell C15. The formula displayed in the formula bar is =A15+B15.

To add six numbers (5, 10, 15, 20, 30, 40) entered in cells A34:F34, you can write the formula: =5+10+15+20+30+40 in cell G34 to get 120. Alternatively, you can use the SUM function: enter =SUM(A34:F34) to get the same result.

Excel Formula for Subtraction
Subtraction formulas are similar to addition but use the minus sign. To subtract 15 from 25:

• Enter 25 in cell A50 and 15 in cell B50.
• In cell C50, write the formula: =A50-B50.
• The answer is 10. The order of entries matters (A50-B50 gives a positive result; B50-A50 gives -10).

📐 Formula: =A50-B50 → subtracts the value in B50 from the value in A50.

Excel Formula for Multiplication
Multiplication uses the * operator. To multiply 25 by 15:

• Enter 25 in cell A50 and 15 in cell B50 (using row 60 as shown in slides, though text mentions row 50).
• In cell C50, write the formula: =A50*B50.
• The answer is 375.

📐 Formula: =A50*B50 → multiplies the value in A50 by the value in B50.

Excel Formula for Division
Division uses the / operator. To divide 240 by 15:

• Enter 240 in cell A75 and 15 in cell B75.
• In cell C75, write the formula: =A75/B75.
• The answer is 16.

📐 Formula: =A75/B75 → divides the value in A75 by the value in B75.

Excel Formula for Percent
The percent operator % converts a percentage to its decimal fraction. To convert 20%:

• Enter 20 in cell A99.
• In cell B99, write: =A99%.
• The answer is 0.2.

📐 Formula: =A99% → divides the value in A99 by 100 to convert from percent to decimal.

Excel Formula for Exponentiation
Exponentiation uses the ^ operator (carat). To calculate 16 raised to the power 2:

• Enter 16 in cell A85 and 2 in cell B85.
• In cell C85, write the formula: =A85^B85.
• The answer is 256.

📐 Formula: =A85^B85 → raises the value in A85 to the power indicated by the value in B85.

⭐ Key Takeaways

The five basic arithmetic operations—addition, subtraction, multiplication, division, and exponents—are the foundation for all business mathematics and statistical calculations. Excel is a powerful tool for performing these operations, and understanding its interface (cells, ranges, and formulas) is essential for efficient computation. All Excel formulas must start with an = sign, and cell references (like A15 or B50) are used to perform calculations dynamically. Each arithmetic operation has a specific operator: + for addition, - for subtraction, * for multiplication, / for division, ^ for exponentiation, and % for percentage conversion. Mastering Excel formulas for these operations is critical for solving real-world business problems efficiently.

🧠 Quick Revision Questions

1. What are the five basic arithmetic operations that provide the foundation for all mathematical operations?
2. What is the symbol for exponentiation in Excel, and what is the result of =5^2?
3. Describe the steps to add two numbers (like 10 and 5) using cell references in an Excel formula.
4. Explain how a Range is defined in Excel. What does the reference A1:D15 mean?
5. What is the difference between using =A50-B50 and =B50-A50 in Excel when A50 is 25 and B50 is 15? What are the results?

📘 Lecture 3 — Applications of Basic Mathematics Part 2

📖 Overview: This lecture covers the evaluation criteria and grading structure for the course, then dives into the practical mathematics of calculating gross earnings for employees. It explains the components of salary, taxation rules on allowances, and various costs borne by the company, including provident fund, gratuity fund, leaves, and social charges, concluding with a refresher on fractions, decimals, and percentages. Understanding these calculations is critical for business payroll and cost management.

🗂️ Topics Covered

The lecture begins with the course's evaluation criteria, grading breakdown, and methodology. It then introduces types of employees and defines gross earnings, focusing on the structure of allowances and the rule that only the portion above 50% of basic salary is taxable. The topics cover provident trust fund contributions (1/11th of basic salary by employee and employer), gratuity fund contributions (1/11th of basic salary by employer), costing of leaves (casual, earned, sick), and the calculation of total social charges as a percentage of gross salary. The lecture concludes with a review of converting fractions to percents and vice versa, and the formula for calculating a percentage.

📝 Lecture Summary

Evaluation

To pass this course, you must meet four criteria: full participation is expected, all assignments must be completed by the closing date, the overall grade will be based on VU’s existing Grading Rules, and all requirements must be met. The grading structure consists of a Mid Term Exam (35%), a Final Exam (50%), and 4 Assignments (15%). You are encouraged to collaborate with other students but must prepare your own original submissions, as copying will negatively impact your studies.

Types of Employees

There are three types of employees in a company: Regular employees drawing a monthly salary, Part time employees paid on an hourly basis, and employees with Payments on a per piece basis.

GROSS EARNINGS/SALARY

Gross salary includes Basic salary and Allowances. Allowances may include House Rent, Conveyance allowance, and Utilities allowance. According to taxation rules, if allowances are 50% of the basic salary, the amount is treated as tax free. Any allowances that exceed this amount are considered taxable for both the employee and the company.

🔑 Definition — Taxable Allowances: The portion of allowances that exceeds 50% of the basic salary. This amount is added back to the employee's taxable income and to the company's income. 📐 Formula: Total Taxable Income = Basic Salary + (Total Allowances - 0.5 × Basic Salary) 📌 Example 1: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. % Allowances = (5000/10000) × 100 = 50%. Since allowances are exactly 50%, they are not taxable. Total taxable income = 10,000 Rs. Add back to the income of the company = 0. 📌 Example 2: Basic salary = 10,000 Rs., Allowances = 7,000 Rs. % Allowances = (7000/10000) × 100 = 70%. Allowed non-taxable allowances = 50% = 0.5 × 10000 = 5,000 Rs. Taxable allowances = 70% – 50% = 7000 - 5000 = 2,000 Rs. Hence, 2,000 Rs. of allowances are taxable. Total taxable income = 10,000 + 2000 = 12,000 Rs. Add back to the income of the company = 2,000 Rs.

Structure of Allowances

The common structure of allowances is: House Rent = 45%, Conveyance allowance = 2.5%, Utilities allowance = 2.5%. 📌 Example 3: Basic salary = 10,000 Rs. House rent allowances = 0.45 × 10000 = 4,500 Rs. Conveyance allowance = 0.025 × 10000 = 250 Rs. Utilities allowance = 0.025 × 10000 = 250 Rs. Thus total allowances are 4500+250+250 = 5,000 Rs.

Provident Fund

A company can establish a Provident Trust Fund for the benefit of employees. By law, 1/11th of Basic Salary per month is deducted from the employee’s gross earnings. An equal amount (1/11th of basic salary per month) is contributed by the company to the Provident Fund for the employee. Interest earned on investments is credited to the employees' accounts. 📌 Example 4: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Employee contribution to Provident Fund = 1/11 × 10000 = 909.1 Rs. Company contribution to Provident Fund = 1/11 × 10000 = 909.1 Rs. Total savings of employee in Provident Fund = 909.1 + 909.1 = 1,818.2 Rs.

Gratuity Fund

A company can establish a Gratuity Trust Fund for employees. By law, 1/11th of Basic Salary per month is contributed only by the company to the Gratuity Fund for the employee. Interest earned on investments is credited to the employees' accounts. 📌 Example 5: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Company contribution to Gratuity Fund = Total savings of employee = 1/11 × 10000 = 909.1 Rs.

Leaves

Typical leaves allowed may be: Casual Leave = 18 Days per year, Earned Leave = 18 Days per year, Sick Leave = 12 Days per year. 📌 Example 6: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Normal working days per month = 22. Gross salary = 10000 + 5000 = 15,000 Rs. Cost of casual leaves per year = {18 / (22 × 12)} × 15000 × 12 = 12,272.7 Rs. Cost of earned leaves per year = {18 / (22 × 12)} × 15000 × 12 = 12,272.7 Rs. Cost of Sick leaves per year = {12 / (22 × 12)} × 15000 × 12 = 8,181.8 Rs. Total cost of leaves per year = 12272.7 + 12272.7 + 8181.8 = 32,727.3 Rs. Total cost of leaves as percent of gross salary = (32727.3 / (12 × 15000)) × 100 = 18.2%

Social Charges

Social charges comprise leaves, group insurance, and medical. Typical medical/group insurance is about 5% of gross salary. Other social benefits may be about 5.8%. Leaves are 18.2% of gross salary. Therefore, total social charges = 18.2 + 5 + 5.8 = 29% of gross salary. 📌 Example 7: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Gross Salary = 15,000 Rs. Leaves cost = 0.182 × 15000 = 2,730 Rs. Group insurance/medical = 0.05 × 15000 = 750 Rs. Other social benefits = 0.058 × 15000 = 870 Rs. Total social charges = 2730 + 750 + 870 = 4,350 Rs.

SUMMARY of Salary Components

Different components of salary are summarized as:

• Basic salary
• Allowances: 50% of basic salary
• Gratuity: 9.09% of basic salary
• Provident Fund: 9.09% of basic salary
• Social Charges: 29% of gross salary

Gross remuneration includes: 1. Basic Salary, 2. House rent allowance, 3. Conveyance allowance, 4. Utilities, 5. Provident fund, 6. Gratuity fund, 7. Leaves, 8. Group insurance, 9. Miscellaneous social charges. 💡 Why this matters: Calculating total gross remuneration is essential for determining the true cost of an employee to the company.

Converting fraction to percent

To calculate a percent, multiply the fraction by 100 and put the percent sign (%). 📐 Formula: Percent = Fraction × 100 📌 Example 9: Convert 0.1 to percent. 0.1 × 100 = 10%

Common fraction: A fraction having an integer as a numerator and an integer as a denominator (e.g., ½, 10/100). Convert percent into Common Fraction: 📌 Example 11: 20% = 20/100 = 0.2

Decimal fraction: Any number written in the form: an integer followed by a decimal point followed by a string of digits (e.g., 2.5, 3.9). Convert percent into decimal fraction: 📌 Example: 20% = 0.2

Percent: 20% or 20/100 = 0.2.

Percentage: A percentage is formed by multiplying a number called the base by a percent, called the rate. 📐 Formula: Percentage = Base × Rate 📌 Example 13: What is 20% of 120? Rate = 20% = 20/100 = 0.2. Base = 120. Percentage = 0.2 × 120 = 24 📌 Example 14: What is 6% of 40? Percentage = Rate × Base = 0.06 × 40 = 2.4

Base: To find the base when the percentage and rate are known: 📐 Formula: Base = Percentage / Rate 📌 Example 15: Find base if Rate = 24.0% = 0.24, Percentage = 96. Base = 96 / 0.24 = 400

⭐ Key Takeaways

The most critical concepts from this lecture are the components of gross salary and the rules for taxation, specifically that allowances up to 50% of basic salary are tax-free and any excess is taxable. You must know how to calculate employee and employer contributions to the Provident Fund and employer contributions to the Gratuity Fund, both at 1/11th of basic salary. The method for calculating the annual cost of leaves (Casual, Earned, Sick) as a percentage of gross salary is essential, along with the total Social Charges figure of 29% of gross salary. Finally, be fluent in converting between fractions, decimals, and percentages, and using the formula Percentage = Base × Rate to solve real-world problems.

🧠 Quick Revision Questions

1. What is the tax-free limit for allowances as a percentage of basic salary?
2. An employee has a basic salary of 15,000 Rs. and allowances of 9,000 Rs. What is the add back to the company's income?
3. If an employee’s basic salary is 11,000 Rs., what is the total employee contribution to the Provident Fund per month?
4. For an employee with a gross salary of 18,000 Rs. per month, what is the annual cost of Sick Leave (12 days/year) if normal working days per month is 22?
5. If a rate is 30% and the percentage is 150, what is the base?

📘 Lecture 4 — Applications of Basic Mathematics Part 3

📖 Overview: This lecture continues the application of basic mathematics to payroll calculations, focusing on gross remuneration and social charges. It also introduces the concept of averages, including weighted averages, and provides comprehensive guidance on using Microsoft Excel for calculations, sums, and averages.

🗂️ Topics Covered

The lecture begins with a review of gross remuneration calculation based on basic salary, including house rent, conveyance, utilities, gratuity, and provident fund, with corresponding Excel formulas. It then explains how to calculate social charges and details various methods for adding numbers in Excel, such as AutoSum, SUMIF, and DSUM. The concepts of simple average, weighted average, and their Excel implementations are covered, including examples of grade calculation and labor cost averaging.

📝 Lecture Summary

Review Lecture 3

This section shows the worksheet calculation of Gross remuneration based on a basic salary of 6000 Rs. House rent is 45% of basic salary, Conveyance allowance is 2.5% of basic salary, Utilities allowance is 2.5% of basic salary. Both Gratuity and Provident fund are 1/11th of basic salary. The $ sign in Excel formulas (e.g., =$B$93) fixes the cell location, allowing quick and correct calculation of all allowances based on the basic salary. The ROUND function is used to round off values to a desired number of decimals, e.g., =ROUND((1/11)*$B$93;0) rounds to no decimal places.

The calculation for Social charges uses the formula B93*(29/100), representing 29% social charges. In the example, the $ sign was not used to explain that if the formula in cell D93 were copied to cell E93, the cell reference B93 would change to C93 (relative reference). $B$93 would be needed to keep the basic salary fixed.

🔑 Definition — Gross Remuneration: The total salary including basic pay and all allowances (house rent, conveyance, utilities) before deductions. 📐 Formula: Gross Salary = Basic Salary + House Rent + Conveyance Allowance + Utilities Allowance. House Rent = 0.45 × Basic Salary. Conveyance/Utilities = 0.025 × Basic Salary each. Gratuity = (1/11) × Basic Salary. 📌 Example: Basic Salary = 6000 Rs. House Rent = 0.45 × 6000 = 2700 Rs. Conveyance Allowance = 0.025 × 6000 = 150 Rs. Utilities Allowance = 0.025 × 6000 = 150 Rs. Gross Salary = 6000 + 2700 + 150 + 150 = 9000 Rs. Gratuity = (1/11) × 6000 ≈ 545 Rs.

AVERAGE

The Average (or Arithmetic Mean) is calculated by dividing the sum of all data values by the number of data values.

🔑 Definition — Average (Arithmetic Mean): A measure of central tendency calculated as the sum of all values divided by the count of values. 📐 Formula: Average = Sum / N, where Sum = total of all data values and N = number of data values. 📌 Example: Data: 10, 7, 9, 27, 2. Sum = 10 + 7 + 9 + 27 + 2 = 55. There are 5 data values. Average = 55 / 5 = 11.

ADDING NUMBERS USING MICROSOFT EXCEL

This section details seven methods for adding numbers in Excel:

1. Add numbers in a cell: Type an equation directly, e.g., =5+10 results in 15.
2. Add all contiguous numbers in a row or column using AutoSum: Click a cell next to the last data value, click the AutoSum symbol (Σ) in the toolbar, and press ENTER.
3. Add noncontiguous numbers: Use the SUM function.
4. Add numbers based on one condition: Use the SUMIF function to create a total value for one range based on a value in another range.
5. Add numbers based on multiple conditions: Use the IF and SUM functions together.
6. Add numbers based on criteria stored in a separate range: Use the DSUM function.
7. Add numbers based on multiple conditions with the Conditional Sum Wizard.

🔑 Definition — DSUM: A function that adds numbers in a column of a list or database that match specified conditions. 📐 Formula: DSUM(database, field, criteria). database is the range of cells for the list, field indicates the column for the function, and criteria is the range containing specified conditions. 📌 Example: =DSUM(A4:E10;"Profit";A1:F2) gives the total profit from apple trees (in this case, 75).

AVERAGE USING MICROSOFT EXCEL

The AVERAGE function returns the arithmetic mean of given arguments.

🔑 Definition — AVERAGE Function: An Excel function that calculates the arithmetic mean of a set of numbers. 📐 Formula: AVERAGE(number1, number2, ...), where number1, number2, ... are up to 30 numeric arguments. 📌 Example: To calculate the average of numbers in a contiguous row or column, use the AVERAGE function on the cell range. For non-contiguous cells, select the individual cells separated by commas in the function (e.g., =AVERAGE(A1, C1, E1)).

WEIGHTED AVERAGE

A Weighted average is an arithmetic mean where some elements of the set carry more importance (weight) than others. The weights must be in fraction form (e.g., percentages converted to decimals).

🔑 Definition — Weighted Average: A type of average where each data point is multiplied by a predetermined weight before summing to reflect its relative importance. 📐 Formula: Weighted Average = (x₁)(w₁) + (x₂)(w₂) + (x₃)(w₃) + ... + (xₙ)(wₙ), where x are the data values and w are the weights (in fractions). 📌 Example 1 (Grades): Homework grade=92 (weight 10% or 0.1), Quiz grade=68 (weight 20% or 0.2), Test grade=81 (weight 70% or 0.7). Weighted Average = (0.10)(92) + (0.20)(68) + (0.70)(81) = 9.2 + 13.6 + 56.7 = 79.5. 📌 Example 2 (Labor Costs): Skilled labor: 6 hours at 300 Rs. Semiskilled: 3 hours at 200 Rs. Unskilled: 1 hour at 100 Rs. Total hours = 10. Weights as fractions: Skilled = 6/10 = 0.6, Semiskilled = 3/10 = 0.3, Unskilled = 1/10 = 0.1. Weighted Average = (0.6)(300) + (0.3)(200) + (0.1)(100) = 180 + 60 + 10 = 250. 💡 Why this matters: Weighted averages are crucial for fair grade calculation in education and for determining accurate costs in business scenarios like labor where different categories contribute differently.

⭐ Key Takeaways

The student must remember that gross remuneration is the sum of basic salary and all allowances, with house rent at 45% and conveyance/utilities at 2.5% each of basic salary. The Excel $ sign fixes a cell reference for consistent calculations, and the ROUND function manages decimal places. The simple average is the sum divided by the count. For weighted averages, each data value is multiplied by its fractional weight and then summed; this is essential for computing grades and labor costs. Key Excel functions to remember include SUM, AVERAGE, SUMIF, and DSUM for different types of data aggregation.

🧠 Quick Revision Questions

1. Calculate the gross remuneration for a basic salary of 8,000 Rs., given house rent is 45%, conveyance is 2.5%, and utilities is 2.5% of the basic salary.
2. What is the purpose of the $ sign in the Excel formula =$B$93*0.45?
3. Find the simple average of the following data set: 15, 22, 30, 43, 50.
4. A student has a project grade of 85 (weight 25%), a midterm grade of 78 (weight 35%), and a final exam grade of 92 (weight 40%). Calculate the student's overall weighted average.
5. Which Excel function would you use to add all sales values in a column only for a specific product type listed in another column?

📘 Lecture 5 — Applications of Basic Mathematics Part 4

📖 Overview: This lecture teaches how to calculate percentage change between two values, including increases and decreases. It also covers the application of successive percentage changes for salary increases and investment returns over multiple years, with all calculations demonstrated in Microsoft Excel.

🗂️ Topics Covered

The lecture covers the concept of percentage change, including calculating increases and decreases. It then presents four detailed examples: calculating percentage change in sales, the shrinking of fresh fruit to dried fruit, the expansion of cotton after adding water, and successive wage increases over a three-year collective agreement. Finally, it applies the same logic to calculate the final value of an investment over four years with varying annual rates of return, including a negative return.

📝 Lecture Summary

PERCENTAGE CHANGE

This section introduces the fundamental formula for percentage change using the example of Monday's sales of Rs.1000 growing to Rs.2500 on Tuesday. The core method is explained: first find the change (final value minus initial value), then divide by the initial value and multiply by 100%. The calculation yields a 150% increase. The lecture then shows how to perform this in Excel by entering the initial value in cell C4 and the final value in cell C5, then using the formula =C5 – C4 for the change in cell C6 and =C6/C4*100 for the percentage change in cell C7, which gives the result 150%.

🔑 Definition — Percentage Change: The relative change between an old value and a new value, expressed as a percentage. 📐 Formula: Percentage Change = ((Final Value – Initial Value) / Initial Value) × 100% 📌 Example: Monday’s Sales = Rs.1000 (Initial Value), Tuesday’s Sales = Rs.2500 (Final Value). Change = 2500 – 1000 = 1500. Percentage Change = (1500 / 1000) × 100 = 150%. This means sales increased by 150%.

EXAMPLE 1

This example asks what percent Tuesday’s sale is of Monday’s sale. The calculation finds the ratio of the new value to the old value. The result is 250%, meaning Tuesday’s sale was two and a half times Monday's sale.

📌 Example: Monday’s sale = Rs.1000, Next day’s sale = Rs.2500. Ratio = 2500 / 1000 = 2.5. Percentage = 2.5 × 100 = 250%. Interpretation: Next day’s sale was 250% of Monday’s sale, or two and a half times.

EXAMPLE 2

This section demonstrates a percentage decrease using the process of making dried fruit. Fresh fruit weighing 15 kg shrinks to 3 kg of dried fruit. The change is negative (-12 kg), leading to a negative percentage change. The result is -80%, indicating the fruit's weight was reduced by 80%. The Excel implementation is shown with data entered in cells D19 (15) and D20 (3). The formula for the change in cell D21 is = D20 – D19, and for the percentage change in cell D22 is = D21/D19*100. The results are -12 kg and -80%.

📌 Example: Original fresh fruit = 15 kg, Final dried fruit = 3 kg. Change = 3 – 15 = -12 kg. Percentage Change = (-12 / 15) × 100 = -80%. Interpretation: The size was reduced by 80%.

EXAMPLE 3

This example shows a massive percentage increase when cotton absorbs water. The original weight of 3 kg increases to 15 kg. The change is +12 kg, resulting in a 400% increase. The Excel method mirrors the previous example, with data in cells D26 (3) and D27 (15). The formulas in D28 and D29 are = D27 – D26 and = D28/D26*100, giving results of 12 kg and 400%.

📌 Example: Original weight = 3 kg, Final weight = 15 kg. Change = 15 – 3 = 12 kg. Percentage Change = (12 / 3) × 100 = 400%. Interpretation: The weight increased by 400%.

EXAMPLE 4

This section tackles successive percentage increases for a salary over a three-year collective agreement. An employee earning Rs.5000 per month receives raises of 3%, 2%, and 1% in successive years. The calculation method multiplies the original salary by each growth factor sequentially: 5000 × (1 + 3%) × (1 + 2%) × (1 + 1%). This simplifies to 5000 × 1.03 × 1.02 × 1.01, yielding Rs.5306. The Excel method uses the ROUND function to handle currency. Data is entered as: cell C35 (5000), C36 (3), C38 (2), C40 (1). The formulas are: =ROUND(C35*(1+C36/100);0) for year 2 salary in C37, =ROUND(C37*(1+C38/100);0) for year 3 salary in C39, and =ROUND(C39*(1+C40/100);0) for the final salary in C41. The results: C37 = Rs.5150, C39 = Rs.5253, C41 = Rs.5306.

📌 Example: Current salary = Rs.5000, Year-1 raise = 3%, Year-2 raise = 2%, Year-3 raise = 1%. Calculation: 5000 × 1.03 × 1.02 × 1.01 = 5306 Rs. Final salary at the end of the term = Rs.5306 per month.

EXAMPLE 5

This final example applies the same principle of successive changes to an investment with varying rates of return, including a negative return. An investment of Rs.100,000 earns 4%, 8%, -10%, and 9% over four years. The calculation multiplies the initial investment by each year's growth factor: Year 1: 100000 × 1.04; Year 2: × 1.08; Year 3: × 0.90 (for a -10% loss); Year 4: × 1.09. The final value is Rs.110,186. The Excel implementation uses data in cells C46 (100000), C47 (4), C49 (8), C51 (-10), C53 (9). The formulas are =ROUND(C46*(1+C47/100);0) for the value in year 2 (C48), =ROUND(C48*(1+C49/100);0) for year 3 (C50), =ROUND(C50*(1+C51/100);0) for year 4 (C52), and =ROUND(C52*(1+C53/100);0) for the final value end of year 4 (C54). Results: C48 = Rs.104000, C50 = Rs.112320, C52 = Rs.101088, C54 = Rs.110186.

📌 Example: Investment = Rs.100,000, Year-1 return = 4%, Year-2 return = 8%, Year-3 return = -10%, Year-4 return = 9%. Calculation: 100000 × 1.04 × 1.08 × 0.90 × 1.09 = 110186 Rs. Final value at the end of Year 4 = Rs.110,186.

💡 Why this matters: Successive percentage changes cannot be simply added together (e.g., 3% + 2% + 1% = 6% of 5000 = 300, leading to 5300, which is incorrect). The correct method is to multiply the growth factors (1 + rate) for each period. This is critical for compound interest, investment returns, and multi-year financial planning.

⭐ Key Takeaways

The most critical concepts are the calculation of percentage change using the formula (Change/Initial Value) × 100%, and the crucial distinction between a simple ratio (Example 1) and a percentage change (Example 0). For multi-period problems, you must apply successive percentage changes by multiplying the original value by the growth factor (1 + rate) for each period, not by adding the rates. This applies to both salary increases and investment returns, including handling negative returns by using a growth factor of less than 1 (e.g., 1 - 0.10 = 0.90). All calculations can be performed accurately in Excel using the ROUND function for monetary values and the fundamental formulas for change and percentage change.

🧠 Quick Revision Questions

1. A store's sales were Rs.800 on Monday and Rs.600 on Tuesday. Calculate the percentage change and state whether it is an increase or decrease.
2. An employee's salary starts at Rs.45,000. She receives a 5% raise in year 1, a 7% raise in year 2, and a 3% raise in year 3. What is her salary at the end of year 3?
3. If you invest Rs.50,000 and it earns 10% in year 1, loses 5% in year 2, and gains 12% in year 3, what is the final value of the investment?
4. What is the correct Excel formula to calculate a 4% increase on a value in cell A1? What formula would you use to calculate a 4% decrease on the same value?
5. In the dried fruit example, why is the percentage change -80%? What does the negative sign indicate, and why is the change not simply -12/15?

📘 Lecture 6 — Applications of Basic Mathematics Part 5

📖 Overview: This lecture covers practical business mathematics concepts including discount calculations, simple and compound interest, and stock market metrics. It also reinforces percentage change calculations from Lecture 5 and introduces key stock investment terminology and return calculations essential for financial decision-making.

🗂️ Topics Covered

The lecture begins with a revision of percentage increase and decrease calculations, then introduces stock market concepts including yield, earnings per share, price-earnings ratio, and net current asset value per share. It proceeds to buying shares with commission, return on investment calculations, discount formulas, and concludes with simple and compound interest computations with worked examples.

📝 Lecture Summary

REVISION LECTURE 5

A chartered bank lowering its interest rate from 9% to 7% results in a percent decrease of -22.2% (calculated as -2/9 × 100). Conversely, increasing from 7% to 9% gives a percent increase of 28.6% (2/7 × 100). In Excel, for the decrease: cell F4=9, F5=7, formula F6=F5-F4 gives -2, and F7=F6/F4100 gives -22.2. For the increase: cell F14=7, F15=9, formula F16=F15-F14 gives 2, and F17=F16/F14100 gives 28.6.

The Definition of a Stock

Stock represents a share in the ownership of a company and a claim on its assets and earnings. Stock yield refers to the rate of income generated from a stock in the form of regular dividends, calculated as annual dividend payments divided by the stock's current share price. Earnings per share (EPS) is total profits divided by the number of shares — a company with $1 billion earnings and 200 million shares has EPS of $5 per share.

🔑 Definition — Price-earnings ratio (P/E ratio): A valuation ratio of a company's current share price compared to its per-share earnings. 📐 Formula: P/E Ratio = Current Share Price / Earnings per Share 📌 Example: If a company trades at $43 per share and earnings over the last 12 months were $1.95 per share, the P/E ratio = $43/$1.95 = 22.05

Outstanding shares are stock currently held by investors, including restricted shares owned by company officers and the public, but excluding repurchased shares. Net current asset value per share (NCAVPS) is calculated by taking current assets minus total liabilities, then dividing by total shares outstanding. Current assets include cash, accounts receivable, inventory, marketable securities, and prepaid expenses convertible to cash within one year. Liabilities are a company's legal debts or obligations from business operations. Market value is the price at which investors buy or sell a share at a given time. Face value (or par value) is the original cost of a share shown on the certificate, typically a small amount unrelated to market price.

Dividend

A dividend is the portion of profit a company distributes to shareholders. For example, a company earning Rs 1 crore keeps half (Rs 50 lakh) for reinvestment and distributes the other half as dividend. With 10,000 shares, each share earns Rs 500 dividend. If you own 100 shares, you receive Rs 50,000 (100 × Rs 500). When expressed as a percentage, dividend is based on face value — a 50% dividend on a Rs 10 face value share means Rs 5 per share.

BUYING SHARES

If you buy 100 shares at Rs 62.50 per share with a 2% commission, calculate total cost: 📌 Example: 100 × Rs 62.50 = Rs 6,250; Commission = 0.02 × Rs 6,250 = Rs 125; Total = Rs 6,375

RETURN ON INVESTMENT

Suppose you bought 100 shares at Rs 52.25 and sold them after 1 year at Rs 68, with a 1% commission rate on buying and selling, and 10% dividend per share (face value Rs 10 each).

📌 Bought: 100 shares at Rs 52.25 = Rs 5,225; Commission at 1% = Rs 52.25; Total Cost = Rs 5,277.25

📌 Sold: 100 shares at Rs 68 = Rs 6,800; Commission at 1% = Rs 68; Total Sale = Rs 6,732

📌 Gain: Net Receipts = Rs 6,732; Total Cost = Rs 5,277.25; Net Gain = Rs 1,454.75; Dividends (100 × 10/10) = Rs 100; Total Gain = Rs 1,554.75; Return on investment = (1,554.75/5,277.25) × 100 = 29.46%

In Excel: For Bought, cell B21=100, B22=52.25, B23=B21×B22=5225, B24=B23×0.01=52.25, B25=B23+B24=5277.25. For Sold, cell B28=68, B29=B21×B28=6800, B30=B29×0.01=68, B31=B29-B30=6732. For Gain, B34=B31=6732, B35=B25=5277.25, B36=B31-B25=1454.75, B37=B36/B35×100=27.57.

💡 Why this matters: The Excel % gain (27.57%) differs from the manual return on investment (29.46%) because the manual calculation includes dividends while the Excel gain calculation does not.

DISCOUNT

Discount is a rebate or reduction in price, expressed as a percentage of the list price.

📌 Example: List Price = Rs 2,200; Discount Rate = 15%; Discount = 2,200 × 0.15 = Rs 330

NET COST PRICE

Net Cost Price = List Price - Discount

📌 Example: List Price = Rs 4,500; Discount = 20%; Net Cost Price = 4,500 - (0.2 × 4,500) = 4,500 - 900 = Rs 3,600

SIMPLE INTEREST

P = Principal, R = Rate of interest percent per annum, T = Time in years, I = Simple interest 📐 Formula: I = (P × R × T) / 100 Total amount A to be paid at end = P + I

📌 Example: P = Rs 500, T = 4 years, R = 11%; I = (500 × 4 × 11)/100 = Rs 220

COMPOUND INTEREST

Compound Interest also attracts interest on previously earned interest.

🔑 Definition — Compound Interest: Interest calculated on both the initial principal and the accumulated interest from previous periods.

📐 Formula: S = P(1 + r/100)^n, where S = compound amount (money accrued after n years), P = Principal, r = Rate of interest, n = Number of periods. Compound Interest = S - P

📌 Example: P = Rs 800, r = 10%: Year 1 interest = 0.1 × 800 = 80, New P = 880; Year 2 interest = 0.1 × 880 = 88, New P = 968

📌 Example: Calculate compound interest on Rs 750 invested at 12% per annum for 8 years: S = 750(1+12/100)^8 = 750(1.12)^8 = Rs 1,857; Compound Interest = 1,857 - 750 = Rs 1,107

💡 Why this matters: Compound interest grows faster than simple interest because interest earns interest, making it crucial for long-term investments and loans.

⭐ Key Takeaways

The most critical concepts from this lecture are: (1) Stock yield, EPS, P/E ratio, and NCAVPS are essential metrics for evaluating stock investments, with P/E ratio calculated as share price divided by EPS. (2) When buying shares, total cost includes the purchase price plus commission; return on investment considers both capital gains and dividends. (3) Discount is always calculated as a percentage of list price, and net cost price equals list price minus discount. (4) Simple interest is calculated only on the principal using I = PRT/100, while compound interest grows exponentially using S = P(1+r/100)^n. (5) The percent change formula (change/original × 100) works for both increases and decreases, but the base value differs depending on the direction of change.

🧠 Quick Revision Questions

1. What is the formula for calculating the Price-Earnings ratio of a stock?
2. If you buy 200 shares at Rs 50 each with a 1.5% commission, what is your total cost?
3. Calculate the simple interest on Rs 1,000 at 8% per annum for 3 years.
4. A stock has a face value of Rs 10 and declares a 40% dividend. How much dividend will you receive per share?
5. What is the compound amount after 5 years if Rs 2,000 is invested at 10% per annum compounded annually?

📘 Lecture 7 — Applications of Basic Mathematics

📖 Overview: This lecture introduces the concept of annuities, which are series of fixed payments made or received over time, and provides formulas for calculating their accumulated (future) and discounted (present) values. It also reviews fundamental algebraic operations, exponents, and the method for solving linear equations, establishing a foundation for further studies in business mathematics and statistics.

🗂️ Topics Covered

The lecture covers the scope of Module 2, a review of Lecture 6, and then dives into the definition of an annuity. It explains how to calculate the accumulated value (future value) of an annuity using the accumulation factor and the discounted value (present value) using the discount factor. The latter part of the lecture reviews algebraic operations, including division by monomials, multiplication of polynomials, working with exponents, and solving linear equations.

📝 Lecture Summary

Annuity

An annuity is a series of fixed payments required from you or paid to you at a specified frequency over a fixed period of time. Annuities are typically used to build retirement income, save for a child’s education, or create a trust fund. The most common payment frequencies are yearly, semi-annually, quarterly, and monthly.

💡 Why this matters: Understanding annuities is crucial for personal financial planning, like retirement savings or loan payments.

🔑 Definition — Annuity: A series of fixed payments made or received at a specified frequency over a fixed period of time.

Calculating the Future Value or accumulated value of an Annuity

The future value of an ordinary annuity formula is useful for finding out how much you would have in the future by investing at a given interest rate. The formula calculates the accumulated value of all cash flows.

📐 Formula: S = R * [((1 + i)^n - 1) / i] Where:

• S = Accumulated value
• R = Payment per period (amount of annuity)
• i = interest rate per conversion period
• n = number of payments
• ((1 + i)^n - 1) / i is called the accumulation factor for n periods.

Thus: Accumulated value = Payment per period × Accumulation factor for n periods

📌 Example 1: You receive $1,000 every year for the next five years and invest each payment at 5% interest.

• R = $1000
• i = 5% = 0.05
• n = 5
• Accumulation Factor (AF) = ((1 + 0.05)^5 - 1) / 0.05 = [1.27628 - 1] / 0.05 = 5.53
• S = $1,000 × 5.53 = $5,525.63 Note: The formula gives a more accurate result than manually calculating and adding each year’s future value, avoiding rounding errors.

Calculating the Present Value or discounted value of an Annuity

If you would like to determine today's value of a series of future payments, you need to use the formula that calculates the present value or discounted value of an ordinary annuity.

📐 Formula: A = R * [(1 - (1 + i)^(-n)) / i] Where:

• A = Discounted or present worth of an annuity
• R = Cash flow per period
• i = interest rate
• n = number of payments
• (1 - (1 + i)^(-n)) / i is called the discount factor for n periods.

Thus: Discounted value = Payment per period × Discount factor for n periods

📌 Example 2: Using the same cash flow schedule (receiving $1,000 every year for five years at 5% interest), calculate the present value.

• R = $1000
• i = 0.05
• n = 5
• Discount Factor (DF) = (1 - (1 + 0.05)^(-5)) / 0.05 = (1 - 0.7835) / 0.05 = 0.2165 / 0.05 = 4.33
• A = $1,000 × 4.33 = $4,329.48

Notations

The following notations are used in calculations of Annuity:

• R = Amount of annuity
• N = Number of payments
• I = Interest rate per conversion period
• S = Accumulated value
• A = Discounted or present worth of an annuity

Accumulated Value

The accumulated value S of an annuity is the total payments made including the interest.

• Formula: S = R ((1+i)^n – 1)/i
• Accumulation factor for n payments = ((1 + i)^n – 1) / i

The discounted or present worth of an annuity is the value in today’s rupee value. For example, if you deposit 100 rupees and get 110 rupees after one year (10% interest), the Present Worth of 110 rupees is 100. Here 110 is the future value of 100. If 110 is invested again, it can be Rs. 121 after year 2. The present value of Rs. 121 at the end of year 2 is also 100.

Discount Factor and Discounted Value

When future value is converted into present worth, the rate at which the calculations are made is called the discount factor rate. In the previous example, 10% was used. This rate is called the Discount Rate. The present worth of future payments is called Discounted Value.

Example 1. Accumulation Factor (AF) for n Payments

Calculate Accumulation Factor and Accumulated value when:

• i = 4.25% = 0.0425
• n = 18
• R = 10,000 Rs.
• AF = ((1 + 0.0425)^18 - 1) / 0.0425 = 26.24
• S = 10,000 × 26.24 = 260,240 Rs.

Example 2. Discounted Value (DV)

In the above example, calculate the discounted (present) value.

• i = 4.25% = 0.0425
• n = 18
• R = 10,000 Rs.
• DF = (1 - 1/(1+0.0425)^18) / 0.0425 = 12.4059
• Discounted value = 10,000 × 12.4059 = 124,059 Rs.

Example 3. Discounted Value (DV)

How much money deposited now will provide payments of Rs. 2000 at the end of each half-year for 10 years if interest is 11% compounded six-monthly?

• R = 2000 Rs.
• i = 11% / 2 = 0.055
• n = 10 × 2 = 20
• DF = (1 - 1/(1+0.055)^20) / 0.055 = 11.95
• Discounted value = 2,000 × 11.95 = 23,900.77 Rs.

Algebraic Operations

An Algebraic Expression indicates the mathematical operations to be carried out on a combination of numbers and variables. The components of an algebraic expression are separated by Addition and Subtraction. In the expression 2x² – 3x - 1, the components are separated by minus signs.

In algebraic expressions, there are four types of terms:

• Monomial: 1 term (e.g., 3x²)
• Binomial: 2 terms (e.g., 3x² + xy)
• Trinomial: 3 terms (e.g., 3x² + xy - 6y²)
• Polynomial: more than 1 term (Binomial and trinomial examples are also polynomials)

Algebraic operations in an expression consist of one or more FACTORs separated by MULTIPLICATION or DIVISION sign.

• Multiplication is assumed when two factors are written beside each other (e.g., xy = x*y).
• Division is assumed when one factor is written under another.

Factors can be further subdivided into NUMERICAL and LITERAL coefficients.

Division by a Monomial

There are two steps:

1. Identify factors in the numerator and denominator.
2. Cancel factors in the numerator and denominator.

📌 Example: 36x²y / 60xy²

• 36 = 3 × 12, 60 = 5 × 12
• x²y = (x)(x)(y), xy² = (x)(y)(y)
• Expression becomes: [3 × 12 × (x)(x)(y)] / [5 × 12 × (x)(y)(y)]
• 12(x)(y) cancel, leaving 3(x) / 5(y)

📌 Example: (48a² – 32ab) / 8a Steps:

1. Divide each term in the numerator by the denominator.
2. Cancel factors.

• 48a² / 8a = [8 × 6 × (a)(a)] / [8a] = 6(a)
• 32ab / 8a = [4 × 8 × (a)(b)] / [8(a)] = 4(b)
• Answer = 6a – 4b

How to Multiply Polynomials?

📌 Example: -x(2x² – 3x - 1) Each term in the trinomial is multiplied by -x.

• = (-x)(2x²) + (-x)(-3x) + (-x)(-1)
• Note: The product of two negatives is positive.
• = -2x³ + 3x² + x

Exponents

An exponent of a term means calculating some power of that term.

📌 Example: (3x⁶y³ / x²z³)² Steps:

1. Simplify inside the brackets first: (3x⁶⁻²)(y³)/z³ = (3x⁴)(y³)/z³
2. Square each factor: (3²)(x⁴*²)(y³*²) / z³*²
3. Simplify: 9x⁸y⁶ / z⁶

Linear Equation

If there is an expression A + 9 = 137, we can calculate the value of A by moving the 9 to the right of the equality: A = 137 – 9 = 128.

To solve linear equations:

1. Collect like terms.
2. Divide both sides by the numerical coefficient.

📌 Example: x = 341.25 + 0.025x Step 1:

• x – 0.025x = 341.25
• x(1 - 0.025) = 341.25
• 0.975x = 341.25 Step 2:
• x = 341.25 / 0.975 = 350

⭐ Key Takeaways

• An annuity is a series of fixed payments, and its value can be calculated as an accumulated value (future value) or a discounted value (present value). The accumulation factor ((1+i)^n - 1)/i and the discount factor (1 - (1+i)^(-n))/i are the core tools for these calculations, with the total value being the payment per period multiplied by the respective factor. The fundamental algebraic operations of division by monomials, multiplying polynomials, and simplifying exponents are essential for manipulating these and other mathematical formulas. Finally, solving a linear equation like x = a + bx requires collecting like terms and then dividing by the coefficient of x, a process critical for solving for unknown variables in business problems.

🧠 Quick Revision Questions

1. What is the definition of an annuity, and what are the most common payment frequencies?
2. What is the formula for the accumulated value (S) of an ordinary annuity, and what is the component ((1+i)^n - 1)/i called?
3. What is the formula for the discounted value (A) of an ordinary annuity, and what is the component (1 - (1+i)^(-n))/i called?
4. Simplify the algebraic expression: (24x³y²) / (8x²y).
5. Solve the linear equation for x: 5x + 10 = 2x + 25.

📘 Lecture 8 — Compound Interest

📖 Overview: This lecture introduces compound interest concepts and a comprehensive suite of Excel financial functions for investment analysis. It covers how to calculate returns from investments, annuities, and use specialized Excel functions to determine cumulative interest, principal payments, future values, and net present values. Mastering these tools is essential for real-world financial decision-making in banking, loans, and investments.

🗂️ Topics Covered

The lecture reviews compound interest fundamentals, then systematically explains and demonstrates over a dozen Excel financial functions: CUMIPMT, CUMPRINC, EFFECT, FV, FVSCHEDULE, IPMT, ISPMT, NOMINAL, NPER, NPV, PMT, PPMT, PV, and RATE. Each function is defined with its syntax, and most include practical examples with complete numerical values showing how to calculate loan interest, investment growth, payment amounts, and more.

📝 Lecture Summary

Review of Lecture 7

The lecture begins with a brief review of previous material before diving into new compound interest applications and Excel functions. The focus shifts from basic calculations to using spreadsheet tools for complex financial analysis.

Compound Interest

Compound interest is interest calculated on the initial principal and also on the accumulated interest from previous periods. It allows investments to grow exponentially over time, as earnings generate additional earnings.

💡 Why this matters: Compound interest is the foundation of all modern finance — it determines how loans accumulate debt and how investments grow over time.

CUMIPMT

Returns the cumulative interest paid on a loan between start_period and end_period.
🔑 Definition — CUMIPMT: A function that calculates total interest paid over a specified range of payment periods.

📐 Formula: CUMIPMT(rate, nper, pv, start_period, end_period, type)
→ Calculates total interest paid from one period to another.

📌 Example: For a 9% annual rate, 30-year loan of 125,000 with monthly payments:

• Total interest in second year (periods 13-24): =CUMIPMT(9%/12, 30*12, 125000, 13, 24, 0) → (-11135.23)
• Interest in first single payment (period 1): =CUMIPMT(9%/12, 30*12, 125000, 1, 1, 0) → (-937.50)

Type=0 means payment at end of period.

CUMPRINC

Returns the cumulative principal paid on a loan between two periods.
🔑 Definition — CUMPRINC: A function that calculates total principal paid over a specified range of payment periods.

📐 Formula: CUMPRINC(rate, nper, pv, start_period, end_period, type)
→ Calculates total principal repaid from one period to another.

📌 Example: Same loan (9%, 30 years, 125,000):

• Total principal in second year (periods 13-24): =CUMPRINC(9%/12, 30*12, 125000, 13, 24, 0) → (-934.1071)
• Principal in first single payment: =CUMPRINC(9%/12, 30*12, 125000, 1, 1, 0) → (-68.27827)

EFFECT

Returns the effective annual interest rate given a nominal rate and number of compounding periods per year.
🔑 Definition — EFFECT: Converts a nominal (stated) interest rate to the actual annual rate earned after compounding.

📐 Formula: EFFECT(nominal_rate, npery)
→ Shows true annual yield when interest compounds multiple times per year.

📌 Example: Nominal_rate = 5.25%, Npery = 4 (quarterly compounding):
=EFFECT(5.25%, 4) → 0.053543 or 5.3543% (round to 5.35%)

FV

Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
🔑 Definition — FV: Calculates what an investment or series of payments will be worth at a future date.

📐 Formula: FV(rate, nper, pmt, pv, type)
→ Determines total accumulated value including principal, payments, and compound interest.

📌 Example 1: Rate=6%, Nper=10, Pmt=-200, Pv=-500, Type=1 → 2581.40
📌 Example 2: Rate=12%, Nper=12, Pmt=-1000 (no Pv/Type) → 12682.50
📌 Example 3: Rate=11%, Nper=35, Pmt=-2000, Type=1 (Pv omitted with double commas) → 82846.25

FVSCHEDULE

Returns the future value of an initial principal after applying a series of compound interest rates.
🔑 Definition — FVSCHEDULE: Calculates growth when interest rates vary each period.

📐 Formula: FVSCHEDULE(principal, schedule)
→ Applies different compound rates sequentially to a starting principal.

📌 Example: Principal=1, Rates={0.09, 0.11, 0.1}:
=FVSCHEDULE(1, {0.09, 0.11, 0.1}) → 1.33089

IPMT

Returns the interest payment for an investment for a given period.

📐 Formula: IPMT(rate, per, nper, pv, fv, type)
→ Calculates the interest portion of a payment in a specific period.

ISPMT

Calculates the interest paid during a specific period of an investment (simpler version of IPMT).

📐 Formula: ISPMT(rate, per, nper, pv)
→ For a loan, pv is the loan amount.

NOMINAL

Returns the annual nominal interest rate given the effective rate and number of compounding periods.

📐 Formula: NOMINAL(effect_rate, npery)
→ Converts an effective annual rate back to its nominal (stated) equivalent.

NPER

Returns the number of periods for an investment.

📐 Formula: NPER(rate, pmt, pv, fv, type)
→ Tells how many payments/periods needed to reach a financial goal.

NPV

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

📐 Formula: NPV(rate, value1, value2, ...)
→ Determines whether an investment is worthwhile in today's money.

PMT

Returns the periodic payment for an annuity.

📐 Formula: PMT(rate, nper, pv, fv, type)
→ Calculates the fixed payment amount needed to pay off a loan or reach a future value.

PPMT

Returns the payment on the principal for an investment for a given period.

📐 Formula: PPMT(rate, per, nper, pv, fv, type)
→ Shows how much of a specific payment goes toward reducing principal.

PV

Returns the present value of an investment.

📐 Formula: PV(rate, nper, pmt, fv, type)
→ Determines what a future sum or series of payments is worth today.

RATE

Returns the interest rate per period of an annuity.

📐 Formula: RATE(nper, pmt, pv, fv, type, guess)
→ Solves for the interest rate given payment, periods, and present value.

📌 Example: 4 years loan, -200 monthly payment, 8000 loan amount:
=RATE(4, -200, 8000) → 0.09241767 or 9.24%

⭐ Key Takeaways

Students must memorize the syntax and purpose of all major Excel financial functions covered: CUMIPMT, CUMPRINC, EFFECT, FV, FVSCHEDULE, IPMT, ISPMT, NOMINAL, NPER, NPV, PMT, PPMT, PV, and RATE. The most critical concept is that negative signs typically represent cash outflows (payments) while positive signs represent inflows (received amounts). Compound interest calculations require careful conversion of annual rates to periodic rates (divide by periods per year) and annual terms to total periods (multiply by periods per year). The difference between IPMT (interest for a specific period) and ISPMT (simpler version) as well as between FV (constant rate) and FVSCHEDULE (variable rates) is essential. Finally, understanding that CUMIPMT and CUMPRINC work over ranges of periods while PMT/PPMT/IPMT work for single periods is fundamental for exam problems.

🧠 Quick Revision Questions

1. What is the syntax and purpose of the CUMIPMT function? What does the Type argument of 0 versus 1 mean?
2. How do you calculate the total principal paid in the first year of a 30-year loan using CUMPRINC?
3. If a nominal interest rate is 5.25% compounded quarterly, what is the effective annual rate (EFFECT)?
4. Using the FV function, what inputs are needed and what does a negative sign on Pmt or Pv indicate?
5. How does the RATE function work, and what was the result (as a percentage) in the example with a 4-year, 8000 loan with 200 monthly payments?

📘 Lecture 9 — Matrix and its dimension Types of matrix

📖 Overview: This lecture introduces the fundamental concept of matrices, which are rectangular arrays of numbers used extensively in business, economics, and data processing. It covers matrix dimensions, various types of matrices including row, column, square, and identity matrices, and explains the multiplicative identity property of matrices.

🗂️ Topics Covered

The lecture begins with reviewing the importance and applications of matrices in business contexts such as econometrics, network analysis, and linear programming. It then defines what a matrix is and demonstrates how tabular data can be represented as a matrix. The lecture proceeds to explain matrix dimension (order), different types of matrices (row, column, square), and concludes with a detailed examination of identity matrices and their multiplicative identity property with worked examples.

📝 Lecture Summary

Review and Applications

Matrices have many important applications in business and industry where large amounts of data are processed daily. Practical questions in modern business and economic management can be answered with matrix representation in fields such as econometrics, network analysis, decision networks, optimization, linear programming, analysis of data, and computer graphics.

What is a Matrix?

A Matrix is a rectangular array of numbers. The plural of matrix is matrices. Matrices are usually represented with capital letters such as Matrix A, B, C. The numbers in a matrix are often arranged in a meaningful way. For example, the order for school clothing in September is illustrated in a table with rows representing clothing types (Sweat Pants, Sweat Shirts, Shorts, T-shirts) and columns representing sizes (Youth S, M, L, XL). This data can be entered in the shape of a matrix.

Dimension

Dimension or Order of a Matrix equals Number of Rows × Number of Columns. The '×' is just notation and does not mean to multiply.

🔑 Definition — Dimension of a Matrix: The size of a matrix given by rows × columns, written as r × c where r is the number of rows and c is the number of columns.

📌 Example: Matrix T has dimensions of 2×3 or the order of matrix T is 2×3.

Row, Column and Square Matrix

A matrix with dimensions 1×n is referred to as a row matrix. For example, matrix A is a 1×4 row matrix. A matrix with dimensions n×1 is referred to as a column matrix. For example, matrix B is a 2×1 column matrix. A matrix with dimensions n×n is referred to as a square matrix. For example, matrix C is a 3×3 square matrix.

🔑 Definition — Row Matrix: A matrix with exactly one row and n columns (1×n dimension). 🔑 Definition — Column Matrix: A matrix with exactly one column and n rows (n×1 dimension). 🔑 Definition — Square Matrix: A matrix with equal number of rows and columns (n×n dimension).

Identity Matrix

An identity matrix is a square matrix with 1's on the main diagonal from the upper left to the lower right and 0's off the main diagonal. An identity matrix is denoted as I. The subscript indicates the size of the identity matrix. For example, Iₙ represents an identity matrix with dimensions n×n.

🔑 Definition — Identity Matrix (I): A square matrix with 1s on the main diagonal and 0s elsewhere.

Multiplicative Identity

With real numbers, the number 1 is referred to as a multiplicative identity because it has the unique property that the product of a real number and 1 is that real number. With matrices, the identity matrix shares the same unique property. In other words, a 2×2 identity matrix is a multiplicative inverse because for any 2×2 matrix A, I·A = A and A·I = A.

🔑 Definition — Multiplicative Identity Property: For any matrix A and identity matrix I of compatible dimensions, A·I = A and I·A = A.

📌 Example: Given the 2×2 matrix A = [[2, -1], [-3, 4]] and identity matrix I = [[1, 0], [0, 1]]:

I·A = [[1,0],[0,1]] · [[2,-1],[-3,4]] = [[2,-1],[-3,4]] = A

Work: r1c1 = 1(2) + 0(-3) = 2, r1c2 = 1(-1) + 0(4) = -1, r2c1 = 0(2) + 1(-3) = -3, r2c2 = 0(-1) + 1(4) = 4

A·I = [[2,-1],[-3,4]] · [[1,0],[0,1]] = [[2,-1],[-3,4]] = A

Work: r1c1 = 2(1) + -1(0) = 2, r1c2 = 2(0) + -1(1) = -1, r2c1 = -3(1) + 4(0) = -3, r2c2 = -3(0) + 4(1) = 4

Where 'r' denotes row and 'c' denotes column.

💡 Why this matters: The identity matrix is essential for solving matrix equations and finding matrix inverses, which are fundamental operations in solving systems of linear equations in business applications.

⭐ Key Takeaways

The most critical concepts from this lecture are: a matrix is a rectangular array of numbers with dimension given by rows × columns; there are three main types based on dimensions — row matrices (1×n), column matrices (n×1), and square matrices (n×n); the identity matrix is a special square matrix with 1s on the main diagonal and 0s elsewhere; and the identity matrix serves as the multiplicative identity for matrices, meaning any matrix multiplied by the identity matrix remains unchanged. These fundamental concepts form the foundation for all matrix operations used in business mathematics and statistics.

🧠 Quick Revision Questions

1. What is the definition of a matrix and how is its dimension expressed?
2. What are the three main types of matrices based on their dimensions? Provide an example of each.
3. What is an identity matrix and what are its defining characteristics?
4. What is the multiplicative identity property for matrices? How does it relate to the identity matrix?
5. Given matrix A = [[2, -1], [-3, 4]] and identity matrix I = [[1,0],[0,1]], verify that A·I = A by showing the multiplication steps.

📘 Lecture 10 — Matrices

📖 Overview: This lecture introduces matrices as a tool for organizing and interpreting business data, with a focus on how matrices can represent real-world scenarios such as university clothing orders and company sales. It covers fundamental matrix operations including addition, subtraction, scalar multiplication, matrix multiplication, and multiplicative inverses, all essential for business applications.

🗂️ Topics Covered

The lecture begins with a review of previous content, then introduces matrices through a real example of a clothing company supplying two universities. It covers the organization and interpretation of data using matrices, matrix addition and subtraction, scalar multiplication, matrix multiplication including the rules for when multiplication is possible, and concludes with the concept of multiplicative inverses for matrices.

📝 Lecture Summary

EXAMPLE 1

An athletic clothing company manufactures T-shirts and sweatshirts in four sizes (small, medium, large, x-large) for two universities: University of S and University of R. The September orders are shown as tables, which can be represented as matrices. For University of S, the order matrix S has T-shirts: [100, 300, 500, 300] and sweatshirts: [150, 400, 450, 250] across the four sizes. For University of R, the order matrix R has T-shirts: [60, 250, 400, 250] and sweatshirts: [100, 200, 350, 200].

🔑 Definition — Matrix: A rectangular array of numbers organized in rows and columns.

MATRIX OPERATIONS

Matrix operations include organizing and interpreting data using matrices, using them in business applications, adding and subtracting two matrices, multiplying a matrix by a scalar, and multiplying two matrices. The goal includes interpreting the meaning of elements within a product matrix.

PRODUCTION

The company's production in preparation for the September orders is shown in matrix P. For T-shirts: [300, 700, 900, 500] and for sweatshirts: [300, 700, 900, 500] across sizes S, M, L, XL.

ADDITION AND SUBTRACTION OF MATRICES

The sum or difference of two matrices is calculated by adding or subtracting the corresponding elements of the matrices. To add or subtract matrices, they must have the same dimensions.

PRODUCTION REQUIREMENT: To calculate total orders for both universities, add corresponding elements of matrices S and R. For small T-shirts: 100 (U of S) + 60 (U of R) = 160 total. The full sum yields total requirements.

OVERPRODUCTION: To determine over-production, subtract the total order matrix from the production matrix P. For small T-shirts: 300 (produced) - 160 (ordered) = 140 over-produced.

📌 Example: Over-production calculation for small T-shirts: Production = 300, Total orders = 100 + 60 = 160, Over-production = 300 - 160 = 140.

MULTIPLY A MATRIX BY A SCALAR

Given a matrix A and a number c, the scalar multiplication cA is computed by multiplying the scalar c by every element of A.

MULTIPLICATION OF MATRICES

Consider two competing companies, A and B, selling juice in 591 mL, 1 L, and 2 L bottles at prices of Rs. 1.60, Rs. 2.30, and Rs. 3.10, respectively. Sales for July are: Company A: [20,000, 5,500, 10,600] and Company B: [18,250, 7,000, 11,000] for the three bottle sizes. Total revenue is found by multiplying the sales matrix by the price matrix.

The sales data forms a 2×3 matrix S, prices form a column matrix P, and total revenue forms a column matrix R. Revenue is calculated by multiplying number of sales by selling price. The product of a row and a column is defined as the number obtained by multiplying corresponding entries (first by first, second by second, etc.) and adding the results.

🔑 Definition — Matrix multiplication: If matrix A is an m×n matrix and matrix B is an n×p matrix, then the product AB is the m×p matrix whose entry in the i-th row and j-th column is the product of the i-th row of A and the j-th column of B.

📐 Formula: For matrix multiplication, number of columns of A must equal number of rows of B. The resulting matrix has dimensions (rows of A) × (columns of B).

📌 Example: Company A's total revenue = (20,000 × 1.60) + (5,500 × 2.30) + (10,600 × 3.10) = sum of products. Company B's total revenue = (18,250 × 1.60) + (7,000 × 2.30) + (11,000 × 3.10).

MULTIPLICATION CHECKS: For product AB with A = 3×3 and B = 3×2, the product exists because inner dimensions match (# columns of A = # rows of B = 3), and the product matrix is 3×2. For product BA with B = 3×2 and A = 3×3, the product does NOT exist because inner dimensions do not match (# columns of B = 2 ≠ # rows of A = 3).

💡 Why this matters: Understanding when matrix multiplication is possible is critical for business calculations like revenue, cost, and production planning.

MULTIPLICATIVE INVERSES

Real Numbers: Two non-zero real numbers are multiplicative inverses of each other if their product, in both orders, is 1. The multiplicative inverse of a real number x is 1/x, since x × (1/x) = 1 and (1/x) × x = 1.

📌 Example: The multiplicative inverse of 5 is 1/5, since 5 × (1/5) = 1 and (1/5) × 5 = 1.

Matrices: Two 2×2 matrices are inverses of each other if their products, in both orders, is a 2×2 identity matrix (a matrix with 1s on the main diagonal and 0s elsewhere). The multiplicative inverse of a 2×2 matrix A is denoted A⁻¹.

🔑 Definition — Identity matrix: A square matrix with 1s on the main diagonal (from top-left to bottom-right) and 0s everywhere else.

📌 Example: The multiplicative inverse of matrix [2 1; 5 3] is matrix [3 -1; -5 2]. Their product in both orders equals the identity matrix [1 0; 0 1].

⭐ Key Takeaways

A matrix is a rectangular arrangement of data in rows and columns, useful for organizing business information like orders, production, and sales. Matrix addition and subtraction require matrices of the same dimensions, with operations performed on corresponding elements. Matrix multiplication requires the number of columns in the first matrix to equal the number of rows in the second, and the resulting product yields a matrix where each element is the sum of products of corresponding row and column entries. Scalar multiplication involves multiplying every element of a matrix by a constant. The multiplicative inverse of a matrix, when it exists, produces the identity matrix when multiplied in either order, analogous to the reciprocal of a real number.

🧠 Quick Revision Questions

1. What condition must be satisfied for two matrices to be added or subtracted?
2. How is scalar multiplication of a matrix performed?
3. What is the rule for determining whether matrix multiplication AB is possible, and what are the dimensions of the resulting product?
4. If matrix A is 2×3 and matrix B is 3×4, what is the dimension of the product AB?
5. What is the identity matrix for a 2×2 matrix, and what property does it have with respect to multiplication?

📘 Lecture 11 — Matrices

📖 Overview: This lecture covers three key matrix functions in Microsoft Excel — MINVERSE, MDETERM, and MMULT — along with the practical applications of ratios and proportions. Understanding these topics is essential for solving systems of equations, performing matrix algebra in business contexts, and allocating resources proportionally.

🗂️ Topics Covered

The lecture begins by reviewing three Microsoft Excel matrix functions: MINVERSE (for finding the inverse of a matrix), MDETERM (for calculating the determinant of a matrix), and MMULT (for multiplying two matrices). It then introduces the concept of ratios as comparisons between quantities, followed by proportions as equations stating that two ratios are equal. Finally, it demonstrates how to use ratios and proportions for estimating unknown quantities in real-world business scenarios.

📝 Lecture Summary

Matrix Functions in MS Excel

The three main matrix functions in Microsoft Excel are MINVERSE, MDETERM, and MMULT. These functions allow users to perform advanced matrix operations directly in spreadsheets.

MINVERSE

MINVERSE returns the inverse matrix for a matrix stored in an array. The function requires a numeric array with an equal number of rows and columns (a square matrix).

🔑 Definition — MINVERSE(array): Returns the inverse of a square matrix stored in a cell range or array constant.

📐 Formula: For a 2×2 matrix [a b; c d], the inverse is: MINVERSE = [d/(ad-bc) b/(bc-ad); c/(bc-ad) a/(ad-bc)]

📌 Example: Find the multiplicative inverse of matrix [4 -1; 2 0]

1. Enter data in cells A4:B5 (4, -1 in row 1; 2, 0 in row 2)
2. Select cells A6:B7 (four cells for the result)
3. Press F2, type =MINVERSE(A4:B5)
4. Press Ctrl+Shift+Enter simultaneously
5. The inverse appears in cells A6:B7

💡 Why this matters: The product of a matrix and its inverse yields the identity matrix (diagonal = 1, all others = 0). This is fundamental for solving systems of linear equations.

Remarks:

• Array can be a cell range (A1:C3), array constant ({1,2,3;4,5,6;7,8,9}), or a name
• Empty cells or text return #VALUE! error
• Non-square matrices return #VALUE! error
• Formulas returning arrays must be entered as array formulas (Ctrl+Shift+Enter)
• Accuracy is approximately 16 digits
• Non-invertible matrices (determinant = 0) return #NUM! error

MDETERM

MDETERM returns the matrix determinant of an array. The determinant is a single number derived from the values in a square array.

🔑 Definition — MDETERM(array): Returns the determinant (a scalar value) of a square matrix.

📐 Formula: For a 3×3 matrix A1:C3: MDETERM(A1:C3) = A1*(B2C3-B3C2) + A2*(B3C1-B1C3) + A3*(B1C2-B2C1)

📌 Example: For a 4×4 matrix in cells A14:D17, MDETERM returns 88.

Additional examples:

• =MDETERM({3,6,1;1,1,0;3,10,2}) returns 1
• =MDETERM({3,6;1,1}) returns -3
• =MDETERM({1,3,8,5;1,3,6,1}) returns #VALUE! (not square)

⚠️ Note: Determinants are used for solving systems of equations. A singular matrix (determinant = 0) cannot be inverted.

MMULT

MMULT returns the matrix product of two arrays. The result has the same number of rows as array1 and the same number of columns as array2.

🔑 Definition — MMULT(array1, array2): Returns the product of two matrices as an array.

📐 Formula: The element at row i, column j of the product is: aᵢⱼ = Σ(bᵢₖ × cₖⱼ) where k is the common dimension

📌 Example: Find AB where A = [1 3; 7 2] and B = [2 0; 0 2]

1. Enter array1 (A) in cells A25:B26 and array2 (B) in D25:E26
2. Select cells A29:B30 (2×2 result)
3. Press F2, type =MMULT(A25:B26, D25:E26)
4. Press Ctrl+Shift+Enter
5. Product AB appears in A29:B30

⚠️ Rule: The number of columns in array1 must equal the number of rows in array2. Both arrays must contain only numbers. Empty cells or text return #VALUE! error.

Ratio

A ratio is a comparison between things. It is written as a:b and read as "a is to b." The order matters — a ratio of 2:1 is not the same as 1:2.

🔑 Definition — Ratio: A comparison between two or more quantities, expressed as a:b.

📐 Calculation method:

1. Find the minimum value among all quantities
2. Divide all values by the smallest value

📌 Example: Three friends invest — Ali Rs. 7,800, Fawad Rs. 5,200, Tanveer Rs. 6,500

• Smallest value = 5,200
• Ali: 7,800/5,200 = 1.5
• Fawad: 5,200/5,200 = 1
• Tanveer: 6,500/5,200 = 1.25
• Ratio = 1.5 : 1 : 1.25

💡 Why this matters: Ratios allow comparison of different quantities on a common scale, essential for financial analysis, resource allocation, and recipe scaling.

Proportion

A proportion is an equation that states two ratios are equal. For example, 3:4 = 6:8 or 3/4 = 6/8. When one number is unknown, cross-multiplication is used to find it.

🔑 Definition — Proportion: An equation stating that two ratios are equal.

📐 Formula: a:b = c:d → a/b = c/d → a × d = b × c (cross-multiplication)

📌 Example 1: Sales ratio of Product X to Y is 4:3. If X sales are forecast at Rs. 180,000, find Y sales.

• 180,000 : Y = 4 : 3
• 180,000/Y = 4/3
• Cross-multiply: 180,000 × 3 = 4 × Y
• 4Y = 540,000
• Y = 135,000 Rs.

Excel formula: =B71/B70*D70 where B70=4 (ratio X), B71=3 (ratio Y), D70=180,000 (sales X)

📌 Example 2: Hospital expansion — 500 beds to 100 beds. Currently 200 nurses, 150 other staff.

• Nurses needed: N₂ = (100/500) × 200 = 40
• Other staff needed: O₂ = (100/500) × 150 = 30

📌 Example 3: Fruit punch recipe — mango:apple:orange = 3:2:1. Find quantities for 2 liters.

• Total parts = 3+2+1 = 6
• Mango: (3/6) × 2 = 1.0 liter
• Apple: (2/6) × 2 = 0.67 liter
• Orange: (1/6) × 2 = 0.33 liter

Excel formulas: Mango = B20/B23D23, Apple = B21/B23D23, Orange = B22/B23*D23

⭐ Key Takeaways

The three essential Excel matrix functions are MINVERSE (for inverses), MDETERM (for determinants), and MMULT (for multiplication) — all must be entered as array formulas using Ctrl+Shift+Enter. A ratio compares quantities by dividing each by the smallest value, and order matters (2:1 ≠ 1:2). A proportion equates two ratios and is solved using cross-multiplication. For estimating unknown quantities, use the ratio of the unknown to the known (e.g., new_value = (ratio_unknown/ratio_known) × known_value). Matrix functions are critical for solving systems of equations, while ratios and proportions are fundamental for resource allocation, recipe scaling, and financial forecasting.

🧠 Quick Revision Questions

1. What keyboard shortcut is required to enter an array formula in Excel, and why is it necessary for MINVERSE, MDETERM, and MMULT?
2. How do you calculate the multiplicative inverse of a 2×2 matrix manually, and what condition makes a matrix non-invertible?
3. A hospital has 800 beds, 320 nurses, and 240 other staff. If it expands by 200 beds, how many additional nurses and other staff are needed?
4. Three partners invest Rs. 12,000, Rs. 8,000, and Rs. 10,000. What is the ratio of their investments in simplest form?
5. If the sales ratio of two products is 5:2 and the first product's sales are Rs. 250,000, what must the second product's sales be to maintain this ratio?

📘 Lecture 12 — Ratio and Proportion / Merchandising

📖 Overview: This lecture introduces the concepts of ratio and proportion, demonstrating how to estimate unknown quantities when only partial data is available. It then transitions into merchandising, covering trade discounts, list prices, and the roles of stakeholders in the distribution chain. Understanding these concepts is essential for solving real-world business and pricing problems.

🗂️ Topics Covered

The lecture covers estimating using ratios with two detailed examples, proportion and its fundamental property, solving for unknown values in proportions, and an introduction to merchandising including stakeholders, list price, and trade discounts. Excel calculations are also demonstrated for ratio problems.

📝 Lecture Summary

Estimating Using Ratios-Example 1

When only one quantity is known from a ratio, we can estimate the total quantity. The method uses the ratio of the unknown to the known quantity. For a punch recipe with a ratio of mango juice, apple juice, and orange juice at 3:2:1, if you have 1.5 liters of orange juice, you can calculate the other quantities. Using the ratio, mango juice = (3/1) × 1.5 = 4.5 liters, apple juice = (2/1) × 1.5 = 3.0 liters, and total punch = 4.5 + 3.0 + 1.5 = 9 liters.

🔑 Definition — Ratio: A comparison of two or more quantities, often expressed as a:b or a/b, indicating their relative sizes. 📐 Formula: Unknown Quantity = (Ratio of Unknown / Ratio of Known) × Known Quantity → This allows finding missing values when one quantity is known. 📌 Example: Punch recipe ratio 3:2:1, with 1.5 L orange juice. Mango = (3/1)×1.5 = 4.5 L, Apple = (2/1)×1.5 = 3.0 L. Total punch = 4.5 + 3.0 + 1.5 = 9 L.

Estimating Using Ratios-Example 2

This example uses a ratio with a decimal value. The punch ratio is 3:2:1.5, and you have 500 milliliters of orange juice. Mango juice = (3/1.5) × 500 = 1000 liters, apple juice = (2/1.5) × 500 = 667 liters, and total punch = 1000 + 667 + 500 = 2167 liters. The Excel formula used is Mango juice = B45/B47*D47.

📐 Formula: For ratio a:b:c with known c, total quantity = (a/c)×known + (b/c)×known + known. 📌 Example: Ratio 3:2:1.5, orange juice = 500 L. Mango = (3/1.5)×500 = 1000 L, Apple = (2/1.5)×500 = 667 L. Total = 2167 L.

Example

In a class, the ratio of passing to failing grades is 7:5. Out of 36 students, the proportion who failed is 5/12 (since 7+5=12 total parts). Then (5/12) × 36 = 15 students failed.

🔑 Definition — Proportion: An equation stating that two ratios are equal, written as a/b = c/d. 📐 Formula: (5/12) × 36 = 15 → Multiply the fraction representing the desired category by the total number. 📌 Example: Ratio 7:5, total students 36. Failed students = (5/(7+5)) × 36 = (5/12) × 36 = 15.

Proportion

In a proportion a/b = c/d, the values in the "b" and "c" positions are called the means, while the values in the "a" and "d" positions are called the extremes. The fundamental property is that the product of the means equals the product of the extremes: ad = bc.

🔑 Definition — Means: In a proportion a/b = c/d, the middle terms (b and c) are called the means. 🔑 Definition — Extremes: In a proportion a/b = c/d, the outer terms (a and d) are called the extremes. 📐 Formula: ad = bc → The product of the extremes equals the product of the means. 💡 Why this matters: This property allows us to verify if two ratios form a proportion and to solve for unknown values.

Proportion-Examples

To check if 24/140 is proportional to 30/176, cross multiply: 140×30 = 4200 and 24×176 = 4224. Since 4200 ≠ 4224, the ratios are not proportional.

📌 Example: Check 24/140 = 30/176. Cross multiply: 140×30 = 4200, 24×176 = 4224. Not proportional (4200 ≠ 4224).

Proportion Example 1

Find the unknown value in 2:x = 3:9. Convert to fractions: 2/x = 3/9. Cross multiply: 2×9 = 3x → 18 = 3x → x = 6.

📌 Example: 2:x = 3:9 → 2/x = 3/9 → 18 = 3x → x = 6.

Proportion Example 2

Find the unknown in (2x+1):2 = (x+2):5. Convert to fractions: (2x+1)/2 = (x+2)/5. Cross multiply: 5(2x+1) = 2(x+2) → 10x + 5 = 2x + 4 → 8x = -1 → x = -1/8.

📌 Example: (2x+1):2 = (x+2):5 → (2x+1)/2 = (x+2)/5 → 10x+5 = 2x+4 → 8x = -1 → x = -1/8.

Merchandising

Merchandising covers understanding ordinary dating notation for invoice payment terms, solving pricing problems involving markups and markdowns, calculating net price after single or multiple trade discounts, calculating equivalent single discount rates, and calculating cash discount amounts.

🔑 Definition — Merchandising: The activities involved in promoting and selling products, including pricing, discounts, and payment terms.

Stakeholders in Merchandising

The main stakeholders are the manufacturer, middleman, retailer, and consumer. Discounts occur at all levels in this chain. A middleman buys products from the manufacturer and sells either at retail prices to the public or at wholesale prices to a distributor.

🔑 Definition — Middleman: A person who buys products from the manufacturer and sells them to retailers or consumers, serving as an intermediary in the distribution chain.

List Price or Retail Price

List price is the manufacturer's suggested retail price. It depends on the product itself, the built-in profit margin, and supply and demand. Resellers buy products in bulk at a substantial discount to make a profit when selling at or below list price.

🔑 Definition — List Price: The manufacturer's suggested retail price for a product, from which discounts are often given.

Trade Discount

Trade discount is a percentage reduction from the list price given to resellers. If L is the list price and d is the discount percentage, then amount of discount = d × L, and net price = L - Ld = L(1-d).

🔑 Definition — Trade Discount: A reduction from the list price offered to buyers in the distribution chain, expressed as a percentage of the list price. 📐 Formula: Net Price = L(1-d) → List price multiplied by (1 minus the discount rate) gives the final price after discount. 📐 Formula: Amount of Discount = d × L → The discount rate multiplied by the list price gives the dollar amount of the discount. 📌 Example: If list price is $100 and trade discount is 20%, net price = 100(1-0.20) = $80, and discount amount = 0.20 × 100 = $20.

⭐ Key Takeaways

Ratios allow estimating unknown quantities when only one part is known by using the proportion of each part relative to the known part. A proportion is an equality of two ratios, with the fundamental property that the product of means equals the product of extremes. In merchandising, the list price is the suggested retail price from which trade discounts are subtracted to arrive at the net price. The main stakeholders in merchandising include manufacturers, middlemen, retailers, and consumers. The net price formula is L(1-d), where L is list price and d is the discount rate.

🧠 Quick Revision Questions

1. In a punch recipe with ratio 3:2:1, if you have 2 liters of mango juice, how much punch can you make?
2. Are 15/25 and 9/15 proportional? Verify using the means-extremes property.
3. Solve for x in the proportion: (3x + 1):4 = (2x - 1):3.
4. What is the net price of an item with a list price of $500 and a trade discount of 30%?
5. What is the amount of trade discount if the list price is $250 and the discount rate is 15%?

📘 Lecture 13 — Mathematics of Merchandising

📖 Overview: This lecture covers the mathematics behind retail pricing, focusing on how markup and markdown are used to determine selling prices. It explains how to calculate markup as a percentage of cost or sale price, and how to compute markdowns and trade discounts, which are essential for business decision-making.

🗂️ Topics Covered

The lecture reviews markup as a percentage of cost and sale price, including calculations for Rs markup and markup rate. It then covers markdown as a percentage of current selling price and Rs markdown, followed by an introduction to trade discount, including single trade discount calculations and net price determination. Examples and Excel-based calculation methods are provided for each concept.

📝 Lecture Summary

MARKUP

Markup is an amount added to a cost price to calculate a selling price. It accounts for overhead and profit. Markup can be expressed as a percentage of cost, a percentage of sale, or in rupees (Rs markup).

Markup as Percentage of Cost (MUC): Here markup is some percentage of the cost price, also called %Markup on cost.

📐 Formula: Selling Price = Cost price + (Cost price × %Markup on cost) = Cost price (1 + %Markup on cost)

Markup as Percentage of Sale price (MUS): Here markup is some percentage of the selling price, also called %Markup on sale.

📐 Formula: Selling Price = Cost price + (Selling price × %Markup on sale) 📐 Formula: Cost price = Selling price – (Selling price × %Markup on sale) = Selling price (1 – %Markup on sale)

Rs Markup: Markup in terms of rupees.

📐 Formula:

1. Selling Price = Cost price + Rs Markup
2. Rs Markup = %Markup on cost × Cost price
3. Rs Markup = %Markup on sale × Selling price

📌 Example: The cost price of a certain item is 80Rs and its selling price is 100Rs. Then Rs Markup = 100 – 80 = 20 Rs.

💡 Why this matters: If a percentage is given as markup without specifying whether it is on cost or sale, it is understood to be %markup on cost.

EAMPLE 1

A golf shop pays its wholesaler 2,400Rs for a club, and sells it for 4,500Rs. What is the markup rate?

Calculation of Markup: Cost price = 2400Rs, Selling price = 4500Rs.

Step 1: Calculate Rs markup: Rs markup = 4500 – 2400 = 2100Rs

Step 2: Calculate %Markup on cost: %Markup on cost = (Rs markup / Cost price) × 100% = (2100 / 2400) × 100% = 87.5%

The markup rate is 87.5%.

Calculation using EXCEL: Enter wholesale price 2400 in cell B5, sale price 4500 in cell B6. Enter formula for Rs. Markup =B6-B5 in cell B7 (answer 2100). Enter formula for % markup =B7/B5*100 in cell B8 (answer 87.5%).

MARKUP-EXAMPLE 2

A computer software retailer used a markup rate of 40%. Find the selling price of a computer game that cost the retailer Rs. 1,500.

Markup: The markup is 40% on cost. Rs Markup = %Markup on cost × Cost price = (0.40)(1,500) = Rs. 600

Selling Price: Selling Price = Cost price + Rs Markup = 1,500 + 600 = Rs. 2,100

The item sold for Rs. 2,100.

Calculation using EXCEL: Enter wholesale price 1500 in cell B17. Enter % Markup in cell B18. Enter formula =(1+B18/100)*B17 in cell B19 (answer 2100).

MARKDOWN

Markdown means a reduction from the original sale price to stimulate demand, take advantage of reduced costs, or force competitors out of the market. Markdown can be expressed as a percentage of current selling price or Rs markdown.

Markdown as Percentage of current selling price: Also called percent markdown (%markdown).

📐 Formula: New selling price = Current selling price – (Current selling price × %markdown) = Current selling price (1 - %markdown)

Rs Markdown: Markdown in terms of rupees.

📐 Formula:

1. New selling price = Current selling price – Rs Markdown
2. Rs markdown = Current selling price × %markdown

📌 Example: An item originally priced at 3,300 Rs is marked 25% off. What is the sale price?

Markdown: Rs markdown = original price × %markdown = (0.25)(3300) = 825Rs

Selling Price: New Selling price = 3,300 – 825 = 2,475Rs

The sale price is 2,475 Rs.

Calculation using EXCEL: Enter original price 3300 in cell B28. Enter % Markdown 25 in cell B29. Enter formula for Rs. Markdown (=B29/100*B28) in cell B30 (result 825). Enter formula for new sale price (=B28-B30) in cell B31. Alternatively, use formula (=(1-B29/100)*B28).

DISCOUNT

Discount is a reduction in price which the seller offers to the buyer. Types include: Trade discount, Cash discount, Seasonal discount, etc.

TRADE DISCOUNT

When a manufacturer or wholesaler offers goods for sale, a list price or retail price is set for each item. A discount on the list price granted by a manufacturer or wholesaler to buyers in the same trade is called trade discount. It represents a reduction in list price in return for quantity purchases.

📐 Formula:

1. Rs Trade discount = list price × discount rate
2. Net price = list price – Rs trade discount

Types of trade discounts: Single trade discount, Multiple or series trade discount.

SINGLE TRADE DISCOUNT-EXAMPLE 1

The price of office equipment is 3000 Rs. The manufacturer offers a 30% trade discount. Find the net price and the trade discount amount.

Discount Amount: Amount of discount = dL = 0.3 × 3000 = 900 Rs.

Net Price: Net Price = L(1 – d) = 3000(1 – 0.3) = 3000(0.7) = 2100 Rs.

The net price is 2100 Rs and the discount amount is 900 Rs.

Calculation using EXCEL: Enter price of equipment 3000 in cell B39. Enter % trade Discount 30 in cell B40. Enter formula for Rs. Discount =B40/100*B39 in cell B41 (result 900). Enter formula for net price =B39-B41 in cell B42 (result 2100).

⭐ Key Takeaways

The most critical concepts from this lecture are: understanding the distinction between markup on cost versus markup on sale price, as the formulas differ (cost-based uses multiplication by 1+ rate, while sale-based uses 1-rate). Markdown is always calculated as a percentage of the current selling price, reducing it to a new lower price. Trade discount reduces the list price to a net price using a discount rate. All calculations can be performed in Excel using simple arithmetic formulas, which helps verify intermediate steps. Remember that when markup percentage is given without specification, it is assumed to be %markup on cost.

🧠 Quick Revision Questions

1. What is the formula for selling price when markup is given as a percentage of cost?
2. If an item costs 500 Rs and is sold for 700 Rs, what is the Rs markup and the %markup on cost?
3. A store offers a 15% markdown on an item originally priced at 2,000 Rs. What is the new selling price?
4. What is the difference between a trade discount and a markdown?
5. If a product has a list price of 5,000 Rs and a 20% trade discount is applied, what is the net price?

📘 Lecture 14 — Mathematics of Merchandising Part 2

📖 Overview: This lecture continues the study of merchandising mathematics by focusing on series trade discounts. It explains how multiple discounts are applied sequentially to a list price, how to calculate single equivalent discount rates, and introduces cash discounts for prompt payment. Understanding these concepts is essential for pricing, purchasing, and financial decision-making in business.

🗂️ Topics Covered

The lecture begins with a review of trade discounts from Lecture 13, then introduces series trade discounts and their calculation method. It covers finding net price from list price using multiple discount rates, computing list price from net price, calculating single equivalent discount rates, and understanding cash discount terms like "2/10, net/30". Excel applications are demonstrated for each calculation.

📝 Lecture Summary

SERIES TRADE DISCOUNT

This refers to giving further discounts as incentives for more sales, usually offered for selling products in bulk. When series discounts of 15%, 10%, and 5% are offered on a list price L, the net price is calculated by applying each discount sequentially. First, subtract 15% of L from L to get L₁. Then subtract 10% of L₁ from L₁ to get L₂. Finally, subtract 5% of L₂ from L₂ to get the net price. Alternatively, N = L(1 – d₁)(1 – d₂)(1 – d₃) where d₁ = 15%, d₂ = 10%, d₃ = 5%. The total discount is not the sum of the percentages (15% + 10% + 5% = 30%).

🔑 Definition — Series Trade Discount: Multiple discounts applied sequentially to a list price, where each discount is applied to the reduced price from the previous step.

📐 Formula: N = L(1 – d₁)(1 – d₂)(1 – d₃)... where N = net price, L = list price, d₁, d₂, d₃... = discount rates as decimals.

📌 Example: Office furniture has list price Rs. 20,000 with series discounts 20%, 10%, 5%. Net price = 20,000(1-0.2)(1-0.1)(1-0.05) = 20,000(0.8)(0.9)(0.95) = 20,000(0.6840) = Rs. 13,680.

LIST PRICE

When only the net price and trade discount rate are known, the list price can be found by rearranging the discount formula. The relationship is Net Price = L(1 – d), so L = N / (1 – d).

📐 Formula: L = N / (1 – d) where L = list price, N = net price, d = discount rate as decimal.

📌 Example: An order for power tools has a Rs. 2,100 net price after a 30% trade discount. L = 2,100 / (1 – 0.3) = 2,100 / 0.7 = Rs. 3,000.

💡 Why this matters: Businesses often know what they paid (net price) and the discount rate, but need to find the original list price for inventory valuation or pricing strategies.

TRADE DISCOUNT — FINDING SINGLE EQUIVALENT DISCOUNT RATE

To find a single discount rate equivalent to a series of discounts, apply the series to a list price of Rs. 100 (a convenient base). The net price calculated represents the percentage of list price that is paid, so the single equivalent discount rate is 100% minus this net price percentage.

🔑 Definition — Single Equivalent Discount Rate: A single discount percentage that produces the same net price as applying a series of discounts sequentially.

📌 Example 1: Find single discount equivalent to series 15%, 10%, 5%. Apply to Rs. 100: Net price = 100(0.85)(0.9)(0.95) = 72.68. Single equivalent discount = 100 – 72.68 = 27.62%.

📌 Example 2: Car parts priced at Rs. 20,000 with series 20%, 8%, 2%. Net price on Rs. 100 = 100(0.8)(0.92)(0.98) = 72.13. Single equivalent discount = 100 – 72.13 = 27.87%. Rs. discount = 0.2787 × 20,000 = Rs. 5,574.

CASH DISCOUNT

A seller always desires prompt payment, so a cash discount is given for the early payment of dues. This benefits both parties — the buyer saves money while the seller gets funds sooner. Cash discount is allowed on invoices, returned goods, freight, sales tax, etc.

🔑 Definition — Cash Discount: A discount offered to encourage prompt payment of an invoice within a specified time period.

📌 Key Business Phrase: "3/10, net/30" means a 3% discount is offered if paid within 10 days; otherwise, the full amount is due in 30 days. For Rs. 100 due, buyer pays Rs. 97 within 10 days or Rs. 100 within 30 days.

DISCOUNT PERIODS AND CREDIT PERIODS

Discount Periods are the time frames within which the buyer must pay to take advantage of discount terms. Credit Periods are the times given for buyers to pay invoices within specified limits.

📌 Example: Invoice dated May 1st with terms 2/10 means 2% discount if paid by May 10th. For Rs. 50,000 invoice: N = 50,000(1 – 0.02) = 50,000(0.98) = Rs. 49,000.

💡 Why this matters: Cash discounts directly impact a company's cash flow. Buyers must calculate whether the discount is worth paying early, while sellers use this to accelerate receivables.

⭐ Key Takeaways

Series trade discounts are applied sequentially, not added together — the formula N = L(1 – d₁)(1 – d₂)(1 – d₃) must be used. The total discount from a series is always less than the sum of individual percentages. To find a single equivalent discount rate, assume a list price of Rs. 100 and subtract the resulting net price from 100. Cash discount terms like "2/10, net/30" define specific time windows (discount periods and credit periods) within which payment must occur to receive the discount. Excel formulas can automate all these calculations, making them efficient for business applications.

🧠 Quick Revision Questions

1. If series discounts of 25%, 10%, and 5% are offered on a list price of Rs. 50,000, what is the net price? Show your calculation.

2. What is the single equivalent discount rate for the series 20%, 15%, and 10%? Use the Rs. 100 method.

3. An invoice of Rs. 30,000 has terms "4/15, net/45". If paid on day 12, what amount should be paid?

4. Why is it incorrect to simply add 15% + 10% + 5% = 30% as the total discount when applying series trade discounts?

5. If the net price is Rs. 5,100 after a 15% trade discount, what was the list price?

📘 Lecture 15 — Mathematics of Merchandising Part 3

📖 Overview: This lecture focuses on the mathematics behind merchandising decisions, including partial payments on invoices and the critical distinction between markup on cost and markup on selling price. Understanding these concepts is essential for setting profitable selling prices and managing cash discounts in business transactions.

🗂️ Topics Covered

The lecture begins with a review of partial payments, explaining how cash discounts apply to part payments on invoices. It then introduces key marketing and financial terms including manufacturer cost, selling price, and the distribution chain. A major portion is dedicated to explaining margin versus markup, with detailed examples showing how to calculate selling price, cost, and rupee markup using both cost-based and sale-based markups. The lecture concludes with formulas for converting between markup on cost and markup on selling price.

📝 Lecture Summary

Partial Payments

When you buy on credit with cash discount terms, part of the invoice may be paid within the specified time. These part payments are called Partial Payments.

In the example: You owe Rs. 40,000 with terms 3/10 (3% discount by 10th day). Within 10 days you sent a payment of Rs. 10,000.

First, find the amount (t) that when given a 3% discount, equals Rs. 10,000: 10000 = t (1 – 0.03) t = 10000 / (1 – 0.03) t = 10309 Rs.

This means although you pay Rs. 10,000, due to the 3% cash discount, Rs. 10,309 of the Rs. 40,000 is considered paid. Hence, the new balance = 40000 – 10309 = 29691 Rs.

🔑 Definition — Partial Payment: A payment made on an invoice within the discount period that is less than the full invoice amount, where the discount applies to the portion being paid.

Marketing Terms

There are several important marketing terms. Manufacturer Cost is the cost of manufacturing. Next is the price charged to middlemen in The Distribution Chain, which flows: Distributor > Wholesaler > Retailer. Selling Price is the price charged to consumers by retailers. It may or may not be the same as list price.

Marketing, Operating Expenses and Selling Price

Gross Sales less Cost of Goods Sold gives the Gross Profit. The Gross Profit less the Operating Expenses gives the Net Profit.

Operating Expenses are expenses the company incurs in operating the business, e.g. rent, wages and utilities.

Selling Price is composed of Cost and Rs Markup: Selling Price (S) = Cost (C) + Rs Markup (M)

Margin

While determining Sale Price, a company includes the operating expenses and profit to their own cost. This amount is called the margin of the company. It is usually calculated as a percentage but can also be expressed in rupees. It is also named as markup on sale.

Margin or markup on sale = (Selling price - Cost price) / Selling Price × 100%

Selling price = Cost price + Rs Margin

Margin and markup confuse many. By margin, a company evaluates how much is left over to cover basic operating costs and profit for every rupee generated in sales. Markup represents the amount added to a cost to arrive at a selling price.

Markup on cost = (Selling price – Cost price) / Cost price × 100%

Example: An item costs Rs. 50, and is sold for Rs. 100: Markup = (100 – 50) / 50 × 100% = 100% Margin = (100 – 50) / 100 × 100% = 50%

💡 Why this matters: The same numerical markup yields different percentages depending on whether it is calculated on cost or on selling price, which can significantly affect profit analysis.

Note: Remember unless it is mentioned that markup is on sale, simple markup means markup on cost.

Example

A computer’s cost is Rs. 9,000. An amount of Rs. 3,000 was added to this cost by the retailer to determine the sale price for the consumer. Thus, the selling price = 9,000 + 3,000 = 12,000 Rs. Rs. 3,000 is the margin available to meet expenses and make a profit.

Markup

If the Markup on cost is 33% then: Selling Price (S) = Cost (C) + {Cost (C) × Markup on cost (MUC)} S = C + (C × MUC) = C(1 + MUC)

Markup - Example

You buy candles for Rs. 10 and plan to sell them for Rs. 15. Rs. Markup = Selling price – Cost price = 15 – 10 = Rs. 5 %Markup on cost = 5/10 × 100% = 50%

Selling Price (Cost-Based Markup)

Fawad’s Appliances bought a sewing machine for Rs. 1,500. He needs a 60% Markup on Cost.

Rs. Markup = Cost price × %Markup on cost = 1,500 × 0.6 = 900 Rs.

Selling Price (S) = Cost (C) + Rs Markup (M) = 1,500 + 900 = 2,400 Rs.

Or using the formula: S = C(1 + MUC) = 1,500 × (1+0.6) = 1,500 × 1.6 = 2,400 Rs.

📌 Excel Calculation: With cost 1500 in cell F4 and 60% markup in cell F5, Rs. Markup = 60/100*1500 in cell F6, and Selling Price = F4+F6 in cell F7, giving result 2400.

Rs. Markup and Percent on Cost (Finding Cost)

Tanveer’s flower business sells floral arrangements for Rs. 35. He needs a 40% Markup on cost.

S = C + 0.40(C) 35 = 1.40(C) C = 35/1.4 = 25 Rs. Rs. Markup = 25 × 0.4 = 10 Rs.

📌 Excel Calculation: Selling price 35 in cell H15, % Markup on cost 40 in cell H16. Cost = 35/1.4 in cell H18. Rs. Markup = H18*H16/100 in cell H19, giving result 10.

Markup Again (Percent Markup on Selling Price)

You buy candles for Rs. 2 and plan to sell them for Rs. 2.50. Rs. Markup = 2.5 – 2 = 0.5 Rs.

As explained in lecture 13: Cost price = Selling price (1 – %Markup on sale)

Markup on selling price = (Selling price - Cost price) / Selling price × 100% Markup on Selling Price = (0.5/2.5) × 100% = 20%

📌 Excel Calculation: Purchase price 2 in cell E30, Sale price 2.5 in cell E31. Rs. Markup = E31-E30 in cell E32. % Markup on sale price = E32/E31*100 in cell E33, giving 20.

Selling Price (Sale-Based Markup)

Fawad’s Appliances bought a sewing machine for Rs. 1,500. He needs a 60% Markup on Selling price.

As explained in lecture 13: Selling Price = Cost price + (Selling price × %Markup on sale) S = 1,500 + 0.6S S - 0.6S = 1,500 0.4S = 1,500 S = 3,750 Rs.

Rs. Markup = 3,750 × 0.6 = 2,250 Rs.

📌 Excel Calculation: Purchase price 1500 in cell E39, % Markup on Sale Price 60 in cell E40. Sale Price = E39/(1-E40/100) in cell D41, giving 3750. Rs. Markup = E41-E39 in cell E42, giving 2250.

Basic formula: S = C + 0.6S, simplified to 0.4S = C, rewritten as S = C/0.4 = C/(1-mus).

Rs. Markup and Percent Markup on Cost (Finding Cost with Sale-Based Markup)

Tanveer’s flower business sells floral arrangements for Rs. 35. He needs a 40% Markup on Selling Price.

Selling Price = Cost price + (Selling price × %Markup on sale) 35 = C + (0.4 × 35) 35 = C + 14 C = 35 – 14 = 21 Rs.

Or alternatively: C = S - 0.4S = 0.6S = 0.6 × 35 = 21 Rs. Rs. Markup = 35 × 0.4 = 14 Rs.

📌 Excel Calculation: Sale price 35 in cell E50, % Markup on Sale Price 40 in cell E51. Cost = E50*(1-E51/100) in cell D52, giving 21. Rs. Markup = E50-E52 in cell E53, giving 14.

Converting Markups

Convert 50% Markup (MU) on Cost to %MU on Sale

The formula for converting %Markup on Cost (muc) to %Markup on Selling Price (mus) is: mus = muc / (1 + muc)

Solution: mus = 0.5 / (1+0.5) = 0.5/1.5 = 0.3333 = 33.33%

Convert 33.33% MU on Sale to %MU on Cost

The formula for converting %Markup on Sale (mus) to %Markup on Cost (muc) is: muc = mus / (1 - mus)

Solution: Markup on cost = 0.3333/(1 – 0.333) = 0.3333/0.6666 = 0.5 = 50%

📌 Excel Calculation: Markup on sale 33.3 in cell E61. Markup on cost = (E61/100)/(1-E61/100)*100 in cell E62, giving 50.

⭐ Key Takeaways

The lecture demonstrates that markup calculations fundamentally differ depending on the base used—cost versus selling price—and these cannot be used interchangeably without conversion. Partial payments involve "grossing up" the payment amount to account for the discount applicable to the paid portion. Margin (markup on sale) always yields a lower percentage than markup on cost for the same numerical markup. The conversion formulas between muc and mus are mus = muc/(1+muc) and muc = mus/(1-mus), which are critical for translating between pricing strategies. Mastery of the selling price formula S = C(1+MUC) for cost-based markup and S = C/(1-MUS) for sale-based markup is essential for solving for any unknown variable.

🧠 Quick Revision Questions

1. If an invoice of Rs. 50,000 has terms 2/10 and you send a partial payment of Rs. 20,000 on day 8, what is the new balance?
2. A retailer buys a product for Rs. 800 and wants a 25% markup on cost. What is the selling price?
3. How do you calculate margin (markup on sale) if the cost is Rs. 200 and selling price is Rs. 300?
4. Convert a 40% markup on cost to a markup on selling price.
5. If the selling price of an item is Rs. 120 and the markup on selling price is 20%, what is the cost?

📘 Lecture 16 — Mathematics of Merchandising PART 4

📖 Overview: This lecture covers markdowns (reductions from original selling price) and introduces project financial analysis concepts. It demonstrates how to calculate markdown percentages and sale prices, and provides an overview of key financial calculations used in project evaluation, including cost estimates, revenue forecasts, cash flows, benefit-cost analysis, internal rate of return, and break-even analysis.

🗂️ Topics Covered

The lecture begins with a review of markup concepts from Lecture 15, then introduces markdown calculations with examples. It then transitions to project financial analysis, covering cost estimates, revenue estimates, forecasts of costs and revenues, net cash flows, benefit-cost analysis, internal rate of return, and break-even analysis. Excel calculation methods are shown for markdown problems.

📝 Lecture Summary

Markdown

Markdown is defined as the reduction from the original selling price.

🔑 Definition — Markdown: Reduction from the original selling price.

📐 Formula: %Markdown = (Rs. Markdown / Selling Price (original)) × 100%

• Rs. Markdown = Old Selling Price – New Selling Price

Markdown – Example 1

Store A marked down a Rs. 500 shirt to Rs. 360.

Step 1: Rs. Markdown Let S = Sale price Rs. Markdown = Old S – New S = Rs. 500 – Rs. 360 = Rs. 140 Markdown

Step 2: % Markdown % Markdown = (Markdown / Old S) × 100% % Markdown = (140 / 500) × 100% = 0.28 × 100% = 28%

📌 Excel Calculation: Original price 500 in cell E73. Price after markdown 360 in cell E74. Rs. Markdown in cell E75 using formula =E73-E74 (result 140 in D75). % Markdown in cell E76 using =E75/E73*100 (result 28).

Markdown – Example 2

A variety of plastic jugs bought for Rs. 57.75 was marked up 45% of the selling price. When the jugs went out of production, they were marked down 40%. What was the sale price after the 40% markdown?

Part 1: Find Original Sale Price Let Selling price = 100 %Markup on selling price = 45% Cost = 100 – 45 = 55 Thus Original Sale price = (100/55) × 57.75 = Rs. 105

Part 2: Rs. Markdown %Markdown = 40% = 0.4 Rs. Markdown = 105 × 0.4 = Rs. 42

Part 3: Sale Price After Markdown Sale price after markdown = 105 – 42 = Rs. 63

📌 Excel Calculation: Purchase price 57.75 in cell F83. Selling price as 100 in cell F84. Rs. Markup in cell F85 using =F84-F83 (result 45 in F85). Original Sale Price in cell F87 using =F84/F86F83 (result 105 in E87). % Markdown as 40 in cell F88. Rs. Markdown in cell F89 using =F87F88/100 (result 42 in F89). Reduced price in cell F90 using =F87-F89 (result 63 in F90).

💡 Why this matters: Markdown calculations are essential for retail pricing strategies, clearance sales, and inventory management. The two-step process in Example 2 shows how to work backwards from cost and markup to find original price, then apply markdown.

Project Financial Analysis

Financial analysis is the analysis of the accounts and the economic prospects of a firm, which can be used to monitor and evaluate the firm's financial position, to plan future financing, and to designate the size of the firm and its rate of growth.

Key financial calculations required:

• Cost estimates
• Revenue estimates
• Forecasts of costs
• Forecasts of revenues
• Net cash flows
• Benefit cost analysis
• Internal Rate of Return
• Break-Even Analysis

Cost Estimates

In every project, you will be required to prepare a cost estimate. Such cost estimates cover calculations based on quantities and unit rates. Calculations are done in the form of tabular worksheets. In large projects, there may be a number of separate calculations for part projects. Component costs are then combined to calculate total cost. These are simple worksheet calculations unless conditional processing is required. Such conditional processing is useful if unit prices are to be found for a specific model from a large database.

Revenue Estimates

Along with costs, even revenues are calculated. These calculations are similar to component costs.

Forecasts of Costs

Forecasting requires a technique for projections. One such technique, Time Series Analysis, will be covered later in the course. Forecasting techniques vary from case to case. The applicable method should be determined first. Calculation of future forecasts can then be done through worksheets.

Forecasts of Revenues

These will be done similar to the forecast of costs. Here also the method must be determined first. Once the methodology is clear, the worksheets can be prepared easily.

Net Cash Flows

The difference between Revenue and Cost is called the Net Cash Flow. This is an important calculation as the entire Project Operation and Performance is based on its cash flows.

Benefit Cost Analysis

This is the end result of the Project Analysis. The ratio between Present Worth of Benefits and Costs is called the Benefit Cost (BC) Ratio. For a project to be viable without profit or loss, the BC Ratio must be 1 or more. Generally, a BC Ratio of 1.2 is considered acceptable. For public projects, even lesser BC ratio may be accepted for social reasons.

Internal Rate of Return

Internal Rate of Return (IRR) is that Discount Rate at which the Present Worth of Costs is equal to the Present Worth of Benefits. IRR is the most important parameter in Financial and Economic Analysis. There are a number of functions in EXCEL for calculation of IRR.

Break-Even Analysis

In every project where investment is made, it is important to know how long it takes to recover the investment. It is also important to find the breakeven point where the Cash Inflow becomes equal to Cash Outflow. After that point, the company has a positive cash flow (i.e., there is surplus cash after meeting expenses).

💡 Why this matters: These financial analysis concepts are foundational for evaluating project viability, making investment decisions, and understanding a firm's financial health through metrics like BC ratio and IRR.

⭐ Key Takeaways

Markdown is the reduction from original selling price, calculated as a percentage using the formula %Markdown = (Rs. Markdown / Original Selling Price) × 100%. When solving markdown problems involving both markup and markdown, first find the original selling price from cost and markup percentage, then apply the markdown percentage to find the reduced price. Project financial analysis involves multiple calculations including cost/revenue estimates, forecasts, and net cash flows. The Benefit-Cost (BC) Ratio must be at least 1 for project viability, with 1.2 generally acceptable. IRR is the discount rate where present worth of costs equals benefits, and break-even analysis identifies when cash inflows equal cash outflows.

🧠 Quick Revision Questions

1. A store marks down a Rs. 800 jacket to Rs. 600. What is the Rs. Markdown and % Markdown?
2. An item costing Rs. 120 was marked up 30% of selling price, then marked down 25%. What is the final sale price?
3. What is the formula for calculating %Markdown?
4. What is the significance of a Benefit-Cost (BC) Ratio of exactly 1.0?
5. Define Internal Rate of Return (IRR) in project financial analysis.

📘 Lecture 17 — Mathematics Financial Mathematics Introduction to Simultaneous Equations

📖 Overview: This lecture introduces Module 4, focusing on Financial Mathematics and the beginning of Linear Equations. It provides a comprehensive overview of Excel financial functions used for depreciation, loan calculations, and investment analysis. The lecture serves as a foundation for understanding break-even analysis and project financial evaluation, emphasizing practical application in business contexts.

🗂️ Topics Covered

The lecture covers Module 4 overview and project financial analysis components, followed by an extensive list of Excel financial functions including AMORDEGRC, AMORLINC, CUMIPMT, CUMPRINC, DB, DDB, MIRR, and IRR. Each function's syntax, parameters, and usage are explained with mathematical formulas and examples where applicable.

📝 Lecture Summary

Financial Mathematics

This section introduces Module 4 which covers Financial Mathematics (Lecture 17), Applications of Linear Equations (Lectures 17-18), and Break-even Analysis (Lectures 19-22). The Project Financial Analysis component includes cost estimates, revenue estimates, forecasts of costs, forecasts of revenues, net cash flows, benefit cost analysis, Internal Rate of Return, and Break-Even Analysis.

💡 Why this matters: Understanding these financial analysis tools is essential for evaluating project viability and making informed business investment decisions.

Excel Functions for Financial Analysis

This section details various Excel financial functions used in business mathematics.

AMORDEGRC returns the depreciation for each accounting period, taking into account prorated depreciation when an asset is purchased mid-period. A depreciation coefficient is applied depending on the life of the assets.

🔑 Definition — AMORDEGRC: A function that returns depreciation for each accounting period with a depreciation coefficient based on asset life. 📐 Formula Syntax: AMORDEGRC(cost,date_purchased,first_period,salvage,period,rate,basis)

• Cost: cost of the asset
• Date_purchased: date of purchase
• First_period: date of end of first period
• Salvage: salvage value at end of asset life
• Period: period for depreciation
• Rate: rate of depreciation
• Basis: year basis (0 or omitted = 360 days NASD, 1 = Actual, 3 = 365 days, 4 = 360 days European)

Remarks:

• Excel stores dates as sequential serial numbers (Jan 1, 1900 = 1; Jan 1, 2008 = 39448)
• Function returns depreciation until last period or until cumulative depreciation exceeds cost minus salvage
• Asset life calculated by (1 / "rate")
• Depreciation coefficient: 1.5 for life 3-4 years, 2 for 5-6 years, 2.5 for >6 years
• Rate grows to 50% for period preceding last, 100% for last period
• #NUM! error for life between 0-1, 1-2, 2-3, or 4-5 years

AMORLINC returns the depreciation for each accounting period, with prorated depreciation for mid-period purchases.

🔑 Definition — AMORLINC: A function that returns depreciation for each accounting period, similar to AMORDEGRC but without the depreciation coefficient.

📌 Example — AMORLINC:

• Data: Cost = 2400, Date purchased = 8/19/2008, End of first period = 12/31/2008, Salvage value = 300, Period = 1, Depreciation rate = 15%, Basis = 1 (Actual)
• Formula: =AMORLINC(A2,A3,A4,A5,A6,A7,A8) where cells contain the above data
• Result: First period depreciation = 360

CUMIPMT returns the cumulative interest paid between two periods (described in Lecture 8).

CUMPRINC returns the cumulative principal paid on a loan between two periods (described in Lecture 8).

DB returns the depreciation of an asset for a specified period using the fixed-declining balance method.

🔑 Definition — DB: A function that computes depreciation using the fixed-declining balance method at a fixed rate. 📐 Formula Syntax: DB(cost,salvage,life,period,month)

• Cost: initial cost of asset
• Salvage: value at end of depreciation
• Life: number of periods (useful life)
• Period: period for depreciation (same units as life)
• Month: number of months in first year (assumed 12 if omitted)

📐 Formulas:

• rate = 1 - ((salvage / cost) ^ (1 / life)), rounded to three decimal places
• Period depreciation: (cost - total depreciation from prior periods) * rate
• First period: cost * rate * month / 12
• Last period: ((cost - total depreciation from prior periods) * rate * (12 - month)) / 12

DDB returns the depreciation of an asset for a specified period using the double-declining balance method or another specified method.

🔑 Definition — DDB: A function that computes accelerated depreciation using the double-declining balance method. 📐 Formula Syntax: DDB(cost,salvage,life,period,factor)

• Cost: initial cost
• Salvage: value at end (can be 0)
• Life: useful life
• Period: period for depreciation
• Factor: rate of decline (2 if omitted = double-declining balance)

📐 Formula: Min( (cost - total depreciation from prior periods) * (factor/life), (cost - salvage - total depreciation from prior periods) )

MIRR returns the modified internal rate of return for a series of periodic cash flows, considering both the cost of investment and interest received on reinvestment of cash.

🔑 Definition — MIRR: A function that calculates the modified internal rate of return accounting for financing and reinvestment rates. 📐 Formula Syntax: MIRR(values,finance_rate,reinvest_rate)

• Values: array of payments (negative) and income (positive) at regular periods
• Finance_rate: interest rate paid on money used in cash flows
• Reinvest_rate: interest rate received on reinvested cash flows

IRR returns the internal rate of return for a series of cash flows.

🔑 Definition — IRR: A function that calculates the internal rate of return using an iterative technique. 📐 Formula Syntax: IRR(values,guess)

• Values: array of cash flows (must contain at least one positive and one negative)
• Guess: initial estimate (assumed 0.1 or 10% if omitted)

Remarks:

• Uses iterative technique, cycles until accurate within 0.00001%
• Returns #NUM! error if no result after 20 tries
• Order of values must match cash flow sequence

📌 Example — IRR:

• Data: Investment of 70,000 in cell A97 (negative cash flow), Revenue per year in cells A98 to A102 (years 1-5)
• Formula in A103: =IRR(A97:A101) — only years 1 to 4 selected
• Result: -2%
• Formula in A105: =IRR(A97:A102) — entire revenue stream considered
• Result: 9%
• Formula with guess: Considering only first 2 years with initial guess of -10%
• Result: -44%

⭐ Key Takeaways

1. Excel provides specialized financial functions (AMORDEGRC, AMORLINC, DB, DDB) for calculating different types of asset depreciation, each using distinct methods like fixed-declining balance, double-declining balance, and coefficient-based approaches.
2. Investment analysis functions (IRR, MIRR) evaluate project profitability by computing internal rates of return, requiring at least one positive and one negative cash flow value for calculation.
3. The basis parameter (0-4) in depreciation functions determines the day-count convention (360-day, actual, or 365-day years), significantly affecting depreciation calculations.
4. The DB function uses a fixed rate formula (rate = 1 - ((salvage/cost)^(1/life))) with special adjustments for first and last period calculations based on the month parameter.
5. IRR uses iterative calculation and may require a user-provided guess value if the default 10% assumption fails to converge within 20 iterations.

🧠 Quick Revision Questions

1. What is the syntax for the AMORDEGRC function and what does the "basis" parameter represent?
2. How does the depreciation coefficient change based on asset life in the AMORDEGRC function?
3. What formula does the DB function use to calculate the fixed depreciation rate?
4. In the IRR example, why did the result change from -2% to 9% when different cash flow ranges were selected?
5. What are the key differences between the MIRR and IRR functions in terms of what they account for?

📘 Lecture 18 — Mathematics Financial Mathematics Solve Two Linear Equations with Two Unknowns

📖 Overview: This lecture covers financial mathematics functions in Excel, including depreciation methods (AMORDEGRC, AMORLINC, DB) and present value functions (PV, NPV, XNPV). It also reviews solving two linear equations with two unknowns, building on concepts from Lecture 17.

🗂️ Topics Covered

The lecture reviews depreciation functions from Lecture 17 including AMORDEGRC, AMORLINC, and DB with additional examples. It then introduces present value (PV), net present value (NPV), and XNPV functions for investment analysis. The lecture concludes with methods for solving two linear equations with two unknowns.

📝 Lecture Summary

AMORDEGRC-EXAMPLE

The AMORDEGRC function returns depreciation for each accounting period using a French declining balance method. This function is primarily used in French accounting systems. The syntax requires parameters including cost, date purchased, first period end, salvage value, period, rate, and basis.

AMORLINC-EXAMPLE

The AMORLINC function returns depreciation for each accounting period using a French straight-line method. Unlike AMORDEGRC which uses declining balance, AMORLINC applies straight-line depreciation across periods. Each function requires similar input parameters but calculates depreciation differently.

DB-EXAMPLE

The DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. The syntax is DB(cost, salvage, life, period, month). This calculates depreciation at a fixed rate, with higher depreciation in early years and decreasing amounts over time.

ADDITIONAL DB_EXAMPLES

The DB function can handle partial-year depreciation by specifying the number of months in the first year. Examples show:

• =DB(A27,A28,A29,1,7) — Depreciation in first year with only 7 months calculated (186,083.33)
• =DB(A27,A28,A29,2,7) — Depreciation in second year (259,639.42)
• =DB(A27,A28,A29,3,7) — Depreciation in third year (176,814.44)
• =DB(A27,A28,A29,4,7) — Depreciation in fourth year (120,410.64)
• =DB(A27,A28,A29,5,7) — Depreciation in fifth year (81,999.64)
• =DB(A27,A28,A29,6,7) — Depreciation in sixth year (55,841.76)
• =DB(A27,A28,A29,7,5) — Depreciation in seventh year with only 5 months calculated (15,845.10)

💡 Why this matters: Partial-year depreciation is essential when assets are purchased mid-year, and the DB function automatically adjusts calculations to reflect the actual months of use.

PV

PV returns the present value of an investment. The present value represents the current worth of a future sum of money or stream of cash flows given a specified rate of return.

Syntax: PV(rate, nper, pmt, fv, type)

• Rate — interest rate per period
• Nper — total number of payment periods in an annuity
• Pmt — payment made each period, cannot change over the life of the annuity
• Fv — future value, or a cash balance you want to attain after the last payment is made
• Type — number 0 or 1 indicating when payments are due (0 = end of period, 1 = beginning)

🔑 Definition — Present Value (PV): The current value of a future sum of money or stream of cash flows given a specified rate of return.

NPV

NPV returns the net present value of an investment based on a series of periodic cash flows and a discount rate. Net present value is the difference between the present value of cash inflows and the present value of cash outflows over a period of time.

Syntax: NPV(rate, value1, value2, ...)

• Rate — rate of discount over the length of one period
• Value1, value2, ... — 1 to 29 arguments representing the payments and income

🔑 Definition — Net Present Value (NPV): The difference between the present value of cash inflows and the present value of cash outflows, used to analyze profitability of an investment.

XNPV

XNPV returns the net present value for a schedule of cash flows that is not necessarily periodic. This function is more flexible than NPV because it accepts specific dates for each cash flow.

Syntax: XNPV(rate, values, dates)

• Rate — discount rate to apply to the cash flows
• Values — series of cash flows that corresponds to a schedule of payments in dates
• Dates — schedule of payment dates that corresponds to the cash flow payments

🔑 Definition — XNPV (Extended Net Present Value): A function that calculates NPV for cash flows that occur at irregular intervals by specifying exact dates for each cash flow.

⭐ Key Takeaways

The DB function calculates depreciation using a fixed-declining balance method, with higher depreciation in early years. Both AMORDEGRC and AMORLINC are French accounting methods for calculating periodic depreciation. PV calculates the current worth of future cash flows, while NPV extends this to analyze the difference between cash inflows and outflows. XNPV provides additional flexibility by accepting non-periodic cash flows with specific dates. The functions PV, NPV, and XNPV are essential tools for evaluating the profitability and value of investments in financial mathematics.

🧠 Quick Revision Questions

1. What is the difference between AMORDEGRC and AMORLINC functions?
2. How does the DB function calculate the depreciation in the seventh year if only 5 months are used (result 15,845.10)?
3. What does the PV function return, and what are its five parameters?
4. What is the key distinction between NPV and XNPV functions?
5. If an asset has cost 1,000,000, salvage value 100,000, and life of 10 years, what would be the first year depreciation using DB with 7 months?

📘 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:

1. Multiply the second equation by 2: 2x + 2y = 4
2. Subtract from the first equation: 2x – 3y = –6 minus (2x + 2y = 4) gives –5y = –10
3. Therefore, y = 2

Solve for x by substituting y=2 into the second equation:

1. x + 2 = 2
2. x = 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

1. What is the syntax for the SLN function, and what does each argument represent?
2. How is SYD depreciation calculated mathematically, and why is it considered an accelerated method?
3. What is the difference between IRR and XIRR in terms of cash flow timing?
4. In the IRR example, why did the IRR change from -2% to 9% when the revenue stream was expanded?
5. Solve the following system of linear equations: 3x + 2y = 12 and x - 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:

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:

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

1. 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?
2. Using the same product from question 1, what is the break-even point in units?
3. If the production capacity is 1,000 units, what is the break-even point as a percentage of capacity?
4. In a contribution margin statement, what is the formula to calculate net income?
5. 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

1. What is the formula for contribution margin per unit and how is it used to find BEP in units?
2. In Scenario 1, what is the BEP in rupees if FC = Rs. 8640, S = Rs. 50, and VC = Rs. 30?
3. In Scenario 2, if FC are reduced from Rs. 3136 to Rs. 2688, what is the new BEP as a percentage of capacity?
4. In Scenario 2-2, how is new VC calculated when it is set to 80% of selling price?
5. 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

1. 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?
2. How do you calculate net income when the number of units sold exceeds the break-even point?
3. 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?
4. 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?
5. 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?