Comparative Income Statement - Real Estate Accounting

Transcription

Database:ENTITY:PYRAMID300Comparative Income StatementIncome StatementPyramid Real EstateABC COMMERCIAL PROPERTY ASSOCIATESPage:Date:Time:13/13/200808:42 AMAccrualReport includes an open period. Entries are not final.VarianceActualDec 2007Year-To-DateBudgetDec 70.88784,497.1418,773.74784,497.14Real Estate ExpenseSewer Tax 4.106,764.00Total 00874.06139.093,500.008,500.00Utilities - 2,000.00Thru:ActualDec 2007Current PeriodBudgetDec 200762,379.0325.00600.0016,856.341,139.09Operating Income:Base Rent IncomeElectric IncomeLate Fee IncomeEscalations OperatingEscalations Real Estate TaxOther IncomeOperating Income - TotalOperating Expenses:Taxes:Utilities:Repairs:

Database:ENTITY:PYRAMID300Comparative Income StatementIncome StatementPyramid Real EstateABC COMMERCIAL PROPERTY ASSOCIATESPage:Date:Time:23/13/200808:42 AMAccrualReport includes an open period. Entries are not final.ActualDec 2007Current PeriodBudgetDec 2007VarianceActualDec 2007Year-To-DateBudgetDec 2007VarianceAnnualBudgetHVAC RepairsOn Site ManagementGeneral Building 0,000.00Repairs - ,363.3854,000.00Cleaning & SuppliesGeneral Building MaintenanceLandscaping & Snow RemovalRefuse & 0.0012,000.0012,000.00870.00Maintenance - 21,947.49)32,870.00InsuranceOther Administrative ExpenseTaxesManagement (250.00)0.0012,000.0010,000.000.0037,184.00Other Operating 1,143.0259,184.00Total Operating ,732.10(19,446.93)248,732.10Operating 65.04(673.19)535,765.04Thru:Maintenance:Other Operating Expenses:

Database:ENTITY:PYRAMID300Comparative Income StatementIncome StatementPyramid Real EstateABC COMMERCIAL PROPERTY ASSOCIATESPage:Date:Time:33/13/200808:42 AMAccrualReport includes an open period. Entries are not final.Thru:ActualDec 2007Current PeriodBudgetDec 2007VarianceActualDec 2007Year-To-DateBudgetDec .43Other Income & ExpensesMortgage Interest ExpenseMortgage Principal ExpenseOther Mortgage ExpenseDistributionsCommission ExpenseNon Routine ExpenseProfessional FeesClosing ExpenseInterest IncomeNet Income (Loss)

Database:ENTITY:PYRAMID225Balance SheetPyramid Real EstateABC COMMERCIAL PROPERTY INC.AccrualNov 2006Current Assets:Cash - Bank of America OperatingCash - Bank of America Working Capital ReserveCash - Bank of America Capital Project ReservePeople's CDAccount ReceivableOther ReceivablesDue From Operating FundAdvanced WagesPrepaid InsurancePrepaid ExpensesTotal abilities:Accounts PayableAdvance Payments Common ChargesDue to Capital Reserve FundDue to Repairs & Maint FundAccrued 1Total Liabilities86,931.19Equity:Working Capital ReserveCapital Expenditure ReserveRepairs & Maintenance FundNet Income (Loss) YTD50,000.0028,543.8937,694.707,048.34Net Worth123,286.93Total Liabilities & Capital210,218.12Page:Date:Time:12/12/200809:03 AM

InvoiceDateBCAIN66643/1/2008Vendor Total Owed:Vendor:52292HOFFDueDateP.O. NumberBRIAN CANE LAND SERVICES2/13/20082/13/20082/23/20086731Aged Invoice ListPyramid Real EstateABC COMMERCIAL PROPERTY INC2/23/20083/1/20083/12/20083/12/2008510SNOW PLOWING5105103/20/20083/20/2008SNOW PLOWINGSNOW PLOWING5101505.4GALS @ 2.249013/13/200808:34 AMInvoice 2/17/2004 Invoice 1/17/2004 Invoice beforethru 1/18/2004thru 000.000.000.000.000.000.000.000.00RRRVendor - Total Released:Vendor - Total On Hold:Vendor - Grand 0.000.00Vendor - Total Released:Vendor - Total On Hold:Vendor Total Owed:0.000.0Page:Date:Time:StatusVendor - Total Released:Vendor - Total On Hold:Vendor - Grand Total:3,385.64Vendor: NEWALNEWALLIANCE FMAN FUEL COMPANY INC.2/15/20082/25/2008Vendor Total Owed:EntityAging by Invoice DateUsing Gross Amounts4,340.18Vendor - Grand Total:4,340.180.00

