Tuesday, February 26, 2008

The Definition of A Spreadsheet

A spreadsheet is the computer equivalent of a paper ledger sheet. It consists of a grid made from columns and rows. It is an environment that can make number manipulation easy and somewhat painless.

paper ledger
computer  ledger

The math that goes on behind the scenes on the paper ledger can be overwhelming. If you change the loan amount, you will have to start the math all over again (from scratch). But lets take a closer look at the computer version.

So Why do it on a Computer?

Looking at our previous example it seems pretty evenly matched. Right? WRONG! The nice thing about using a computer and spreadsheet is that you can experiment with numbers without having to RE-DO all the calculations. Lets change the interest rate and then the number of months. Let the COMPUTER do the calculations! Once we have the formulas set up, we can change the variables that are called from the formula and watch the changes.

Change the Interest Rate
Change the Number of Months
new interest rate

new number of months

Do that on paper and you better get your calculator back out and get an Eraser and hope you punched all the right keys and in the right order. Spreadsheets are instantly updated if one of the entries is changed.
NO erasers! NO new formulas! NO calculators!

Spreadsheets can be very valuable tools in business. They are often used to play out a series of what-if scenarios! (much like our car purchase here.)


No comments: