Lesson: Course Fee Calculation in Microsoft Excel

1. Introduction

In Excel, we can prepare a Course Fee Sheet to calculate the total amount payable by a student.

A course fee may consist of different charges such as:

• Course Fee
• Admission Fee
• Prospectus Fee
• Examination Fee
• Tax
• Installment Amount
• Discount

Excel formulas make it easier to calculate the final amount accurately instead of calculating every amount manually.

2. What is Course Fee Calculation?

Course Fee Calculation means calculating the total amount that a student has to pay for a particular course by combining the applicable fees, taxes, discounts and other charges.

A simple structure can be:

Course Fee
     +
Admission Fee
     +
Prospectus Fee
     +
Examination Fee
     +
Tax
     -
Discount
     =
Final Payable Amount

The exact charges depend on the fee structure being used.

3. Example of Course Fee Sheet

Suppose a student has the following fees:

The total before any tax or discount can be calculated as:

₹20,000 + ₹1,000 + ₹200 + ₹800

Excel Formula

=SUM(B2:B5)

The result will be:

₹22,000

4. Using SUM for Course Fee

The SUM function can be used to add multiple fee amounts.

Formula

=SUM(B2:B5)

Here:

• B2:B5 = range containing the fee amounts
• SUM = adds all the values in that range

Flow

B2 → Course Fee
B3 → Admission Fee
B4 → Prospectus Fee
B5 → Examination Fee
        ↓
   =SUM(B2:B5)
        ↓
   Total Fee

The provided notes demonstrate multiple ways of calculating totals using SUM.

5. Admission Fee

Admission Fee is a fee included in the course fee structure for admission-related charges.

For example:

The admission fee can be included in the total calculation.

=SUM(B2:B3)

6. Prospectus Fee

Prospectus Fee is another fee that may be included in the fee structure.

Example:

Total:

=SUM(B2:B4)

7. Examination Fee

An Examination Fee can also be included in the total payable amount.

Example:

Formula:

=SUM(B2:B5)

Result:

₹22,000

8. Tax Calculation

If tax is applicable, it can be calculated using a percentage.

For example, suppose the taxable amount is in B6 and the tax rate is stored in B7.

Formula

=B6*B7

If:

B6 = ₹22,000
B7 = 18%

then:

Tax = ₹22,000 × 18%

The tax amount can then be included in the final payable amount.

9. Final Amount with Tax

The basic structure can be:

Total Fee
   +
Tax
   =
Final Amount

Excel Formula

If total fee is in B6 and tax is in B7:

=B6+B7

10. Course Fee in Installments

Sometimes the course fee may be paid in installments rather than as one complete payment.

For example:

Total:

=SUM(B2:B4)

Result:

₹22,000

This allows Excel to calculate the total amount paid through different installments.

11. Lump-Sum Payment and Discount

The notes also cover the concept of a lump-sum payment with a discount.

For example:

Total Fee
    ↓
Discount
    ↓
Final Payable Amount

If total fee is ₹22,000 and the discount amount is stored in B7:

=B6-B7

This gives the amount payable after the discount.

12. Course Fee Calculation Flow

┌─────────────────────────────┐
│        COURSE FEE           │
├─────────────────────────────┤
│                             │
│ Course Fee                  │
│      +                      │
│ Admission Fee               │
│      +                      │
│ Prospectus Fee              │
│      +                      │
│ Examination Fee             │
│      ↓                      │
│ Total Fee                   │
│      +                      │
│ Tax                         │
│      -                      │
│ Discount                    │
│      ↓                      │
│ Final Payable Amount        │
│                             │
└─────────────────────────────┘

13. Important Excel Formulas

14. Why Use Excel for Course Fee Calculation?

Excel makes fee calculation easier because:

• Calculations are performed automatically.
• Multiple fees can be added quickly.
• Tax calculations can be included.
• Installments can be recorded separately.
• Discounts can be calculated.
• Formulas can be copied for multiple students.
• Changes in fee values can automatically update the result.

15. Complete Practical Example

Suppose:

Step 1 — Calculate Total Fee

=SUM(B2:B5)

Result:

₹22,000

Step 2 — Add applicable tax

=TotalFee+Tax

Step 3 — Apply discount if applicable

=AmountAfterTax-Discount

Step 4 — Final Payable Amount

Final Payable Amount

16. Easy Memory Trick

Remember the basic flow:

ADD FEES
   ↓
TOTAL FEE
   ↓
ADD TAX
   ↓
SUBTRACT DISCOUNT
   ↓
FINAL AMOUNT

For installments:

Installment 1
     +
Installment 2
     +
Installment 3
     ↓
Total Paid

⭐ One-Line Definition

Course Fee Calculation in Excel is the process of calculating the total or final amount payable by a student using fees, taxes, installments and applicable discounts.

Quick Revision

Course Fee
+ Admission Fee
+ Prospectus Fee
+ Examination Fee
= Total Fee

Total Fee
+ Tax
- Discount
= Final Payable Amount