Question: Please answer this on excel ANSWER THIS ON EXCEL. I need it like in 1 hour please help me. Using the following cash flows compute

Please answer this on excel Please answer this on excel ANSWER THIS ON EXCEL. I need it

ANSWER THIS ON EXCEL. I need it like in 1 hour please help me.

Using the following cash flows compute NPV. The cash flows are annual. The cost of capital is 10%. Report the NPV in the answer box. \begin{tabular}{|r|c|c|c|c|} \hline 0 & 1 & 2 & 3 & 4 \\ \hline100 & 10 & 80 & 25 & 80 \\ \hline \end{tabular} For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The Problem You work for new startup that is trying to manufacture phones. You are tasked with building a model which will help determine how many machines to invest in and how much to spend on...

Using the following cash flows compute NPV, IRR and DPP. The cash flows are annual. The cost of capital is 12.5%. Report the NPV, IRR, and DPP in the answer box. Hint: To calculate DPP use an Excel...

please answer both parts right please help me answer it right i got it wrong Intro You've estimated the following cash flows (in $) for a project: B 1 Year Cash flow 2 0 -5,400 3 1 1,325 4 2,148 3...

The table below gives the initial investment (the negative numbers at Year 0) for two projects. Compute the payback period, the NPV, and the IRR using Excel. Then rank the two projects based on each...

i need help in order to submit this within a 2 hour time frame! please help sons Question 1 7 pts Attempt du 21 Minut 1. A project has the following cash flows. Year 0:-$50,000 Year 1: $30,000 Year...

please answer question 1 and 2 E F G H B Greenback, Inc. Project Analysis Spreadsheet Listed Below are the cash flows for 2 projects we are considering at the firm. Using these cash flows calculate...

Kindly help me answer the following questions CORRECTLY with solutions and short explanations. If you give correct answers, I WILL DEFINITELY GIVE BONUS :) Please refer to the Excel file for the...

please answer all questions 1. Concepts used in cash flow estimation Capital budgeting analysis not only requires the evaluation of cash flows but also requires the understanding of the origin of...

Attached is a homework for Finance. It is 4 questions and includes a link highlighted in yellow where one can get the financial information. Price is flexible, I just need a great grade on this hwk!...

For the following cash flows, compute the internal rate of return. Year 0 -$30,000, Year 1, 5,000, Year 2, 3,000, Year 3, 5,000, Year 4, 3,000, continuing forever. *Please work this using both...

Assignment A3.1 - Making a Business Decision Part 2 In this final assignment, you are asked to answer several questions regarding a potential business idea (described below). Remember to use last...

An individual has two employment opportunities involving the same work conditions but different incomes. Job 1 yields Y1 = 50, Y2 = 30. Job 2 yields Y1 = 40, Y2 =40. Given that markets are perfect...

Which of the following is a vector quantity? Select one: a. acceleration b. density c mass d. speed Cul de las siguientes es una cantidad vectorial? Select one: O a. aceleracion b. densidad O O c...

On which of the four major financial statements would you find the increase in inventory?Multiple Choice 0 t: 5 7 : 5 9 statement of retained earningsincome statementbalance sheetstatement of cash...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

=+ c. Assume the production function is Cobb Douglas. Compare the real wage and the real rental price of capital in the two countries.

=+ d. Who benefi ts from having a better-developed fi nancial system?

=+ a. Which nation would you expect to have a higher level of total factor productivity?