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

assignment...

The death of a patient (as described in the Real Life Scenario (text Chapter 11, pages 233-234) is always classified as a sentinel event. The Joint Co...

the...

The Omnivore’s Dilemma Research EssayFor your last out-of-class essay of the semester, you will pick a topic and create aresearch question you are i...

health...

Case Study Project(first draft and revised draft)OverviewFor this final project you will continue with the social issue that you selected (language an...

projman...

IT301-4: Create project artifacts to effectively manage and control project execution.PurposeThe project communication plan outlines the who, where, w...

enterprise...

Chapters 30, 31, and 34 present three mini-case studies on ERM and risk. Each one presents a slightly different risk scenario. Suppose General Motors...

strategic...

Your tasksPart 1.1. Introduce your organisation and its objectives and examine its ownership structure, external and internal governance mechanisms an...

choose...

Identify another, different policy issue that impacts or interests along the lines of government and federal policies. This policy issue can be at the...

gov...

FINISH THE REST OF MY ANNOTATED BIBLIOGRAPHYThis provides the research foundation for the research paper. The sources in your papers plus some more ma...

hist...

analyzing one primary source from this website, describe what medical aspect from the war would you think with have the longest lasting effects. (10 p...

write...

ESSAY PROMPT: Write a three-page essay that describes the social, racial, and economic, and political complexities of the Reconstruction Era.Include f...

practical...

Hello,Here are the instructions for this assignment. Thanks:The Approval Committee reviewed the Requirements Definition that you submitted in Module 3...

confidence...

Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer da...

750...

For your third exam, you will write an essay response to the topic posted below using only readings on the syllabus from the last three weeks of this...

mail...

Powerpoint presentation. It’s only meant to be about 4 minutes long, but I do need to summarize each question asked below. All the documentation wil...

write...

Language school assignment, write an essay, title is “The advantages and potential of clone”, talk about clone, what advantages and potential it h...

your...

Your patient is a 52-year-old male with a history of smoking and alcohol abuse. He presents to the ED with complaints of “my skin looks yellow, my s...

movie...

Structure:From your list of identified concepts, select TWO to connect to the film in a short essay. See the rubric below for what the focus of the re...

hey...

This Capstone Project focuses on an US Organization. If you chose this option in Week 1, this week you will use this option to submit deliverables in...

active...

The Columbine (Colorado) High School shooting in 1999 changed the active school shooter response forever. Fifteen people, including the perpetrators d...

hlt...

Identify a quality improvement opportunity in your organization or practice. In a 1,250-1,500 word paper, describe the problem or issue and propose a...

develop...

Develop a rough and ready theory of declining participation in democratic process. Taking any case that you choose, or reviewing democracy in general,...

texas...

The exam consists of 50 multiple choice questions. You have 120 minutes to take the exam. You get two opportunities to take the exam, however, please...

the...

The game known in this project as Connect Three is a variant of the commercial game Connect Four in which a player wins by matching 3 of their pieces...

business...

Your initial post should be 75-150 words in length.Conditional Probability1. If there are 3 green marbles and 4 red marbles in a bag, and you were ask...

If you didn't find the right answer

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