Excel spreadsheet recreate

profilewaterdawg77
NP_EX16_4a_MirielleWhite_1.xlsx
Home>Business & Finance homework help>Accounting homework help>Excel spreadsheet recreate

Documentation

New Perspectives Excel 2016 | Module 4: SAM Project 1a
Inception Workspace
ANALYZING AND CHARTING FINANCIAL DATA
Author: Mirielle White
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.

Average Usage 2024

Inception Workspace
Average Usage by Member in 2024
Member ID Average Weekly Use (in Hours)
AP6052 32
AP9617 30
AP5409 29
AP9034 60
AP9673 63
AP3708 30
AP7235 22
AP9499 29
AP5853 28
AP8225 25
AP8617 21
AP7315 33
AP7187 35
AP7346 28
AP5408 22
AP8150 33
AP6068 22
AP3706 29
AP7867 20
AP1744 58
AP9764 26
AP8020 66
AP7310 43
AP8013 67
AP1073 26
AP7539 26
AP9822 31
AP8141 20
AP5479 59
AP2139 27
AP4738 25
AP3375 53
AP7159 26
AP5946 35
AP9018 45
AP8745 26
AP8387 31
AP9710 30
AP3004 54
AP7921 21
AP2991 28
AP4249 34
AP6245 65
AP6366 27
AP3412 61
AP9045 23
AP4941 24
AP6955 66
AP9774 20
AP5881 18
AP2901 23
AP4991 35
AP6385 17
AP9983 54
AP3729 74
AP1638 25
AP1370 39
AP9587 39
AP6078 29
AP2277 42
AP5423 35
AP5081 22
AP5639 46
AP5798 60
AP5687 23
AP8182 35
AP8928 56
AP1683 67
AP4718 20
AP6499 35
AP4399 55
AP7664 29
AP2039 39
AP9236 66
AP5166 35
AP4551 26
AP6687 25
AP7563 32
AP6280 31
AP6962 20
AP4455 75
AP5044 32
AP5563 27
AP7611 19
AP6187 35
AP4610 18
AP7490 25
AP3932 44
AP1649 60
AP5731 30
AP9211 66
AP9265 25
AP7827 53
AP6294 21
AP5888 23
AP2582 23
AP1694 28
AP7994 46
AP9314 60
AP6933 54
AP3911 70
AP4158 25
AP5437 55
AP3544 33
AP7606 49
AP3605 33
AP2310 30
AP9186 24
AP8389 23
AP7334 24
AP3722 34
AP6218 30
AP8893 66
AP9588 37
AP9792 34
AP9082 22
AP8252 33
AP7135 62
AP5943 19
AP5617 75
AP7919 65
AP1533 70
AP9070 28
AP2576 42
AP9382 59
AP4175 73
AP5800 48
AP3423 39
AP4025 30
AP4826 27
AP6780 73
AP3896 30
AP6432 69
AP1361 28
AP6489 25
AP7445 49
AP2715 59
AP4030 27
AP3808 26
AP1255 21
AP5549 20
AP9424 22
AP1730 31
AP2546 17
AP5015 26
AP4720 61
AP6930 30
AP7975 64
AP7575 18
AP8840 42
AP1675 33
AP6694 21
AP9811 54
AP8990 26
AP6345 53
AP3987 64
AP1884 55
AP7749 34
AP5679 28
AP6722 48
AP8408 41
AP1815 71
AP8696 25
AP5274 23
AP3290 17
AP1621 26
AP6782 27
AP4375 48
AP3144 27
AP4047 69
AP2354 25
AP6824 51
AP2492 48
AP8730 16
AP3677 23
AP9409 50
AP3283 58
AP5847 75
AP9115 26
AP8541 56
AP5000 37
AP5072 22
AP6975 65
AP5446 32
AP8451 45
AP4579 28
AP9850 34
AP8645 32
AP7938 28
AP9657 19
AP3100 70
AP7834 15
AP3077 32
AP7757 33
AP8230 23
AP2430 44
AP2464 25
AP5642 29
AP4063 47
AP2785 30
AP3723 35
AP7150 32
AP8640 23
AP1500 34
AP3417 22
AP2844 27
AP1586 64
AP6204 67
AP4191 30
AP8624 30
AP3607 24
AP9905 75
AP1879 74
AP3749 23
AP3208 38
AP4084 26
AP8429 23
AP7839 24
AP8082 26
AP4015 58
AP3800 70
AP1131 56
AP5663 27
AP8079 35
AP7405 24
AP1724 34
AP8109 59
AP9173 46
AP2743 41
AP1303 58
AP4093 53
AP8026 66
AP9037 55
AP1738 34
AP5907 69
AP4497 35
AP4550 49
AP2228 23
AP9291 57

Annual Income

Inception Workspace
Total Annual Income: 2019 - 2024
Membership Package 2019 2020 2021 2022 2023 2024 Trends Total
Open Desk - Visitor $ 54,000 $ 62,640 $ 67,500 $ 65,520 $ 69,660 $ 68,475 $ 387,795
Open Desk - Regular $ 86,400 $ 120,960 $ 130,500 $ 117,000 $ 145,800 $ 158,400 $ 759,060
Dedicated Desk $ 21,600 $ 27,000 $ 28,125 $ 40,950 $ 42,525 $ 43,313 $ 203,513
Dedicated Office $ 28,800 $ 43,200 $ 60,000 $ 46,800 $ 48,600 $ 82,500 $ 309,900
Meeting Room $ - $ - $ 41,700 $ 58,650 $ 73,200 $ 78,877 $ 252,427
Total $ 190,800 $ 253,800 $ 327,825 $ 328,920 $ 379,785 $ 431,565 $ 1,912,695

2024 Total Annual Income by Package

2024 Open Desk - Visitor Open Desk - Regular Dedicated Desk Dedicated Office Meeting Room 68475 158400 43312.5 82500 78877

Total Annual Income: 2019 – 2024

Total 190800 253800 327825 328920 379785 431564.5

Package Contribution to Annual Income: 2019 – 2024

Open Desk - Visitor 2019 2020 2021 2022 2023 2024 54000 62640 67500 65520 69660 68475 Open Desk - Regular 2019 2020 2021 2022 2023 2024 86400 120960 130500 117000 145800 158400 Dedicated Desk 2019 2020 2021 2022 2023 2024 21600 27000 28125 40950 42525 43312.5 Dedicated Office 2019 2020 2021 2022 2023 2024 28800 43200 60000 46800 48600 82500 Meeting Room 2019 2020 2021 2022 2023 2024 0 0 41700 58650 73200 78877 Total 2019 2020 2021 2022 2023 2024 190800 253800 327825 328920 379785 431564.5

Income Overview

Inception Workspace
Annual Income Overview: 2019 - 2024

Loan Options

Inception Workspace
Business Loan Request
Option A Option B Option C
Loan Amount $ 300,000 $ 300,000 $ 350,000
Annual Interest Rate 8.00% 6.57% 5.99%
Payments per Year 12 12 12
Interest Rate per Period 0.67% 0.55% 0.50%
Number of Years 10 15 20
Total Payments 120 180 240
Monthly Payments
Annual Payments $ - 0 $ - 0 $ - 0