Database:PYRAMIDBLDG:300Invoice 23/20065/12/2008CAMLATLATCAMLATCAMLATAged DelinquenciesPyramid Real EstateABC COMMERCIAL PROPERTY ASSOCIATESDate: 00.001,452.75218.65278.301,500.000.00COMMON AREA MAINTLATE REEN ACRE VARIETYDARN AMBSKI203-715-6790-CCOMMON AREA MAINTCHLATE FEECHLATE FEECHCOMMON AREA MAINTCHMONTHLY RENTCHLATE FEECHPYRAMID LEGAL COLLECTIONCOMMON AREA MAINTMONTHLY RENTLATE FEECOMMON AREA MAINTLATE FEEPYRAMID LEGAL COLLECTIONMONTHLY RENTCOMMON AREA MAINTLATE FEEPYRAMID LEGAL COLLECTIONMONTHLY RENTBLDG 300 Total:CAMLATPLC1200.000.000.000.000.00COMMON AREA MAINTMONTHLY RENTCOMMON AREA MAINTLATE FEEPYRAMID LEGAL COLLECTIONCHCHCHDay Due:1Last Payment:900.000.000.000.00278.30GREEN ACRE VARIETY 8.30THE PRINCETOWN VIEW Total:300-00298130Master Occupant Id: 00000037-1300-01 CurrentTHE PRINCETOWN VIEWJASON ACCOUNTS PAYABLE901-620-3000CAM COMMON AREA MAINTCRRNT MONTHLY RENTCRCAMRNTCurrent16/9/200804:50 PMPURE DANCE STUDIOMICHAEL WEISS / BRETT ALMANN203-231-7468-WPCOMMON AREA MAINTCHLATE FEECHLATE FEECHCOMMON AREA MAINTCHLATE FEECHPURE DANCE STUDIO Total:300-001782AmountPage:Date:Time:Master Occupant Id: 00001776-1300-03 CurrentDay Due:1Last Payment:Delq Day: 106/2/20087,300.00Delq Day: 105/29/2008 .27-5,767.270.000.000.000.00Master Occupant Id: 00002978-130007CurrentDay Due:1Last Payment:Delq 06.25748.620.000.00730.630.0010,776.50496.950.00

Database:BLDG:PYRAMID300Expiration ListingACB COMMERCIAL PROPERTY ASSOCIATESAll Expiration Dates IncludedBldg IdLease IdSuite IdOccupant Name300001339300-04NAILS AND PAILS, INC.Page:Date:Time:Annual RentRent urrentNotesNumberOption DateOption TypeNotice DateSuite IdTerm 6060Total for 200997,792.56Number of Leases Expiring: 116/9/200801:39 PMSqft% of Bldg1,0005.371,000300000879300-9BROCK B. 01782300-03THE PRINCETOWN umberOption DateOption TypeNotice DateSuite IdTerm (mo.)110/1/2010REN3/1/2010300-0360SPIRIT SHOP, INC.170,964.84000042300-06Option DateOption TypeNotice DateSuite IdTerm (mo.)Notes111/1/2005REN5/1/2005300-1160INCREASE MIN. OF 1/2% CPI ANNUALLYSPIRIT SHOP, INC.12/1/199910/31/2010NumberOption DateOption TypeNotice Date28,361.64Suite IdTerm (mo.)Notes111/1/2005REN5/1/2005300-12603% BUMPS EACH YEARCONNECTICUT SCHOOL OF MEDICINE8/10/20019/30/20112,000NotesOption TypeNotice DateSuite IdTerm (mo.)REN3/30/2006300-0660PURE DANCE STUDIO30000315830008EASTSIDE REALTY GROUP, LTD10.73Number of Leases Expiring: tion DateOption TypeNotice DateSuite IdTerm (mo.)17/1/2012REN12/31/20113000860FIRST ABC BANKCurrent2.15100,202.16NumberTotal for on Date000037400Number of Leases Expiring: 41300Current294,958.08NumberTotal for 201130010/31/2010NumberTotal for 20103008/1/1980134,480.16Number of Leases Expiring: 23,695431,571.243,7386/1/19965/31/2016NumberOption DateOption TypeNotice DateSuite IdTerm 5300-10300-106060Current20.06

