Excel spreadsheet recreate using instructions and example of final work
waterdawg77
NP_EX16_4b_MirielleWhite_1.xlsxDocumentation
| New Perspectives Excel 2016 | Module 4: SAM Project 1b | |
| Calorie Courier | |
| 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. | |
2024 Average Monthly Order
| Calorie Courier | |
| 2024 Average Monthly Orders | |
| Member ID | Average Monthly Orders |
| NC6395 | 20 |
| NC8492 | 6 |
| NC8864 | 24 |
| NC8229 | 12 |
| NC9947 | 13 |
| NC7683 | 6 |
| NC3489 | 6 |
| NC5476 | 15 |
| NC1586 | 6 |
| NC7195 | 20 |
| NC7248 | 27 |
| NC5996 | 18 |
| NC5194 | 17 |
| NC6777 | 15 |
| NC7278 | 14 |
| NC6364 | 15 |
| NC4316 | 13 |
| NC7862 | 24 |
| NC1812 | 25 |
| NC4662 | 5 |
| NC2247 | 16 |
| NC8653 | 8 |
| NC6743 | 17 |
| NC2962 | 21 |
| NC2261 | 27 |
| NC2316 | 14 |
| NC5996 | 22 |
| NC5799 | 10 |
| NC4679 | 13 |
| NC5282 | 11 |
| NC5426 | 20 |
| NC3977 | 11 |
| NC7132 | 28 |
| NC3242 | 19 |
| NC4433 | 18 |
| NC4774 | 10 |
| NC1269 | 25 |
| NC6265 | 17 |
| NC5614 | 17 |
| NC6364 | 14 |
| NC6912 | 19 |
| NC5871 | 20 |
| NC2388 | 10 |
| NC3316 | 28 |
| NC9337 | 15 |
| NC1646 | 28 |
| NC9511 | 30 |
| NC3274 | 8 |
| NC7844 | 13 |
| NC8538 | 6 |
| NC1521 | 6 |
| NC8312 | 19 |
| NC6894 | 20 |
| NC4338 | 16 |
| NC1745 | 14 |
| NC5776 | 17 |
| NC7752 | 19 |
| NC8449 | 16 |
| NC9356 | 11 |
| NC4824 | 19 |
| NC6485 | 14 |
| NC8547 | 28 |
| NC1419 | 5 |
| NC1264 | 23 |
| NC8921 | 8 |
| NC5757 | 11 |
| NC4218 | 16 |
| NC5483 | 13 |
| NC6735 | 7 |
| NC8957 | 29 |
| NC8956 | 28 |
| NC9574 | 16 |
| NC3214 | 14 |
| NC3252 | 26 |
| NC8389 | 11 |
| NC4294 | 6 |
| NC5383 | 12 |
| NC1126 | 16 |
| NC7626 | 14 |
| NC3191 | 11 |
| NC6627 | 30 |
| NC5795 | 7 |
| NC6561 | 20 |
| NC2332 | 19 |
| NC2636 | 9 |
| NC7262 | 13 |
| NC2245 | 25 |
| NC7438 | 17 |
| NC2838 | 17 |
| NC2811 | 13 |
| NC6236 | 18 |
| NC5815 | 11 |
| NC4222 | 9 |
| NC3256 | 28 |
| NC1781 | 10 |
| NC6852 | 16 |
| NC9175 | 14 |
| NC3638 | 14 |
| NC7884 | 20 |
| NC8776 | 9 |
| NC5738 | 14 |
| NC9687 | 16 |
| NC8665 | 7 |
| NC2831 | 13 |
| NC5686 | 20 |
| NC7345 | 13 |
| NC3282 | 23 |
| NC1175 | 17 |
| NC9833 | 18 |
| NC2967 | 17 |
| NC6586 | 15 |
| NC5121 | 15 |
| NC1274 | 15 |
| NC8474 | 14 |
| NC5945 | 20 |
| NC3511 | 18 |
| NC5983 | 20 |
| NC1485 | 16 |
| NC6462 | 11 |
| NC9328 | 19 |
| NC3928 | 29 |
| NC1116 | 17 |
| NC3238 | 19 |
| NC7776 | 16 |
| NC6811 | 18 |
| NC2153 | 11 |
| NC4734 | 11 |
| NC6954 | 14 |
| NC5742 | 11 |
| NC9425 | 21 |
| NC5777 | 25 |
| NC4624 | 12 |
| NC7121 | 11 |
| NC4512 | 25 |
| NC9537 | 6 |
| NC3211 | 14 |
| NC5821 | 12 |
| NC3728 | 13 |
| NC7828 | 15 |
| NC8837 | 20 |
| NC5336 | 20 |
| NC1447 | 20 |
| NC4926 | 16 |
| NC1913 | 7 |
| NC2597 | 28 |
| NC9923 | 29 |
| NC4254 | 27 |
| NC2721 | 27 |
| NC1658 | 20 |
| NC7127 | 18 |
| NC2367 | 15 |
| NC1948 | 13 |
| NC4261 | 23 |
| NC2688 | 10 |
| NC7531 | 9 |
| NC3919 | 27 |
| NC8586 | 11 |
| NC7583 | 16 |
| NC1118 | 18 |
| NC2313 | 7 |
| NC7977 | 20 |
| NC6525 | 12 |
| NC5815 | 7 |
| NC4513 | 15 |
| NC1196 | 6 |
| NC2653 | 19 |
| NC8144 | 7 |
| NC7295 | 24 |
| NC1165 | 18 |
| NC1651 | 17 |
| NC7295 | 14 |
| NC2442 | 8 |
| NC1459 | 25 |
| NC2677 | 15 |
| NC2427 | 6 |
| NC8842 | 20 |
| NC9649 | 12 |
| NC6846 | 25 |
| NC2895 | 12 |
| NC3722 | 29 |
| NC6442 | 14 |
| NC8349 | 12 |
| NC4532 | 12 |
| NC2777 | 22 |
| NC2217 | 14 |
| NC7282 | 8 |
| NC6857 | 16 |
| NC4925 | 11 |
| NC3834 | 20 |
| NC3879 | 18 |
| NC6872 | 25 |
| NC2632 | 18 |
| NC3621 | 17 |
| NC5244 | 16 |
| NC7145 | 11 |
| NC1529 | 24 |
| NC5469 | 15 |
| NC1365 | 19 |
| NC9249 | 14 |
| NC2893 | 19 |
| NC3712 | 20 |
| NC2291 | 30 |
| NC3581 | 8 |
| NC6566 | 23 |
| NC4243 | 16 |
| NC3974 | 14 |
| NC4485 | 24 |
| NC8636 | 24 |
| NC2491 | 18 |
| NC8396 | 16 |
| NC2719 | 13 |
| NC4696 | 28 |
| NC1385 | 18 |
| NC4765 | 8 |
| NC3196 | 14 |
| NC6939 | 27 |
| NC1458 | 16 |
| NC1544 | 20 |
| NC7859 | 20 |
| NC6879 | 6 |
| NC3582 | 10 |
| NC6727 | 19 |
| NC3877 | 6 |
| NC8688 | 14 |
| NC3248 | 29 |
| NC7314 | 7 |
| NC3691 | 5 |
2019-2024 Annual Income
| Calorie Courier | ||||||||
| Annual Income: 2019 - 2024 | ||||||||
| Meal Plans (Weekly) | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | Trends | Total |
| Two Day | $ 3,500 | $ 5,650 | $ 8,650 | $ 12,750 | $ 13,550 | $ 15,550 | $ 59,650 | |
| Three Day | $ 6,750 | $ 5,350 | $ 10,350 | $ 13,500 | $ 14,250 | $ 20,750 | $ 70,950 | |
| Five Day | $ 5,250 | $ 8,750 | $ 10,325 | $ 12,500 | $ 13,500 | $ 14,525 | $ 64,850 | |
| Seven Day | $ 750 | $ 3,500 | $ 4,550 | $ 6,500 | $ 5,750 | $ 7,750 | $ 28,800 | |
| On Demand | $ 7,000 | $ 7,540 | $ 3,200 | $ - | $ - | $ - | $ 17,740 | |
| Total | $ 23,250 | $ 30,790 | $ 37,075 | $ 45,250 | $ 47,050 | $ 58,575 | $ 241,990 | |
2024 Annual Income by Meal Plan
$15,550 $20,750 $14,525 Two Day Three Day Five Day Seven Day On Demand 15550 20750 14525 7750 0
Annual Income: 2019 – 2024
Total 23250 30790 37075 45250 47050 58575
Meal Plan Contribution to Annual Income: 2019 – 2024
Two Day 2019 2020 2021 2022 2023 2024 3500 5650 8650 12750 13550 15550 Three Day 2019 2020 2021 2022 2023 2024 6750 5350 10350 13500 14250 20750 Five Day 2019 2020 2021 2022 2023 2024 5250 8750 10325 12500 13500 14525 Seven Day 2019 2020 2021 2022 2023 2024 750 3500 4550 6500 5750 7750 On Demand 2019 2020 2021 2022 2023 2024 7000 7540 3200 0 0 0 Total 2019 2020 2021 2022 2023 2024 23250 30790 37075 45250 47050 58575
2024 Annual Income by Meal Plan
$15,550 $20,750 $14,525 Two Day Three Day Five Day Seven Day On Demand 15550 20750 14525 7750 0
Annual Income: 2019 – 2024
Total 23250 30790 37075 45250 47050 58575
Meal Plan Contribution to Annual Income: 2019 – 2024
Two Day 2019 2020 2021 2022 2023 2024 3500 5650 8650 12750 13550 15550 Three Day 2019 2020 2021 2022 2023 2024 6750 5350 10350 13500 14250 20750 Five Day 2019 2020 2021 2022 2023 2024 5250 8750 10325 12500 13500 14525 Seven Day 2019 2020 2021 2022 2023 2024 750 3500 4550 6500 5750 7750 On Demand 2019 2020 2021 2022 2023 2024 7000 7540 3200 0 0 0 Total 2019 2020 2021 2022 2023 2024 23250 30790 37075 45250 47050 58575
2024 Annual Income by Meal Plan
$15,550 $20,750 $14,525 Two Day Three Day Five Day Seven Day On Demand 15550 20750 14525 7750 0
Annual Income: 2019 – 2024
Total 23250 30790 37075 45250 47050 58575
Meal Plan Contribution to Annual Income: 2019 – 2024
Two Day 2019 2020 2021 2022 2023 2024 3500 5650 8650 12750 13550 15550 Three Day 2019 2020 2021 2022 2023 2024 6750 5350 10350 13500 14250 20750 Five Day 2019 2020 2021 2022 2023 2024 5250 8750 10325 12500 13500 14525 Seven Day 2019 2020 2021 2022 2023 2024 750 3500 4550 6500 5750 7750 On Demand 2019 2020 2021 2022 2023 2024 7000 7540 3200 0 0 0 Total 2019 2020 2021 2022 2023 2024 23250 30790 37075 45250 47050 58575
Income Overview
| Calorie Courier |
| Total Income: 2019 - 2024 |
Loan Options
| Calorie Courier | |||
| Business Loan Request | |||
| Option 1 | Option 2 | Option 3 | |
| Loan Amount | $ 150,000 | $ 150,000 | $ 150,000 |
| Annual Interest Rate | 6.25% | 5.75% | 5.45% |
| Payments per Year | 12 | 12 | 12 |
| Interest Rate per Period | 0.52% | 0.48% | 0.45% |
| Number of Years | 10 | 15 | 20 |
| Total Payments | 120 | 180 | 240 |
| Monthly Payments | |||
| Annual Payments | $ - 0 | $ - 0 | $ - 0 |
