Investor Pitch for Export Lead Hub

from docx import Document
import pandas as pd

# Create a new Document
doc = Document()

# Title
doc.add_heading('Investor Pitch for Export Lead Hub', level=1)

# Executive Summary
doc.add_heading('Executive Summary', level=2)
doc.add_paragraph(
    "Export Lead Hub is a comprehensive platform designed to automate the generation, nurturing, and management of leads for import/export businesses. "
    "Our mission is to provide these businesses with a steady stream of high-quality leads through AI-driven automation."
)

# Market Overview
doc.add_heading('Market Overview', level=2)

# Map Visualization (Placeholder for visual content)
doc.add_heading('Map Visualization', level=3)
doc.add_paragraph("Global export markets with color-coding for potential (e.g., high, medium, low).")

# Market Size Chart
doc.add_heading('Market Size Chart', level=3)
market_size_data = {
    'Year': [2019, 2020, 2021, 2022, 2023],
    'Market Size (Trillions USD)': [18.5, 17.8, 19.0, 20.5, 21.6]
}
df_market_size = pd.DataFrame(market_size_data)
doc.add_paragraph("Market Size (Trillions USD) over the years:")
table = doc.add_table(rows=1, cols=len(df_market_size.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_market_size.columns):
    hdr_cells[i].text = column

for row in df_market_size.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Key Market Segments
doc.add_heading('Key Market Segments', level=3)
key_segments = {
    'Segment': ['Technology', 'Apparel', 'Machinery', 'Chemicals', 'Food and Beverage'],
    'Market Potential (Billion USD)': [500, 350, 600, 450, 300]
}
df_key_segments = pd.DataFrame(key_segments)
doc.add_paragraph("Most promising market segments for Export Lead Hub:")
table = doc.add_table(rows=1, cols=len(df_key_segments.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_key_segments.columns):
    hdr_cells[i].text = column

for row in df_key_segments.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Company Performance
doc.add_heading('Company Performance', level=2)

# Revenue Projections
doc.add_heading('Revenue Projections', level=3)
revenue_projections = {
    'Year': [1, 2, 3, 4, 5],
    'Revenue (INR)': [2400000, 3600000, 4800000, 6000000, 7200000]
}
df_revenue_projections = pd.DataFrame(revenue_projections)
doc.add_paragraph("Projected revenue growth over the next 3-5 years:")
table = doc.add_table(rows=1, cols=len(df_revenue_projections.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_revenue_projections.columns):
    hdr_cells[i].text = column

for row in df_revenue_projections.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Customer Acquisition Cost (CAC)
doc.add_heading('Customer Acquisition Cost (CAC)', level=3)
cac_data = {
    'Year': [1, 2, 3, 4, 5],
    'CAC (INR)': [500, 480, 460, 440, 420],
    'CLTV (INR)': [2000, 2100, 2200, 2300, 2400]
}
df_cac = pd.DataFrame(cac_data)
doc.add_paragraph("Comparing CAC to Customer Lifetime Value (CLTV):")
table = doc.add_table(rows=1, cols=len(df_cac.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_cac.columns):
    hdr_cells[i].text = column

for row in df_cac.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Key Performance Indicators (KPIs)
doc.add_heading('Key Performance Indicators (KPIs)', level=3)
kpis = {
    'Metric': ['Website Traffic', 'Lead Generation Rate', 'Conversion Rate'],
    'Value': ['15000 visits/month', '10%', '2%']
}
df_kpis = pd.DataFrame(kpis)
doc.add_paragraph("Key metrics:")
table = doc.add_table(rows=1, cols=len(df_kpis.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_kpis.columns):
    hdr_cells[i].text = column

for row in df_kpis.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Financial Summary
doc.add_heading('Financial Summary', level=2)

# Profit and Loss (P&L) Statement
doc.add_heading('Profit and Loss (P&L) Statement', level=3)
pl_data = {
    'Year': [1, 2, 3],
    'Revenue (INR)': [2400000, 3600000, 4800000],
    'Expenses (INR)': [1500000, 2000000, 2500000],
    'Net Profit (INR)': [900000, 1600000, 2300000]
}
df_pl = pd.DataFrame(pl_data)
doc.add_paragraph("Summary of key financial data:")
table = doc.add_table(rows=1, cols=len(df_pl.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_pl.columns):
    hdr_cells[i].text = column

for row in df_pl.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Cash Flow Statement
doc.add_heading('Cash Flow Statement', level=3)
cash_flow = {
    'Month': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
    'Cash Inflows (INR)': [50000, 60000, 70000, 80000, 90000, 100000, 110000, 120000, 130000, 140000, 150000, 160000],
    'Cash Outflows (INR)': [20000, 25000, 30000, 35000, 40000, 45000, 50000, 55000, 60000, 65000, 70000, 75000],
    'Net Cash Flow (INR)': [30000, 35000, 40000, 45000, 50000, 55000, 60000, 65000, 70000, 75000, 80000, 85000]
}
df_cash_flow = pd.DataFrame(cash_flow)
doc.add_paragraph("Cash inflows and outflows:")
table = doc.add_table(rows=1, cols=len(df_cash_flow.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_cash_flow.columns):
    hdr_cells[i].text = column

for row in df_cash_flow.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Funding Requirements and Use of Funds
doc.add_heading('Funding Requirements and Use of Funds', level=2)
doc.add_paragraph(
    "Initial Investment Required: INR 70,000 to INR 1,50,000\n\n"
    "The funds will be allocated as follows:\n"
    "1. Technology Development: INR 30,000\n"
    "2. Marketing and Sales: INR 40,000\n"
    "3. Operational Expenses: INR 20,000\n"
    "



4. Contingency: INR 10,000"
)

# Staffing Plan
doc.add_heading('Staffing Plan', level=2)

# Initial Setup Costs from Freelancers
doc.add_heading('Initial Setup Costs from Freelancers', level=3)
setup_costs = {
    'Job': ['Website Development', 'AI Integration', 'Database Setup', 'Initial Marketing'],
    'Cost (INR)': [30000, 25000, 20000, 15000]
}
df_setup_costs = pd.DataFrame(setup_costs)
doc.add_paragraph("One-time costs for setting up the website and related infrastructure:")
table = doc.add_table(rows=1, cols=len(df_setup_costs.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_setup_costs.columns):
    hdr_cells[i].text = column

for row in df_setup_costs.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Success Target and Staffing Costs
doc.add_heading('Success Target and Staffing Costs', level=3)
success_target = {
    'Month': [6, 12],
    'Target Revenue (INR)': [1000000, 2000000]
}
df_success_target = pd.DataFrame(success_target)
doc.add_paragraph("Revenue targets for success in the first 6 to 12 months:")
table = doc.add_table(rows=1, cols=len(df_success_target.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_success_target.columns):
    hdr_cells[i].text = column

for row in df_success_target.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Staffing Requirements and Costs
doc.add_heading('Staffing Requirements and Costs', level=3)
staffing_costs = {
    'Position': ['Developer', 'AI Specialist', 'Marketing Executive', 'Sales Executive'],
    'Monthly Salary (INR)': [50000, 60000, 40000, 45000],
    'Yearly Salary (INR)': [600000, 720000, 480000, 540000],
    'Other Costs (INR)': [10000, 12000, 8000, 9000]
}
df_staffing_costs = pd.DataFrame(staffing_costs)
doc.add_paragraph("Monthly and yearly costs for necessary staffing:")
table = doc.add_table(rows=1, cols=len(df_staffing_costs.columns))
hdr_cells = table.rows[0].cells
for i, column in enumerate(df_staffing_costs.columns):
    hdr_cells[i].text = column

for row in df_staffing_costs.itertuples(index=False):
    row_cells = table.add_row().cells
    for i, value in enumerate(row):
        row_cells[i].text = str(value)

# Appendices
doc.add_heading('Appendices', level=2)
doc.add_paragraph("Additional charts, graphs, and detailed data analysis will be included in the appendices section.")

# Save the document
doc_path = "/mnt/data/Investor_Pitch_Export_Lead_Hub_Updated.docx"
doc.save(doc_path)