Instructions on where to find your student loans. Open microsoft excel on your computer by going to the start button and selecting microsoft excel. Use excel and other spreadsheets to easily build a model of your loan. They may or may not have a specialized degree in taxation or be individually licensed in your particular state. Either way, check out these simple excel formulas to compare different student loan options. While they may employ attorneys, CPA’s and enrolled agents pursuant to IRS Regulation Circular 230, the use of the term ‘Tax Attorney’ is used as a general or generic term referencing attorneys seasoned in aspects of tax relief and collection work. For example, you have borrowed 100000 from bank in total, the annual loan interest rate is 5.20, and you will pay the bank every month in the coming 3 years as below screenshot shown. Calculate total interest paid on a loan in Excel. The student loan resolution company referenced herein is not a law firm nor are such representations being made. Calculate total interest paid on a loan in Excel. Nothing on this site constitutes official qualification or guarantee of result. Information obtained through the site(s) are for advertising and/or educational purposes only. Enter your Actual Balance at the top of the worksheet. Updating the worksheet After a month has passed: 1. Throughout the year you can then keep track of your actual spending to see if it matches your predicitions. You can apply for loan consolidation or other repayment programs without paid assistance at no cost through the Department of Education (DOE) at Product name(s), logo(s), brands and other trademarks feature on referred to with this site(s) are the property of MoneySolver. It may become apparent, for example, that surviving just on your student loan isnt possible. Second, we have a special currently for 12.99 per month for our innovative FitBUX Solution. Borrowing for a student loan is a serious financial commitment. Therefore, we can offer student loan planning and our student loan refinance service for free. Private student loans sometimes known as alternative loans are options for students to pay for college when other sources of funding, like federal and state grants, scholarships, and Direct Stafford Loans are not available. Andrew Josuweit CEO of Student Loan Hero shares the spreadsheet he used to pay off 107,000 of student loan debt in just a few years. MoneySolver helps prepare and process the application for student loan consolidation and repayment programs offered by the DOE. First, our student loan planners help so many Young Professionals that student loan refinance lenders pay us to be on the platform. Department of Education (DOE) or any other government agency. Disclaimer: MoneySolver is a private, student loan resolution services company and not affiliated with the U.S.