Questions
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...

Forecasting and Estimating Share Value Using the DCF Model
Following are the income statement and balance sheet for Intel Corporation.

INTEL CORPORATION
Consolidated Statements of Income
Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008
Net revenue $ 44,123 $ 35,127 $ 37,586
Cost of sales 15,132 15,566 16,742
Gross margin 28,991 19,561 20,844
Research and development 6,576 5,653 5,722
Marketing, general and administrative 6,309 7,931 5,452
Restructuring and asset impairment charges -- 231 710
Amortization of acquisition-related intangibles 18 35 6
Operating expenses 12,903 13,850 11,890
Operating income 16,088 5,711 8,954
Gains (losses) on equity method investments, net* 117 (147) (1,380)
Gains (losses) on other equity investments, net 231 (23) (376)
Interest and other, net 109 163 488
Income before taxes 16,545 5,704 7,686
Provisions for taxes 4,581 1,335 2,394
Net income $ 11,964 $ 4,369 $ 5,292

*This should be considered as operating income.

INTEL CORPORATION
Consolidated Balance Sheets
As of Year-Ended (In millions, except par value) Dec. 25, 2010 Dec. 26, 2009
Assets
Current assets
Cash and cash equivalents $ 5,498 $ 3,987
Short-term investments 11,294 5,285
Trading assets 5,093 4,648
Accounts receivables, net 2,867 2,273
Inventories 3,757 2,935
Deferred tax assets 1,488 1,216
Other current assets 1,614 813
Total current assets 31,611 21,157
Property, plant and equipment, net 17,899 17,225
Marketable equity securities 1,008 773
Other long-term investments** 3,026 4,179
Goodwill 4,531 4,421
Other long-term assets 5,111 5,340
Total assets $63,186 $53,095
Liabilities
Current liabilities
Short-term debt $38 $172
Accounts payable 2,190 1,883
Accrued compensation and benefits 2,888 2,448
Accrued advertising 1,007 773
Deferred income on shipments to distributors 622 593
Other accrued liabilities 2,482 1,722
Total current liabilities 9,227 7,591
Long-term income taxes payable 190 193
Long-term debt 1,677 2,049
Long-term deferred tax liabilities 926 555
Other long-term liabilities 1,236 1,003
Total liabilities 13,256 11,391
Stockholders' equity:
Preferred stock, $0.001 par value -- --
Common stock, $0.001 par value, 10,000 shares authorized; 5,581 issued and 5,511 outstanding and capital in excess of par value 16,178 14,993
Accumulated other comprehensive income (loss) 333 393
Retained earnings 33,419 26,318
Total stockholders' equity 49,930 41,704
Total liabilities and stockholders' equity $ 63,186 $ 53,095

** These investments are operating assets as they relate to associated companies.

(a) Compute Intel's net operating assets (NOA) for year-end 2010.
2010 NOA = $Answer



(b) Compute net operating profit after tax (NOPAT) for 2010, assuming a federal and state statutory tax rate of 37%.

HINT: Gains/losses on equity method investments are considered operating income. Round your answer to the nearest whole number.
2010 NOPAT = $Answer



(c) Forecast Intel's sales, NOPAT, and NOA for years 2011 through 2014 using the following assumptions:

Sales growth 10%
Net operating profit margin (NOPM) 26%
Net operating asset turnover (NOAT) at fiscal year-end 1.50

Forecast the terminal period value using the assumptions above and assuming a terminal period growth of: 1%.

INTC Reported Forecast Horizon Terminal
($ millions) 2010 2011 Est. 2012 Est. 2013 Est. 2014 Est. Period
Sales (rounded two decimal places) $Answer $Answer $Answer $Answer $Answer $Answer
Sales (rounded nearest whole number) Answer Answer Answer Answer Answer Answer
NOPAT (rounded nearest whole number)* Answer Answer Answer Answer Answer Answer
NOA (rounded nearest whole number)* Answer Answer Answer Answer Answer Answer

* Use sales rounded to nearest whole number for this calculation.


