# Interest Calculator - Excel

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      125   8.379121
2      125   8.138736
1     ENTER the Date of the First Day of Periodic Payments IN BOX A                       A                                             3      125   7.898352
If the date was July 5, 1995 enter 7051999, that is, (MMDDYYYY)                                                                   4      125   7.657967
The Date you have entered in Box A is:                             #NUM!                         5      125   7.417582
6      125   7.177198
2     ENTER the Date of the First Day Following                                           B                                             7      125   6.936813
The Last Day of Periodic Payments IN BOX B                                                                                        8      125   6.696429
If the the first day following the last payment day                                                                               9      125   6.456044
was December 21, 2002, enter 12212002, that is, (MMDDYYYY)                                                                       10      125   6.215659
The Date you have entered in Box B is:                         #NUM!                        11      125   5.975275
12      125    5.73489
Number of Total Days in Payments Period                                             C               #NUM!                        13      125   5.494505
14      125   5.254121
Number of Whole Weeks in Payments Period                                            D               #NUM!                        15      125   5.013736
16      125   4.773352
Number of Days in the Final Partial Week of Payments Period                         E               #NUM!                        17      125   4.532967
18      125   4.292582
3     ENTER Amount Per Week IN BOX F                                                      F                                            19      125   4.052198
20      125   3.811813
21      125   3.571429
22      125   3.331044
COMPOUND INTEREST CALCULATION at 10%                                                                                             23      125   3.090659
24      125   2.850275
25      125    2.60989
Compound Interest Accrued up to End of Payments Period                              G               #NUM!                        26      125   2.369505
27      125   2.129121
Total Weekly Payments                                                               H               #NUM!                        28      125   1.888736
29      125   1.648352
Weekly Payments plus Accrued Compound Interest                                      I               #NUM!                        30      125   1.407967
Up to End of Periodic Payments Period                                                                                            31      125   1.167582
32      125   0.927198
33      125   0.686813
34      125   0.446429
35      125   0.206044
35.85714 107.1429          0

SIMPLE INTEREST CALCULATION at 10% *                                                                                                4482.143 150.2404              4632.383

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.

42527f24-ce2b-41fb-a9a1-a3345ee9a004.xls Weekly Payments                                                                                                                9/22/2012 4:50 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%
1.22304333 1.211581 1.22284516
Accrued COMPOUND Interest Over the Accrual Period                            G       \$    88,270.00                     1.22304333 1.211581 1.3509523
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.

42527f24-ce2b-41fb-a9a1-a3345ee9a004.xls Principal Amount                                                                                          9/22/2012 4:50 PM

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 14 posted: 9/22/2012 language: English pages: 2
How are you planning on using Docstoc?