Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
Verified Expert
The task is related to the capital budgeting problem of finance. The incremental revenue has to be computed in this case with the given fields like the capital investment, operating costs and hurdle rate. After computing the revenue, the amount of EBITDA has to be calculated. NPV and IRR metrics have to be assessed as well.
Need a 35 hour turn around. Must be done on excel Must be done via Excel can you please clarify the administration costs. 12 heads at 100k. Does this mean staffing costs 100K/ year or (100K*12 heads) 1.2M / Year. Please clarify this... thank you Also please quickly explain where depreciation fits on this sheet. The depreciation says 66,666.67/year. However the the capital investment is 2,000,000 depreciated over 3 years. So 666,666.67 a year. Can you please fix this. Also can you explain how you got 6008400 (Discounted cash flow).. 1.65372x-106079= 200000 x = 99705 (Required Incremental Revenue) is it correct, x= 10,921,272.7 Thanks for clearing my all of the doubts, this is really amazing place where i could be able to resolve all of my queries. Thanks a lot.
Dressler Engine Tuning just decided to save money each year for the next 4 years to help fund a new building. If it earns 5.5 percent on its savings, how much will the firm have saved at the end of year 4?
1. The mean rate of return on a stock is estimated at 20% while the volatility is 40%: The risk free interest rate is 5%: What is the mean for the log price relative?
A critic of state unemployment insurance programs stated that "unemployment insurance programs are designed to maintain economic security for unemployed workers, but several critical problems must be resolved."
Computation of NPV of the project at various interest rates and what is the NPV of this project if the five-year interest rate is
HMK Enterprises would like to raise $10 million to invest in capital expenditures. The company plans to issue five-year bonds with a face value of $1000 and a coupon rate of 6.5% (annual payments). The following table summarizes the yield to maturity..
Depreciation is expected to increase at the same rate as sales.Interest costs are expected to remain unchanged.The tax rate is expected to remain at 40%. On the basis of that information, what will be the forecast for Roberts' year-end net income?
mr. swansonhad recently overheard afellow member of his local business association discussing possible investments in
Execute an investigation into whether the firm's managers are generating adequate operating profits on the company's assets. Calculate how liquid a firm is and whether it can pay its bills
The paper should discuss the following about the Caesar's Entertaiment corporation.
Computation of current yield of the bond and they pay interest annually and have a 9% coupon rate
Identify three or more competitive strategies of your choice that may be used by the organization to maximize its profits over the long run. Evaluate the effectiveness of these strategies in the market structure you identified
The division has fixed costs of $10,000 per month, and it expects to sell 42,000 strips per month. If the variable cost per strip is $2.00, what price must the division charge in order to break even?
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd