Monday, May 19, 2014

John Smith Student Loan Calculations and Budgeting Exercise

John Smith recently graduated from an in-State University with a degree in physical therapy.  He is about to embark on his career as a physical therapist at New Haven Physical Therapeutics, and is expected to make $46,300 per year. In order to get his degree, John had to take out $35,000 in student loans (Stafford loans plus Student Plus loans).

Please click on this link to access an Excel spreadsheet that we'll use to calculate the costs and duration of paying off John's student loans.  You will also learn how to use the CNN Money student loan calculator to help John determine whether he should try to pay off his tsudent loans in 5, 10 or 15 years.

In the next exercise, we will take a close look at John's monthly cash flows - since he plans on creating a budget to monitor his spending habits across expense categories.

For some guidance on an average household's spending habits (expense allocations), please check out this monthly cash flow analysis calculator.

You will use it along with the expense spending cash flow spreadsheet that you downloaded for the student loan calculation above, to calculate John Smith's average monthly net income.


  1. Thanks for this article. It's just what I was searching for. I am always interested in this subject.

    Money Lenders

  2. Thanks for your post, I like this post very much

    Money Lenders Singapore

  3. I found your website the other day and after reading a handful of posts, thought I would say thank you for all the great content.
    Keep it coming! I will try to stop by here more often.To get new information visit here
    home loans hobart
    mortgage broker hobart

  4. Hi everyone. I saw comments from people who already got their loan from Daniel Silva and then I decided to apply under their recommendations and just few hours ago I confirmed in my own personal bank account a total amount of $80,000 which I requested for. This is really a great news and I am advising everyone who needs real loan to apply through their email ( ) I am happy now that i have gotten the loan I requested

  5. "Mortgage Loan Software is very important when you are working in a mortgage industry. All the loan officers, mortgage brokers and loan processors need a way to organize and keep track of all their loans in their pipelines"!!