Get help from the best in academic writing.

Excel and report

Excel and report.

Set up the timeline and computation of the free cash flow in five columns. (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. Determine the IRR of the project and the NPV of the project at a cost of capital of 12% using the Excel functions. Build a Data Table in Excel to show how the NPV changes for a range of discount rates (4% to 20% with increments of 2%) and for a range of first-year revenues (\$1.4 billion to \$3 billion).Remember that your Excel document must not be hard-coded for the Data Table to work.Write a one-page (1.5 spaced 12 pt font) report on your recommendation for this project.This should be a professional email to Mr. Swan on the profitability of the new mobile chips.Set up
the timeline and computation of the free cash flow in five columns.
a. Assume
that the project’s profitability will be similar to Intel’s existing projects
in 2018 and estimate costs each year by using the 2018 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 in 2018.
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 2018 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. Note that in
part 2d, you estimated NWC for the project, not change in NWC.
2.
Determine the IRR of the
project and the NPV of the project at a cost of capital of 12% using the Excel
functions.
3.
Build a Data Table in
Excel to show how the NPV changes for a range of discount rates (4% to 20% with
increments of 2%) and for a range of first-year revenues (\$1.4 billion to \$3
document must not be hard-coded for the Data Table to work.
4.
Write a one-page (1.5
spaced 12 pt font) report on your recommendation for this project. This should be a professional email to Mr.
Swan on the profitability of the new mobile chips. The first paragraph should state your recommendation and report the most important numbers, including the base case NPV and IRR and the NPV with different inputs from step 4. The second paragraph should discuss what you did for this analysis.Include the details on estimating costs, tax rates, and NWC.You should say to “see my attached Excel document for calculations.”The third paragraph should conclude with a summary and an offer to answer any questions.
Excel and report

Read the article attached and complete the assignment with a robust response that is at least 500 words. MLA format required. Go to the salary database Kolbert mentions in paragraph 2 and explore it. Look up some salaries: https://www.sacbee.com/site-services/databases/state-pay/article2642161.html. Do you think this database is a good idea? Is it ethical? Is it a violation of privacy, or should everyone know everyone else’s salary? What problems does it create, beyond the ones mentioned by Kolbert? Whether you think it’s a good or bad idea to have a public database like this one, defend your opinion persuasively. If the assignment can be completed by 11:00 pm EST tonight, I will add a bonus \$10.
NWMC Wk 3 Relationship in Class & Political Identities & Behaviors Essay.

Write a memo about this prompt: “What is the relationship between class (on the one hand) and
political identities or behavior (on the other)? Do you think that
class trumps other social categories? Why or why not?”based on those readings :
Weber, Max. 1973. “Class, Status, Party.” Chapter 7, Sections 2–8 in From Max
Weber: Essays in Sociology. Edited and translated by H. H. Gerth and C. Wright
Mills. Oxford University Press,

Madison, James. 1987. “The Utility of the Union as a Safeguard Against Domestic
Faction and Insurrection (continued).” Essay 10 in The Federalist Papers. Edited by
Isaac Kramnick. Penguin Classics.

Dahl, Robert. 1977. “Subcultures, Cleavage Patterns, and Governmental
Effectiveness.” Chapter 7 in Polyarchy: Participation and Opposition. Yale
University Press

Marx, Karl, and Friedrich Engels. 1978. “Manifesto of the Communist Party.” In The
Marx-Engels Reader. 2nd ed. Edited by Robert C. Tucker. W.W. Norton & Company.
Note: Skip the preamble.•Scheve, Kenneth, and David Slesvig. 2017. “Wealth inequality and democracy.” Annual Review of Political Science 20: 451-468. • Acemoglu, Daron, and James A. Robinson. 2001. “A Theory of Political Transitions.” American Economic Review 91 (4): 938-963. The goal of the
memos is to practice the skill of identifying the key issues and debates within a specific
literature, describing the positions of scholars within those literatures, and commenting
critically on those positions and the state of the debate. A high-quality memo should not
simply summarize the readings, but rather offer a critical discussion of the underlying issues
they address.The memo should engage with as many of the readings as you feel are appropriate to sufficiently develop your argument(s). It is not necessary to cite every single reading. However, as many of the readings are in conversation with each other, it is generally a good idea to make sure you are engaging with pieces that present alternative perspectives on the topic. Memos should be double-spaced in 12-point font and should be around 1000 words.
NWMC Wk 3 Relationship in Class & Political Identities & Behaviors Essay

The Strategic Planning Process At United Parcel Commerce Essay

UPSs primary business is the delivery time identification of packages and documents worldwide. In recent years, UPS has extended their service portfolio to include less than truck transportation (mainly in the U.S.) and supply chain services. UPS reports its operations divided into three parts: U.S. Domestic Package operations, International Package operations, and Supply Chain

can an attorney reveal the information in the following statements?

assignment writing services can an attorney reveal the information in the following statements?.

a. A client tells her attorney that she murdered her husband.b. A client tells her attorney that she is planning to murder her husband.c.A client tells her attorney that at the end of the week she is planning to steal all her employer’s cash receipts as she has access to his safe.d. A client tells her attorney that her husband is so upset with how the litigation is going that he is planning to kill the opposing attorney.e. A client tells her attorney that it was she, who killed the victim.
can an attorney reveal the information in the following statements?

Writing experiences

Essay Writing at Online Custom Essay

5.0 rating based on 10,001 ratings

Rated 4.9/5
10001 review

Review This Service

Rating: