|
Written by Janet Swift
|
|
Friday, 05 March 2010 |
|
In this spreadsheet we use Excel's financial functions and the Scenario Manager to help decide whether it is worth purchasing an annuity.
|
|
Last Updated on Friday, 16 April 2010 |
|
Read more...
|
|
|
Written by Janet Swift
|
|
Tuesday, 01 December 2009 |
|
Two everyday questions:
- If the price including sales tax is $125, what is the price without tax?
- You are offered a 10% reduction on an item that has just increased in price by 10% - are you still paying the old price?
Discover the answers, and how to work them out using a spreadsheet.
|
|
Last Updated on Friday, 16 April 2010 |
|
Read more...
|
|
Written by Janet Swift
|
|
Friday, 06 November 2009 |
Spreadsheets provide a range of financial functions that make it possible to work out how interest rates affect loans and savings.
|
|
Last Updated on Friday, 16 April 2010 |
|
Read more...
|
|
|
Written by Janet Swift
|
|
Friday, 30 October 2009 |
|
Spreadsheets such as Microsoft Excel and OpenOffice Calc can automate lookups making it possible to retrieve data easily. Here we use a look-up table to implement a simple discount scheme.
|
|
Last Updated on Friday, 16 April 2010 |
|
Read more...
|
|
|
|
|
|