Docstoc

Budget Cash Flow Spreadsheet

Document Sample
Budget Cash Flow Spreadsheet Powered By Docstoc
					Your House Corporation                            Budget and Cash Flow
         7/16/2011                                    FY Ending:      6/30/08

                          Jul        Aug        Sept        Oct        Nov        Dec                                  Jan        Feb        Mar        Apr        May        Jun        Total
Revenue                                                                                      Revenue
Monthly Rent                                                                                 Monthly Rent                                                                                         0
Semester Rent                                                                                Semester Rent                                                                                        0
Summer Rent                                                                                  Summer Rent                                                                                          0
Parking                                                                                      Parking                                                                                              0
Liab Ins from Chapter                                                                        Liab Ins from Chapter                                                                                0
Prop Ins from Chapter                                                                        Prop Ins from Chapter                                                                                0
Security Dep for Damage                                                                      Security Dep for Damage                                                                              0
Int/Div/Capital Gains                                                                        Int/Div/Capital Gains                                                                                0
Fundraising                                                                                  Fundraising                                                                                          0
Washers & Dryers                                                                             Washers & Dryers                                                                                     0
Other                                                                                        Other                                                                                                0
Other                                                                                        Other                                                                                                0
Total Oper. Revenue             $0         $0          $0         $0         $0         $0   Total Oper. Revenue             $0         $0         $0         $0         $0         $0           $0

Expenses                                                                                     Expenses
Property Insurance                                                                           Property Insurance                                                                                   0
Liability Insurance                                                                          Liability Insurance                                                                                  0
Property Taxes                                                                               Property Taxes                                                                                       0
Property Mgmt Fees                                                                           Property Mgmt Fees                                                                                   0
Repairs & Maint.                                                                             Repairs & Maint.                                                                                     0
Int. First Loan                                                                              Int. First Loan                                                                                      0
Int. Second Loan                                                                             Int. Second Loan                                                                                     0
Loan Closing Costs                                                                           Loan Closing Costs                                                                                   0
Utilities #1                                                                                 Utilities #1                                                                                         0
Utilities #2                                                                                 Utilities #2                                                                                         0
Utilities #3                                                                                 Utilities #3                                                                                         0
Utilities #4                                                                                 Utilities #4                                                                                         0
Legal                                                                                        Legal                                                                                                0
Accounting                                                                                   Accounting                                                                                           0
Office Supplies                                                                              Office Supplies                                                                                      0
Postage                                                                                      Postage                                                                                              0
Bank Fees                                                                                    Bank Fees                                                                                            0
Recruitment                                                                                  Recruitment                                                                                          0
Scholarship                                                                                  Scholarship                                                                                          0
Karnea                                                                                       Karnea                                                                                               0
Division Conference                                                                          Division Conference                                                                                  0
Alumni/Fundraising                                                                           Alumni/Fundraising                                                                                   0
Other                                                                                        Other                                                                                                0
Other                                                                                        Other                                                                                                0
Total Oper. Expenses            $0         $0          $0         $0         $0         $0   Total Oper. Expenses            $0         $0         $0         $0         $0         $0           $0

Gain/Loss on Oper.              $0         $0          $0         $0         $0         $0   Gain/Loss on Oper.              $0         $0         $0         $0         $0         $0           $0
Your House Corporation                                          Budget and Cash Flow
         7/16/2011                                                  FY Ending:      6/30/08

                                    Jul         Aug         Sept          Oct         Nov          Dec                                              Jan        Feb        Mar            Apr          May            Jun         Total

Non Operations Cash Inflow                                                                                     Non Operations Cash Inflow
Proceeds from Loan                                                                                             Proceeds from Loan                                                                                                         0
Total NonOp Cash Inflow                    0           0            0            0           0            0    Total NonOp Cash Inflow                     0          0          0              0             0             0             0

