Answered step by step
Verified Expert Solution
Question
1 Approved Answer
See the prompt below and write a max. 1.page memo to share your recommendation with senior leadership. Please submit any supporting analysis you've done (including
See the prompt below and write a max. 1.page memo to share your recommendation with senior leadership. Please submit any supporting analysis you've done (including Excel sheets, charts, etc.) Hinewsis considering breaking into local news coverage by launching a newsletter and mini website into these 4 cities: Denver, Des Moines, Minneapolis and Tampa. Build a quarterly 3- year model based off of the below assumptions with the first 4 cities launching on Jan 1, 2022 and then another 4 on April 1, 2022. With the model you've built, advise on whether this is a worthy investment for Hinews. Market economics Per City growth to maturity Revenue Costs Profit Profit Margin Year 1 25% $750,000 800,000 (50,000) -7% Year 2 55% $1,650,000 1,300,000 350,000 21% Year 3 100% $3,000,000 1,950,000 1,050,000 35% See the prompt below and write a max. 1.page memo to share your recommendation with senior leadership. Please submit any supporting analysis you've done (including Excel sheets, charts, etc.) Hinewsis considering breaking into local news coverage by launching a newsletter and mini website into these 4 cities: Denver, Des Moines, Minneapolis and Tampa. Build a quarterly 3- year model based off of the below assumptions with the first 4 cities launching on Jan 1, 2022 and then another 4 on April 1, 2022. With the model you've built, advise on whether this is a worthy investment for Hinews. Market economics Per City growth to maturity Revenue Costs Profit Profit Margin Year 1 25% $750,000 800,000 (50,000) -7% Year 2 55% $1,650,000 1,300,000 350,000 21% Year 3 100% $3,000,000 1,950,000 1,050,000 35%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started