Finance
Evaluating an annuity
Written by Janet Swift   
Friday, 05 March 2010 00:00

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 18:02
Read more...
 
Percentages in practice
Written by Janet Swift   
Tuesday, 01 December 2009 00:00

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 17:57
Read more...
 
Loans and Savings
Written by Janet Swift   
Friday, 06 November 2009 00:00
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 17:54
Read more...
 
A Simple Discount Scheme
Written by Janet Swift   
Friday, 30 October 2009 00:00

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 17:52
Read more...
 


 

   
RSS feed of all content
I Programmer - full contents
Copyright © 2013 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.