Saturday, November 18, 2006

Student Loan Calculator

This project focuses on utilizing the different features of Excel. The objective was to create a business/financial model with supporting charts and documentation.

I chose to do a student loan calculator. Mostly because by the end of all of this, I will have accumulated quite a large debit. So why not prepare for the future!

Overview:

  • Required inputs of this model include size of the loan, period of repayment, and interest rate.
  • After sufficient information has been provided, the calculator will compute how many payments as well as how much each payment will be for a particular loan and a particular compound period (annually, semi-annually, etc.)
  • Extra features include a Randomizer, which will generate a random repayment period

A demo copy can be downloaded here.

0 Comments:

Post a Comment

<< Home