What do you get as the npv for the status quo scenario

Assignment Help Financial Accounting
Reference no: EM131347294

Springfield PuBLISHING

SETTING THE STAGE - BACKGROUND:

The newspaper industry and Springfield Publishing

Newspaper publishing is a classic example of an industry that evolved within a changing set of economic conditions. Many say the demise of the daily paper is just a matter of time - and not much time at that. Circulation is dropping, display and classified ad revenue is drying up, and the industry in recent years has experienced an unprecedented wave of layoffs. The future of journalism is in the digital world of websites and apps, not newsprint, some say.

The financial ratios below paint a bleak picture of Springfield's financial health. It is apparent that Springfield has been facing the same economic pressures as its competitors: declining margins and sales. Sales increased substantially in 2013, but quickly fell below 2012 levels. Assets have been shrinking as Springfield closed down publishing facilities and reduced new investments in order to conserve cash. But the fact that asset turnover has declined, indicates that Springfield has not contracted assets as fast as the decline in sales.

Financial Ratios (2012-2015)

 

2012

2013

2014

2015

Sales growth


-6.6%

-20.4%

-19.4%

Gross Profit/sales

57.8%

57.3%

56.6%

56.0%

Selling, gen. & admin. exp./sales

45.9%

46.2%

46.4%

47.0%

Net Oper. Profit After Tax/sales

5.89%

5.34%

5.17%

4.56%

Asset turnover

1.37

1.39

1.28

1.08

Indeed it can be said that newspapers are facing tough times, and yes, the Internet can offer many things that papers cannot. Even so, the death of newspapers has been predicted by many for decades. Radio, TV and now the Internet were all supposed to kill them off, but they are still here. Those who claim that the future of news is online and only online ignore one critical point: online ad revenue alone just is not enough to support most news companies. So for online news sites to survive, they'll need a different business model.

Paywalls, a system that prevents Internet users from accessing webpage content without a paid subscription, is one such model. There are two types of paywalls. Hard" paywalls allow minimal to no access to content without subscription, while "soft" paywalls allow more flexibility in what users can view without subscribing, such as selective free content and/or a limited number of articles per month, or the sampling of several pages of a book or paragraphs of an article.

Newspapers can implement paywalls on their websites to increase their revenue, which has been diminishing due to a decline in print subscriptions and advertising revenue. A recent PewResearchCenter study found that the success of paywalls, combined with print subscription and single-copy price increases, has led to a stabilization or in some cases even an increase in revenues from circulation, which means papers do not have to rely as much as they once did on advertising revenue. In order to make the "paywalls model" successful, however, investment in content creation and commerce development is necessary.

Content creation and commerce development expenses, including but not restricted to advertising, will be the norm for the modern news company. Typical forms of content creation include maintaining and updating one's web site, blogs, photography, videography, online commentary, the maintenance of social media accounts, and editing and distribution of digital media. Commerce development includes ecommerce costs associated with web design and functionality as well as running costs.

The question, then as we look at this case, is whether the added content creation & commerce development expense will be worthwhile. Otherwise said, will it allow for Springfield to produce sufficient cash flows to add value to the company?

rEACHING A DECISION USING CAPITAL BUDGETING:

Create two sets of cash flows: one for the status quo and one for pursuing growth via "the paywalls" model. I have started this for you by identifying all relevant cash flows, setting up the comparative spreadsheets and filling in some of the information. (See Springfield Cash Flow Spreadsheets.xls)

Assume a Cost of Capital of 10% as representative of the weighted average of cost of outstanding debt and common equity that exists within Springfield's capital structure.

Status quo cash flows

See below for the base-case cash flows for the status quo: assuming that Springfield continues to operate "as is". What follows are the explanations of each of the line items:

Net sales: 2015 sales were $26.6 million, down 19.4% from the previous year. Subsequent years' sales forecasts continue to fall at the same rate as 2015.

Gross Profit: Newspaper production costs in 2015 represented 44% of sales. Assumptions include a 100 basis point reduction in margins annually (i.e. Year 1 production costs are 45%).

Selling and general administrative expenses: Estimated to grow 50 basis points annually. SG&A expense stood at 47% of sales in 2015.

Depreciation: Depreciation is computed using the straight-line method for the book value of existing investments and a remaining depreciable life of years. So while the cash flow analysis subtracts depreciation before NOPAT, so as to arrive at taxes, it adds it back after the fact since it's a non-cash item.

Taxes: Assume a tax rate of 36% for your analysis. (Springfield has not been paying taxes, owing to its consistent string of losses. The effective marginal tax rate is difficult to estimate accurately. Carryforward and carryback provisions in the tax code could eliminate any actual cash taxes for Springfield for many years to come. Thus, the true tax rate on a present-value basis lies somewhere between the nominal rate of 36% and zero.)

Paywalls Model

Net sales: Year 1 sales forecasts reflect a gradual stabilization in revenues. Annual decline is scaled back 300 basis points (Year 0 was down 19.4%, but Year 1 assumed only down 16.4%, etc.). Sales growth turns positive in 2022.

Gross Profit: Newspaper production costs in 2015 represented 44% of sales. With online business growth efforts, assumptions include a 125 basis point improvement in margins annually through year 5 (i.e. 2015 GPM of 56% improves to 57.25% in Year 1) AND THEN FURTHER IMPROVEMENT to reflect a 175 basis point rise annually year 6 through 10.

Selling and general administrative expenses: Expenses related to new digital content and running an improved ecommerce site means this expense category will grow. Estimated growth is 150 basis points annually. (2015 SG&A expense at 47% of sales increases to 48.5% in Year 1).

Net initial investment (one-time):

