# Interest Calculate

Description

Interest Calculate document sample

Shared by:
Categories
-
Stats
views:
145
posted:
2/25/2011
language:
English
pages:
2
Document Sample

```							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.

c56a241d-c480-48d4-a0ae-8f30d6adf6e2.xls Weekly Payments                                                                           2/25/2011 7:07 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.

c56a241d-c480-48d4-a0ae-8f30d6adf6e2.xls Principal Amount                                                            2/25/2011 7:07 PM

```
Related docs
Other docs by iww21415
Interest in Information Management
Internet Income