Current income statement using the same format

Reference no: EM13818423

You manufacture hunting pack systems in China for 80 dollars each, including shipping. The manufacturing costs only include variable costs. Variable costs are not calculated as a percentage of sales in this case. Sales are a function of the number of packs sold and the price per pack. Likewise, variable costs are a function of the number of packs sold and the cost to produce each pack. You sell these packs to retailers for 200 dollars each. In the current year you will sell 100,000 packs. Your fixed costs including such items as insurance, marketing, travel, shows, office supplies, warehouse rentals etc. totals 5 million dollars this year and are not part of the 80 dollars per pack manufacturing cost. The federal income tax rate for your company is 40 percent.

Your company is publicly traded on the NASDAQ with 1,000,000 shares outstanding.

a. Please create a current income statement using the same format as found in the lecture.

b. Please calculate earnings per share.

c. Please calculate the price/earnings multiple assuming that the current stock price is 10 dollars per share

2. Create a two-year forecast of the income statement from the information provided in problem number one. Please create three columns of data: current year, year 2, and year 3. Assume that sales increase ten percent per year for year's two and three. Please show the earnings per share for each of the three years.

3. Please estimate the stock price for year's two and three, assuming that the current PE multiple remains constant for each of the two forecasted years.

Please do this assignment in an excel spreadsheet.

Reference no: EM13818423

Questions Cloud

What characteristics distinguish an outstanding consultant : What three characteristics do you think distinguish an outstanding consultant from a less effective one. Describe these briefly. Reflect on and describe how strong you are and how you can increase your abilities in these areas.

What is the country trade policy : What is the country's trade policy and why have they established it? What industries or who benefits from these policies

Evaluate the impact of the fed policy : You work for a large domestic corporation as a Financial Analyst. You have been asked to evaluate the impact of the Fed's policy and make recommendations about how the firm's stock portfolio should be managed given the new policies

Describe how property presented on the balance sheet : Describe how the property, plant, and equipment of Target Inc (target.com) is presented on the Balance Sheet. Find the note that follows the financial statements relating to depreciation and state in your own words the method of depreciation that ..

Current income statement using the same format : Your company is publicly traded on the NASDAQ with 1,000,000 shares outstanding. Please create a current income statement using the same format as found in the lecture.

Describe the role of interpersonal communication : Describe the role of interpersonal communication both as a manager and as an employee. What specific techniques have you used to overcome barriers to communication?

Describe both the push and pull promotion strategies : Describe both the push and pull promotion strategies. Research two companies that are making successful use of both promotion mix strategies (larger companies typically use both)

Difference betweenf the policewoman and the policewoman : difference between the identity of the policewoman and the policewoman

Explain the basic steps in the planning process : Explain the basic steps in the planning process. Describe the steps in the decision-making process and predict how the personal attributes of the manager influence decision making.

User Account

All Pages