Untitled
unknown
plain_text
5 months ago
3.4 kB
5
Indexable
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)
Editor is loading...
Leave a Comment