Tag Archives: spreadsheet

Smart Tactics to Manage Student Debt

According to the Federal Reserve, U.S. student loan debt is now $1.5 trillion with more than 44 million borrowers. Only mortgage debt currently has bigger numbers among types of consumer debt. Even worse, more than 10 percent of these loans are past due. Here are some tactics to help make student debt easier to manage:

  • Know the loan terms. Not all student debt is created equal. Understanding the terms of all your student loans is important. With this knowledge, select the correct loan option and know which loan to pay first. Things you should know about each loan include:
    • The interest rate
    • The term of the loan
    • Amount of any upfront fees
    • Pre-payment penalties (if any)
    • When interest and payments start
    • Payment amounts
    • Payment flexibility
    • How the interest is calculated

Suggestion: Create a spreadsheet with a student loan in each column. Then note the terms under each loan. This will create a strong visual of your situation and show you which loans are most important.

  • Avoid accruing interest. Some student loans accrue interest while you are in school. With the compounding of this interest, your student loan amount continues to grow with each passing year before repayment begins. Banks love this — you should not.

Suggestion: Figure out how to make some or all of the interest payments while in school. This will not only lock the amount you owe, it will reduce the amount of overall loan payments.

  • Pay a little extra in the early days. The math of loans benefits banks in the early years of the repayment period. This is because the vast majority of interest is paid in the first years of repayment. By the time you get to the last year of repayment, payments are primarily the principal balance and interest is nil.

Suggestion: Pay extra every month as soon as payments start. While this seems impossible as you enter the workforce, even $25 extra per month can dramatically reduce the amount of total payments you make over the life of your loan. For example, a $25 extra payment on a 10-year $50,000 student loan with 5 percent interest would cut six months off the loan, save $834 in interest, AND save $3,180 in future loan payments!

  • Make small cuts elsewhere. Having a hard time finding a few extra dollars to make extra payments? Consider observing and then changing your spending habits.

Suggestion: Purchase one less latte a week. Drop one monthly service from a bill. Eat in more often. Then use these savings as a bonus payment on your student loan principal.

While student debt is often an unavoidable outcome of getting a college education, it can be minimized if actively managed. Small changes can yield results if planned for in advance.

Your Cash Flow – What Is It and How Can You Improve It? – Part 1

One of the most common reasons businesses fail is due to lack of understanding of cash flow. The same can be said about your household’s personal financial statement. So what is this cash flow concept, how does it apply to you, and what are some ways to improve yours? In Part 1 of this two-part article, we’ll explain what cash flow is and how to determine your cash flow.

Cash flow defined

Cash flow equals cash coming in (wages, interest, social security benefits) and subtracting the bills you pay. Unfortunately, calculating cash flow is never that easy. Some bills are due weekly, others monthly. Some large bills come quarterly, or annually. Understanding this flow of cash is the first step in knowing how to improve yours.

Create your cash flow snapshot

Before improving your cash flow, you need to be able to see it. There are many online tools to create a map, but you can also take a snapshot of your cash flow using a monthly spreadsheet.

  1. Put each month across the top of the spreadsheet with an annual total.
  2. Note all your revenue and corresponding expense descriptions in the left-hand column.
  3. Enter your income and bills by month. Create a monthly subtotal of all your inflows. Do the same for your expenses or cash outflows. Then subtract the expenses from income. Positive numbers? You have positive cash flow. Negative numbers? You have negative cash flow.
  4. Create a cumulative total for the year to see which months will need additional funds and which months will have excess funds.

Check out Part 2 where we list various ways to improve your cash flow!