(d) Estimate the value of a share of Intel common stock using the discounted cash flow (DCF) model as of December 25, 2010; assume a discount rate (WACC) of 11%, common shares outstanding of 5,511 million, and net nonoperating obligations (NNO) of $(21,178) million (NNO is negative which means that Intel has net nonoperating investments).

Use your rounded answers for subsequent calculations.

Do not use negative signs with any of your answers below.

INTC Reported Forecast Horizon Terminal
($ millions) 2010 2011 Est. 2012 Est. 2013 Est. 2014 Est. Period
DCF Model
Increase in NOA Answer Answer Answer Answer Answer
FCFF (NOPAT - Increase in NOA) Answer Answer Answer Answer Answer
Discount factor

(rounded to 5

decimal places)

Answer Answer Answer Answer
Present value of horizon FCFF

(rounded to nearest

whole number)

Answer Answer Answer Answer
Cumulative present value of horizon FCFF $Answer (rounded to nearest
whole number)
Present value of terminal FCFF Answer (rounded to nearest
whole number)
Total firm value Answer (rounded to nearest
whole number)
NNO Answer
Firm equity value $Answer (rounded to nearest
whole number)
Shares outstanding (millions) Answer (rounded to nearest
whole number)
Stock price per share $Answer (rounded to two
decimal places)


(e) Intel (INTC) stock closed at $22.14 on February 18, 2011. How does your valuation estimate compare with this closing price?
What do you believe are some reasons for the difference? What investment decision is suggested from your results?
(Select all that apply)

Answeryesno

Our lower stock price estimate may be due to more pessimistic forecasts or a higher discount rate compared to other investors' and analysts model assumptions.
Answeryesno

Our stock price estimate is higher than the INTC market price as of February 18, 2011, indicating that we believe the stock is undervalued.
Answeryesno

Stock prices are a function of expected NOPAT and NOA, as well as the WACC discount rate.
Answeryesno

Our higher stock price estimate may be due to more optimistic forecasts or a lower discount rate compared to other investors' and analysts model assumptions.

In: Finance

THIS IS THE QUESTION I NEED ANSWERED, CALCULATIONS PROVIDED BELOW: From your analysis, summarize the major...

THIS IS THE QUESTION I NEED ANSWERED, CALCULATIONS PROVIDED BELOW:

From your analysis, summarize the major strenths and weaknesses comparing *scroll to the right to see 2010 analysis

    Summer's 2017 and 2016 performance. Summarize part 6 A through M.
Current Ratio 2011 2010
Current Assets / Current Liabilities 8.54 (478250/56000) 6.86 (329150/48000)
                                        Strengths and Weaknesses
Current Ratio is calculated by dividing the company's total current assets by the company's total current liabilities. This ratio is a widely used measure of a firm's ability to meet it's current obligations & to have funds available for use in daily operations.
A generally accepted rule of thumb is that the current ratio should be 2:1, indicating that a company should maintain twice the dollar amount of current assets as was needed to satisfy it's current liabilities.
2011's current ratio was better than 2010
PART 6 B. 2011 2010
Quick Ratio
Cash & cash equivalents + short term investments + Accts Recievable) / 3.15 (176200+238850)/56000 5.94 (253100+31850)/48000
Current Liabilities
                                        Strengths and Weaknesses
Quick ratio reveals the relationship between the company's Liquid Assets and it's Current Liabilities. It gives a more accurate picture of a company's ability to meet current obligations since the ratio ignores potentially illiquid inventory and prepaid expenses.
The higher the ratio, the the more financially secure a company is in the short term. 2010 has the better ratio
PART 6 C. 2011 2010
Rate of Return on Total Assets 0.026 (27100/1049800) 0.073 (70100/963700)
Net Income / Average Total Assets
                                        Strengths and Weaknesses
The rate of return on total assets reveals the rate of profit earned per dollar of assets under a firm's control.
Both 2011 and 2010 have poor ratios, but 2010 is slightly better.
PART 6 D.
Rate of Return on Common Stockholder's Equity 2011 2010
(Net Income - Preferred Stock Dividends) / Average common stockholders equity
                                        Strengths and Weaknesses
