Lesson: Prospectus Fee in Microsoft Excel

1. Introduction

Prospectus Fee is one of the fee components included in the Course Fee calculation.

In an Excel fee sheet, it can be entered separately along with other charges such as Course Fee, Admission Fee and Examination Fee. These individual amounts can then be added to calculate the total fee.

Your provided notes include Prospectus Fee as part of the course-fee calculation practical.

2. What is Prospectus Fee?

Prospectus Fee is a separate amount included in the fee structure for the prospectus-related charge.

In Excel, it is maintained as an individual fee item so that every component of the student’s fee can be clearly shown.

Simple Definition

Prospectus Fee is a separate fee component recorded in the fee sheet and included in the total course fee calculation.

3. Example of Prospectus Fee

Suppose the fee structure is:

Here:

Course Fee        = ₹20,000
Admission Fee     = ₹1,000
Prospectus Fee    = ₹200
Examination Fee   = ₹800

The Prospectus Fee is recorded separately and then included in the total.

4. Entering Prospectus Fee in Excel

Suppose the fee details are entered as:

The Prospectus Fee is stored in:

B4

So the cell reference for the Prospectus Fee is B4.

5. Calculating Total Fee

The Prospectus Fee can be included with the other fee components using the SUM function.

Formula

=SUM(B2:B5)

This formula adds:

Course Fee
+ Admission Fee
+ Prospectus Fee
+ Examination Fee

Calculation

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

The provided notes cover the calculation of these course-fee components using Excel’s SUM function.

6. Direct Addition Formula

The fee amounts can also be added directly without using SUM.

=B2+B3+B4+B5

Here:

B2 → Course Fee
B3 → Admission Fee
B4 → Prospectus Fee
B5 → Examination Fee

The result is:

₹22,000

7. Prospectus Fee — Practical Flow

Enter Course Fee
       ↓
Enter Admission Fee
       ↓
Enter Prospectus Fee
       ↓
Enter Examination Fee
       ↓
Calculate Total
       ↓
=SUM(B2:B5)
       ↓
Total Fee

8. Why Keep Prospectus Fee Separate?

Keeping Prospectus Fee as a separate entry makes the fee structure more transparent.

Instead of:

Total Fee = ₹22,000

We can show:

Course Fee          ₹20,000
Admission Fee        ₹1,000
Prospectus Fee         ₹200
Examination Fee        ₹800
                    ───────
Total Fee            ₹22,000

This makes it easier to understand how the total amount has been calculated.

9. Prospectus Fee with Other Charges

A complete fee sheet may be organized like:

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

The exact fee components depend on the fee structure being prepared.

10. Important Formulas

Total Fee

=SUM(B2:B5)

Direct Addition

=B2+B3+B4+B5

Prospectus Fee Cell Reference

=B4

11. Quick Revision Table

⭐ Easy Memory Trick

COURSE FEE
     +
ADMISSION FEE
     +
PROSPECTUS FEE
     +
EXAMINATION FEE
     ↓
TOTAL FEE

One-Line Definition

Prospectus Fee is a separate fee component entered in the Excel fee sheet and included in the calculation of the total course fee.