Untitled

import pandas as pd

# Define the parameters for the 5-year pro forma
years = ["2025", "2026", "2027", "2028", "2029"]
categories = [
    "Sponsorships",
    "Ticket Sales",
    "Seasonal Outdoor Rentals",
    "Mini Golf Revenue",
    "Capital Gift Releases",
    "Outdoor Event Rentals",
    "Concert Revenue",
    "Program Fees",
    "Store Sales",
    "Total Revenue"
]

# Base assumptions
base_sponsorships = 100000
base_ticket_sales = 50000
base_rentals = 75000
base_mini_golf = 0  # Starts in 2027
base_event_rentals = 25000
base_concert_revenue = 0  # Starts in 2029
base_program_fees = 0  # Starts in 2029
base_store_sales = 0  # Starts in 2029

capital_gift_release_2026 = 0.05 * 2000000
capital_gift_release_2027 = 0.05 * 6000000
capital_gift_release_2028 = 0.05 * 2000000
capital_gift_release_2029 = 0  # Assuming no further releases after 2028

# Growth rates
growth_rate_general = 0.10  # General 10% increase per year for Sponsorships and Ticket Sales
rental_growth_2026 = 0.25
rental_growth_post_2026 = 0.10

# Construct the pro forma year by year
pro_forma = {
    "2025": [
        base_sponsorships, base_ticket_sales, base_rentals, 0, 0, base_event_rentals, 0, 0, 0, 0
    ],
    "2026": [
        base_sponsorships * (1 + growth_rate_general),
        base_ticket_sales * (1 + growth_rate_general),
        base_rentals * (1 + rental_growth_2026),
        0,
        capital_gift_release_2026,
        base_event_rentals * (1 + growth_rate_general),
        0,
        0,
        0,
        0
    ],
    "2027": [
        base_sponsorships * (1 + 2 * growth_rate_general),
        base_ticket_sales * (1 + 2 * growth_rate_general),
        base_rentals * (1 + rental_growth_2026) * (1 + rental_growth_post_2026),
        base_mini_golf + 30000,  # Initial mini golf revenue
        capital_gift_release_2027,
        base_event_rentals * (1 + 2 * growth_rate_general),
        0,
        0,
        0,
        0
    ],
    "2028": [
        base_sponsorships * (1 + 3 * growth_rate_general),
        base_ticket_sales * (1 + 3 * growth_rate_general),
        base_rentals * (1 + rental_growth_2026) * (1 + rental_growth_post_2026) * (1 + growth_rate_general),
        base_mini_golf + 33000,  # 10% increase in mini golf revenue
        capital_gift_release_2028,
        base_event_rentals * (1 + 3 * growth_rate_general),
        0,
        0,
        0,
        0
    ],
    "2029": [
        base_sponsorships * (1 + 4 * growth_rate_general),
        base_ticket_sales * (1 + 4 * growth_rate_general),
        base_rentals * (1 + rental_growth_2026) * (1 + rental_growth_post_2026) * (1 + 2 * growth_rate_general),
        base_mini_golf + 36300,  # 10% increase in mini golf revenue
        0,
        base_event_rentals * (1 + 4 * growth_rate_general),
        300000,  # Concert revenue from amphitheater
        50000,  # Program fees
        20000,  # Store sales
        0
    ]
}

# Calculate total revenue for each year
for year, values in pro_forma.items():
    values[-1] = sum(values[:-1])

# Create a DataFrame
df = pd.DataFrame(pro_forma, index=categories)

# Display the table to the user
import ace_tools as tools; tools.display_dataframe_to_user(name="5-Year Pro Forma for GoggleWorks Art Park", dataframe=df)