The return on common stockholder's equity measures the profitability of the ownership interest held by a company's common stockholders. The ratio shows the percentage of income available to common stockholders- that is, net income less any preferred stock dividends - for each dollar of common stockholder equity invested in a business.
PART 6 E. 2011 2010
Earnings Per Share
(net income-preferred dividends) / outstanding common shares (27100-0) /
                                        Strengths and Weaknesses
PART 6 F. 2011 2010
Accounts Receivable Turnover
Net Sales / Average Accts Recievable (Net) 1.92 (260000/135350) 10.5 (521000/49600)
                                        Strengths and Weaknesses
The Accounts Recievable Turnover measures the ability to collect cash from customers. A higher turnover indicates that the company is converting their recievables at a faster rate.
2010 is much higher than 2011.
2011 2010
Average Collection Period 190.01 (365/1.921) 34.76 (365/10.50)
365 / Accts Recievable Turnover (Net)
                                        Strengths and Weaknesses
The average collection period indicates how many days remain in accounts receivable. The lower the # of days, the quicker you are converting the recievables into cash. 2010 had the better average collection period.

In: Accounting

1. In thinking about intercultural communication and diversity in the business environment, what, areas of concern...

1. In thinking about intercultural communication and diversity in the business environment, what, areas of concern do you see with the organization’s process for the business meeting with Mr. Takahashi?

2. Based on the interoffice discussions and interactions between the advertising firm staff and the discussions between the staff and Mr. Takaashi, where do you see the 5 dimensions of culture coming into play? Identify at least 5 examples of those features you observed in the interactions and discuss how they create conflict, misunderstandings, or other situations if any.

All of the questions are Based on this video

https://www.youtube.com/watch?v=jQbXao0mQ1M

3.      Identify and discuss the nonverbal communication at play within the business meeting and office culture before, during and after they met with the prospective client.

The answers need to be answered by 03/14/2020

also, they need to be 350 words long. this is an essay question. All of them are

In: Psychology

What yearly cash flows are relevant for this investment decision? Do not forget the effect of...

  1. What yearly cash flows are relevant for this investment decision? Do not forget the effect of taxes and the initial investment amount. Complete the table below using the detail summarized below:
    1. Investment :Initial Investment - $16M 2016, $2M 2017/Working Capital - 10% of Incremental Sales
    2. Operating Savings - $2M 2017, $3.5M 2018-2022
    3. Sales Revenue - $4M 20017, $10M 2018-2022
    4. Expenses - CGS – 75% of Revenue, SG&A - 5% of Revenue
    5. Salvage:Working Capital - recoverable at cost/Initial Investment - 10% or $1.8M before tax, $1.08M after taxes
    6. Depreciation – Straight Line over 6 years, no salvage, start in 2017

2016

2017

2018

2019

2020

2021

2022

Investment:

Capital Outlay

Net Working Capital (10% Sales)

Total Investment

Investment Recovery :

    Equipment Salvage

    Net Working Capital (full recovery)

Earnings before Interest and Taxes (EBIT):

Sales Revenue

Cost of Goods Sold (75% Sales)

SG&A (5% Sales)

Operating Savings

Depreciation ($18,000/6)

Total Costs & Expenses

   EBIT

- Taxes (40%)

   NOPAT

+ Depreciation

- Investment