Database:Bldg Status:Rent RollABC COMMERCIAL PROPERTY ASSOCIATES5/31/2008PYRAMIDAllBldg Id-Suit IdOccupant NameRent StartExpirationProrataShareGLASqftMonthlyBase RentAnnualRate PSFMonthlyCost ther Income16/9/200804:53 PM---------------- Future Rent Increases ---------------CatDateMonthly AmountPSFOccupied Suites300-300-01PURE DANCE STUDIOS5/1/19904/30/20120.0000 1,8955,492.7934.78300-300-02TUNA'S DELI9/15/19755/31/201810.1400 1,0004,315.4351.79300-300-03THE PRINCETOWN VIEW6/1/20059/30/20100.0000 2,0004,244.3725.47300-300-04NAILS AND PAILS, INC.12/1/200411/30/20090.0000 1,0003,166.9238.00300-300-06CONNECTICUT SCHOOL OF MED8/10/20019/30/20110.0000 2,0003,500.0021.00300-300-10FIRST ABC BANK6/1/19965/31/20160.0000 3,73820,052.8164.37300-300-11SPIRIT SHOP, INC.8/1/198010/31/20100.0000 2,4007,470.8237.35300-300-12SPIRIT SHOP, 00-9B ROCK B. 076/1/20072/28/20179.8000 1,8006,180.0041.20GREEN ACRES 45.0246.3747.7649.1950.6752.191,306.25

Database:ENTITY:PYRAMID300General LedgerPyramid Real EstateABC COMMERCIAL PROPERTY ASSOCIATESAccrualPage:Date:Time:13/13/200808:40 AM12/07 - 12/07Report includes an open period. Entries are not final.AccountEntityPeriodEntryDateSrc H - USB OPERATINGBalance Forward0.001016CASH - BANK OF AMERICA OPERATINGBalance Forward136,619.81300@300@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0760,200.83ABC COMMERCIAL PROPERTY ASSOCIATES12/07A/P Cash Disbursed for checks 0-015,138.0845,062.75ABC COMMERCIAL PROPERTY12/07 12/31/07 CMAREA MA 2,189.6447,252.39300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041583 Cash Recpt RNT MONTHLY RENT9,541.9256,794.31@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041622 Cash Recpt CAM COMMON AREA MA 1,522.90 58,317.21@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041622 Cash Recpt ELC ELECTRIC25.00 58,342.21@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041622 Cash Recpt RNT MONTHLY RENT5,088.4963,430.70@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041681 Cash Recpt CAM COMMON AREA MA 181.7663,612.46@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041681 Cash Recpt RET REAL ESTATE TAX90.0063,702.46@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041681 Cash Recpt RNT MONTHLY RENT8,547.5872,250.04@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041756 Cash Recpt CAM COMMON AREA MA 2,158.33 74,408.37@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041756 Cash Recpt RET REAL ESTATE TAX1,049.0975,457.46@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041756 Cash Recpt RNT MONTHLY RENT24,368.2499,825.70@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041846 Cash Recpt RNT MONTHLY RENT3,500.00103,325.70@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041987 Cash Recpt CAM COMMON AREA MA 1,967.20 105,292.90@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700041987 Cash Recpt RNT MONTHLY RENT5,332.80110,625.70@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700042283 Non Suf Fund CAM COMMON AREA1,967.20108,658.50@300ABC COMMERCIAL PROPERTY ASSOCIATES12/0700042283 Non Suf Fund RNT MONTHLY RENT5,332.80103,325.70@300ABC COMMERCIAL PROPERTY ASSOCIATES12/07Transfer to Patriot Bk Op15,138.0888,187.62@300ABC COMMERCIAL PROPERTY ASSOCIATES12/07Reclass Patriot Bk Mtg Payment 63003929@00041583 Cash Recpt CAM COMMONA/P Cash Disbursed for checks 6364-6388 2/31/07RC00674812/31/07** Account Totals1051300@300@CASH-PATRIOT OPABC COMMERCIAL PROPERTY ASSOCIATES35,138.18ABC COMMERCIAL PROPERTY ASSOCIATESReclass Patriot Bk Mtg Payment ce 10RC006748Transfer to Patriot Bk Op15,138.08** Account Totals15,138.08RC00674815,138.0820,000.101075CASH - R.E. TAX ESCROWBalance Forward0.001100EXCHANGE/TRANSFERBalance Forward0.00

Database:ENTITY:PYRAMID300Check RegisterPyramid Real EstateABC COMMERCIAL PROPERTY ASSOCIATESPage:1Date: 3/13/2008Time: 08:39 AM12/1/2007 Through 12/31/2007Check #Check 636830063693003003003006370300300Check Pd12/4/200712/07INVOICE# 060418MISC. EXPENSES12/5/200712/0708-25-07 - 11-17-0712/5/200712/0712/07 CHG12/12/200712/0710-29-07 - 11-29-0712/12/200712/07BALSM STRIBUTION:VendorP.O. Invoice NumberInvoiceDateABC REAL ESTATE & MNGMNT GRP, AQUARION WATER COMP. OF CONNECTICUT5130200080012-Nov07 11/19/2007CITY CARTING & RECYCLING INC.5350322210612/2/2007NORTHEAST UTILITIES5120795621913-Nov07 11/29/2007PLANT SCAPES5325257171000-1100 POST ROAD, DISTRIBUTIONALSO ue k 132.52Check heck k eck 00.002,423.16692.322,019.15576.93Check 32576.930.000.00692.32576.93Check Total:1,269.250.001,269.25

Mr. John SmithABC Tenant123 Main StreetGreenwich, CT 06830RE:2005 Common Area Maintenance ReconciliationDear Mr. Smith:I have enclosed with this letter a statement of actual operating expenses for 2008 for yourspace at ABC Shopping Center in Westport, Connecticut. Below is the reconciliationof actual versus estimated expenses, as provided for in your lease.2008 Expenses 182,748.00Pro Rata Share11%Your ShareLess agreed 50%Your ShareLess previously billedBalance due: 20,102.2810,051.14 10,051.148,333.12 1,718.02Monthly CAM Charge Effective April 1, 20062005 Common Area Maintenance 837.59Please be advised that this amount will be reflected on your next rent invoice. Do nothesitate to contact me at (203) 348-8566 ext. 119 should you require clarification.Yours truly,Frances Sabatocc:Accounting

ABC Commercial Property123 Main StreetGreenwich, CT 06830(203) 123-456710/21/2008ABC TenantABC COMPANY123 MAIN STREETGREENWICH, CT 06830Day Due:1Delq Day:10Last Payment: 3,335.39Payment Date: 10/8/2008Re: Lease 999-000394 at PYRAMID REAL ESTATE GROUPDear Tenant:We are writing to inform you that your account is currently past due. Our records show that as of theabove date the following items are 8DescriptionCAMLATCAMRNTCOMMON AREA MAINTLATE FEECOMMON AREA MAINTMONTHLY RENTChargesPaymentsBalance 88169.32505.872,880.40Total Due3,606.47We would appreciate your prompt attention to this matter. If you have any questions, please call ouroffice at the above number.Sincerely,RUSSELL MUNZ

ABC COMMERCIAL PROPERTY INC123 MAIN STREETSTAMFORD CT 06901NOTE: THIS AREA CAN BE USED FOR CUSTOM NOTES TOUNIT D0001 0000001 00000000 001 001 00001 INS: 0 0*069025468136*MR. COMMERCIAL PROPERTY OWNERABC COMMERCIAL PROPERTY INC123 MAIN STREET, UNIT #1CSTAMFORD CT 06901MAKE CHECKS PAYABLE TO: ABC CONDO AMLTFRENTCOMMON AREA MAINTENACLATE FEEDATE11/01/06ACCOUNT NUMBER530 - 000452LOCATIONUNIT1C123 MAIN STREETCHARGESPAYMENTS 164.00 239.00 117.94AMOUNT DUE 0.00 0.00 0.00 164.00 239.00 117.94Payment received after the 12th of the month will have Late Fees.Please send this portion of the statement with your remittance. 520.94DATE11/01/06ACCOUNT NUMBER530 - 000452LOCATIONUNIT123 MAIN STREET1CCURRENTABC COMMERCIAL PROPERTY INCC/O PYRAMID REAL ESTATEP.O. BOX 120005STAMFORD CT 0691212230000000005300004526 2 520.9430 0.0060 0.0090 0.00120BALANCE DUE 0.00 520.94000052094 0038509619276 1101068

Pyramid Real Estate Time: 08:42 AM ABC COMMERCIAL PROPERTY ASSOCIATES Accrual Report includes an open period. Entries are not final. Current Period Year-To-Date Actual Budget Actual Budget Annual Thru: Dec 2007 Dec 2007 Variance Dec 2007 Dec 2007 Variance Budget HVAC Repairs