Finance
Evaluating an annuity
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...
 
Percentages in practice
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...
 
Loans and Savings
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...
 
A Simple Discount Scheme
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...
 


 

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