Lesson: Lump Sum Payment in Microsoft Excel

1. Introduction

Lump Sum Payment means paying the applicable course fee in one complete payment instead of paying it through separate installments.

In the Course Fee practical, Excel can be used to calculate the amount payable when a student makes a lump-sum payment, including an applicable discount.

The provided notes specifically cover lump-sum payment with discount as part of the fee calculation practical.

2. What is Lump Sum Payment?

A Lump Sum Payment is a single payment made for the complete applicable fee amount.

For example:

Total Course Fee = ₹22,000

Instead of:

1st Installment = ₹8,000
2nd Installment = ₹7,000
3rd Installment = ₹7,000

the student pays the applicable amount at once.

Lump Sum Payment
       ↓
Complete Payment
       ↓
One Payment Entry

3. Lump Sum Payment with Discount

One important concept in the provided notes is discount on lump-sum payment.

Suppose:

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

Then the amount payable after discount is:

₹22,000 − ₹2,000
       ↓
₹20,000

So the student pays:

₹20,000 as the lump-sum amount after discount.

4. Excel Fee Sheet Example

A simple Excel structure can be:

The discount is subtracted from the total fee.

5. Formula for Lump Sum Payment

Suppose:

B2 = Total Course Fee
B3 = Discount

The final lump-sum payable amount can be calculated using:

=B2-B3

Example

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

=B2-B3
     ↓
₹20,000

6. Lump Sum Payment Calculation Flow

Total Course Fee
       ↓
Lump Sum Payment
       ↓
Applicable Discount
       ↓
Subtract Discount
       ↓
Final Payable Amount

Formula Flow

Total Fee − Discount
       ↓
Final Lump Sum Amount

7. Example with Complete Fee Structure

Suppose the course fee consists of:

Step 1 — Calculate Total Fee

=SUM(B2:B5)

Result:

₹22,000

Step 2 — Apply Lump Sum Discount

Suppose discount = ₹2,000.

=B6-B7

Result:

₹20,000

Therefore:

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

8. Lump Sum vs Installment Payment

The provided notes cover both installment calculations and lump-sum payment with discount within the Course Fee practical.

9. Why Use Excel for Lump Sum Calculation?

Excel helps because:

• Total course fee can be calculated automatically.
• Discount can be entered separately.
• Final payable amount can be calculated using a formula.
• Changes in fee or discount can automatically update the result.
• The fee structure remains clearly organized.

10. Important Formulas

Total Fee

=SUM(B2:B5)

Final Amount After Discount

=B6-B7

General Formula

Final Lump Sum Amount
=
Total Fee − Discount

11. Practical Flow Chart

┌──────────────────────────────┐
│       COURSE FEE             │
├──────────────────────────────┤
│ Course Fee                   │
│ Admission Fee                │
│ Prospectus Fee               │
│ Examination Fee              │
└──────────────┬───────────────┘
               ↓
          TOTAL FEE
               ↓
       LUMP SUM PAYMENT
               ↓
        APPLY DISCOUNT
               ↓
       TOTAL FEE − DISCOUNT
               ↓
      FINAL PAYABLE AMOUNT

12. Easy Memory Trick

Remember:

LUMP SUM
   ↓
ONE COMPLETE PAYMENT
   ↓
DISCOUNT (IF APPLICABLE)
   ↓
FINAL PAYABLE AMOUNT

Formula

=Total_Fee-Discount

⭐ One-Line Definition

Lump Sum Payment is a single complete payment of the applicable course fee, where an applicable lump-sum discount can be subtracted to calculate the final payable amount.

Quick Revision

TOTAL FEE
    ↓
LUMP SUM PAYMENT
    ↓
LESS: DISCOUNT
    ↓
FINAL PAYABLE AMOUNT