Other : Assignment for due excel sheet - Finance homework help

“Do we have everything we need on sales and costs?” you ask. ”It must be time to compute the net present value (NPV) and internal rate of return (IRR) of the Apix expansion project.”

“We have the data from James and Luke regarding projected sales and costs, respectively, for the food packaging project,” says Mary. “It is feasible to project that we will receive a tax break from this implementation. I have information from our audit firm that indicates that future depreciation methods for taxes will be straight-line; however, the corporate rates will be reduced to 35% as we assumed in our weighted average cost of capital (WACC) calculation.”

“That sounds good,” you say.

“Right," says Mary. "You can use a WACC of 10% for the computation of the NPV and comparison for IRR."

“I’ve got the information I need from Luke and James,” you say. "Does this look right to you? Here’s what they gave me,” you say, as you hand a sheet of paper to Mary.

“Let’s look at this now while we’re together,” she says.

The information you hand to Mary shows the following:

You continue your conversation.

“It looks good,” says Mary. “Use this information from Luke and James to compute the cash flows for the project.”

“No problem,” you say.

“Then, compute NPV and IRR of the project using the Excel spreadsheetI sent earlier today,” says Mary. “Use the IRR financial function for the computation of IRR.”

“Okay,” you say. "I’ll submit my Excel file showing the computation of cash flows, NPV, and IRR by the end of week so you can look at it over the weekend.”

“Thanks,” says Mary.

Complete the above worksheet for this assignment.

Answers

Related Questions

Economics : Econometric Assignment...

Running head: Econometric Assignment1Econometric AssignmentStudents name:Institution affiliation:Date:Econometric Assignment2Q1)1400012000Growth rate1...

Sociology : Rt...

What actually surprised me about Steves response to the Memphis Islamic Center is thatSteve Stone had no opinion on the Muslim due to the fact that he...

Computer Science : Penetration Test Differ From Ot...

1. How does the penetration test differ from other types of security testing such as avulnerability assessment?As explained by Van Westen, Castellanos...

Management : Summary Of Findings And Recommendatio...

Running head: SUMMARY AND RECOMMENDATIONSSummary of Findings and RecommendationsInstructorClassDateName1SUMMARY AND RECOMMENDATIONS2Those who work in...

Economics : 1 Assignmt 1...

Running head: Finance stock journalFinance stock journalStudents nameInstitutional affiliationDateRunning head: Finance stock journalWeek three summar...

Business : Zero Budgeting...

Zero budgetingZero-based planning, or ZBB, is a thorough planning process that requires each dollar of eachcost to be advocated regardless of the poss...

Health & Medical : Hernia Pathogenesis...

Hernia pathogenesisWhile a male fetus is in the womb, the testes are formed in the abdomen and before birth; theydescend into the scrotum via the ingu...

Philosophy : Response...

Surname1NameCourseProfessorDate1st responseEvery individual is often unique. Psychologists have gone a mile further and establishedthat even identical...

Computer Science : Pki And Cryptographic Applicati...

PKI and Cryptographic Applications Asymmetric CryptographyThe asymmetric cryptography uses the combination of public and private keys to encrypt andde...

English : Short Essay 1 Reflectve Essay...

Surname 1NameProfessorCourseDateReflective EssayThe essay is a reflection of my synthesis essay in which I discussed the rise in the use ofinternet an...

English : Sci Fi Movies...

Surname [1]Students NameProfessors NameArt & Entertainment3 October 2017Sci-Fi Movies.Science-fiction is arguably considered the best genre in the cin...

Marketing : Marketing Opportunties...

Surname 1NameTutorCourseDateOrganic products opportunities to McDonaldsEntry and increased demand for organic products pose a lot of opportunities to...

Management : Project Scope Statement.edited...

Project Scope StatementProject __Relocating Office____________ Date _____10.3.2017_____Project Work StatementThe project will involve the moving of of...

Business : Inventory Control...

INVENTORY CONTROL1Inventory Control in HospitalsHealth care activities have been talked about in many occasions equally engineeringsystems and operati...

Art & Design : A Discussion Post Becoming An Infor...

Running head: AN INFORMED VIEWER OF ARTAn Informed Viewer of ArtNameInstitution1AN INFORMED VIEWER OF ART2An Informed Viewer of ArtEnrolling in this c...

Marketing : A Focus On An Article...

Surname 1NameProfessorCourseDateA Focus on an ArticleSaudi Arabias economy can be transformed by incorporating medieval society of thecountry into the...

Computer Science : Internal Memo...

Internal MemoTo: Dr. Cumbie (Senior Partner)From: Mr. McKean Joseph (Project Manager)CC: Head of Project PersonnelDate: October 2nd, 2017Dear all,Subj...

Mathematics : Submatingale...

Surname 1Students NameProfessors NameCourseDateShowing theLetis a Submartingalebe a martingale, thenis a Submartingale.SolutionFor a filtration adapte...

Business : Business Letter...

Dear Mr. Nathan,I hope you are fine. I am writing to you concerning your earlier communication about a brokencontract you had entered verbally with Al...

Economics : Economics Worksheet...

Efficiency of MarketsECO/365University of Phoenix MaterialEfficiency of MarketsThe difference between the highest price a consumer will pay and the ac...

Writing : 2010 Nobel Prize In Physiology Or Medici...

2010 Nobel Prize in Physiology or MedicineIn 2010, the Nobel Prize for Physiology or Medicine was given to Robert G. Edwards for hisachievements in In...

Business Law : Texas Has A Low Voter Turnout In Co...

Texas has a low voter turnout in comparison to other states. Participation in Texaselections varies by elections. Turnout is lowest in party primaries...

Writing : Finding The Mistakes In The Paper...

Gilgamesh: Is He a Hero?Since the beginning of time, man has written about heroes who are partly God and partlymortal with divine traits given to them...

Business Law : Looting In Savings And Loans In The...

Running head: LOOTING IN SAVINGS AND LOANS IN THE USLooting in Savings and Loans in the USNameInstitution1LOOTING IN SAVINGS AND LOANS IN THE US2Looti...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it