HomeMy WebLinkAbout04-02-09 5056041125
REV-1500 ~ (06-05)
OFFICIAL USE ONLY
PA Department of Revenue
Bureau of Individual Taxes
PO BOX 280601
INHERITANCE TAX RETURN County Code Year
2 1 0 9 File Number
~
Harrisburg, PA 17128-0601 RESIDENT DECEDENT O'`
ENTER DECEDENT INFORMATION BELOW
Social Security Number Date of Death Date of Birth
1 7 4 2 0 2 9 5 3 0 1 1 6 2 0 0 9 1 2 2 2 1 9 2 6
Decedent's Last Name Suffix Decedent's First Name MI
RA S M U S S E N R O B E R T H
(If Applicable) Enter Surviving Spouse's Information Below
Spouse's Last Name Suffix Spouse's First Name MI
R A S M U S S E N F R A N C E S A
Spouse's Social Security Number
THIS RETURN MUST BE FILED IN DUPLICATE WITH THE
REGISTER OF WILLS
FILL IN APPROPRIATE OVALS BELOW
0 1.Original Retum
4. Limited Estate
^X 6. Decedent Died Testate
(Attach Copy of Will)
9. Litigation Proceeds Received
2. Supplemental Retum
4a. Future Interest Compromise (date of
death after 12-12-82)
7. Decedent Maintained a Living Trust _
(Attach Copy of Trust)
10. Spousal Poverty Credit (date of death
between 12-31-91 and 1-1-95)
3. Remainder Retum (date of death
prior to 12-13-82)
5. Federal Estate Tax Retum Required
8. Total Number of Safe Deposit Boxes
11. Election to tax under Sec. 9113(A)
(Attach Sch. O)
CORRESPONDENT -THIS SECTION MUST BE COMPLETED. ALL CORRESPONDENCE AND CONFIDENTU-L TAX INFORMATION SHOULD BE DIRECTED T0:
Name Daytime Telephone Number
H A R O L D S I R W I N I I I 7 1 7 2 4 3 6 0 9 0
Firm Name (If Applicable)
I R W I N L A W O F F I C E
First line of address
6 4 S O U T H P I T T S T R E E T
Second line of address
City or Post Office
C A R L I S L E
Correspondent's e-mail address: Irwfnlawotffice~mafl.com
State ZIP Code
P A 1 7 0 1 3
.'r:
~~~ :. ~
r~ ~ ~'
~~ s - ~~
G'~F ~~~^
r't._3 r"rl
_r~; ,_~
~_` ~:~
s--
r= '~',
`'I
~+
REGISTER S USE OIIL°P
~ ~
I
ui ~
~
~ -v
~
~ W
~
DATE FILED ~
Under penalties of perjury, I dedare that I have examined this return, induding accompanying schedules and statements, and to the best of my knowledge and belief,
it is true, coned and complete. Dedaretion of preparer other than the personal representative ~s based on all information of wli~ch preparer has any
OF PERSON RESP SIBLE FOR FILING RETURN PATE
~~ ~,~~ t.~...,~ d~ „ ~'~, ~~~. _ , l/.¢ l yon 3 ~/~%/o ~
0
PLEASE USE ORIGINAL FORM ONLY
Side 1
L 15056041125 15056041125 J
e~
056042126
REV-1500 EX Decedent's Social Security Number
Decedent's Name: ROBERT H. RASMUSSEN 1 7 4 2 0 2 9 5 3'
RECAPITULATION
0 0 0
1.
..................................
Real estate (Schedule A)
...... 1
0 0 0
2. Stocks and Bonds (Schedule B} ............................ ...... 2.
0 0 0
3. Closely Held Corporation, Partnership or Sole-Proprietorship (Schedule C) ..... 3.
4 2 7 2 8 1 3
4. .............
Mortgages & Notes Receivable (Schedule D) ..... ...... 4.
0 0 0
5. Cash, Bank Deposits 8 Miscellaneous Personal Property (Schedule E) . ...... 5.
6. Jointly Owned Property (Schedule F) ^ Separate Billing Requested . ...... 6. 0 0 0
7. Inter-Vivos Transfers 8~ Miscellaneous Non-Probate Property 0 0 0
(Schedule G) ^ Separate Billing Requested . ...... 7.
8. Total Gross Assets (total Lines 1-7) ..................... ...... 8. 4 2 7 2 8 1 3
9. Funeral Expenses & Administrative Costs (Schedule H) .......... ...... 9. 1 3 4 3 8 0 8
0 0 0
10. Debts of Decedent, Mortgage Liabilities, 8~ Liens (Schedule I) ...... ...... 10.
11. Total Deductions (total Lines 9~ 10) ..................... ...... 11: 1 3 4 3 8 0 8
12. Net Value of Estate (Line 8 minus Line 11) ..... . ... , .. 12. 2 9 2 9 0 0 5
13. Charitable and Governmental Bequests/Sec 9113 Trusts for which 0 0 0
an election to tax has not been made (Schedule J) ............ ...... 13.
2 9 2 9 0 0 5
14. Net Value Subject to Tax (Line 12 minus Line 13) .................. 14.
TAX COMPUTATION -SEE INSTRUCTIONS FOR APPLICABLE RATES
15. Amount of Line 14 taxable
at the spousal tax rate, or
transfers under Sec. 9116
2 9 2 9 0 0
5
0
0
0
(a>(1.2) x.oo00 15.
16. Amount of Line 14 taxable
0 0
0
0
0
0
at lineal rate X .0 _ 16
17. Amount of Line 14 taxable
0 0
0
0
0
0
at sibling rate X .12 17,
18. Amount of Line 14 taxable
0 0
0
0
0
0
at collateral rate X .15 18
19. Tax Due ................................................19. 0 0 0
20. FILL IN THE OVAL IF YOU ARE REQUESTING A REFUND OF AN OVERPAYMENT
Side 2
15056042126 15056042126
REV-1500 EX Page 3
Qecedent's Complete Address:
File Number
DECEDENTS NAME
ROBERT N. RASMUSSEN
STREET ADDRESS
321 JUNIPER STREET
CITY
CARLISLE STATE
PA ZIP
17013
Tax Payments and Credits:
1. Tax Due (Page 2 Line 19)
2. Credits/Payments
A. Spousal Poverty Credit
B. Prior Payments
C. Discount
3. InteresUPenalty if applicable
D. Interest
E. Penalty
4.
5.
If Line 2 is greater than line 1 + Line 3, enter the difference. This is the OVERPAYMENT.
Fill in oval on Page 2, Line 20 to request a refund.
If lane 1 + Line 3 is greater than Line 2, enter the difference. This is the TAX DUE.
A. Enter the interest on the tax due.
B. Enter the total of Line 5 +SA. This is the BALANCE DUE.
0.00
Total Credits (A + B + C) (2) 0.00
Total InteresUPenalty (D + E) (3) 0.00
(5)
(5B)
(4) 0.00
0.00
(5A)
0.00
Make Check Payable to: REGISTER OF WILLS, AGENT
PLEASE ANSWER THE FOLLOWING QUESTIONS BY PLACING AN "X" IN THE APPROPRIATE BLOCKS
1, Did decedent make a transfer and: Yes No
a. retain the use or income of the property transferred : ...................................................................... ^ ^X
b. retain the right to designate who shall use the property transferred or its income; ............................... ^
c. retain a reversionary interest; or ................................................................................................ ^ X^
d. receive the promise for life of either payments, benefits or care? ....................................................... ^ X^
2. If death occurred after December 12,1982, did decedent transfer property within one year of death
without receiving adequate consideration? ....................................................................................... ^
3. Did decedent own an'in trust for' or payable upon death bank account or security at his or her death? ......... ^
4. Did decedent own an Individual Retirement Account, annuity, or other non-probate property which
contains a beneficiary designation? .................................................................................................. ^
IF THE ANSWER TO ANY OF THE ABOVE QUESTIONS IS YES, YOU MUST COMPLETE SCHEDULE G AND FILE IT AS PART OF THE RETURN.
For dates of death on or after July 1,1994 and before January 1,1995, the tax rate imposed on the net value of transfers to or for the use of the surviving spouse
is three (3) percent [72 P.S. §9116 (a) (1.1) (i)].
For dates of death on or after January 1,1995, the tax rate imposed on the net value of transfers to or for the use of the surviving spouse is zero (Oj percent
[72 P.S. §9116 (a) (1.1) (ii)]. The statute does not exemot a transfer to a surviving spouse from tax, and the statutory requirements for disclosure of assets and
filing a tax return are still applicable even if the surviving spouse is the only beneficiary.
For dates of death on or after July 1, 2000:
The tax rate imposed on the net value of transfers from a deceased child twenty-0ne years of age or younger at death to or for the use of a natural parent, an
adoptive parent, or a stepparent of the child is zero (0) percent (72 P.S. §9116(a)(1.2)].
The tax rate imposed on the net value of transfers to or for the use of the decedent's lineal beneficiaries is four and one-half (4.5) percent, except as noted in
72 P.S. §9116(1.2) (72 P.S. §9116(a)(1)].
The tax rate imposed on the net value of transfers to or for the use of the decedent's siblings is twelve (12) percent [72 P.S. §9116(a)(1.3)]. Asibling is defined, under
Section 9102, as an individual who has at least one parent in common with the decedent, whether by blood or adoption.
REV-1502 EX+ (6-98)
' SCHEDULE A
COMMONWEALTH OF PENNSYLVANIA ~ RG/1L ES 1/'11 E
INHERITANCE TAX RETURN
RESIDENT DECEDENT
- __
ESTATE OF FILE NUMBER
ROBERT H. RASMUSSEN
All real property owned soky or as a tenant in common must be reported at fair market value. Fair market value is defined as the price at which properly would be
exchanged between a willing buyer and a willing seller, neiUier being compelled to buy or sell, both having reasonable knowledge of the relevant facts.
Real ro which is i -owned with ht of survivorshi must be disclosed on Schedule F.
ITEM VALUE AT DATE
NUMBER DESCRIPTION OF DEATH
1. NONE 0.00
TOTAL (Also enter on line 1, Recapitulation) .~ S 0.00
(If more space is needed, insert additional sheets of tire same sae)
REV-1503 EX + (8-98)
' SCHEDULE B
COMMONWEALTH OF PENNSYLVANIA STOCKS & BONDS
INHERITANCE TAX RETURN
RESIDENT DECEDENT
ESTATE OF FILE NUMBER
ROBERT H. RASMUSSEN
All property jointly-owned wffh right of survivorship must be disclosed on Schedule F.
ITEM VALUE AT DATE
NUMBER DESCRIPTION OF DEATH
1. NONE 0.00
TOTAL (Also enter on line 2, Recapitulation) ~ s 0.00
(If more space >s needed, insert addffional sheets of the same size)
REV-1504 EX + (8-86)
COMMONWEALTH OF PENNSYLVANIA
INHERITANCE TAX RETURN
RESIDENT DECEDENT
SCHEDULE C
CLOSELY-HELD CORPORATION,
PARTNERSHIP OR
SOLE-PROPRIETORSHIP
ATE OF
FILE NUMBER
ROBERT H. RASMUSSEN
Schedule G1 or G2 (including all supporting information) must be attached for each closely-held corporationlpartnershipinterest ofthe decedent, other than a
sole-proprietorship. See instructions for the supporting information to besubmittedforsole-proprietorships. _
ITEM VALUE AT DATE
NUMBER DESCRIPTION OF DEATH
......~ 0.00
TOTAL (Also enter on line
(If more space is needed, insert additanal sheets of the same size)
REV-1507 EX + (8-98)
SCHEDULE D
CONpNONWEALTH OF PENNSYLVANIA MORTGAGES & NOTES
INHERITANCE TAX RETURN RECEIVABLE
RESIDENT DECEDENT
ESTATE OF FILE NUMBER
ROBERT H. RASMUSSEN
AIt property jointly-owned with the right of survivorship must be disclosed on Schedule F.
ITEM VALUE AT DATE
NUMBER DESCRIPTION OF DEATH
1. MORTGAGE FROM TERESA M. O"SULLIVAN ON PROPERTY LOCATED AT 42,728.13
HASTINGS STREET, WEST ROXBURY, MASSACHUSETTS 02132
Value based on date of death principal balance
TOTAL (Also enter on line 4, Recapitulation) ~ ; 42,728.13
(If more space is needed, insert additisonal sheets of the same size)
REV-1508 EX + (6-98)
COMMONWEALTH OF PENNSYLVANIA
INHERITANCE TAX RETURN
RESIDENT DECEDENT
OF
SCHEDULE E
CASH, BANK DEPOSITS, 8~ MISC.
PERSONAL PROPERTY
FILE NUMBER
ROBERT H. RASMUSSEN
Include the proceeds of litigation and the date the proceeds were n3oeived by the estate.
All uroowty Jointly-owned with right of survivorship must be disclosed on Schedule F.
ITEM VALUE AT DATE
NUMBER DESCRIPTION OF DEATH
1. NONE 0.00
TOTAL (Also enter on line 5, Recapitulation) I S 0.00
(If more space is needed, insert additional sheets of the same size)
REV-1509 EX + (6-98)
• SCHEDULE F
COMMONWEALTH OF PENNSYLVANIA JOINTLY-OWNED PROPERTY
INHERITANCE TAX RETURN
RESIDENT DECEDENT
ESTATE OF FILE NUMBER
ROBERT N. RASMUSSEN __. _
ff an asset was made joint within one year of the decedent's date of death, it must be reported on Schedule G.
SURVMNG JOINT TENANT(S) NAME
A.
B
C
JOINTLY-0WNED PROPERTY:
NONE
ADDRESS
TO DECEDENT
ITEM
NUMBER LETTER
FOR JOINT
. TENANT DATE
MADE
JOINT DESCRIPTION OF PROPERTY
INCLUDE NAME OF FINANCIAL INSTITUTION AND BANK ACCOUNT NUMBER OR SIMILAR
IDENTIFYING NUMBER. ATTACH DEED FOR JOINTLY-HELD REAL ESTATE.
DATE OF DEATH
VALUE OF ASSET % OF
DECD'S
INTEREST DATE OF DEATH
VALUE OF
DECEDENTS INTEREST
1. A. NONE 0.00 0.00
TOTAL (Also enter on line 6, Regpitulation) I S 0.00
(If more space is needed,. insert addfional sheets of the same size)
REV-1510 EX + (6-98)
COMMONWEALTH OF PENNSYLVANIA
INHERITANCE TAX RETURN
RESIDENT DECEDENT
SCHEDULE G
INTER-VIVOS TRANSFERS 8~
MISC. NON-PROBATE PROPERTY
ESTATE OF FILE NUMBER
RABERT M. R~SMUSSEN
This schedule must be completed and filed ff the answer to any of questions 1 through 4 on the reverse side of the REV-1500 COVER SHEET is yes.
ITEM
NUMBER DESCRIPTION OF PROPERTY
INCLUDE THENNAEOFTHEiRIWBFEREE.iHEIRRELATIONSHIPTODECEDENTAND
TM~°"~0P'N""s~rt~rucr'"c~P+oFn+E°EE°PONaExEStnre'
DATE OF DEATH
VALUE OF ASSET
%OFDECD'S
INTEREST
EXCLUSION
pP,wPUCneLEI
TAXABLE
VALUE
1. NONE 0.00 0.00
TOTAL (Also enter on line 7 Recapitulation) I s 0.00.
(If more space is needed, insert additlona(sheets of the same size)
REV-1511 EX + (12-99)
SCHEDULE H
COMMONWEALTH OF PENNSYLVANIA FUNERAL EXPENSES ~
INHERITANCE TAX RETURN ADMINISTRATIVE COSTS
RESIDENT DECEDENT
ESTATE OF FILE NUMBER
ROBERT H. RASMUSSEN
Debts of decedent must be reported on Schedule I.
ITEM
NUMBER DESCRIPTION AMOUNT
A. FUNERAL EXPENSES:
1. EWIN6 BROTHERS FUNERAL HOME, INC. 8,438.08
B. ADMINISTRATIVE COSTS:
1, Personal Representative's Commissions
Name of Personal Representative (s)
Soaal Security Number(s)IEIN Number of Personal Representative(s)
Street Address
City State Zip
Year(s) Commission Paid:
2, Attamey Fees IRWIN LAW OFFICE 1,334:00
3. Family Exemptan: (If decedent's address is not the same as claimant's, attach explanation) 3,500.00
Claimant FRANCES A. RASMUSSEN
Street Address 321 JUNIPER STREET
Cty CARLISLE State PA Zip 17013
Relationship of Claimantto Decedent SPOUSE
4• Probate Fees CUMBERLND COUNTY REGISTER OF WILLS 136.00
5 Aodountant's Fees
6. Tax Retum Preparer's Fees
7. REGISTER OF WILLS - Flle Inventory and Appraisement 30.00
TOTAL (Also enter on line 9, Recapitulation) I S ~ 3A3g.o8
(If more space Ls needed, Insert additional sheets of the same size)
REV-1512 EX + (12-03)
SCHEDULE 1
COMMONWEALTH OF PENNSYLVANIA DEBTS OF DECEDENT,
INHERITANCETAX RETURN MORTGAGE LIABILITIES ~ LIENS
RESIDENT DECEDENT f
ESTATE OF FILE NUMBER
ROBERT H. RASMUSSEN
Report debts incurred by the decedent prior to death which remained unpaid as of the date of death, including unreimbursed medical expenses.
ITEM VALUE AT DATE
NUMBER DESCRIPTION. OF DEATH
1. NONE 0.00
TOTAL (Also enter on line 10, Recapitulation) I S 0.00
(If more space is needed, insert additional sheets of the same size)
REV-1513 EX + (9.00)
SCHEDULE J
COMMONWEALTH OF PENNSYLVANIA BENEFICIARIES
INHERITANCE TAX RETURN
RESIDENT DECEDENT 1
ESTATE OF
FILE NUMBER
ROBERT H. RASMUSSEN
RELATIONSHIP TO DECEDENT AMOUNT OR SHARE
NUMBER NAME AND ADDRESS OF PERSON(S) RECEIVING PROPERTY Do Not List Trustee(s) OF ESTATE
I TAXABLE DISTRIBUTIONS [indude outri~M spousal distributions, and transfers under
Sec. 9116 a 1.2
1. FRANCES A. RASMUSSEN Spousal
321 Juniper Street 100% Residue
CarBsle, PA 17013
ENTER DOLLAR AMOUNTS FOR DISTRIBUTIONS SHOWN ABOVE ON LINES 15 T HROUGH 18, AS APPROPRIATE, ON REV-1500 COVER SHEET
II. NON-TAXABLE DISTRIBUTIONS:
A. SPOUSAL DISTRIBUTIONS UNDER SECTION 9113 FOR WHICH AN ELECTION TO TAXIS NOT BEING MADE
1. NONE 0.00
B. CHARITABLE AND GOVERNMENTAL DISTRIBUTIONS
1. NONE 0.00
TOTAL OF PART II -ENTER TOTAL NON-TAXABLE DISTRIBUTIONS ON LINE 13 OF REV-1500 COVER SHEET : 0.00
(It more space is needed, insert additional sheets of the same size)
. CUMBERLAND COUNTY, PENNSYLVANIA
' REGISTER OF WILLS
INVENTORY
Estate Of ROBERT H. RASMUSSEN Np 21 09
also known as Date of Death v16~2o09
Deceased Social Security No. 174-20-2953
Personal Representative(s) of the above Estate, deceased, verify that the items appearing in the following- inventory include all of the
personal assets wherever situate and all of the real estate in the Commonwealth of Pennsylvania of said Decedent, that the valuation
placed opposite each item of said inventory represents its fair value as of the date of the Decedent's death, and that Decedent owned no
real estate outside the Commonwealth of Pennsylvania except that which appears in a memorandum at the end of this inventory. IIWe
verify that the statements made in this inventory are true and correct. I/VNe understand that false statements herein made are subject to the
penalties of 18 Pa. C.S. Section 4904 relating to unswom falsification to authorities.
Personal Representative:
Name of
Attorney: HAROLD S. IRWIN, 111
I.D. No.: 29920 FRANCES A. RASMUSSEN
Address: 64 SOUTH PITT STREET Dated FEBUARY ,2009
CARLI8LE PA 17013
Telephone: 717-Z43-6090
Description
MORTGAGE GIVEN TO TERESA M. O'SULLIVAN ON POPERTY LOCATED
AT HASTINGS STREET, WEST ROXBURY, MASSACHUSETTS 02132
Value based on date of death principal balance owed to decedent
(Attach Additional Sheets 'rf necessary)
Total
Value
42,728.13
42,728.13
NOTE: The Memorandum of real estate outside the Commonwealth of Pennsylvania may, at the election of the personal representative,
indude the value of each item, but such figures should not be extended into the total of the Inventory.
RW-4
EXHIBIT ^A"
i
t ti~ a
LAST WILL AND TESTAMENT
I, ROBERT H. RASMUSSEN, of 321 Juniper Street, Carlisle, Cumberland
County, Pennsylvania 17013, do hereby make, publish and declare this to be my last
will and testament, hereby revoking all wills heretofore made by me.
1. I direct my personal representative to pay all of my debts, funeral and
administrative expenses as soon as convenient after my decease.
2. I authorize and empower my personal representative to sell any realty
and/or personalty owned by me at my death and not specifically devised or bequeathed
herein, at public or private sale or sales and to give good and sufficient deeds and/or
bills of sale therefor, in fee simple, as I could do if living. My representative is
authorized and empowered to engage in any business in' which I may be engaged at
my death, for such period of time after my death as seems expedient to said
representative.
3. I give, devise and bequeath all of my estate of whatever nature and
wherever situate to my spouse, Frances A. Rasmussen.
4. If my spouse does not survive me by a period of at least sixty (60) days,
then my estate I give, devise and bequeath to Thomas Rasmussen, Gary Rasmussen,
Donna Hicks, Diane McCalister, Laura Duncan, and Lisa Lewellen, share and share
alike, the child or children of any deceased beneficiary taking the share their parent
would have taken if living.
5. Other than the mortgage which I hold on real property in Massachusetts
which is owned by Teresa O'Sullivan, I hereby forgive any remaining indebtedness of
any family members or friends to whom I have loaned money in my lifetime.
6. I nominate and appoint my spouse to be the personal representative of
my estate, to serve without bond. If my spouse cannot or does not serve, then I appoint
Laura Duncan to be the substitute personal representative, also without bond.
7. I suggest that my personal representative retain the services of Harold S.
Irwin, III, Carlisle, Pennsylvania in the settlement of my estate.
IN WITNESS WHEREOF, I have hereunto set my hand and seal this ~ day
of October, 2002.
~~~ !~ /~ ~... (SEAL)
ROBERT H. RASMUSSEN
Signed, sealed, published and declared by the above-named person as and for a
last will and testament, in our presence, who at said person's request, in said person's
presence and in the presence of each other have hereunto set our names as
subscribing witnesses.
~ ~L ,~-~
r
ACKNOWLEDGMENT AND AFFIDAVIT
WE, ROBERT H. RASMUSSEN, HEATHER A. BARBOUR and RHONDA S.
IRWIN, the testator and witnesses respectively, whose names are signed to the
foregoing instrument, being first duly sworn, do hereby declare to the undersigned
authority that the testator signed and executed the instrument as his last will and that
he had signed willingly, and that he executed it as his free and voluntary act for the
purpose herein expressed, and that each of the witnesses, in the presence and hearing
of the testator, signed the will as a witness and that to the best of their knowledge the
testator was, at that time, eighteen years of age or older, of sound mind and under no
constraint or undue influence.
COMMONWEALTH OF PENNSYLVANIA
as:
COUNTY OF CUMBERLAND
Subscribed, sworn to and acknowledged before me by ROBERT H.
RASMUSSEN, the testator herein, and subscribed and sworn to b~ef~f ~ me by
HEATHER A. BARBOUR and RHONDA S. IRWIN, witnesses, this/mar ,r~ day of
October, 2002.
~ ~
Notary Public
NOTARIAL sEAL
80NNIE L COYIi. NOTARY PUBLIC
80R0 OF CARLISLE, CUM9ERLANO COUNTY
MY CONIN118810N EXMRES OCTOBER 17 2002
~s.(.~t ~~ - -.
ROBERT H. RASMUSSEN
EXHIBIT "B"
,i
$130,301.97
DATE: AUGUST 2, 1993
For Value Received; I, Teresa M. O'Sullivan, promise to pay to Robert H.
Rasmussen One hundred thirty thousand three hundred one dollars and .ninety seven
cents ($130,301.97) in two hundred forty (240) monthly payments of eight hundred fifty
eight dollars ($858.00) at the rate of five percent per annum during said term, and for
such further time as said principal sum, or any part thereof shall remain unpaid
provided however, that if any default shall be made in the payment of any installment of
principal or interest and such default continues for 30 days or more, the whole principal
sum then remaining unpaid, together with interest, shall at the option of the holder of
the mortgage thereof become due and payable on demand.
This Agreement, provided properly signed copies are in possession of both
parties, will serve to replace a similar agreement currently in effect for real estate
located at 30 and 32 Hastings Street, W. Roxbury, Massachusetts 02132.
GOp~(
:.
• D
Robert H. Rasmussen
Teresa M. O'Sullivan
AMORTIZE.XLS
Initial Data
LOAN DATA TABLE DATA
Loan amount Table starts at date:
Annual interest rate.. or at payment number: 1
Term in years:
Payments per year.-
First payment due:
PERIODIC PAYMENT ,~,._.,,_
uses the calculated
Calculated payment: x$.00 unless you enter a value for "Entered payment"
CALCULATIONS
Use payment of: $858.00 Beginning balance at payment 1: 130,301.97
1st payment in table: 1 Cumulative interest prior to payment 1: 0.00
Table
Payment Beginning Ending Cumulative
No. Date Interest Princi al Balance Interest
1 9/2/1993 542.92 315.08 129,986.89 542.92
2 10/2/1993 .89 541.61 316.39 129,670.51 1,084.54
3 11/2/1993 129,670.51 540.29 317.71 129,352.80 1,624.83
4 12/2/1993 129,352.80 538.97 319.03 129,033..77 2,163.80
5 1/2/1994 129,033.77 537.64 320.36 128,713.41 2,701.44
6 2/2/1994. 128,713.41 536.31 321.69 128,391.72 3,237.75
7 3/2/1994 128,391.72 534.97 323.03 128,068,68 3,772.71
8 4/2/1994 128,068.68 533.62 324.38 127,744.30 4,306.33
9 5/2/1994 127,744.30 532.27 325.73 127,418.57 4,838.60
10 6/2/1994 127,418.57 530.91 327.09 127,091,48 5,369.51
11 7/2/1994 127,091.48 529.55 328.45 126,763.03 5,899.06
12 8/2/1994 126,763.03 528.18 329.82 126,433.21 6,427.24
13 9/2/1994 126,433:21 526.81 331.19 126,102.01 6,954.04
14 10/2/1994 126,102.01 525.43 332.57 125,769.44 7,479.47
15 11/2/1994 125,769.44 524.04 333.96 125,435.48 8,003.51
16 12/2/1994 125,435.48 522.65 335.35 125,100.13 8,526.16
17 1/2/1995 125,100.13 521.25 336.75 124,763.38 9,047.41
18 2/2/1995 124,763.38 519.85 338.15 124,425.22 9,567.25
19 3/2/1995 124,425.22 518.44 339.56 124,085.66 10,085.69
20 4/2/1995 124,085.66 517.02 340.98 123,744.69 10,602.72
21, 5/2/1995 123,744.69 515.60 342.40 123,402.29 11,118.32
22 6/2/1995 123,402.29 514.18 343.82 123,058.46 11,632.49
23 7/2/1995 123,058.46 512.74 345.26 122,713.21 12,145.24
24 8/2/1995 122,713.21 511.31 346.69 122,366.51 12,656.54
25 9/2/1995 122,366.51 509.86 348.14 122,018.37 13,166.40
26 10/2/1995 122,018.37 508.41 349.59 121,668.78 13,674.81
27 11 /2/1995 121,668.78 506.95 351.05 121,317.74 14,181.77
28 12/2/1995 121,317.74 505.49 352.51 120,965.23 14,687.26
29 1/2/1996 120,965.23 504.02 353.98 120,611.25 15,191.28
30 2/2/1996 120,611.25 502.55 355.45 120,255.80 15,693.83
31 3/2/1996 120,255.80 501.07 356.93 119,898.86 16,194.89
32 4/2/1996 119,898.86 499.58 358.42 119,540.44 16,694.47
33 5/2/1996 119,540.44 498.09 359.91 119,180.53 17,192.56
34 6/2/1996 119,180.53 496.59 361.41 118,819.11 17,689.14
35 7/2/1996 118,819.11 495.08 362.92 118,456.19 18,184.22
36 8/2/1996 118,456.19 493.57 364.43 118,091.76 18,677.79
Page 1
AMORTIZE.XLS
37 9/2/1996 118,091.76 492.05 365.95 117,725.81 19,169.84
38 10/2/1996 117,725.81 490.52 367.48 117,358.33 19,660.36
39 11/2/1996 117,358.33 488.99 369.01 116,989.32 20,149.35
40 12/2/1996 116,989.32 487.46 370.54 116,618..78 20,636.81
41 1/2/1997 116,618.78 485.91 372.09 116,246.69 21,122.72
42 2/2/1997 116,246.69 484.36 373.64 115,873.05 21,607.08
43 3/2/1997 115,873.05 482.80 375.20 115,497.86 22,089.89
44 4/2/1997 115,497.86 481.24 376.76 115,121.10 22,571.13
45 5/2/1997 115,121.10 479.67 378.33 114,742.77 23,050.80
46 6/2/1997 114,742.77 478.09 379.91 114,362.86 23,528.89
47 7/2/1997 114,362.86 476.51 381.49 113,981.38 24,005.41
48 8/2/1997 113,981.38 474.92 383.08 113,598.30 24,480.33
49 9/2/1997 113,598.30 473.33 384.67 113,213.62 24,953.65
50 10/2/1997 113,213.62 471.72 386.28 112,827.35 25,425.38
51 11/2/1997 112,827.35 470.11 387.89 112,439.46 25,895.49
52 12/2/1997 112,439.46 468.50 389.50 112,049.96 26,363.99
53 1/2/1998 112,049.96 466.87 391.13 111,658.83 26,830.86
54 2/2/1998 111,658.83 465.25 392.75 111,266.08 27,296.11
55 3/2/1998 111,266.08 463.61 394.39 110,871.69 27,759.72
56 4/2/1998 110,871.69 461.97 396.03 110,475.65 28,221.68
57 5/2/1998 110,475.65 460.32 397.68 110,077.97 28,682.00
58 6/2/1998 110,077.97 458.66 399.34 109,678.63 29,140.66
59 7/2/1998 109,678.63 456.99 401.01 109,277.62 29,597.65
60 8/2/1998 109,277.62 455.32 402.68 108,874.94 30,052.97
61 9/2/1998 108,874.94 453.65 404.35 108,470.59 30,506.62
62 10/2/1998 108,470.59 451.96 406.04 108,064.55 30,958.58
63 11/2/1998 108,064.55 450.27 407.73 107,656.82 31,408.85
64 12/2/1998 107,656.82 448.57 409.43 107,247.39 31,857.42
65 1/2/1999 107,247.39 446.86 411.14 106,836.25 32,304.28
66 2/2/1999 106,836.25 445.15 412.85 106,423.41 32,749.44
67 3/2/1999 106,423.41 443.43 414.57 106,00$.84 33,192.87
68 - - 4/?J1999 - _ -_~06,00~.$d _ _ _ 441.7 416-:30 _ _ 105~592~b4 _ 33,~34~57
69 5/2/1999 105,592.54 439.97 418.03 105,174.51 34,074.54
70 6/2/1999 105,174.51 438.23 419.77 104,754.74 34,512.77
71 7/2/1999 104,754.74 436.48 421.52 104,333.21 34,949.24
72 8/2/1999 104,333.21 434.72 423.28 103,909.94 35,383.97
73 9/2/1999 103,909.94 432.96 425.04 103,484.89 35,816.92
74 ~ 10/2/1999 103,484.89 431.19 426.81 103,058.08 36,248.11
75 11/2/1999 103,058.08 429.41 428.59 102,629.49 36,677.52
76 ,12/2/1999 102,629.49 427.62 430.38 102,199.11 37,105.14
77 1/2/2000 102,199.11 425.83 432.17 101,766.94 37,530.97
78 2/2/2000 101,766.94 424.03 433.97 101,332.97 37,955.00
79 3/2/2000 101,332.97 422.22 435.78 100,897.19 38,377.22
80 4/2/2000 100,897.19 420.40 437.60 100,459.60 38,797.63
81 5/2/2000 100,459.60 418.58 439.42 100,020.18 39,216.21
82 6/2/2000 100,020.18 416.75 441.25 99,578.93 39,632.96
83 7/2/2000 99,578.93 414.91 443.09 99,135.84 40,047.87
84 8/2/2000 99,135.84 413.07 444.93 98,690.91 40,460.94
85 9/2/2000 98,690.91 411.21 446.79 98,244.12 40,872.15
86 10/2/2000 98,244.12 409.35 448.65 97,795.47 41,281.50
87 11/2/2000 97,795.47 407.48 450.52 97,344.95 41,688.98
88 12/2/2000 97,344.95 405.60 452.40 96,892.55 42,094.58
89 1/2/2001 96,892.55 403.72 454.28 96,438.27 42,498.30
90 2/2/2001 96,438.27 401.83 456.17 95,982.10 42,900.13
91 3/2/2001 95,982.10 399.93 458.07 95,524.03 43,300.06
Page 2
AMORTIZE.XLS
92 4/2/2001 95,524.03 398.02 459.98 95,064.04 43,698.07
93 5/2/2001 95,064.04 396.10 461.90 94,602.14 44,094.17
94 6/2/2001 94,602.14 394.18 463.82 94,138.32 44,488.35
95 7/2/2001 94,138.32 392.24 465.76 93,672.56 44,880.59
96 8/2/2001 93,672.56 390.30 467.70 93,204.86 45,270.89
97 9/2/2001 93,204.86 388.35 469.65 92,735.22 45,659.25
98 10/2/2001 92,735.22 386.40 471.60 92,263.61 46,045.64
99 11/2/2001 92,263.61 384.43 473.57 91,790.05 46,430.08
100 12/2/2001 91,790.05 382.46 475.54 91,314.50 46,812.53
101 1 /2/2002 91, 314.50 380.48 477.52 90,836.98 47,193.01
102 2/2/2002 90,836.98 378.49 479.51 90,357.47 47,571.50
103 3/2/2002 90,357.47 376.49 481.51 89,875.96 47,947.99
104 4/2/2002 89,875.96 374.48 483.52 89,392.44 48,322.47
105 5/2/2002 89,392.44 372.47 485.53 88,906.91 48,694.94
106 6/2/2002 88,906.91 370.45 487.55 88,419.36 49,065.39
107 7/2/2002 88,419.36 368.41 489.59 87,929.77 49,433.80
108 8/2/2002 87,929.77 366.37 491.63 87,438.14 49,800.17
109 9/2/2002 87,438.14 364.33 493.67 86,944.47 50,164.50
110 10/2/2002 86,944.47 362.27 495.73 86,448.74 50,526.77
111 11/2/2002 86,448.74 360.20 497.80 85,950.94 50,886.97
112 12/2/2002 85,950.94 358.13 499.87 85,451.07 51,245.10
113 1/2/2003 85,451.07 356.05 501.95 84,949.12 -51,601.15
114 2/2/2003 84,949.12 353.95 504.05 84,445.07 51,955.10
115 3/2/2003 84,445.07 351.85 506.15 83,938.92 52,306.95
116 4/2/2003 83,938.92 349.75 508.25 83,430.67 52,656.70
117 5/2/2003 83,430.67 347.63 510.37 82,920.30 53,004.33
118 6/2/2003 82,920.30 345.50 512.50 82,407.80 53,349.83
119 7/2/2003 82,407.80 343.37 514.63 81,893.16 53,693.19
120 8/2/2003 81,893.16 341.22 516.78 81,376.39 54,034.42
121 9/2/2003 81,376.39 339.07 518.93 80,857.45 54,373.48
122 10/2/2003 80,857.45 336.91 521.09 80,336.36 54,710.39
123 11/2/2003 80,336.36 334.73 523.27 79,813.10 55,045.13
124 12/2/2003 79,813.10 .332.55 525.45 79,287.65 55,377.68
125 1/2/2004 79,287.65 330.37 527.63 78,760.02 55,708.05
126 2/2/2004 78,760.02 328.17 529.83 78,230.18 56,036.21
127 3/2/2004 78,230.18 325.96 532.04 77,698.14 56,362.17
128 4/2/2004 77,698.14 323.74 534.26 77,163.$8 56,685.91
129 5/2/2004 77,163.88 321.52 536.48 76,627.40 57,007.43
130 6/2/2004 76,627.40 319.28 538.72 76,088.68 57,326.71
131 7/2/2004 76,088.68 317.04 540.96 75,547.72 57,643.75
132 8/2/2004 75,547.72 314.78 543.22 75,004.50 57,958.53
133 9/2/2004 75,004.50 312.52 545.48 74,459.02 58,271.05
134 10/2/2004 74,459.02 310.25 547.75 73,911.26 58,581.29
135 11/2/2004 73,911.26 307.96 550.04 73,361.23 58,88926
136 .12/2/2004 73,361.23 305.67 552.33 72,808.90 59,194.93
137 1/2/2005 72,808.90 303.37 554.63 72,254.27 59,498.30
138 2/2/2005 72,254.27 301.06 556.94 71,697.33 59,799.36
139 3/2/2005 71,697.33 298.74 559.26 71,138.07 60, 098.10
140 4/2/2005 71,138.07 296.41 561.59 70,576.48 60,394.51
141 5/2/2005 70,576.48 294.07 563.93 70,012.54 60,688.57
142 6/2/2005 70,012.54 291.72 566.28 69,446.26 60,980.29
143 7/2/2005 69,446.26 289.36 568.64 68,877.62 61,269.65
144 8/2/2005 68,877.62 286.99 571.01 68,306.61 61,556.64
145 9/2/2005 68,306.61 284.61 573.39 67,733.22 61,841.25
146 10/2/2005 67,733.22 282.22 575.78 67,157.45 62,123.48
Page 3
4
AMORTIZE.XLS
147 11/2/2005 67,157.45 279.82 578.18 66,579.27 62,403.30
148 12/2/2005 66,579.27 277.41 580.59 65,998.68 62,680.71
149 1/2/2006 65,998.68 274.99 583.01 65,415.68 62,955.71
150 2/2/2006 65,415.68 272.57 585.43 64,830.24 63,228.27
151 3/2/2006 64,830.24 270.13 587.87 64,242.37 63,498.40
152 4/2/2006 64,242.37 267.68 590.32 63,652.04 63,766.07
153 5/2/2006 63,652.04 265.22 592.78 63,059.26 64,031.29
154 6/2/2006 63,059.26 262.75 595.25 62,464.01. 64,294.04
155 7/2/2006 62,464.01 260.27 597.73 61,866.28 64,554.31
156 8/2/2006 61,866.28 257.78 600.22 61,266.05 64,812.08
157 9/2/2006 61,266.05 255.28 602.72 60,663.33 65,067.36
158 10/2/2006 60,663.33 252.76 605.24 60,058.09 65,320.12
159 11/2/2006 60,058.09 250.24 607.76 59,450.33 65,570.36
160 12/2/2006 59,450.33 247.71 610.29 58,840.04 65,818.07
161 1/2/2007 58,840.04 245.17 612.83 58,227.21 66,063.24
162 2/2/2007 58,227.21 242.61 615.39 57,611.82 66,305.85
163 3/2/2007 57,611.82 240.05 617.95 56,993.87 66,545.90
164 4/2/2007 56,993.87 237.47 620.53 56,373.35 66,783.38
165 5/2/2007 56,373.35 234.89 623.11 55,750.23 67,018.26
166 6/2/2007 55,750.23 232.29 625.71 55,124.53 67,250.56
167 7/2/2007 55,124.53 229.69 628.31 54,496.21 67,480.24
168 8/2/2007 54,496.21 227.07 630.93 53,865.28 67,707.31
169 9/2/2007 53,865.28 224.44 633.56 53,231.72 67,931.75
170 10/2/2007 53,231.72 221.80 636.20 52,595.52 68,153.55
171 11/2/2007 52,595.52 219.15 638.85 51,956.67 68,372.70
172 12/2/2007 51,956.67 216.49 641.51 51,315.15 68,589.18
173 1/2/2008 51,315.15 213.81 644.19 50,670.97 68,803.00
174 2/2/2008 50,670.97 211.13 646.87 50,024.09 69,014.12
175 3/2/2008 50,024.09 208.43 649.57 49,374.53 69,222.56
176 4/2/2008 49,374.53 205.73 652.27 48,722.26 69,428.29
177 5/2/2008 48,722.26 203.01 654.99 48,067.26 69,631.29
178 6/2/2008 48,067.26 200.28 657.72 47,409.55 69,831.58
179 7/2/2008 47,409.55 197.54 660.46 46,749.08 70,029.11
180 8/2/2008 46,749.08 194.79 663.21 46,085.$7 70,223.90
181 9/2/2008 46,085.87 192.02 665.98 45,419.90 70,415.93
182 10/2/2008 45,419.90 189.25 668.75 44,751.15 70,605.18
183 11/2/2008 44,751.15 186.46 671.54 44,079.61 70,791.64
184 08 44,079.61 183.67 674.33 43,405.27 70,975.30
185 $`
Page 4