Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    New Microsoft Excel Worksheet

    Uploaded by

    Sourav Nath Shaan 1611875630
    The document contains financial information on marketing and operational costs for an organization. It includes monthly costs and annual spends on different digital marketing platforms like Google Ads, Facebook Ads, YouTube ads. It also lists costs related to website development, maintenance, employee salaries, delivery and other expenses. The total annual marketing cost is around BDT 4.38 million and total annual operational cost is around BDT 4.38 million. The document also outlines revenue projections based on number of art sales and profit/loss calculations for the first two years of operations.

    Copyright:

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

    New Microsoft Excel Worksheet

    Uploaded by

    Sourav Nath Shaan 1611875630
    13 views22 pages
    The document contains financial information on marketing and operational costs for an organization. It includes monthly costs and annual spends on different digital marketing platforms like Google Ads, Facebook Ads, YouTube ads. It also lists costs related to website development, maintenance, employee salaries, delivery and other expenses. The total annual marketing cost is around BDT 4.38 million and total annual operational cost is around BDT 4.38 million. The document also outlines revenue projections based on number of art sales and profit/loss calculations for the first two years of operations.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains financial information on marketing and operational costs for an organization. It includes monthly costs and annual spends on different digital marketing platforms like Google Ads, Facebook Ads, YouTube ads. It also lists costs related to website development, maintenance, employee salaries, delivery and other expenses. The total annual marketing cost is around BDT 4.38 million and total annual operational cost is around BDT 4.38 million. The document also outlines revenue projections based on number of art sales and profit/loss calculations for the first two years of operations.

    Copyright:

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

    New Microsoft Excel Worksheet

    Uploaded by

    Sourav Nath Shaan 1611875630
    The document contains financial information on marketing and operational costs for an organization. It includes monthly costs and annual spends on different digital marketing platforms like Google Ads, Facebook Ads, YouTube ads. It also lists costs related to website development, maintenance, employee salaries, delivery and other expenses. The total annual marketing cost is around BDT 4.38 million and total annual operational cost is around BDT 4.38 million. The document also outlines revenue projections based on number of art sales and profit/loss calculations for the first two years of operations.

    Copyright:

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

    Platform Per Month Cost Spend (Taka)

    Google Search Ads 51,569.05 618828.6

    Google Display
    30941.43 371297.16
    network
    Facebook Ads 20627.62 247531.44
    All Facebook
    30941.43 371297.16
    Conversions

    Other social media ads 15470.72 185648.64

    YouTube ads 51569.05 618828.6


    Pop-ups AD 8251.05 99012.6
    Content Marketing 15,000 180000
    In Banner Ad 5,000 60000
    Bidding 12,000 144000
    Content writing 10,000 120000
    SEO 40,000 480000
    Event Sponsorship 750,000

    Community marketing 5,000 60000

    Affiliate Marketing 6,500 78000

    Total 4384444.2

    Platform Per Month Cost Spend (Taka)


    Website design and 77,353.58
    development

    Website maintenance 4,799.00 57,588.00

    Mobile App 150,000.00


    Development
    Mobile App 10,000.00 120,000.00
    Maintenance
    Permits and licenses 35,000.00
    Utilities 10,000.00 120,000.00
    Data storage 8,000.00 96,000.00
    Transactional costs 10,000.00 120,000.00
    Cybersecurity 5,000.00 60,000.00
    Employee salary 200,000.00 2,400,000.00

    Delivery and logistics 30,000.00 360,000.00

    UX/UI and its 40,000.00 480,000.00


    maintenance
    Agency costing 25,000.00 300,000.00
    Total 4,375,941.58
    262,353.58

    vari.cosr increas after increase fi cost total cost


    4,113,588.00 - 4,113,588.00 262,353.58 4,375,941.58
    4,113,588.00 82,271.76 4,195,859.76 262,353.58 4,458,213.34
    4,195,859.76 83,917.20 4,279,776.96 262,353.58 4,542,130.54

    8,760,385.78
    revenue
    4,290,000 (85,941.58)
    4,680,000 221,786.66
    9,262,500 4,720,369.46
    Return On Investment(ROI)
    2023
    SPEND (TAKA)
    Profit -85,942
    Marketing Cost 4,384,444.00
    ROI(yearly) -1.96014774051168
    21922.22

    Loan / Financing (BDT) Fir


    Year

    60% Debt Financing


    40% Equity Financing
    Total
    Loan / Finan
    Y

    Revenue
    Total Cost
    Net Profit
    estment(ROI)
    2024
    SPEND (TAKA)
    221,786
    4,406,366.22
    5.03330837535333

    / Financing (BDT) First


    Year
    SPEND (TAKA)
    4,800,000
    3,200,000
    8,000,000
    Loan / Financing (BDT) First
    Year
    2023

    SPEND (TAKA)

    4,290,000
    4,375,941.58
    -85,942
    2024

    SPEND (TAKA)

    4,680,000
    4,458,213.34
    221,787
    Loan / Financing (BDT) First
    Year
    2023

    SPEND (TAKA)

    Revenue 4,290,000.00
    Total Cost 4,375,941.58
    Net Profit -85,941.58
    -1.96
    (BDT) First

    2024

    SPEND (TAKA)

    4,680,000.00
    4,458,213.34
    221,786.66
    4.97
    Return On Investment(RO

    Revenue

    Total Cost
    ROI
    Return On Investment(ROI)
    2023

    SPEND (TAKA)

    4,290,000

    4,375,941.58
    98.0360437078778
    nt(ROI)
    2024

    SPEND (TAKA)

    4,680,000

    4,458,213.34
    Return On Investment(ROI)
    2023

    SPEND (TAKA)

    Revenue 4,290,000
    Total Cost 4,375,941.58
    Net Profit -85,941.58
    marketing cost 4384444.2
    nvestment(ROI)
    2024

    SPEND (TAKA)

    4,680,000
    0
    4,458,213.34
    221,786.66
    4384444.2
    No Of Art Sell

    Based Price

    Annual Revenue
    Commision
    Total Revenue
    Service Type-01
    120

    35,000.00

    4,200,000.00
    630,000.00
    Service Type-02 Service Type-03
    80 40

    130,000.00 350,000.00

    10,400,000.00 14,000,000.00
    1,560,000.00 2,100,000.00
    4,290,000.00

    4,375,941.58
    4384444.2
    8,760,385.78
    (4,470,385.78)
    Service Type-01 Service Type-02 Service Type-03
    No Of Art Sell 132.00 86.00 44.00

    Based Price 35,000.00 130,000.00 350,000.00

    Annual Revenue 4,620,000.00 11,180,000.00 15,400,000.00


    Commision 693,000.00 1,677,000.00 2,310,000.00
    Total Revenue 4,680,000.00

    You might also like