Non Expense Cash Outflow                                                                                       Non Expense Cash Outflow
Invest. in Building                                                                                            Invest. in Building                                                                                                        0
Invest in Furn & Fix                                                                                           Invest in Furn & Fix                                                                                                       0
Prin: First Loan                                                                                               Prin: First Loan                                                                                                           0
Escrow First Loan                                                                                              Escrow First Loan                                                                                                          0
Prin: Second Loan                                                                                              Prin: Second Loan                                                                                                          0
Escrow Second Loan                                                                                             Escrow Second Loan                                                                                                         0
Savings for LT Capital Improv                                                                                  Savings for LT Capital Improv                                                                                              0
Other                                                                                                          Other                                                                                                                      0
Total NonExp Cash Outflow                  0           0            0            0           0            0    Total NonExp Cash Outflow                   0          0          0              0             0             0             0

Net Cash Flow:                            $0          $0           $0           $0          $0           $0    Net Cash Flow:                             $0         $0         $0             $0            $0            $0            $0

Beginning Cash:                       2500         2500         2500        2500         2500         2500     Beginning Cash:                          2500     2500       2500            2500         2500          2500
Ending Cash:                          2500         2500         2500        2500         2500         2500     Ending Cash:                             2500     2500       2500            2500         2500          2500
Cash Warning                                                                                                   Cash Warning

Note: Insert actual revenue and expense amounts as each month is completed and continue to use this spreadsheet for budgeting and cash flow purposes.
Cash Warning means that cash is insufficient to make the next two monthly loan payments
                                                                                                                                                                                     Market Value of House                      1,000,000
                                                                                                                                                                                     Total $'s for Repairs & Maint                        0
                                                                                                                                                                                     Repairs & Maint Percentage                    0.00%
D:\Docstoc\Working\pdf\[ef5934c4-bede-44d4-885c-f59c9d89c079.xls]Budget Cash Flow Spreadsheet                                                                                                       (Percentage should be 2.5% or more)
Your House Corporation                             Budget and Cash Flow
         7/16/2011                                     FY Ending:      6/30/08

                          Jul        Aug         Sept        Oct         Nov        Dec                                   Jan         Feb         Mar         Apr         May        Jun        Total
Revenue                                                                                         Revenue
Monthly Rent                           5150        5150        5150        5150       5150      Monthly Rent                5150        5150        5150        5150        5150                  51500
Semester Rent                                                                                   Semester Rent                                                                                          0
Summer Rent                 1500                                                                Summer Rent                                                                            1500        3000
Parking                                                                                         Parking                                                                                                0
Liab Ins from Chapter                                                                           Liab Ins from Chapter                                                                                  0
Prop Ins from Chapter                                                                           Prop Ins from Chapter                                                                                  0
Security Dep for Damage                                                                         Security Dep for Damage                                                                                0
Int/Div/Capital Gains           20          20          20       20            20          20   Int/Div/Capital Gains            20          20          20          20         20         20        240
Fundraising                                                    2000                             Fundraising                                                                                        2000
Washers & Dryers                                                                                Washers & Dryers                                                                                       0
Other                                                                                           Other                                                                                                  0
Other                                                                                           Other                                                                                                  0
Total Oper. Revenue       $1,520     $5,170       $5,170     $7,170      $5,170     $5,170      Total Oper. Revenue       $5,170      $5,170      $5,170      $5,170      $5,170     $1,520      $56,740

