Hello, I need help with computing and making some equations in Excel. I feel like I have an idea, but I am not too sure. Also, I believe the equation I came up with in the marketing costs per period column is wrong. Thank you

This Excel has a lot of the CLV work already done for you. Notably, see columns "Active (\% chance) NEXT Period" and "prediction(REV)". Some other analyst has already provided you with specific forecasts for each of the customers regarding their forecasted activity (\%) and revenue. Whew, that's fortunate for you, since that can often be challenging WOrk! Your task in this this sheet is to complete the spreadsheet (you'll notice there are red cells saying "calculate me (Step X)" Your submission for Part 1 should be a one-page (max) report summarizing your calculation strategy and results (if you wish to include tables, figures, charts, and screenshots they do not count toward this page length requirement). Here's some things to consider summarizing: - If you had to make any judgment calls / make any assumptions as part of your CLV calculations, note them and justify them - Depict your CLV equation (possibly illustrate it by way of an example). Consider whether explaining it in Excel terms (cell references) or more generally (depicted as a typical math equation) best suits your purpose. - What is the average CLV? Lowest? Highest? - This CLV model isn't dynamic (why?) but you could still approximately test a few scenarios to help your reader understand the model a bit. As just a few examples, what would happen to CLV if customer activity suddenly dropped? Say, every customer had 20% lower chance of being active in the next period? What if revenue per customer increased by average of 10%? Information Ahout Customers This Excel has a lot of the CLV work already done for you. Notably, see columns "Active (\% chance) NEXT Period" and "prediction(REV)". Some other analyst has already provided you with specific forecasts for each of the customers regarding their forecasted activity (\%) and revenue. Whew, that's fortunate for you, since that can often be challenging WOrk! Your task in this this sheet is to complete the spreadsheet (you'll notice there are red cells saying "calculate me (Step X)" Your submission for Part 1 should be a one-page (max) report summarizing your calculation strategy and results (if you wish to include tables, figures, charts, and screenshots they do not count toward this page length requirement). Here's some things to consider summarizing: - If you had to make any judgment calls / make any assumptions as part of your CLV calculations, note them and justify them - Depict your CLV equation (possibly illustrate it by way of an example). Consider whether explaining it in Excel terms (cell references) or more generally (depicted as a typical math equation) best suits your purpose. - What is the average CLV? Lowest? Highest? - This CLV model isn't dynamic (why?) but you could still approximately test a few scenarios to help your reader understand the model a bit. As just a few examples, what would happen to CLV if customer activity suddenly dropped? Say, every customer had 20% lower chance of being active in the next period? What if revenue per customer increased by average of 10%? Information Ahout Customers