Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Case study

23/01/2021 Client: haris6422W Deadline: 6 Hours

You have just been hired by Intel in its finance division. Your first assignment is to determine

the net cash flows and NPV of a proposed new generation of mobile chips.

Capital expenditures to produce the new chips will initially require an investment of

$1.2 billion. The R&D that will be required to finish the chips is $500 million this year.

Any ongoing R&D for upgrades will be covered in the margin calculation in 2a below.

The product family is expected to have a life of five years. First-year revenues for the new

chip are expected to be $2,000,000,000 ($2,000 million). The chip family’s revenues are

expected to grow by 20% for the second year, and then decrease by 10% for the third,

decrease by 20% for the 4th and finally decrease by 50% for the 5th (final) year of sales.

Your job is to determine the rest of the cash flows associated with this project. Your boss

has indicated that the operating costs and net working capital requirements are similar

to the rest of the company’s products. Since your boss hasn’t been much help, here are

some tips to guide your analysis:

1. Obtain Intel’s financial statements. Download the annual income statements and

balance sheets for the last four fiscal years from Wall Street Journal Website

(https://www.wsj.com/market-data/quotes/INTC/financials/annual/incomestatement).

Go to “Financials.” Click “Annual,” to ensure you’re getting

annual, instead of quarterly, data. Next, copy and paste the income statements

and balance sheets into Excel.

2. You are now ready to determine the free cash flow. Compute the free cash flow for

each year using Eq. 9.6 from this chapter showing all steps :

Free Cash Flow =

$++++++++++%++++++++++& Unlevered Net Income

(Revenues - Costs - Depreciation) * (1 - Tax Rate)

+ Depreciation - CapEx - Change in NWC

CASE STUDY

Set up the timeline and computation of the free cash flow in separate, contiguous

columns for each year of the project life. Be sure to make outflows negative and

inflows positive.

a. Assume that the project’s profitability will be similar to Intel’s existing projects

in 2015 and estimate costs each year by using the 2015 ratio of non-depreciation

costs to revenue:

[(Cost of Revenue + SG&A + R&D)/ Total Revenue]

You should assume that this ratio will hold for this project as well. You do not need

to break out the individual components of operating costs in your forecast. Simply

forecast the total of Cost of Revenue + SG&A + R&D for each year.

b. Determine the annual depreciation by assuming Intel depreciates these assets by

the straight-line method over a 5-year life.

c. Determine Intel’s tax rate as [1 - (Income After Tax/Income Before Tax)] in 2015.

Note that on Intel’s income statement on Google Finance, there is a difference

between operating income and income before tax. That difference is due to small

adjustments. Ignore this issue and simply focus on the Income Before Tax line.

d. Calculate the net working capital required each year by assuming that the level

of NWC will be a constant percentage of the project’s sales. Use Intel’s 2015

NWC/Sales to estimate the required percentage. (Use only accounts receivable,

accounts payable, and inventory to measure working capital. Other components of

current assets and liabilities are harder to interpret and are not necessarily reflective

of the project’s required NWC—e.g., Intel’s cash holdings.)

e. To determine the free cash flow, calculate the additional capital investment and

the change in net working capital each year.

3. Determine the IRR of the project and the NPV of the project at a cost of capital

of 12% using the Excel functions. For the calculation of NPV, include

cash flows 1 through 5 in the NPV function and then subtract the initial cost

(i.e., = NPV1rate, CF1 CF5 2 + CF0 2. For IRR, include cash flows 0 through 5 in

the cash flow range

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Homework Guru
Best Coursework Help
Helping Hand
Top Essay Tutor
Quick Mentor
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$162 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$162 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$160 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$160 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$165 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$155 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

What are some ethical issues in the corrections - Nsw centre for effective reading - How does risk response impact change control management and vulnerability management? - Cs 149 sjsu - Assignment - Osim massage chair hong kong price - Need Research paper in APA format of 600 words with citations and references. Will need at least three journal references and the textbook - Geelong family day care - Of mice and men racism quotes - Recommend an Ethics Plan for Your Organization - Small engine parts identification test - Wireless Security & Forensics - Amoeba sisters sex linked traits answers - Cousin kate poem text - The breakfast club letter to principal - Light organic solvent preservative - Two fundamental qualities of useful accounting information - Solubility curve graph maker - P7#2 - Two ways to live - Sheffield hallam disabled student support - Commercial research firms like ac nielsen and - HIV/AIDS Specialty Care for Pregnant women - List and describe four vulnerability intelligence sources - Disney parks and resorts strategy - Mcgonigle nursing informatics and the foundation of knowledge - Web technologies a computer science perspective - Cisco finesse not ready reason codes - Final Disc 4 - I ask my mother to sing analysis - Volumetric analysis of vinegar lab report - "A" WORK PLAGIARISM FREE IN 15 HOURS - Cafs hsc past papers - Is copper pipe a pure substance - Eastern and western perspective of positive psychology - Disadvantages of system analysis and design - System of equations to matrix calculator - PSYC Life Span Development Psychology - Graph the line whose is and whose is - Department supervisor job description - As level grade boundaries - Disadvantages of peer to peer network - Assignment - Unethical behavior in physical therapy - Paper on psychological bio psychology disorder (PTSD) - 109/8 pottery court brunswick - Power of attorney vietnam - Against school john taylor gatto thesis - The trial of tempel anneke notes - Ucl office 365 login - 1s22s22p63s23p64s23d7 - Principles of flight quiz - Conduct a value chain analysis of the walt disney co - Belle of belfast city remix - Financial Management Assignment. - Ceres gardening company funding growth in organic products case solution - Arbonne vanilla protein balls recipe - Tando stone bucks county gray - Canadian spelling of neighbor - Domestic containment - BuzzFeed Case Study Analysis & Application - The alamo drafthouse case study - Unit 3 IP - Negative vetting level 2 - Having valuable but common resources capabilities leads to - Torque on a dipole in a nonuniform electric field - Managing differences the central challenge of global strategy pdf - Automation anywhere certification questions - 20 Pages - American cinema american culture 5th edition chapter summaries - Citrix connector for sccm - Writing assignment thank you note for nursing field - Aglc 4 quick guide - Week 5 Assignment - Writing - Space exploration through social science lens - Shaver manufacturing inc offers dental insurance - When preparing printed materials and visuals, a salesperson should: - Project - Investment valuation damodaran solutions - 380 ft lbs to nm - Literature class discussion --- due in 12 hours - Teacher registration board sa - The Grant Era and the New South Discussion - What is the meaning of the song eleanor rigby - Triple aim of health reform - Qnt 561 week 6 signature assignment consumer food - Aseptic technique lab report answers - Apply training needs assessment exercise hrm 300 - Parabolic figures in real life - International Finance - Bus.com 2 - Florida southwestern state college online courses - Skye waulking song gcse - Stat - South valley bank cave junction - Certificate iv in security operations - Rate of turn formula for ships - Cognitive behavioral therapy test questions - A sickeningly sweet baby boy case study answers