Expenses                                                                                        Expenses
Property Insurance                                                                              Property Insurance                                  8500                                           8500
Liability Insurance                                                                             Liability Insurance                                                                                    0
Property Taxes                                                             5500                 Property Taxes                                                              5500                  11000
Property Mgmt Fees           200           200      200            200      200           200   Property Mgmt Fees              200         200         200         200      200        200        2400
Repairs & Maint.            2500           600      600            600      600           600   Repairs & Maint.                600         600         600         600      600       2500       11000
Int. First Loan              480           475      470            465      460           455   Int. First Loan                 450         445         440         435      430        425        5430
Int. Second Loan                                                                                Int. Second Loan                                                                                       0
Loan Closing Costs                                                                              Loan Closing Costs                                                                                     0
Internet                        75          75          75          75         75          75   Internet                         75          75          75          75         75         75        900
Utilities #2                                                                                    Utilities #2                                                                                           0
Utilities #3                                                                                    Utilities #3                                                                                           0
Utilities #4                                                                                    Utilities #4                                                                                           0
Legal                                                                                           Legal                                                                                                  0
Accounting                                                                                      Accounting                                                                                             0
Office Supplies                                                                                 Office Supplies                                                                                        0
Postage                                    200                                                  Postage                                                                                              200
Bank Fees                                                                                       Bank Fees                                                                                              0
Recruitment                                                                                     Recruitment                                                                                            0
Scholarship                                                                                     Scholarship                                                                                            0
Karnea                                                                                          Karnea                                                                                                 0
Division Conference                                                                             Division Conference                         400                                                      400
Alumni/Fundraising                                                 250                          Alumni/Fundraising                                                                                   250
Other                                                                                           Other                                                                                                  0
Other                                                                                           Other                                                                                                  0
Total Oper. Expenses      $3,255     $1,550       $1,345     $1,590      $6,835     $1,330      Total Oper. Expenses      $1,325      $1,720      $9,815      $1,310      $6,805     $3,200      $40,080

Gain/Loss on Oper.        -$1,735    $3,620       $3,825     $5,580      -$1,665    $3,840      Gain/Loss on Oper.        $3,845      $3,450      -$4,645     $3,860      -$1,635    -$1,680     $16,660
Your House Corporation                                          Budget and Cash Flow
         7/16/2011                                                  FY Ending:      6/30/08

                                    Jul         Aug         Sept          Oct         Nov          Dec                                              Jan         Feb         Mar             Apr          May            Jun         Total

Non Operations Cash Inflow                                                                                     Non Operations Cash Inflow
Proceeds from Loan                                                                                             Proceeds from Loan                                                                                                           0
Total NonOp Cash Inflow                     0           0          0              0          0             0   Total NonOp Cash Inflow                      0           0           0               0           0               0           0

Non Expense Cash Outflow                                                                                       Non Expense Cash Outflow
Invest. in Building                                                                                            Invest. in Building                                                                                                        0
Invest in Furn & Fix                                                                                           Invest in Furn & Fix                                                                                                       0
Prin: First Loan                          520         525        530            535       540            545   Prin: First Loan                           550         555         560             565         570             575      6570
Escrow First Loan                         165         165        165            165       165            165   Escrow First Loan                          165         165         165             165         165             165      1980
Prin: Second Loan                                                                                              Prin: Second Loan                                                                                                          0
Escrow Second Loan                                                                                             Escrow Second Loan                                                                                                         0
Savings for LT Capital Improv             820         820        820            820       820            820   Savings for LT Capital Improv              820         820         820             820         820             820      9840
Other                                                                                                          Other                                                                                                                      0
Total NonExp Cash Outflow             1505         1510         1515        1520         1525         1530     Total NonExp Cash Outflow                1535      1540        1545             1550         1555          1560        18390

Net Cash Flow:                      -$3,240      $2,110       $2,310      $4,060      -$3,190       $2,310     Net Cash Flow:                       $2,310      $1,910      -$6,190          $2,310       -$3,190       -$3,240      -$1,730

Beginning Cash:                       2900       -340           1770        4080         8140         4950     Beginning Cash:                          7260      9570       11480             5290         7600          4410
Ending Cash:                          -340       1770           4080        8140         4950         7260     Ending Cash:                             9570     11480        5290             7600         4410          1170
Cash Warning                    Warning    Warning                                                             Cash Warning                                                                                         Warning

Note: Insert actual revenue and expense amounts as each month is completed and continue to use this spreadsheet for budgeting and cash flow purposes.
Cash Warning means that cash is insufficient to make the next two monthly loan payments
                                                                                                                                                                                        Market Value of House                       984,000
                                                                                                                                                                                        Total $'s for Repairs & Maint                 22,820
                                                                                                                                                                                        Repairs & Maint Percentage                    2.32%
D:\Docstoc\Working\pdf\[ef5934c4-bede-44d4-885c-f59c9d89c079.xls]Budget Cash Flow Spreadsheet                                                                                                     (Percentage should be a minimum of 2-3%)

				
DOCUMENT INFO