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.
Electronics and More offers credit terms of 1/5, net 20. What is the effective annual rate on a $12,000 purchase if you forgo the discount?
Laurel Street, president of Uvalde Manufacturing Corporation is planning a proposal to present to her board of directors regarding a planned plant expansion that will expense $10 million.
A stock has an expected return of 16.2%, a beta of 1.75 and the expected return on the market is 11%. what must the risk-free rate be?
a. If your investment rate over the next twenty years is 8%, which payoff will you choose? b. If your investment rate over the next twenty years is 5%, which payoff will you choose? c. At what investment rate will the annuity stream of $250,000 be th..
overview planning for retirementin this assignment to be completed individually the objective is to make plans for
The after-tax incremental cash flow
To use the Internal Revenue Service's average cost basis method of determining the average price paid for one share, begin by calculating the average price paid for the shares. In this instance, the $2000 is divided by 215 shares (125 shares + 50 sh..
If Yurdone requires a return of 10 percent on such undertakings, should the firm accept or reject the project?
Northern Airlines is about to go public. It currently has after-tax receiving’s of $6,000,000 and 4,000,000 shares are owned by the present stockholders.
what are three primary roles of the u.s. securities and exchange commission sec? how does the sarbanes-oxley act of
Determine the interest rate that would require a monthly total payment that is less than your current total payment. Also, refinancing costs you $2000 up-front in closing costs.
hamilton control systems will invest 90000 in a temporary project that will generate the following cash inflows for the
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