The College Comparison Spreadsheet - College Talk - Free Printable

It looks like you've uploaded a College Cost Comparison Spreadsheet that calculates the net cost of attendance for a student at College A, and there are blank columns for other colleges (College B, C, D) to compare.

Let’s go through the completed data for College A, explain how each value is calculated, and then show how you can use this spreadsheet to compare other colleges.

---

🔍 Step-by-Step Breakdown of College A

#### 1. Direct Costs
These are expenses paid directly to the college.

| Item | Amount |
|--------------------|------------|
| Tuition and Fees | $15,500 |
| Room and Board | $13,000 |
| Total Direct Costs | $28,500 |

✔ Calculation:
> $15,500 + $13,000 = $28,500

---

#### 2. Indirect Costs
These are personal expenses not paid directly to the college.

| Item | Amount |
|------------------------------|------------|
| Estimated Books & Supplies | $1,350 |
| Estimated Other Expenses | $3,700 |
| Total Indirect Costs | $5,050 |

✔ Calculation:
> $1,350 + $3,700 = $5,050

---

#### 3. Total Cost of Attendance
This is the sum of direct and indirect costs.

> $28,500 (Direct) + $5,050 (Indirect) = $33,550

✔ So:
Total Cost of Attendance = $33,550

---

#### 4. Gift Aid (Non-Repayable Financial Aid)

| Item | Amount |
|-------------------------------------------|------------|
| Pell Grant | $2,000 |
| Federal FSEOG | $0 |
| Total State Scholarships and Grants | $5,900 |
| Total Institutional Scholarships and Grants | $6,000 |
| Other Scholarships and Grants | $0 |
| Tuition Waiver | $0 |
| Total Gift Aid | $13,900 |

✔ Calculation:
> $2,000 + $5,900 + $6,000 = $13,900

Note: The FSEOG, Other Scholarships, and Tuition Waiver are listed as $0 in this case.

---

#### 5. Net Cost or Out-of-Pocket Costs for Year 1

This is the total cost minus gift aid.

> $33,550 (Total Cost) - $13,900 (Gift Aid) = $19,650

✔ So:
Net Cost = $19,650

---

#### 6. Loan Aid – Requires Repayment with Interest
Only one item is filled:

- Federal Subsidized Stafford Loan: $3,500

⚠️ This loan will need to be repaid with interest after graduation.

---

✔ Summary for College A:

| Category | Amount |
|-------------------------------|--------------|
| Total Cost of Attendance | $33,550 |
| Total Gift Aid | $13,900 |
| Net Cost (Out-of-Pocket) | $19,650 |
| Loan Aid (to be repaid) | $3,500 |

---

📌 How to Use This Spreadsheet for Other Colleges

You can fill in the same structure for College B, C, D, etc., using their respective:

- Tuition & Fees
- Room & Board
- Books & Supplies
- Other Expenses
- All types of scholarships and grants
- Loans

Then calculate:

1. Total Direct Costs → Tuition + Room & Board
2. Total Indirect Costs → Books + Other Expenses
3. Total Cost of Attendance → Direct + Indirect
4. Total Gift Aid → Sum of all non-repayable aid
5. Net Cost → Total Cost – Total Gift Aid

👉 Then compare net costs across colleges to see which is most affordable.

---

💡 Tips for Students:

- Lower net cost = lower out-of-pocket expense
- Gift aid is free money – prioritize colleges offering more of it
- Loans add debt – try to minimize them
- Always check if the school offers tuition waivers, institutional scholarships, or state aid

---

✔ Final Answer:

For College A, the net cost of attendance for Year 1 is $19,650.

> This means the student would need to pay $19,650 out-of-pocket (after scholarships and grants), plus $3,500 in loans (which must be repaid with interest).

---

If you provide the data for other colleges (or upload another image), I can help complete the comparison!