• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Work with David
  • Our Services
  • Contact
Young Adult Money

Make more. Save more. Live better.

  • Blog
  • Credit Cards
    • Rewards
    • Cash Back
    • Travel
    • Airlines
    • Hotels
    • Balance Transfer
    • Student
    • Business
  • FREE Budget Spreadsheet
  • FREE Student Loan Spreadsheet
This Just In... Check out the latest travel rewards credit card offers

How to Track Your Student Loans in a Spreadsheet

By David Carlson / Last updated: February 3, 2023 / Download, How To, Spreadsheets, Student Loans

We may receive compensation from companies mentioned within this post via affiliate links. Read our full advertiser disclosure. Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities.
Pin73
Share
Tweet
Email
Buffer
Share
73 Shares


Have student loans? Use this free student loan spreadsheet to track your student loans, run your numbers through an income-driven repayment plan analysis, and more

Student loans can be complex. Annoyingly complex. Even painful. All the emotions.

There is no magical way to get rid of them quickly, especially if you have a lot of them.

The one thing you can do, though, is feel in control. To do that you need to get organized.

The best way to get organized is by putting all your data in a spreadsheet.

So naturally you may be wondering how to track your student loans in a spreadsheet?

You’re in luck – I have a free student loan spreadsheet that you can download.

This spreadsheet will help you get a good overall picture of your student loans, but it goes further than that. It will also run an analysis on your loans for income-driven repayment plans, provides a few repayment calculators, and more.

Grab the student loan spreadsheet by entering your email in the box below, or scroll on to read more about the spreadsheet.

Join our Online Community to Receive your FREE Student Loan Spreadsheet

 

The Features


 
The student loan spreadsheet has the following features:

 

  • Instructions on Where to Find your Student Loans – Whether you have federal, private, or state student loans, there are instructions on how to find the details of your student loans.
  • Tracking Tab to House all your Student Loan Details – The most important part of the spreadsheet. This will be where all your student loan detail is laid out in a nice snapshot.
  • Student Loan Repayment Calculators – Three different student loan calculators that help you visualize what sort of impact putting additional dollars towards your loans will have.
  • Weighted Average Interest Rate Calculation – Simplifies various calculations by giving you one interest rate that can be used in all your student loan repayment calculations.
  • Income-Driven Repayment Calculator – Shows your estimated monthly payment under the various income-driven repayment plans.
  • Federal Poverty Guidelines – Helps with calculating income-driven repayment.
  • Principal vs. Interest – Curious how much of each individual payment is going towards interest versus principal? This tool will help you visualize it.

 
Here’s more detail around the tabs you’ll find in the spreadsheet:

 

Table of Contents

This student loan spreadsheet has so many features that a table of contents felt necessary. This helps you easily jump to different sections of the spreadsheet.

 

Instructions on Where to Find your Student Loans

There are instructions within the spreadsheet on how to find all your student loans, regardless of whether they are federal, private, or through a State.

 

Tracking Tab to House all your Student Loan Details

This main tracking tab within the file is the most important and is the one that you will update over time with your student loan information. When you initially populate it you will identify whether your student loans are federal, private, or state, what the interest rate is on each loan, what the principal balance is, and more.

 
Young Adult Money Student Loan Spreadsheet Student Loan Snapshot

 

Student Loan Repayment Calculators

There are three student loan repayment calculators:

  • Standard Ten-Year Repayment – Enter your loan balance and your interest rate and this calculator will tell you what your monthly payment is under the standard ten-year repayment plan.
  • Goal Payoff Date – Do you have a goal date that you want to pay off your loans by? Curious how much you’d have to put towards your loans each month to make it happen? This calculator will tell you.
  • Goal Monthly Payment – Curious how much faster your loans will be paid off if you put an extra hundred, two hundred, or more, towards your loans each month? This calculator is for you.

 
Young Adult Money Student Loan Spreadsheet Repayment Calculators

 

Weighted Average Interest Rate Calculation

Most people have a number of student loans, but for various estimates and calculations you want just one dollar amount (your total student loan debt) and one interest rate. This calculator will help you find what your weighted average interest rate is, which then can be used in calculators like the repayment ones I described above..

 
Young Adult Money Student Loan Spreadsheet Weighted Average Interest Rate

 

Income-Driven Repayment Calculator

