Scribd Logo
Upload

Welcome to Scribd!

  • 0 views

    Milestone 3

    Uploaded by

    mytreshgowd

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Milestone 3

    Uploaded by

    mytreshgowd
    0 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    0 views6 pages

    Milestone 3

    Uploaded by

    mytreshgowd

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    Setting up the business

    Consultant Fees 124,500


    Business Registration fees 41,500
    Website Related(Domain registration),etc., 83,000
    Licenses 24,900
    Other Start-Up Costs 58,100

    Equipment

    Equipment 166,000

    Starting Operations
    Marketing and Promotional Costs 249,000
    Supplies and Raw Materials 41,500
    Stationery and Office supplies 16,600
    Working Capital 166,000

    Start-Up Capital
    Equity investment(by team) 415,000
    Loans(from college) 249,000
    Total 664000

    Totals

    Total set-up costs 929,200


    Surplus Funds 0
    Additional Funds you need 265,600
    Profit and Loss forecast
    JAN FEB MAR APR MAY JUN

    Sales
    Cash Sakes 50,000 60,000 75,000 85,000 100,000 115,000
    collections from account recievable 0 0 0 0 0 0
    other cash 0 0 0 0 0 0
    Totals sales 50,000 60,000 75,000 85,000 100,000 115,000

    COGS
    Cost of goods sold 10000 12000 15000 17000 20000 23000
    Gross Profit 40000 48000 60000 68000 80000 92000

    Operating Expenses
    Salaries and Consultant Fees 20000 20000 20000 20000 20000 25000
    Marketing and Promotion 10000 10000 15000 15000 20000 25000
    Utilities 2000 2000 2000 2000 2000 2000
    Transportation 1000 1000 1000 1000 1000 1000
    Office Supplies 500 500 500 500 1000 1000
    Repairs and Maintainance 500
    Office Supplies 500 500 500 500 1000 1000
    Misc.Expenses 500 500 500 500 1000 1000
    Interest of Loan 1000 1000 1000 1000 1000 1500
    Loss ,Theft wastage 1000 1000 1000 1000 1000 1500
    Total Expenses 36000 36000 41000 41000 47500 58000

    Result
    Net Profit/Loss 4000 12000 19000 27000 32500 34000
    Gross Profit Margin 8% 20% 25% 32% 32.50% 29.50%
    Net Profit Margins 8% 20% 25% 32% 32.50% 29.50%
    JUL AUG SEP OCT NOV DEC Totals

    130,000 150,000 170,000 190,000 210,000 250,000 1,585,000


    0 0 0 0 0 0 0
    0 0 0 0 0 0 0
    130,000 150,000 170,000 190,000 210,000 250,000 1,585,000

    26000 30000 34000 38000 42000 50000 317,000


    104000 120000 136000 152000 168000 200000 1268000

    25000 25000 30000 30000 35000 35000 305000


    25000 30000 30000 35000 40000 40000 295000
    3000 3000 3000 3000 3000 3000 29000
    1500 1500 1500 2000 2000 2000 16000
    1000 1500 1500 2000 2000 2000 14000
    500 500 2000
    1000 1500 1500 2000 2000 2000 14000
    1000 1500 1500 2000 2000 2500 14500
    1500 1500 2000 2000 2500 2500 19500
    1500 1500 1500 1500 1500 1500 16500
    60000 65500 71000 78500 89500 91500 715500

    44000 54500 65000 73500 78500 108500 632500


    33.80% 36.30% 38.20% 38.70% 37.40% 43.40%
    33.80% 36.30% 38.20% 38.70% 37.40% 43.40%
    Year 1 Year 2 Year 3 Year 4 Year 5
    Number of Sales 1000 3000 6000 10000 15000
    Value of each sale 2000 2200 2500 3000 3500
    Total Revenue 2000000 6600000 15000000 30000000 52500000

    Capital Costs
    Land and Buildings 1000000
    Equipment 500000 200000 200000 250000 300000
    Product(Development costs) 1500000 1000000 700000 500000 300000
    Others 200000 100000 100000 100000 100000
    Total 3200000 1300000 1000000 850000 700000

    Expenses(Annual)
    Salaries 1200000 1500000 2000000 3000000 4000000
    Marketing and Promotion 800000 1000000 1500000 2000000 2500000
    Utilities 300000 350000 400000 500000 600000
    Transportation 100000 150000 200000 250000 300000
    Office Supplies 50000 75000 100000 125000 150000
    Repairs and Maintainance 200000 250000 300000 350000 400000
    Office Supplies 150000 200000 250000 300000 350000
    Misc.Expenses 2800000 3525000 4750000 6525000 8300000

    Earnings(EBDITA) 4000000 1775000 9250000 26225000 43500000


    Number of Existing shares 80,000
    Amount to be invested 10000000
    Earnings after 5 years 43500000
    P/E Ratio 10
    Discount rate 12%
    Number of Years 5

    Estimated terminal Value 435000000


    Present Value 250000000(discounted at 12%)
    Required Ownership Percentage 20%
    Number of shares needed by investor 20,000
    Share Price 500
    P & L/Unit Year 1
    Revenue 250,000
    COGS(Cost of Goods sold) 50,000
    Gross Profit 200000
    Gross Profit Marging 80%
    Operating Costs 150000
    Operating Profit 50000

    Metric Year 1
    CAC(Customer Acquisition Cost) 500 per customer
    CLV(Customer Lifetime Value) 3,000 per customer
    ARPU(Average Revenue Per User) 1,250 per customer

    You might also like