Simple Interest Calculator - Download as Excel

Document Sample
Simple Interest Calculator - Download as Excel Powered By Docstoc
					Bureau of Workers' Compensation, Harrisburg, Pennsylvania                                                          Claims Department / Calculations



                          Worksheet For The Calculation of Interest At 10% Up to the End of the Period
                                    Of Weekly Payments at Compound and Simple Interest

   Step

     1     ENTER the Date of the First Day of Periodic Payments IN BOX A                       A
           If the date was July 5, 1995 enter 7051999, that is, (MMDDYYYY)
                                           The Date you have entered in Box A is:                              #NUM!

     2     ENTER the Date of the First Day Following                                           B
           The Last Day of Periodic Payments IN BOX B
           If the the first day following the last payment day
           was December 21, 2002, enter 12212002, that is, (MMDDYYYY)
                                               The Date you have entered in Box B is:                          #NUM!

           Number of Total Days in Payments Period                                             C               #NUM!

           Number of Whole Weeks in Payments Period                                            D               #NUM!

           Number of Days in the Final Partial Week of Payments Period                         E               #NUM!

     3     ENTER Amount Per Week IN BOX F                                                      F




           COMPOUND INTEREST CALCULATION at 10%


           Compound Interest Accrued up to End of Payments Period                              G               #NUM!

           Total Weekly Payments                                                               H               #NUM!

           Weekly Payments plus Accrued Compound Interest                                      I               #NUM!
           Up to End of Periodic Payments Period




           SIMPLE INTEREST CALCULATION at 10% *


           Simple Interest Accrued up to End of Payments Period                                J               #NUM!

           Total Weekly Payments                                                               K               #NUM!

           Weekly Payments plus Accrued Simple Interest                                        L               #NUM!
           Up to End of Periodic Payments Period




           * Note: A constant rate of simple interest implies a decreasing effective rate of interest for periods over one year.

           This spreadsheet assumes that interest accrues from the end of the first week through to the end of the payments period.
           If this assumption is inappropriate for your calculation, please consult another source.




523ce5c4-960a-45cc-b1dd-8068c0b40809.xls Weekly Payments                                                                           7/6/2010 4:30 PM
Bureau of Workers' Compensation, Harrisburg, Pennsylvania                                               Claims / Calculation Department



        Worksheet to Calculate Interest at 10% over a Period of Time on a Principal Amount
                      Calculations For Both Simple and Compound Interest

   Step

    1      ENTER the Date of the First Day From Which Interest Accrues                  A              4051998
           On a Principal Amount IN BOX A
           If the the first day from which interest accrues on a principal amount
           was December 21, 2002, enter 12212002, that is, (MMDDYYYY)
                                              The Date you have entered in Box A is:                   4/5/1998


    2      ENTER the Date Up To Which Interest Accrues on the                           B              5062004
           Principal Amount IN BOX B
           If the date is August 5, 2004 enter 08052004, that is, (MMDDYYYY)
                                            The Date you have entered in Box B is:                     5/6/2004
           The time from the first date to the last date is the Interest Accrual Period
           Number of Total Days in the Interest Accrual Period                          C                  2223

           Number of Whole Weeks in the Interest Accrual Period                         D                   317

           Number of Days in the Final Partial Week of the                              E                      4
           Interest Accrual Period is Box E

    3      ENTER The Amount of Principal On Which Interest Will                       F         $   105,000.00
           Accrue IN BOX F
           If a principal amount or a stream of periodic payments had accrued
           interest from a prior period, the amount in Box F might then be the original
           Principal or Payments plus the interest that had accrued.


           COMPOUND INTEREST CALCULATION AT 10%

           Accrued COMPOUND Interest Over the Accrual Period                            G       $    88,270.00
           Defined In Section 2, Above


           Principal Plus Accrued Compound Interest                                     H       $   193,270.00




           SIMPLE INTEREST CALCULATION AT 10% *

           Accrued SIMPLE Interest Over the Accrual Period Defined                      I       $    63,949.32
           In Section 2, Above


           Principal Plus Accrued Simple Interest                                       J       $   168,949.32




           * Note: A constant rate of simple interest implies a decreasing effective rate of interest for periods over one year.




523ce5c4-960a-45cc-b1dd-8068c0b40809.xls Principal Amount                                                             7/6/2010 4:30 PM

				
DOCUMENT INFO
Description: Simple Interest Calculator document sample