Scribd Logo
Upload

Welcome to Scribd!

  • 245 views

    Emmanuel Ekpenyong - Expense Section W05 Project Unit 02

    Uploaded by

    Emmanuel Nsa
    - The document projects the profit and loss statement for Kalei Ukuleles over a 2 year period from January 1 to December 31. - It forecasts revenue from ukulele sales, subscriptions, and growth in the number of subscribers over time. It also projects expenses related to advertising, marketing, operations, and subscriptions. - The projections show increasing revenue over the 2 years as the number of subscribers and ukulele sales grow each month. Profits also rise over the period as revenue growth outpaces increasing expenses.

    Copyright:

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

    Emmanuel Ekpenyong - Expense Section W05 Project Unit 02

    Uploaded by

    Emmanuel Nsa
    245 views10 pages
    - The document projects the profit and loss statement for Kalei Ukuleles over a 2 year period from January 1 to December 31. - It forecasts revenue from ukulele sales, subscriptions, and growth in the number of subscribers over time. It also projects expenses related to advertising, marketing, operations, and subscriptions. - The projections show increasing revenue over the 2 years as the number of subscribers and ukulele sales grow each month. Profits also rise over the period as revenue growth outpaces increasing expenses.

    Original Description:

    BUS 118.

    Original Title

    Emmanuel Ekpenyong_Expense Section W05 Project Unit 02 (1)

    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 projects the profit and loss statement for Kalei Ukuleles over a 2 year period from January 1 to December 31. - It forecasts revenue from ukulele sales, subscriptions, and growth in the number of subscribers over time. It also projects expenses related to advertising, marketing, operations, and subscriptions. - The projections show increasing revenue over the 2 years as the number of subscribers and ukulele sales grow each month. Profits also rise over the period as revenue growth outpaces increasing expenses.

    Copyright:

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

    Emmanuel Ekpenyong - Expense Section W05 Project Unit 02

    Uploaded by

    Emmanuel Nsa
    - The document projects the profit and loss statement for Kalei Ukuleles over a 2 year period from January 1 to December 31. - It forecasts revenue from ukulele sales, subscriptions, and growth in the number of subscribers over time. It also projects expenses related to advertising, marketing, operations, and subscriptions. - The projections show increasing revenue over the 2 years as the number of subscribers and ukulele sales grow each month. Profits also rise over the period as revenue growth outpaces increasing expenses.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 10
    At a glance
    Powered by AI
    The projected profit and loss statement shows the expected revenue, costs, and profits over a 12 month period for a business selling ukuleles and subscriptions. It makes assumptions about sales volumes, prices, and costs to estimate how the business will perform financially over time.

    The statement shows increasing sales, subscriptions, and profits each month as the business grows. It tracks metrics like advertising costs, product costs, operating expenses and net income on a monthly basis to estimate overall performance.

    The assumptions made include the average price per ukulele, average cost per ukulele, number of ukuleles purchased per customer, subscription rate and price, initial number of clicks/visits per month and predicted monthly growth rate for these figures.

    W03 Projected Profit and Loss Statement Starter

    Kalei Ukuleles
    Projected Profit and Loss Statement
    For the Period of January 1 - December 31
    Assumptions
    Avg. ukulele price $ 100
    Avg. ukulele cost $ 95
    Ukuleles/customer 1.0
    Subscriber rate 25%
    Avg. no. of months of subscripti 18
    Avg. Subscription Price $ 9.99
    Initial # of clicks/Mnth 1000
    Conversion Rate 2%
    Predicted Growth Rate/Month 0.5% <--Name this cell
    Cost Per Click $ 0.65 1 2 3
    Sales in units Jan Feb Mar
    PPC clicks $1,000 $1,005 $1,010
    Ukulele Sales (units) $20 $20 $20
    New Subscibers 5 5 5
    Ended Subsciption 0 0 0
    Number of subscribers 5 10 15

    Revenue Jan Feb Mar


    Subscriptions $50 $100 $150
    Ukulele Sales $2,000 $2,010 $2,020
    Total Sales $2,050 $2,110 $2,170
    Cost of Goods Sold $1,900 $1,910 $1,919
    Gross Profit $150 $200 $251
    Expenses
    Advertizing Cost $650 $653 $657
    Marketing Materials $75 $75 $84
    Computer $33 $33 $33
    Shipping Insurance $13 $8 $8
    Packaging $400 $20 $20
    Office/ Business Phones $83 $83 $83
    Website Development $350 $300 $300
    Subscription $83 $83 $84
    Total Expenses $1,688 $1,256 $1,269
    Net Income $1,538 $1,056 $1,017
    CLV - CAC
    Ukuleles Sales
    Ukuleles/customer 1.0
    Gross profit/ukulele $ 5
    Ukuleles Contribution $ 5.00
    Subscriptions
    Subscriptions/month $ 9.99
    Subscriber rate 25%
    Months of subscription 18
    Subscription Contribution $ 44.96
    Customer Lifetime Value
    Customer Acquisition Cost
    Contribution to Cash Flow
    4 5 6 7 8
    Apr May Jun Jul Aug
    $1,015 $1,020 $1,025 $1,030 $1,036
    $20 $20 $21 $21 $21
    5 5 5 5 5
    0 0 0 0 0
    20 25 30 36 41

    Apr May Jun Jul Aug


    $201 $252 $303 $355 $406
    $2,030 $2,040 $2,051 $2,061 $2,071
    $2,231 $2,292 $2,354 $2,415 $2,477
    $1,929 $1,938 $1,948 $1,958 $1,968
    $303 $354 $406 $458 $510
    $660 $663 $666 $670 $673
    $84 $84 $84 $85 $85
    $33 $33 $33 $33 $33
    $8 $8 $8 $8 $8
    $20 $20 $20 $20 $20
    $83 $83 $83 $83 $83
    $300 $300 $300 $300 $300
    $84 $84 $84 $85 $85
    $1,272 $1,276 $1,280 $1,284 $1,288
    $970 $922 $874 $826 $778
    $ 49.96
    $ 32.50
    $ 17.46
    9 10 11 12 13 14
    Sep Oct Nov Dec Jan Feb
    $1,041 $1,046 $1,051 $1,056 $1,062 $1,067
    $21 $21 $21 $21 $21 $21
    5 5 5 5 5 5
    0 0 0 0 0 0
    46 51 56 62 67 72

    Sep Oct Nov Dec Jan Feb


    $458 $511 $563 $616 $669 $722
    $2,081 $2,092 $2,102 $2,113 $2,123 $2,134
    $2,540 $2,602 $2,665 $2,729 $2,792 $2,856
    $1,977 $1,987 $1,997 $2,007 $2,017 $2,027
    $562 $615 $668 $722 $775 $829
    $676 $680 $683 $687 $690 $694
    $85 $85 $86 $86 $86 $87
    $33 $33 $33 $33 $33 $33
    $8 $8 $8 $8 $9 $9
    $20 $20 $20 $20 $20 $20
    $83 $83 $83 $83 $83 $83
    $300 $300 $300 $300 $300 $300
    $85 $85 $86 $86 $86 $86
    $1,292 $1,296 $1,300 $1,304 $1,308 $1,312
    $729 $680 $632 $582 $533 $483
    15 16 17 18 19 20
    Mar Apr May Jun Jul Aug
    $1,072 $1,078 $1,083 $1,088 $1,094 $1,099
    $21 $22 $22 $22 $22 $22
    5 5 5 5 5 5
    0 0 0 0 5 5
    78 83 88 94 94 95

    Mar Apr May Jun Jul Aug


    $776 $830 $884 $938 $943 $948
    $2,145 $2,155 $2,166 $2,177 $2,188 $2,199
    $2,920 $2,985 $3,050 $3,115 $3,131 $3,146
    $2,037 $2,048 $2,058 $2,068 $2,078 $2,089
    $883 $937 $992 $1,047 $1,052 $1,057
    $697 $700.49 $704 $708 $711 $715
    $87 $87 $87 $88 $88 $88
    $33 $33 $33 $33 $33 $33
    $9 $9 $9 $9 $9 $9
    $20 $20 $20 $20 $20 $20
    $83 $83 $83 $83 $83 $83
    $300 $300 $300 $300 $300 $300
    $87 $87 $87 $87 $88 $88
    $1,316 $1,320 $1,324 $1,328 $1,332 $1,336
    $433 $382 $332 $281 $280 $279
    21 22 23 24 Total Total
    Sep Oct Nov Dec Year 1 Year 2
    $1,105 $1,110 $1,116 $1,122 $12,336 $13,096
    $22 $22 $22 $22 $247 $262
    6 6 6 6 $62 $65
    5 5 5 5 $30
    95 96 96 97 $397 $1,056
    Total Total
    Sep Oct Nov Dec Year 1 Year 2
    $952 $957 $962 $967 $3,966 $10,546
    $2,210 $2,221 $2,232 $2,243 $24,671 $26,193
    $3,162 $3,178 $3,194 $3,210 $28,637 $36,739
    $2,099 $2,110 $2,120 $2,131 $23,438 $24,883.15
    $1,063 $1,068 $1,073 $1,079 $5,199 $11,856
    $718 $722 $725 $729 $8,018 $8,513
    $88 $89 $89 $90 $998 $1,054
    $33 $33 $33 $33 $400 $400
    $9 $9 $9 $9 $105 $104
    $20 $20 $20 $21 $241 $861
    $83 $83 $83 $84 $1,000 $1,917
    $300 $300 $300 $300 $3,651 $3,602
    $88 $88 $89 $89 $1,013 $1,049
    $1,340 $1,344 $1,348 $1,355 $15,805 $15,964
    $277 $276 $275 $277 $10,606 $4,108

    You might also like