2020 2021 2022 2023 2024 2025 Dividend of two companies Sweet Carolina Corp. 2.15 2.3 2.5 2.7 Growth rate 8.0% 8.0% 8.0% 8.0% 2.9 8.0% 3.2 8.0% Cookie Kingdom Inc. 5.5 Growth rate 4.0% 5.7 4.0% 5.9 4.0% 6.2 4.0% 6.4 4.0% 6.7 4.0% Logic functions (Two Parts, 15 Points) Do not share your exam! 1) You want to research two companies' dividend payout, and know whether each reaches a specified test value in a specific year in the future. We want to do both independent tests and a joint test. 2) Calculate the sum of Sweet Carolina's annual dividend from years that satisfy certain conditions. Test values: Sweet Carolina Corp. 2.8 FALSE FALSE 6 FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE Use logic functions for both parts. Cookie Kingdom Inc. Above test values independently? Sweet Carolina Corp. Cookie Kingdom Inc. Both above test values? return 1 vs. 0 return "T" vs. "F" Calculate the sum of Sweet Carolina's dividend from year 2022 onwards Calculate the sum of Sweet Carolina's dividend from year 2022 onwards if >2.8 Hint: Using embedded "IF (AND)", or compound "IF (... IF ()...)