Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions