Lesson: Discount Calculation in Microsoft Excel

1. Introduction

Discount Calculation means calculating the amount that is reduced from the original fee or payable amount.

In the Course Fee practical, discount is used along with lump-sum payment to calculate the final amount payable by the student.

In simple words:

Original Fee
     ↓
Discount
     ↓
Amount Reduced
     ↓
Final Payable Amount

2. What is a Discount?

A discount is a reduction given on the original fee or amount.

For example:

Original Fee = ₹22,000
Discount     = ₹2,000

Then:

Final Amount = ₹22,000 − ₹2,000
             = ₹20,000

So, after applying the discount, the student has to pay ₹20,000.

3. Discount Calculation in Excel

Excel makes discount calculation easy because the original amount and discount can be entered into separate cells and a formula can calculate the final amount automatically.

Example:

4. Formula for Discount Amount

If the discount amount is already given:

Discount Amount = Given Discount

For example:

Total Fee = ₹22,000
Discount = ₹2,000

The discount amount is simply:

₹2,000

5. Formula for Final Amount After Discount

Suppose:

B2 = Total Course Fee
B3 = Discount

Use:

=B2-B3

Example:

B2 = ₹22,000
B3 = ₹2,000

=B2-B3
   ↓
₹20,000

Therefore:

Final Payable Amount = ₹20,000

6. Discount Calculation Flow

┌──────────────────────┐
│    TOTAL COURSE FEE  │
└──────────┬───────────┘
           ↓
┌──────────────────────┐
│      DISCOUNT        │
└──────────┬───────────┘
           ↓
┌──────────────────────┐
│  SUBTRACT DISCOUNT   │
└──────────┬───────────┘
           ↓
┌──────────────────────┐
│ FINAL PAYABLE AMOUNT │
└──────────────────────┘

Main Formula

=Total Fee-Discount

7. Discount with Lump Sum Payment

Discount calculation is particularly relevant when the student makes a lump-sum payment.

Example:

Total Fee          = ₹22,000
Lump Sum Discount  = ₹2,000
                     ─────────
Final Payable      = ₹20,000

Excel formula:

=B6-B7

Where:

B6 = Total Fee
B7 = Discount

8. Complete Course Fee Example

Suppose the fee structure is:

Step 1 — Calculate Total Fee

=SUM(B2:B5)

Result:

₹22,000

Step 2 — Enter Discount

Discount = ₹2,000

Step 3 — Calculate Final Payable Amount

=B6-B7

Result:

₹20,000

So the complete calculation is:

Course Fee Components
        ↓
    Total Fee
        ↓
      ₹22,000
        ↓
   Less Discount
        ↓
      ₹2,000
        ↓
Final Payable Amount
        ↓
      ₹20,000

9. Important Excel Formula Chart

10. Discount vs Final Amount

Remember:

DISCOUNT = AMOUNT REDUCED

FINAL AMOUNT
= TOTAL FEE − DISCOUNT

11. Practical Excel Table

        A                         B
┌──────────────────────┬──────────────┐
│ Particular            │ Amount       │
├──────────────────────┼──────────────┤
│ Total Course Fee     │ ₹22,000      │
│ Discount             │ ₹2,000       │
│ Final Payable Amount │ =B2-B3       │
└──────────────────────┴──────────────┘

Result:

Final Payable Amount = ₹20,000

12. Easy Way to Remember

TOTAL FEE
    ↓
MINUS
    ↓
DISCOUNT
    ↓
FINAL AMOUNT

One-line formula:

=Total Fee-Discount

⭐ One-Line Definition

Discount Calculation is the process of determining the amount reduced from the total fee and calculating the final payable amount after subtracting the discount.