📊 Balance Sheet & Revenue Projection

← Back to Finance

📈 10-Month Summary

Total Income
£10,285.01
Apr - Jan
Total Expenses
£11,871.30
Apr - Jan
Net Income
-£1,586.29
10-month total
Balance Change
-£1,586.29
£9,814 → £8,228

💰 Monthly Performance Breakdown (Apr 2025 - Jan 2026)

Month Start Balance Income Expenses Ending Balance Net Income Change Transactions
April 2025 £9,814.35 £753.08 £1,478.15 £9,089.28 -£725.07 -7.4% -
May 2025 £9,089.28 £351.90 £1,515.89 £7,925.29 -£1,163.99 -12.8% -
June 2025 £7,925.29 £815.01 £1,084.01 £7,656.29 -£269.00 -3.4% -
July 2025 £7,656.29 £822.15 £986.80 £7,491.64 -£164.65 -2.2% -
August 2025 £7,491.64 £1,927.39 £1,172.40 £8,246.63 +£754.99 +10.1% 108
September 2025 £8,246.63 £4,549.75 £1,205.72 £11,590.66 +£3,344.03 +40.5% 150
October 2025 £11,590.66 £938.90 £1,443.33 £11,086.23 -£504.43 -4.4% 71
November 2025 £11,086.23 £3.15 £1,375.29 £9,714.09 -£1,372.14 -12.4% 252
December 2025 £9,714.09 £123.68 £1,477.22 £8,360.55 -£1,353.54 -13.9% 373
January 2026 £8,360.55 £0.00 £132.49 £8,228.06 -£132.49 -1.6% 29

🎯 Confirmed Future Income (Jan - Aug 2026)

Total Confirmed Income
£8,734.30
8 months (Jan - Aug)
Income Sources
Lamar Retainer: £262.50/mo × 8
= £2,100.00
Blanco White: Feb £3k + May £3.5k
= £6,500.00
Gustavo EP: Jan $170 (£134.30)
Final payment for EP project
Scenario Assumptions:
Monthly expenses: £850 (minimal spending, no major purchases)
Month Start Balance Income Expenses Ending Balance Net Income Change

💡 Key Insights

✅ Positive Trends:
  • Peak month: September with £4,549.75 income (+40.5% balance growth)
  • Total 10-month income: £10,285.01
  • Best months: August (+£755) and September (+£3,344)
⚠️ Concerns:
  • Overall net negative: -£1,586.29 over 10 months
  • 7 out of 10 months were negative
  • Worst month: May (-£1,164, -12.8% balance drop)
  • Average monthly expenses: £1,187 vs average income: £1,029
  • Balance dropped from £9,814 (Apr start) to £8,228 (Jan end) = -16.2%
📊 Recommendations:
  • Income inconsistency: Range from £0 (Jan) to £4,550 (Sep) - need more stable income sources
  • 9-month average (Apr-Dec): £1,304/mo expenses vs £1,142/mo income = £162/mo deficit
  • With confirmed future income (£8,734 Jan-Aug), conservative spending at £1,150/mo provides 12% savings vs historical average
  • Target: Either increase monthly income to £1,400+ or maintain expenses at or below £1,150/mo