Question: I need help with this question- what formula should I use and how to apply it? Using the cash flows below, what is the NPV

I need help with this question- what formula should I use and how to apply it?

Using the cash flows below, what is the NPV of all the cashflows using an interest rate of 10% ?

  • Now: - $120

  • After 1 year: + $20

  • After 2 years: + $90

  • After 3 years: - $10

  • After 4 years: + $30

  • After 5 years: + $30

  • After 6 years: + $30

  • After 7 years: + $40

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!

Q:

Hi I need help with this question 8:28 1 v2.cengagenow.com Chapter 26 investment projects. The estimated net cash flows from each project are as follows: Wind Biofuel Year Turbines Equipment $170,000...

Q:

Finding IRR and incremental IRR without using Excel or trial and error method. And may you help me on Question 2 part C ( probability index ) 1)** [6-20] Consider the following cash flows on two...

Q:

LTE Learning Objectives 8:56 1. Understand how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop...

Q:

Using the Project Two Financial Formulas spreadsheet and the balance sheet, income statement, and cash flow statement from Mergent Online for your chosen company, calculate the financial ratios for...

Q:

HI, I need help with my Finance Course. Will you be able to assist? I have attached the instructions. Please let me know if you can help and let me know if you need any more information. As per...

Q:

($X,XXX,XXX) = 1,658,000 You and your business partners are considering applying for a franchise. If approved, you expect startup costs to be $X.XXX.XXX (where this figure is the same as the last 7...

Q:

Can you fill out these columns? ESPECIALLY THE SECOND PICTURE STARTING FROM INITIAL INVESTMENT TO IRR USING FORMULA -2345 1 A B 19 After tax Salvage Value in year 6 20 Cost of capital 21 Tax rate D G...

Q:

-2345 1 A B 19 After tax Salvage Value in year 6 20 Cost of capital 21 Tax rate D G 2516 5 H F E Discounted Cash-Flow Analysis Estimating depreciation of an asset, calculating cash flows, and...

Q:

TABLE 4 - Company Information some parts require excel, thanks This is all the info that was given, this is a finance question. CASE STUDY: The a2 Milk Company Limited In 2000 Dr Corran McLachlan a...

Q:

Note: Please fill out all the answers and provide the formulas below. Thank you! Discounted Cash-Flow Analysis Estimating depreciation of an asset, calculating cash flows, and estimating NPV. Problem...

Q:

In Example 7.9 on page 294, we conducted a simulation to check the plausibility of the central limit theorem. The variable under consideration there is household size, and the population consists of...

Q:

The statement of cash flows for Yahoo! is reproduced here YAHOO! INC. Consolidated Statements of Cash Flows YEAR ENDED DECEMBER 31, (in thousands) Year 8 Year 7 Year 6 Cash flows from operating...

Q:

F1222. The ball is kicked from point A with the initial velocity vA = 10 m>s. Determine the range R, and the speed when the ball strikes the ground. XB- V = 10 m/s B 30 Prob. F12-21/22 x

Q:

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".