= Free Cash Flow

    In: Finance

    A divided multilane highway in a recreational area (fp=0.90) has four lanes (two lanes in each...

    A divided multilane highway in a recreational area (fp=0.90) has four lanes (two lanes in each direction) and is on a rolling terrain. The highway has 3 m lanes with a 1.8 m right-side shoulder and a 0.9 m left-side shoulder. The posted speed limit is 80 km/h. Formerly there were 3 access points per km, but recent development has increased the number of access points to 9 access points per km. Before development, the peak-hour factor was 0.90 and the directional hourly volume was 2400 vehicles with 8% large trucks and buses and 5% recreational vehicles. After the development, the peak-hour directional flow is 2800 vehicles with the same vehicle percentages and PHF. What is the level of service before and after the development?

    -For the before condition, the free-flow speed is:

    -For the before condition, the analysis flow rate is:

    -For the before condition, the LOS is:

    -For the after condition, the free-flow speed is:

    -for the after condition, the analysis flow rate is:

    -For the after condition, the LOS is:

    In: Civil Engineering

    Ginny is an accountant by trade, she paid $1,000 each year to join as CPA member....

    Ginny is an accountant by trade, she paid $1,000 each year to join as CPA
    member. She also has a knack for programming; hence she also joins the
    Computer Associates membership for $500 per year as she planned to find a new
    career as a programmer. Discuss her eligibility whether she can deduct both
    membership fees from her assessable income!

    Book: Taxation law

    In: Accounting

    Use-Case Discussion 1) In what situations would the additional effort to develop use-case definitions be superior...

    Use-Case Discussion

    1) In what situations would the additional effort to develop use-case definitions be superior to only having functional requirements? How would the programmer/analyst benefit from the use-case approach over just having functional requirements only? How would the project manager potentially benefit?

    2) Should use-case be used in all projects? Discuss why or why not?

    In: Computer Science

    Aida Jebat was hired as a clerk with Syarikat Manisan Sdn BHD on 1 July 2010...

    Aida Jebat was hired as a clerk with Syarikat Manisan Sdn BHD on 1 July 2010 with a salary of RM1,200 per month. She was placed on six-month probation. On 1 October she informs the company that she is going on maternity leave. Her expected date of confinement is 1 December 2010, and she intends to commence her maternity leave on 1 November 2010. On 29 November 2010, she died from childbirth complications. The child was survived.

    1. Is the company obliged to pay any maternity allowance? Explain your answer by relates to related act.

    1. If yes, to whom, how many days and how much must the company pay?

    In: Finance

    PROJECT 3 INSTRUCTIONS Based on Brase & Brase: sections 6.1-6.3 Visit the NASDAQ historical prices weblink....

    PROJECT 3 INSTRUCTIONS Based on Brase & Brase: sections 6.1-6.3 Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on January 13, 2019, then use January 13, 2019 – January 12, 2020. (Do NOT use these dates. Use the dates that match up with the current term.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. NOTE I’M TO USE THESE DATES: JAN 13, 2019 – JAN 12, 2020. PLEASE USE THESE DATES TO HELP ME ANSWER QUESTIONS # 5 – 7 This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points. Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit. 1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions. b) What the mean and Standard Deviation (SD) of the Close column in your data set? c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points) 2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $1150? (5 points) 3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year? (between 50 below and 50 above the mean) (5 points) 4. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $950 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations (5 points)

    5. At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations. (5 points)

    6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution. (5 points)

    7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number. (5 points) There are also 5 points for miscellaneous items like correct date range, correct mean, correct SD, etc. Project 3 is due by 11:59 p.m. (ET) on Monday of Module/Week 5.

    In: Statistics and Probability

    PROJECT 3 INSTRUCTIONS Based on Brase & Brase: sections 6.1-6.3 Visit the NASDAQ historical prices weblink....

    PROJECT 3 INSTRUCTIONS Based on Brase & Brase: sections 6.1-6.3 Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on January 13, 2019, then use January 13, 2019 – January 12, 2020. (Do NOT use these dates. Use the dates that match up with the current term.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. NOTE I'M TO USE THESE DATES JAN. 13, 2019- JAN 12, 2020. PLEASE USE THESE DATES TO HELP ME ANSWER THESE QUESTIONS. I'M HAVING A DIFFICULT TIME!! This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points. Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit. 1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions. b) What the mean and Standard Deviation (SD) of the Close column in your data set? c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points) 2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $1150? (5 points) 3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year? (between 50 below and 50 above the mean) (5 points) 4. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $950 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations (5 points) 5. At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations. (5 points) 6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution. (5 points) 7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number. (5 points) There are also 5 points for miscellaneous items like correct date range, correct mean, correct SD, etc. Project 3 is due by 11:59 p.m. (ET) on Monday of Module/Week 5.

    In: Statistics and Probability