| Home |
 |
Chapter 6 |
|
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.
|