1) You want to research two companies' dividendpayout, 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 dividendfrom years that satisfy certain conditions.

Use logic functions for both parts.

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. 5.9 Cookie Kingdom Inc. Growth rate 5.5 4.0% 5.7 4.0% 6.2 4.0% 6.4 4.0% 6.7 4.0% 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. Use logic functions for both parts. 2.8 6 Above test values independently? art 1 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...)...)" art 2 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. 5.9 Cookie Kingdom Inc. Growth rate 5.5 4.0% 5.7 4.0% 6.2 4.0% 6.4 4.0% 6.7 4.0% 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. Use logic functions for both parts. 2.8 6 Above test values independently? art 1 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...)...)" art 2 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