This has many parts PLEASEEEEE answer fully !

The final exam of this course will be the 99 Agency company case study. We will take a hypothetical company called 99 Agency. 99 Agency is a digital agency offering a wide spectrum of digital marketing services. Our products are divided in two main categories: SEO campaigns and Ad campaigns. We work with small, medium and large enterprises to help them achieve ambitious growth plans. 99 Agency has an 18% market share in its country of operation. You will prepare the overall budget for the 99 Agency, which consist of the following: - Revenue-Bottom - Up - Revenue - Top - Down - Revenue Budget - Cost of Sales - Ad Campaigns - Cost of Sales - SEO Campaigns - SGEA - Fixed Assets - Working Capital - Financial Liabilities - Master Budget: income Statement, Balance Sheet, and Statement of Cash Flows - Financial Liabilities - Master Budget: Income Statement, Balance Sheet, and Statement of Cash Flows To prepare the budgets, you will need to use everything you have leamed in this class thus far. Additionally, you will need to read the 99 Agency Course Challenge puf file for important information and prepare the budget using the 99 Agency Course Challenge Task. You need to mahe appropriate assumptions, construct the Excel model, and present and submit the final budget. The Revenue Budget Cost of SEO and Ad Campaligns Other Key Assumptions - 99 Agency operates in a single country (ABC) - AIISEO and ad campaigns are completed within the same - quarter when they are ordereo ine budgeting Committee agrees upon an average between Bottom-Up and Top-Down revenue targets - Fixed costs of SG\&A remain unchanged - The ratio of Variable costs of SGRA to revenue remains consthnt Bottom-Up Approach Top-Down Approach Average Revenue Projection Previous Year 101,732 Y-o-Y Growth \% Budget Q1 Q2 Revenue Ad campaigns Q3 Q4 FY 2022 Var\% Y.o-Y Revenue SEO campaigns Total Revenue Cost of Saies - Ad Campaigns Cost of Sales - SEO Campaigns Workinq Capital Income Statement The final exam of this course will be the 99 Agency company case study. We will take a hypothetical company called 99 Agency. 99 Agency is a digital agency offering a wide spectrum of digital marketing services. Our products are divided in two main categories: SEO campaigns and Ad campaigns. We work with small, medium and large enterprises to help them achieve ambitious growth plans. 99 Agency has an 18% market share in its country of operation. You will prepare the overall budget for the 99 Agency, which consist of the following: - Revenue-Bottom - Up - Revenue - Top - Down - Revenue Budget - Cost of Sales - Ad Campaigns - Cost of Sales - SEO Campaigns - SGEA - Fixed Assets - Working Capital - Financial Liabilities - Master Budget: income Statement, Balance Sheet, and Statement of Cash Flows - Financial Liabilities - Master Budget: Income Statement, Balance Sheet, and Statement of Cash Flows To prepare the budgets, you will need to use everything you have leamed in this class thus far. Additionally, you will need to read the 99 Agency Course Challenge puf file for important information and prepare the budget using the 99 Agency Course Challenge Task. You need to mahe appropriate assumptions, construct the Excel model, and present and submit the final budget. The Revenue Budget Cost of SEO and Ad Campaligns Other Key Assumptions - 99 Agency operates in a single country (ABC) - AIISEO and ad campaigns are completed within the same - quarter when they are ordereo ine budgeting Committee agrees upon an average between Bottom-Up and Top-Down revenue targets - Fixed costs of SG\&A remain unchanged - The ratio of Variable costs of SGRA to revenue remains consthnt Bottom-Up Approach Top-Down Approach Average Revenue Projection Previous Year 101,732 Y-o-Y Growth \% Budget Q1 Q2 Revenue Ad campaigns Q3 Q4 FY 2022 Var\% Y.o-Y Revenue SEO campaigns Total Revenue Cost of Saies - Ad Campaigns Cost of Sales - SEO Campaigns Workinq Capital Income Statement