This represents the initial cash outlay resulting from recruiting new talent, training and the upfront costs associated with web design and other content creation. In total, $4 million is projected. A portion of this cost, $1 million, will serve to update existing facilities/infrastructure. Depreciation was computed using the straight-line method. The value is assumed to be depreciable over a life of 10 years, making for an added annual depreciation expense of $100,000.

CASE III QUESTIONS-

Finish the two cash flow analyses through year 2025 on the basis of the Status Quo and from Investing in the Paywalls Model. Use the template provided - fill in all highlighted area & submit via Moodle Dropbox.

In a one page memo answer the following two questions:

Using a 10% weighted average cost of capital and assuming a 36% tax rate, what do you get as the Net Present Value (NPV) for the status quo scenario? NPV for the proposed "Paywalls Model" project? Show or tell me as to how you arrived at your answer.

Stepping away from the numbers, do you believe that Springfield can survive long enough to realize a positive NPV? Provide not only your opinion but also support it with at least two reasons/arguments for or against the company's ability to sustain for this indeterminate period.

Reference no: EM131347294

Questions Cloud

End of each year after retirement at each retirement age : Your client is 34 years old; and she wants to begin saving for retirement, with the first payment to come one year from now. She can save $15,000 per year; and you advise her to invest it in the stock market, which you expect to provide an average re..
Describe the quantity theory of money defining each variable : Describe the quantity theory of money, defining each variable. Explain how changes in the money supply can affect real GDP and the price level. Under what circumstances could an increase in the money supply have no effect on nominal GDP?
What is the total rate of return on each bond : Currently, the term structure is as follows: 1-year zero-coupon bonds yield 7%, 2-year bonds yield 8%, 3-year bonds and longer-maturity bonds all yield 9%. You are choosing between 1-, 2-, and 3-year maturity bonds all paying annual coupons of 8%. Wh..
Briefly describe these tools : If the reserve requirement is changed to 5 percent, how much can First Bank lend, and how much can the money supply be expanded?
What do you get as the npv for the status quo scenario : Using a 10% weighted average cost of capital and assuming a 36% tax rate, what do you get as the Net Present Value (NPV) for the status quo scenario? NPV for the proposed "Paywalls Model" project?
What is your estimate of expected return for these? bonds : In? mid-2012, Ralston Purina had? AA-rated, 10-year bonds outstanding with a yield to maturity of 1.96%. What is the highest expected return these bonds could? have? At the? time, similar maturity Treasuries had a yield of 0.96%. If you believe Ralst..
Determine the new importance scores for present worth : New Tech management reviewed the model developed to assess the best approach for the marketing/R&D problem. (See text problem 19.17 which was assigned as a practice problem.) They have decided that the "high" value for Choice A should be 14. Determin..
Why is operating leverage different at two levels of sales : What is the accounting break-even level of sales if the firm pays no taxes? (Do not round intermediate calculations.  Why is operating leverage different at these two levels of sales?
Why do you demand money : Suppose the Fed has a target range for the yen-dollar exchange rate. How would it keep the exchange rate within the target range if free market forces push the exchange rate out of the range? Use a graph to help explain your answer.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Overtime budget for the production department

Last month’s overtime budget for the Production Department of Edna's Earrings Inc. was 1,000 hours and $10,000.The actual overtime was 600 hours and $7,500.Develop a variance report for the department showing the flexible budget variance, the volume ..

  Prepare closing entries and post

Prepare annual adjusting entries and post to the ledger accounts and Prepare closing entries and post

  Calculate property-plant and equipment turnover

The 2015 Financial Statements of Dell Company include the following footnote: Calculate Property, Plant, and Equipment Turnover for 2016. Estimate the Useful Life on average for the depreciable assets at the end of 2016.

  Question 1 sully corp presently has an eps of 240 and the

question 1. sully corp. presently has an eps of 2.40 and the benchmark pe for the company is 23. earnings are expected

  At the beginning of 20x2 dahl ltd acquired 8 of the

at the beginning of 20x2 dahl ltd. acquired 8 of the outstanding common shares of tippy ltd. for 400000.nbsp this

  Average cost procedure for both materials and conversion

ABC Company has a three-stage production cycle. The following data are available for the cutting department for November: Materials are added at the beginning of the process in the cutting department. What are the equivalent units under the average c..

  The pros and cons of drawing up partnership agreement

Imagine that one of your colleagues has offered you the opportunity to become a partner in a new business venture. The colleague stipulates that due to your past relationship, there is no reason to draw up a partnership agreement. Discuss the pros an..

  Document sufficient to verify his employment eligibility

Quinn, a member of the Menominee Indian nation, is a new employee at Raven Enterprises. During the process of completing his I-9, his only means of identity is a Menominee Nation identification document. Is this document sufficient to verify his empl..

  What are the variable costs per unit

The variable costs per unit are $6 when a company produces 12,000 units of product. What are the variable costs per unit when 14,000 units are produced?

  Prepare journal entry that should be recorded as of december

For each of the situations above, prepare the journal entry that should be recorded as of December 31, 2014, or explain why an entry should not be recorded. Show supporting computations in good form.

  Financial information for sheets

Based on the following selected financial information for Sheets Clinicworks, calculate net income for 2003. 2002 2003 Dividends paid $400 $700 Accts. payable/accr. 300 500 Long-term debt 2,300 2,000 Common stock 2,200 3,000 Retained earnings 6,150 6..

  Compute its margin of safety in dollars

Zhao Co. has fixed costs of $354,000. Its single product sells for $175 per unit, and variable costs are $116 per unit. If the company expects sales of 10,000 units, compute its margin of safety in dollars and as a percent of expected sales.

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