Fictional Book Club Budget (6-Month Projection)
Overview & Assumptions
This budget outlines a six-month financial plan for a fictional community book club. All figures are illustrative assumptions denominated in USD ($), with a constant projected monthly membership revenue of $100 and operating costs (books, venue, and refreshments) of $60 per month.
| Month | Revenue | Costs | Surplus |
|---|---|---|---|
| Jan | 100 | 60 | 40 |
| Feb | 100 | 60 | 40 |
| Mar | 100 | 60 | 40 |
| Apr | 100 | 60 | 40 |
| May | 100 | 60 | 40 |
| Jun | 100 | 60 | 40 |
| Total | 600 | 360 | 240 |
Formula examples
[
{
"cell": "D2",
"formula": "=B2-C2"
},
{
"cell": "D3",
"formula": "=B3-C3"
},
{
"cell": "D4",
"formula": "=B4-C4"
},
{
"cell": "D5",
"formula": "=B5-C5"
},
{
"cell": "D6",
"formula": "=B6-C6"
},
{
"cell": "D7",
"formula": "=B7-C7"
},
{
"cell": "B8",
"formula": "=SUM(B2:B7)"
},
{
"cell": "C8",
"formula": "=SUM(C2:C7)"
},
{
"cell": "D8",
"formula": "=SUM(D2:D7)"
}
]