Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    21 Csu 367

    Uploaded by

    shivam

    Copyright:

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

    21 Csu 367

    Uploaded by

    shivam
    8 views8 pages

    Original Title

    21csu367

    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
    8 views8 pages

    21 Csu 367

    Uploaded by

    shivam

    Copyright:

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

    Author:

    Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
    Illustrated Excel 2022 | Modules 1-4: Exam Project 1a

    Cello Worldwide
    CREATE AND FORMAT A FINANCIAL ANALYSIS

    Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
    Cello Worldwide
    Revenue
    San Antonio Office

    September October November Trend Total


    Mobile phones 60,711 65,322 59,877 70,002 255,912
    Wireless services 81,265 68,955 77,382 85,671 313,273
    Business services 45,600 43,288 39,764 40,228 168,880
    Total 187576.00 177565.00 177023.00 195901.00

    Expenses
    September October November December Trend Total
    Rent $ 12,000 $ 12,000 $ 14,000 $ 14,000 $ 52,000
    Insurance 8,200 8,200 8,500 8,500 33,400
    Salaries 41,500 41,600 42,000 42,350 167,450
    Utilities 6,200 6,300 6,250 6,100 24,850
    Taxes 7,500 8,300 8,100 8,000 31,900
    Total $ 75,400 $ 76,400 $ 78,850 $ 78,950 $ 309,600

    Profit
    September October November December Trend Total
    Profit Amount 112176.00 101165.00 98173.00 116951.00 $ (309,600)

    Lowest revenue $ 39,764


    Highest revenue $ 85,671

    250,000

    200,000
    40,228
    45,600
    43,288 39,764
    150,000 85,671
    81,265 77,382
    68,955
    100,000

    65,322 70,002
    50,000 60,711 59,877

    -
    1 2 3 4
    100,000

    65,322 70,002
    50,000 60,711 59,877

    -
    1 2 3 4
    Date: 5/7/2024

    Expenses by Type
    $45,000

    $40,000

    $35,000

    $30,000

    September
    $25,000
    October
    November
    $20,000
    December

    $15,000

    $10,000

    $5,000

    $-
    Rent Insurance Salaries Utilities Taxes

    Monthly Amount

    Sept to Dec Profit

    September
    27% 26%
    October
    November
    December

    23% 24%

    40,228

    85,671

    70,002

    4
    70,002

    4
    Cello Worldwide
    Current date: 5/28/2021
    Business Customers
    Customer ID Location Customer Since Years Wireless Plan Type Discount?
    CS-104 N 3/12/2016 5 N Talk Only Y
    CS-212 SW 2/16/2015 6 Y Unlimited Y
    CS-606 SE 12/15/2017 3 Y Select N
    CS-418 N 4/17/2020 1 Y Select N
    CS-192 SW 11/6/2020 1 Y Unlimited N
    CS-202 SW 4/15/2019 2 Y Unlimited N
    CS-301 SE 2/25/2018 3 Y Select N
    CS-452 N 10/22/2018 3 Y Select N
    CS-127 N 6/12/2017 4 Y Select N
    CS-228 SW 7/1/2020 1 Y Unlimited N
    CS-119 N 4/14/2017 4 Y Unlimited Y
    CS-220 SE 11/4/2018 3 N Talk Only N
    CS-326 N 3/20/2016 5 Y Unlimited Y
    CS-401 N 10/14/2017 4 Y Select N
    Analysis
    New Contract? Free Phone? Number of customers 14
    0 TRUE Average years as customer 3
    TRUE TRUE
    FALSE FALSE
    FALSE TRUE
    FALSE TRUE
    FALSE TRUE
    FALSE FALSE
    FALSE TRUE
    FALSE TRUE
    FALSE TRUE
    TRUE TRUE
    FALSE FALSE
    TRUE TRUE
    FALSE TRUE

    You might also like