Finish the two cash flow analyses

Assignment Help Accounting Basics
Reference no: EM131323707

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

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: EM131323707

Questions Cloud

Analyze essential step that shimon kornfeld could have taken : BUS 518- Outline the essential steps that Shimon Kornfeld could have taken in order to ensure that all team members learned of any proposed changes. Provide the rationale and justification for each step outlined.
How do these interactions compare to those of nurse managers : Reflect upon the role HR has played in your current organization or one with which you are familiar. What interactions have you noticed between HR professionals and other staff in this setting? How do these interactions compare to those of nurse m..
Calculate the change in internal energy : Calculate the change in internal energy(delta E) for a system that is giving off 25.0kJ of heat and is changing from 6.00L to 12.00L in volume at 1.50atm pressure. (101.3J=1 L*atm)
Role of evaluating human capital in recent years : Maintaining a competitive workforce is very challenging in today's economy. The role of evaluating human capital, in recent years, has:
Finish the two cash flow analyses : Finish the two cash flow analyses through year 2025 on the basis of the Status Quo and from Investing in the Paywalls Model.
Temperature of the calorimeter : When .0430 mole of titanium is combusted in a bomb calorimeter, the temperature of the calorimeter increases from 30.00degress Celsius to 91.60 degrees Celsius. In a separate experiment, the heat capacity of the calorimeter is measured to be 9.84k..
What production function is used : What production function is used? What is the cost function? What can you conclude about shipping costs if it is less expensive to produce baseballs in Costa Rica than in Georgia?
Koh solution for complete neutralization : A 0.6745 gram sample of KHP reacts with 41.75 mL of KOH solution for complete neutralization. What is the molarity of the KOH solution? (Molecular weight of KHP = 204 g/mol. KHP has one acidic hydrogen.)
Is this firm producing at minimum cost : Is this firm producing at minimum cost? If it is minimizing cost, explain why. If it is not minimizing cost, explain how the firm should change the ratio of inputs it uses to lower its cost.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Cost of transporting the goods

Duke Associates, antique dealers, purchased the contents of an estate for $38,400. Terms of the purchase were FOB shipping point, and the cost of transporting the goods to Duke Associates' warehouse was $1,650.

  Is sleepy hollow projecting a budgetary surplus

Is Sleepy Hollow projecting a budgetary surplus or a deficit for 2013? Prepare the journal entry to record the 2013 budget.

  Calculate the companys cm ratio and its break-even point in

memofax inc. produces memory enhancement kits for fax machines. sales have been very erratic with some months showing

  Discuss the strengths and weaknesses of each theory

Briefly describe each theory, including its history, foundation, model, and application and discuss the strengths and weaknesses of each theory.

  On january 1 2010 fishbone corporation sold a building that

aon january 1 2010 fishbone corporation sold a building that cost 250000 and that had accumulated depreciation of

  Determine the z-score

Employees in a large manufacturing plant worked an average of 62.0 hours of overtime last year, with a standard deviation of 15.0 hours. For a simple random sample of n 5 36 employees and x 5 the number of overtime hours worked last year, determin..

  Net assets of the acquired company

Net assets of the acquired company are revalued to their fair value and any excess of consideration transferred over fair value of net assets is allocated to goodwill.

  The beginning work in process had materialscost of 2040 and

the ledger of molindo company has the following work in processaccount.work in

  Company''s current performance

This assessment will require you to conduct financial statement analysis based on your financial ratio calculations as well as your observation about the company executives' ethical behaviour and the level of quality of the corporate social responsib..

  Presented below are three transactions

Presented below are three transactions. Mark each transaction as affecting owner's investment (I), owner's drawings (D), revenue (R), expense (E), or not affecting owner's equity (NOE).

  Significant accounting processing

Briefly describe three strategies for testing internal controls when information technology is used for significant accounting processing.

  On january 20 2014 steffi graf inc sold security a for

at december 31 2013 the available-for-sale equity portfolio for steffi graf inc. is as follows.securitycostfair

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