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.
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.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  What would be the tax paid on a new project

Suppose that a firm has a marginal tax rate of 44% and an average tax rate of 34%. What would be the tax paid on a new project that will contribute an additional $8781 to the firm's cash flow?

  Tradeoff model of optimal capital structure

Which of the following expresses the value of a levered firm (VL) in the Static Tradeoff model of optimal capital structure? [Note: VU denotes the value of the unlevered firm; CFD denotes expected costs of financial distress; and PV denotes pr..

  What was the flotation cost as a percentage of funds raised

The Wiley Oakley Co. has just gone public. Under a firm commitment agreement, Wiley Oakley received $31.75 for each of the 7.3 million shares sold.

  How many orders will be placed during the year

Fisk corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 75,000 units per year, an ordering cost of $8 per order, and carrying costs of $1.20 per until.

  Find the costs of the individual capital components compute

cash2000000accounts payable and accruals18000000accounts receivable28000000notes

  What is the rational for the federal reserve board keeping

what is the rational for the federal reserve board keeping the federal rate to a nominal rate in recent years? how does

  What is the company free cash flow

The company is currently paying $2 million in interest per year, has a tax rate of 40%, and a WACC of 10%. What is the company's free cash flow for year 1 of this project?

  What are the average volumes for the two sampleswould you

look up the daily trading volume for the following stocks during a recent five-day periodbull merckbull caterpillarbull

  What is the principal balance on the loan

You take out a 30 year $100,000 mortgage loan with an APR of 6% and monthly payments. In 12 years, you decide to sell your house and pay off the mortgage. What is the principal balance on the loan?

  Computation of net operating income and market value

Computation of Net operating Income and Market Value and Stock Price and If the selling price per deck of cards will be the same under each method

  Why does the cost of equity increase

Why does the cost of equity increase with an increased use of debt in the capital structure?

  Why is the percentage of ownership criterion often

Why is the percentage of ownership criterion often not appropriate for judging whether a VIE should be consolidated

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd