Predict eps of all scenarios including last years eps

Assignment Help Financial Accounting

Reference no: EM131754585

Assignment: Apple Inc.

Monday Apple announced a new 4-inch-display iPhone, called the SE, aimed at consumers whose small hands, tight pockets or thin pocketbooks couldn't handle the big-screened iPhones unveiled last year. IPhone SE starts at $399, making it the most affordable iPhone ever by $150. Product managers project to sell 3.5M IPhone SE in 2017.

IBMLast week, IBM signed a partnership agreement with Facebook which is projected to increase 1% of revenues with flat SG&A

General Electric

Today, GE announced that its revenue will decline in 2017 by about 7%. All other margin % remains the same as current revenues.

Walmart

Walmart is projecting to increase revenue by 5%, decreasing COGS by 1%, and decreasing other expenses by 2% in 2017

Alcoa

Alcoa's steel market share decline by 11% which is projecting to decline revenues in 2017 by 6% and 10% decline in 2018

Boeing

Boeing won the defense contract and is projecting to increase revenue by 10%. Also declared to increase dividend payout by 20%.

Deere & Co.

Depreciation expense is much higher as a percent of sales at Deere. This might be an indication that they are more conservative in their depreciation policy. Deere is changing its depreciation method from Double Declining to Straight Line which will reduce depreciation expense in 2017 by 42%.

MasterCard Inc.

MasterCard announced double rebate and cash back programs to its customer in 2017 which will result in reducing the GM by 9%, everything remains the same.

Oracle Corporation

Oracle increased its customers base in their cloud computing space. This increase in customers is projected to increase 3% of revenue with the COGS remaining the same.

Visa Inc.

Visa Inc., is projecting to increase marketing expenses by 22% in 2017 to be in par with its competitors.

Requirement

• Get last year's Income Statement and Balance Sheet data for your company

• Download to Excel with all necessary computations and formulas

• Follow subsequent event for your company

• Build three scenario model for Net Revenues using Excel:

o Projection Level - As mentioned in the subsequent event
o Below Projection level - Only 50% of what was projected will happen
o Above Projection level - Above 25% of what was projected will happen

• Research and find number of authorized shares of your company

• Predict and report EPS of all scenarios including last year's EPS using Excel functions and charts

• Prepare one slide in PowerPoint to comment on the results with some visuals.

Reference no: EM131754585

Questions Cloud

What is the lowest setting in ounces for the filling machine : What is the lowest setting in ounces for the filling machine that will provide capability in terms of the six-bar box?

How firm market value and book value per share differ : Superior Medical System's 2005 balance sheet showed total common equity of $2,500,000. By how much did the firm's market value and book value per share differ

Determine the sampling methods cpas employ : determine the sampling methods CPAs employ when testing controls and balances of the payroll and personnel cycles

Difference between internal and external target audiences : What is the difference between internal and external target audiences? Desired outcomes or actions for each audience.

Predict eps of all scenarios including last years eps : Prepare one slide in PowerPoint to comment on results with some visuals. Predict EPS of all scenarios including last year's EPS using Excel functions and chart.

Estimate that the equipment will have a scrap value : The company you work for is considering acquiring several of the latest generation desktop computers for use in an office.

Units must be started to allow for loss due to scrap : If the desired daily output is 456 units, how many units must be started to allow for loss due to scrap?

What is the target net income : A company requires $1,020,000 in sales to meet its net income target. What is the target net income

District attorneys receive regarding hate crimes : What types of training do assistant district attorneys receive regarding hate crimes?

User Account

All Pages