2020 2021 2022 2023 2024 2025 Logic functions (Two Parts, 15 Points) Do not share your exam! Dividend of two companies Sweet Carolina Corp. Growth rate 2.15 8.0% 2.3 8.0% 2.5 8.0% 2.7 8.0% 2.9 8.0% 3.2 8.0% 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. Cookie Kingdom Inc. Growth rate 5.5 4.0% 5.7 4.0% 5.9 4.0% 6.2 4.0% 6.4 4.0% 6.7|| 4.0% 2) Calculate the sum of Sweet Carolina's annual dividend from years that satisfy certain conditions. Test values: Sweet Carolina Corp. Cookie Kingdom Inc. 2.8 FALSE 6 FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE Use logic functions for both parts. Above test values independently? Sweet Carolina Corp Cookie Kingdom Inc. Both above test values? return 1 vs. O return "T" Vs. "F" Hint: Using embedded "IF (AND)", or compound "IF (... IF (-)...)" 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 2020 2021 2022 2023 2024 2025 Logic functions (Two Parts, 15 Points) Do not share your exam! Dividend of two companies Sweet Carolina Corp. Growth rate 2.15 8.0% 2.3 8.0% 2.5 8.0% 2.7 8.0% 2.9 8.0% 3.2 8.0% 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. Cookie Kingdom Inc. Growth rate 5.5 4.0% 5.7 4.0% 5.9 4.0% 6.2 4.0% 6.4 4.0% 6.7|| 4.0% 2) Calculate the sum of Sweet Carolina's annual dividend from years that satisfy certain conditions. Test values: Sweet Carolina Corp. Cookie Kingdom Inc. 2.8 FALSE 6 FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE Use logic functions for both parts. Above test values independently? Sweet Carolina Corp Cookie Kingdom Inc. Both above test values? return 1 vs. O return "T" Vs. "F" Hint: Using embedded "IF (AND)", or compound "IF (... IF (-)...)" 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