Curious what your estimated payment would be if you switched from the standard ten-year repayment plan to an income-driven repayment plan? This calculator gives you an estimate of what your new monthly minimum payment will be under the various plans.

 
Young Adult Money Student Loan Spreadsheet Income-Driven Repayment Calculation

 

Federal Poverty Guidelines

Income-driven repayment plans can sometimes feel a bit complicated, as they factor in the federal poverty level, family size, and adjusted gross income. This tab will simplify that for you, allowing you to select from drop-downs to automatically run calculations that are used in the income-driven repayment estimates described above.

 
Young Adult Money Student Loan Spreadsheet Federal Poverty Guidelines

 

Principal vs. Interest

Have you been making payments towards your student loans for a while now but the balance doesn’t seem to drop much? If you’re on the standard ten-year repayment plan it’s because a greater percentage of your payment goes towards interest early on in repayment. This tab shows the detail behind the 120 payments and you can clearly see how the split between principal and interest changes over time.

nbsp;
Young Adult Money Student Loan Spreadsheet Principal versus Interest

 

Get the Free Student Loan Spreadsheet


 
Ready to download the free student loan spreadsheet and access all the features? Simply enter your email below and we will send you a copy.

Join our Online Community to Receive your FREE Student Loan Spreadsheet

 
Remember, the first step to conquering your student loans is understanding them. The sooner you understand your loans and repayment options, the sooner you can put together a repayment strategy that fits with your life. No two situations are the same, and I encourage you to do what makes the most sense for your specific situation.

 

Check out some of our favorite personal finance resources:

Are you getting the best credit card rewards? Check out the top cash back credit card offers (updated daily)

Make extra money: 15 ways to make money from your computer

  • Get our FREE Automated Budget Spreadsheet and our Student Loan Spreadsheet

Get the First Chapter Free!

Student Loan Solution Cover - 3D

Join our online community and get the first chapter of the book Student Loan Solution absolutely FREE!

Pin73
Share
Tweet
Email
Buffer
Share
73 Shares

David Carlson

David Carlson is the founder of Young Adult Money. He is a nationally recognized speaker and the author of Student Loan Solution (2019) and Hustle Away Debt (2016). His opinions have been featured on such media outlets as The New York Times, The Washington Post, Cheddar, NBC's KARE11, and more.
Connect:

Comments Policy

Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Responses have not been reviewed, approved, or otherwise endorsed by this website or its advertisers. It is not the responsibility of advertisers or this website to ensure that all comments and/or questions are answered. With all that being said, please comment away!

Primary Sidebar

Credit Cards

  • Best Travel Rewards Cards
  • Best Balance Transfer Cards
  • Best Cash Back Credit Cards
  • Best Business And Side Hustle Credit Cards
  • Best Student Credit Cards

Start a Blog:

How to Start a Blog that Makes Money
 

Top Posts

  • 15 Ways You Can Make Money From Your Computer Right Now
  • When You Should and Shouldn’t Refinance Student Loans
  • How Much Money You Will Need to Make $1,000 in Dividends

Free Spreadsheets & Downloads

  • Free Automated Budget Spreadsheet
  • Student Loan Repayment Spreadsheet
  • The Ultimate Personal Finance Checklist
  • 401k Spreadsheet to Analyze your Options
  • Wedding Budget Spreadsheet
  • 52 Week Money Challenge Spreadsheet and Printable

First Chapter Free!

Join our online community and receive the first chapter of Student Loan Solution absolutely FREE.

If you don't see the email in your inbox, please check your spam folder.

Connect:

Categories:

Search:

Get the New Book!

Student Loan Solution: 5 Steps to Take Control of Your Student Loans and Financial Life is available on Amazon by clicking here, or by clicking on the graphic below.

Make more. Save more. Live better.

Site Directory:

  • About
  • Contact
  • Advertise
  • Recommendations
  • Finance Tools
  • Credit Cards
  • Insurance
  • Banking
  • Investing

Disclaimer | Privacy Policy

Feedback? Questions?
Contact us and let us know what you think.

Connect:

Search This Site:

Copyright © 2012–2024 Young Adult Money, LLC / All Rights Reserved
Designed by LizTheresa.com / Developed by Nuts and Bolts Media

Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Statistics

Marketing

Features
Always active

Always active
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}
Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}