Content Frame
Skip Breadcrumb Navigation
Home  arrow Chapter 6  arrow Spreadsheets

Spreadsheets


Scroll down the page to view the three spreadsheets for this chapter!


Click here for downloading instructions.



Flat Rate Interest

Simple interest loans require you to pay the same amount of interest each year. You can apply a formula for simple interest in order to calculate the exact figure. Use this spreadsheet to help answer the questions in its accompanying worksheet.

This activity consists of an Excel spreadsheet. You will need to download it to your hard drive before continuing. Right-click (PC) or Control-click (MAC) on the link and select the option which saves the file to disk. (Either 'Save Target As' or 'Download Link to Disk'.) Save the file to your hard drive and then double-click on it to open it. Please note: you will need Microsoft Excel '97 or greater to use this file.

Right/Control-click here: 06_Flat-Rate.xls

For a zipped version, click here: 06_Flat-Rate.zip

To begin the exercise, open up this Excel spreadsheet and its accompanying worksheet (6.2b) which can be found on the Access to Prevocational Maths 1 Teacher's Resource CD.


Prime Cost Depreciation

Prime cost depreciation is calculated on an item's value decreasing by the same amount each year. Learn more by using this spreadsheet to help answer the questions in its accompanying worksheet.

This activity consists of an Excel spreadsheet. You will need to download it to your hard drive before continuing. Right-click (PC) or Control-click (MAC) on the link and select the option which saves the file to disk. (Either 'Save Target As' or 'Download Link to Disk'.) Save the file to your hard drive and then double-click on it to open it. Please note: you will need Microsoft Excel '97 or greater to use this file.

Right/Control-click here: 06_Prime-Cost.xls

For a zipped version, click here: 06_Prime-Cost.zip

To begin the exercise, open up this Excel spreadsheet and its accompanying worksheet (6.10) which can be found on the Access to Prevocational Maths 1 Teacher's Resource CD.


Diminishing Value Depreciation

Diminishing value depreciation is calculated on an item's value decreasing by a smaller amount each year. Learn more by using this spreadsheet to help answer the questions in its accompanying worksheet.

This activity consists of an Excel spreadsheet. You will need to download it to your hard drive before continuing. Right-click (PC) or Control-click (MAC) on the link and select the option which saves the file to disk. (Either 'Save Target As' or 'Download Link to Disk'.) Save the file to your hard drive and then double-click on it to open it. Please note: you will need Microsoft Excel '97 or greater to use this file.

Right/Control-click here: 06_Diminish.xls

For a zipped version, click here: 06_Diminish.zip

To begin the exercise, open up this Excel spreadsheet and its accompanying worksheet (6.11a) which can be found on the Access to Prevocational Maths 1 Teacher's Resource CD.







Pearson Copyright © 1995 - 2010 Pearson Education . All rights reserved. Pearson Education Australia is an imprint of Pearson .
Legal Notice | Privacy Policy | Permissions

Return to the Top of this Page