Jul 4th, 2016
Studypool Tutor
Harvard University
Price: $5 USD

Tutor description

Questions and answers on project management.A unit in computer science

Word Count: 1656
Showing Page: 1/14
QUESTION ONE (35 Marks)a) Explain how you can calculate NPV using excel and provide the formula used by excel.SolutionThe NPV of any investment or project can easily be calculated using Microsoft Excel,given that cash flows are evenly spaced over time.First, enter the anticipated discount rate into cell A1. Next, input all cash flowssequentially into adjacent cells, entering any outflow values as negative numbers. Forexample, a project with a single initial investment that is expected to generate returnsover the course of three years will have four entries in cells A2 through A5. Excelassumes all flows occur at the end of each period. Therefore, if the initial investmentoccurs at project inception rather than at the end of the first period, then this figure willneed to be added to the NPV function separately and not included in the function itself.If the initial investment occurs at the end of the first period, as the program assumes,enter the formula "=NPV(A1,A2,A3,A4,A5)" into cell A6 to render the NPV for thisproject.If the initial investment occurs at the beginning of the first period instead, enter theformula "=NPV(A1,A3,A4,A5)+A2" to account for that initial outlay.b) Supposing a real estate company offers you a piece of land that costs $85,000 and youare certain that after one year the land will be worth $91,000, a sure $6,000 gain. On theother hand a bank guarantees you an interest rate of 10% if you deposit the money withthem for one year should y

Review from student

Studypool Student
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1822 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors