Invoice Summary Sheet - Excel

Document Sample
Invoice Summary Sheet - Excel Powered By Docstoc
					[PROJECT NAME] EXPENSES THRU [DATE]

*** FILL IN PEACH-HIGHLIGHTED CELLS ONLY FOR EACH INVOICE FOR WHICH PAYMENT IS REQUESTED FROM DCA AND OTHER SOURCES; TOTALS ARE AUTOMATICALLY
CALCUATED. ROWS MAY BE ADDED AS NEEDED

                                                                                                      Funding
                                                                  Invoice                                                 Cancelled
    DCA budget item              Vendor name          Invoice #             Description                Source    CHECK #               Amount                     Comments
                                                                    date                                                 check (Y/N)
                                                                                                    DCA or Other
PRE DEVELOPMENT COSTS
   Property Appraisal
                      example vendor                    1111      1/1/10    appraisal                              0000                  1,000.00


                                                                                                                                         1,000.00 subtotal

    Market Study



                                                                                                                                                -   subtotal

    Environmental Report(s)



                                                                                                                                                -   subtotal

    Soil Borings



                                                                                                                                                -   subtotal

    Boundary &Topo Survey



                                                                                                                                                -   subtotal

    Zoning/Site Plan Fees



                                                                                                                                                -   subtotal

    Other:



                                                                                                                                              -   subtotal
                                                                                                                                         1,000.00 PRE DEVELOPMENT COSTS

ACQUISITION
   Acquisition



                                                                                                                                                -   subtotal

    Land



                                                                                                                                                -   subtotal

    Demolition



                                                                                                                                                -   subtotal

    Acquisition Legal Fees (if existing structures)



                                                                                                                                                -   subtotal

    Existing Structures



                                                                                                                                                -   subtotal
                                                                                                                                                -   ACQUISITION

CONSTRUCTION PERIOD FINANCING
   Construction Loan Fees



                                                                                                                                                -   subtotal

    Construction Loan Interest




                                                                                          1 of 10
[PROJECT NAME] EXPENSES THRU [DATE]

*** FILL IN PEACH-HIGHLIGHTED CELLS ONLY FOR EACH INVOICE FOR WHICH PAYMENT IS REQUESTED FROM DCA AND OTHER SOURCES; TOTALS ARE AUTOMATICALLY
CALCUATED. ROWS MAY BE ADDED AS NEEDED

                                                                                               Funding
                                                           Invoice                                                 Cancelled
    DCA budget item             Vendor name    Invoice #             Description                Source    CHECK #               Amount                  Comments
                                                             date                                                 check (Y/N)
                                                                                             DCA or Other



                                                                                                                                         -   subtotal

    Construction Legal Fees



                                                                                                                                         -   subtotal

    Construction Period Real Estate Tax



                                                                                                                                         -   subtotal

    Construction Insurance



                                                                                                                                         -   subtotal

    Bridge Loan Fee and Bridge Loan Interest



                                                                                                                                         -   subtotal

    Other:



                                                                                                                                         -   subtotal
                                                                                                                                         -   CONSTRUCTION PERIOD FINANCING

PROFESSIONAL SERVICES
   Architectural Fee - Design



                                                                                                                                         -   subtotal

    Architectural Fee - Supervision




                                                                                                                                         -   subtotal

    Engineering




                                                                                                                                         -   subtotal

    Real Estate Attorney



                                                                                                                                         -   subtotal

    Accounting



                                                                                                                                         -   subtotal

    Other:



                                                                                                                                         -   subtotal
                                                                                                                                         -   PROFESSIONAL SERVICES

LOCAL GOVERNMENT FEES
   Building Permits



                                                                                                                                         -   subtotal

    Impact Fees




                                                                                   2 of 10
[PROJECT NAME] EXPENSES THRU [DATE]

*** FILL IN PEACH-HIGHLIGHTED CELLS ONLY FOR EACH INVOICE FOR WHICH PAYMENT IS REQUESTED FROM DCA AND OTHER SOURCES; TOTALS ARE AUTOMATICALLY
CALCUATED. ROWS MAY BE ADDED AS NEEDED

                                                                                                          Funding
                                                                      Invoice                                                 Cancelled
    DCA budget item             Vendor name               Invoice #             Description                Source    CHECK #               Amount                  Comments
                                                                        date                                                 check (Y/N)
                                                                                                        DCA or Other



                                                                                                                                                    -   subtotal

    Water Tap Fees



                                                                                                                                                    -   subtotal

    Sewer Tap Fees



                                                                                                                                                    -   subtotal

    Other:



                                                                                                                                                    -   subtotal
                                                                                                                                                    -   LOCAL GOVERNMENT FEES

PERMANENT FINANCING FEES
   Permanent Financing Fees



                                                                                                                                                    -   subtotal

    Permanent Loan Fees



                                                                                                                                                    -   subtotal

    Permanent Loan Legal Fees



                                                                                                                                                    -   subtotal

    Title and Recording Fees



                                                                                                                                                    -   subtotal

    As-Built Survey



                                                                                                                                                    -   subtotal

    Bond Issuance Premium



                                                                                                                                                    -   subtotal

    Cost of Issuance / Underwriter's Discount



                                                                                                                                                    -   subtotal

    Other:



                                                                                                                                                    -   subtotal
                                                                                                                                                    -   PERMANENT FINANCING FEES

DCA RELATED COSTS
   DCA Cur. Loan Appl Fee



                                                                                                                                                    -   subtotal

    Tax Credit Application Fee (less DCA Mkt Study fee)




                                                                                              3 of 10
[PROJECT NAME] EXPENSES THRU [DATE]

*** FILL IN PEACH-HIGHLIGHTED CELLS ONLY FOR EACH INVOICE FOR WHICH PAYMENT IS REQUESTED FROM DCA AND OTHER SOURCES; TOTALS ARE AUTOMATICALLY
CALCUATED. ROWS MAY BE ADDED AS NEEDED

                                                                                             Funding
                                                         Invoice                                                 Cancelled
    DCA budget item            Vendor name   Invoice #             Description                Source    CHECK #               Amount                  Comments
                                                           date                                                 check (Y/N)
                                                                                           DCA or Other

                                                                                                                                       -   subtotal

    DCA-Commissioned Market Study



                                                                                                                                       -   subtotal

    DCA Waiver Fees



                                                                                                                                       -   subtotal

    LIHTC Allocation Processing Fee



                                                                                                                                       -   subtotal

    LIHTC Compliance Monitoring Fee



                                                                                                                                       -   subtotal

    DCA Front End Analysis Fee



                                                                                                                                       -   subtotal

    DCA Final Inspection Fee



                                                                                                                                       -   subtotal

    Other:



                                                                                                                                       -   subtotal
                                                                                                                                       -   DCA RELATED COSTS

EQUITY COSTS
   Partnership Organization Fees



                                                                                                                                       -   subtotal

    Tax Credit Legal Opinion



                                                                                                                                       -   subtotal

    Syndicator Legal Fees



                                                                                                                                       -   subtotal

    Other:



                                                                                                                                       -   subtotal
                                                                                                                                       -   EQUITY COSTS

DEVELOPERS FEE
   Developer's Fee



                                                                                                                                       -   subtotal

    Developer's Overhead



                                                                                                                                       -   subtotal




                                                                                 4 of 10
[PROJECT NAME] EXPENSES THRU [DATE]

*** FILL IN PEACH-HIGHLIGHTED CELLS ONLY FOR EACH INVOICE FOR WHICH PAYMENT IS REQUESTED FROM DCA AND OTHER SOURCES; TOTALS ARE AUTOMATICALLY
CALCUATED. ROWS MAY BE ADDED AS NEEDED

                                                                                              Funding
                                                          Invoice                                                 Cancelled
    DCA budget item             Vendor name   Invoice #             Description                Source    CHECK #               Amount                  Comments
                                                            date                                                 check (Y/N)
                                                                                            DCA or Other

    Construction Management Fee



                                                                                                                                        -   subtotal

    Other:



                                                                                                                                        -   subtotal
                                                                                                                                        -   DEVELOPERS FEE

START UP RESERVES
   Marketing



                                                                                                                                        -   subtotal

    Rent -Up Reserves (DCA 3mos exp)



                                                                                                                                        -   subtotal

    Operating Deficit Reserve



                                                                                                                                        -   subtotal

    Replacement Reserve



                                                                                                                                        -   subtotal

    Furniture, Fixtures and Equipment



                                                                                                                                        -   subtotal

    Other:



                                                                                                                                        -   subtotal
                                                                                                                                        -   START UP RESERVES

OTHER COSTS
   Relocation



                                                                                                                                        -   subtotal

    Other:



                                                                                                                                        -   subtotal
                                                                                                                                        -   OTHER COSTS

                                                                                                                                 1,000.00 SOFT COST TOTAL
HARD COSTS
   Hard Costs



    Construction Contingency



    Other:



                                                                                                                                        -   HARD COST TOTAL

                                                                                                                                 1,000.00 DRAW TOTAL




                                                                                  5 of 10
6 of 10
PERIOD FINANCING




                   7 of 10
8 of 10
9 of 10
10 of 10

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:17
posted:8/9/2012
language:Unknown
pages:10