Get documents about "Budget Cash Flow Spreadsheet
Document Sample
Your House Corporation Budget and Cash Flow
7/18/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/18/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%
C:\Docstoc\Working\pdf\[a6414308-d680-414e-aa78-be9457b49e0f.xls]Budget Cash Flow Spreadsheet (Percentage should be 2.5% or more)
Your House Corporation Budget and Cash Flow
7/18/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/18/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%
C:\Docstoc\Working\pdf\[a6414308-d680-414e-aa78-be9457b49e0f.xls]Budget Cash Flow Spreadsheet (Percentage should be a minimum of 2-3%)
