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

  The salazar corporation manufactures only one product - a

the salazar corporation manufactures only one product - a medium-size high-quality paper shredder called the ms-100. in

  Thomasson air uses two measures of activity flights and

thomasson air uses two measures of activity flights and passengers in the cost formulas in its budgets and performance

  Prepare journal entries as of november 1 20x1 to close the

the trial balance below was taken from the records of r. martin executor for the estate of j. mitchell on october 31

  If a company is determining the present value of the

if a company is determining the present value of the minimum lease payments under a lease what interest rate should be

  A company has two products a amp b it uses activity based

a company has two products a amp b. it uses activity based costing and has prepared the following analysis showing

  Holly inherited 10000 of city of atlanta bonds in february

holly inherited 10000 of city of atlanta bonds in february. in march she received interest of 500 and in april she sold

  Finlon upholstery inc uses a job-order costing system to

finlon upholstery inc. uses a job-order costing system to accumulate manufacturing costs. the companys work-in-process

  Beonce company received proceeds of 188500 on 10-year 8

beonce company received proceeds of 188500 on 10-year 8 bonds issued on january 1 2011. the bonds had a face value of

  Reported for pension expense

Hathaway, Inc. sponsors a defined-benefit pension plan. The following data relates to the plan for 2013: Contributions to the plan, $450,000; Service cost, $500,000;

  Roester inc set its cost per a unit at 120 its markup

roester inc. set its cost per a unit at 120. its markup percentage is 50 percent. what is roesters selling price? what

  If ohare developed a cash flow statement for 2012 using the

ohare companys only asset as of january 1 2012 was a limousine. during 2012 only the following three transactions

  Depreciation expenses are expected to be 0.5%of sales

Depreciation expenses are expected to be 0.5%of 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