Effective Rate Calculator - Excel - Excel by SpreadsheetZONE

VIEWS: 303 PAGES: 5

More Info
									Effective Annual Rate Based on Frequency of Compoundin
Nominal Rate 0.8500 Nominal Rate 1% 5% 10% 15% 20% 30% 40% 50% 60% 70% 80% 90% 100%
200%

Semi-Annual 103.063% Semi-Annual 1.002% 5.062% 10.250% 15.563% 21.000% 32.250% 44.000% 56.250% 69.000% 82.250% 96.000% 110.250% 125.000%

Quarterly 116.136% Quarterly 1.004% 5.095% 10.381% 15.865% 21.551% 33.547% 46.410% 60.181% 74.901% 90.613% 107.360% 125.188% 144.141%

180% 160% 140%
120%

100% 80% 60%
40%

20% 0% 0% 10% 20% 30% 40% 50%

e Based on Frequency of Compounding
Monthly 127.333% Monthly 1.005% 5.116% 10.471% 16.075% 21.939% 34.489% 48.213% 63.209% 79.586% 97.456% 116.943% 138.178% 161.304% Daily 133.734% Daily 1.005% 5.127% 10.516% 16.180% 22.134% 34.969% 49.150% 64.816% 82.122% 101.240% 122.359% 145.688% 171.457% Continuous 133.965% Continuous 1.005% 5.127% 10.517% 16.183% 22.140% 34.986% 49.182% 64.872% 82.212% 101.375% 122.554% 145.960% 171.828%

Semi-Annual
Quarterly

Monthly Daily Continuous
Selected

60%

70%

80%

90%

100%

0% 170%

85% 85%

Follow the steps to enable your Effective Rate Calculator.
>> >> 1) This template is prepared for calculating effective rates for different time periods. Your Effective Rate Calculator is ready to use. Following steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your Effective Rate Calculator. 2) Visit the site below: http://trial.spreadsheetweb.com/spreadsheetweb/ Login to page with your new account information. 3) >> >> Click "Add Web Application" to upload this file. Your Effective Rate Calculator will be created automatically. You can simply use the Effective Rate Calculator from that link or place it on your website. Your Effective Rate Calculator will look like: http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=7194485f-e639-4f3c-9a15-32665730de4f In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

c-9a15-32665730de4f


								
To top