Prepare a three year financial model

Assignment Help Finance Basics

Reference no: EM131373471

We are assembling a top team across the company to look at the feasibility of adding a daily section of the newspaper and website devoted to national sports coverage. This would entail a significant expansion upon our current coverage with highlights of key games, sports scores, standings, etc. We have been asked to build a basic financial analysis to demonstrate what level of incremental revenue we have to assume to target acceptable levels of return.

Key assumptions for the business case:

- Assume the incremental revenue is all advertising related
- This initiative should improve circulation retention and drive new subscriptions, but for the purpose of this analysis, assume no incremental impact here
- Capital Investment of $2m for enhancements to existing website (assume 3 year useful life for book and tax basis accounting)
- Incremental staffing costs of 12 heads at $100k per year
- Incremental production costs of $0.02 per copy (assume 1.4 million daily copies and 304 annual pub days)
- Assume advertising commissions expense at 5% of incremental revenue
- Assume a corporate tax rate of 30%
- Assume a discount rate of 10%

Please prepare a 3 year financial model that you will present to the management team. The analysis needs to demonstrate what level of incremental revenue is needed over a 3 year time horizon to meet our 10% hurdle rate. In addition, the analysis should touch on other key metrics such as NPV, IRR, and annual EBITDA impact.

Reference no: EM131373471

Questions Cloud

Test for a difference between means : New corporate strategies take years to develop. Two methods for facilitating the development of new strategies by executive strategy meetings are to be compared.- Test for a difference between means, using α = 0.05.

Briefly describe your experience of unforgettable arguments : Introductory Essay - Arguments in My Life - Worksheet. Briefly describe your experience of 2-3 unforgettable arguments, and them choose one that will allow you to tell an interesting story. Who, describe you, were the participants

Find the rates of growth of steady-state capital per worker : ECN 101- An economy's technology is described by the following Cobb-Douglas production function. Find the rates of growth of the steady-state capital per worker and GDP per worker. Show your work.

Explain how you reached your conclusion : Using the α = 0.01 level of significance, test the null hypothesis that both methods of advertising are equally effective versus the alternative hypothesis that they are not equally effective. If you conclude that one method is better, state which..

Prepare a three year financial model : Please prepare a three year financial model that you will present to the management team. The analysis needs to demonstrate what level of incremental revenue is needed over a 3 year time horizon to meet our 10% hurdle rate.

What job do you plan to have in the health care sector : HCS 449: In addition to the personal goals you set in Week Three, this week you will be setting professional career goals. These are goals that relate to your chosen career, what type of job you want, and what steps you need to take to secure that..

Is the average sale price of all properties in both location : A random sample of 35 properties in Marin County gives x‾= $4.32 million and s = $0.87 million. Is the average sale price of all properties in both locations approximately equal or not? Explain

Define the function average-price : Define the function average-price. It consumes a list of toy prices and computes the average price of a toy. The average is the total of all prices divided by the number of toys.

User Account

All Pages