Need back in 26 hours from now
Jay1019
SU_MPA6105_W3_Jacob_S.xlsSheet1
| Cash Flow Budget , Month-to-Month | |||||||||||||
| Item | January | February | March | April | May | June | July | August | September | October | November | December | Total |
| Income | |||||||||||||
| Members contribution | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $1,200,000 |
| Grants & Donations | $200,000 | $150,000 | $220,000 | $250,000 | $400,000 | $120,000 | $100,000 | $130,000 | $10,000 | $17,000 | $10,000 | $25,000 | $1,632,000 |
| Loan | $100,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $100,000 |
| Total income | $400,000 | $250,000 | $320,000 | $350,000 | $500,000 | $220,000 | $200,000 | $230,000 | $110,000 | $117,000 | $110,000 | $125,000 | $2,932,000 |
| Expenses | |||||||||||||
| savings | $5,000 | $5,900 | $6,900 | $7,900 | $8,000 | $9,000 | $9,500 | $10,000 | $11,000 | $12,000 | $12,500 | $13,000 | $110,700 |
| Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Transport | $500 | $600 | $700 | $700 | $900 | $900 | $1,000 | $1,100 | $800 | $800 | $1,200 | $1,700 | $10,900 |
| Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $3,600 |
| Internet& Phone | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 |
| Electricity & Water | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $2,400 |
| Salaries | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $120,000 |
| Equipment | $2,500 | $3,000 | $3,500 | $4,500 | $3,500 | $2,500 | $3,000 | $4,000 | $4,500 | $5,000 | $4,000 | $2,500 | $42,500 |
| Loan Payments | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $18,000 |
| Tax | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $1,200 |
| TOTAL EXPENSES | $23,100 | $24,600 | $26,200 | $28,200 | $27,500 | $27,500 | $28,600 | $30,200 | $31,400 | $32,900 | $32,800 | $32,300 | $345,300 |
| DIFFERENCE | $376,900 | $225,400 | $293,800 | $321,800 | $472,500 | $192,500 | $171,400 | $199,800 | $78,600 | $84,100 | $77,200 | $92,700 | $2,586,700 |
| Carry forward balance | $376,900 | $151,500 | ($68,400) | ($28,000) | ($150,700) | $280,000 | $21,100 | ($28,400) | $121,200 | ($5,500) | $6,900 | ($15,500) | $661,100 |
| Balance | $73,900 | $362,200 | $349,800 | $623,200 | ($87,500) | $150,300 | $228,200 | ($42,600) | $89,600 | $70,300 | $108,200 | $1,925,600 |
&RPage 1 of 1
MPA6105_Grant Writing and Contract Administration
© 2009 South University
