Using NPV in Excel how do I solve for: An investment offers the following annual cash...

Using NPV in Excel how do I solve for: An investment offers the following annual cash flows: End of years 1 thru 10, $5000, years 11 thru 20, $7500. If your required return on this investment is 6% what is it worth today?

Solutions

Expert Solution

Ans $ 67624.19

We can also use the formula:

=NPV(6%,value1,value2,value3.......)

=NPV(6%,Cell references of cash inflows)

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

How can I solve this in Excel? Please show how to solve it in excel step...

How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...

DO NOT SOLVE IN EXCEL!!!! I need the actual formula & steps!! Consider the following...

**** DO NOT SOLVE IN EXCEL!!!!**** I need the actual formula & steps!! Consider the following hypotheses and sample data, and then complete parts a and b below using α=0.05 H0:μ≤16 H1:μ>16 2121 1818 1313 1717 2323 1919 1616 1919 1818 1616 I am getting the p-value wrong on all of these... I need to know the steps to solve p-value, please. I get all of the other stuff right, just not the p-value :(

Solve the following questions in excel using the skills from class. Lindner is considering an investment...

Solve the following questions in excel using the skills from class. Lindner is considering an investment with an initial cost of $122,400 and salvage value of 63,600 with the following cash flows over the next 6 years: Year Cash flow 1 $28,750 2 $19,500 3 $44,100 4 $27,900 5 $15,850 6 $13,050 The discount rate is 14.8%. Find the NPV and IRR, what is the decision and what was the criteria for each rule? You want to analyze the impact...

How do i solve the question below: You are looking at an investment that will pay...

How do i solve the question below: You are looking at an investment that will pay you $27,250 in year 2, $44,098 in year 4 and $49,414 in year 6. If your required return is 8.49%, what is the most you should pay for the investment? (In other words, how much is the project worth today?) 2. If you have $485 today and you think you can earn an interest rate of 6% per year, how many years until you...

I would like to know how to solve this problem using POM or Excel Alan Resnik,...

I would like to know how to solve this problem using POM or Excel Alan Resnik, a friend of Ray Cahnman, bet Ray $5 that Ray’s car would not start 5 days from now (see Problem 14-8). What is the probability that it will not start 5 days from now if it started today? What is the probability that it will not start 5 days from now if it did not start today? What is the probability that it will...

Please solve using excel. If 200,000 is available for investment and 60,000 is invested at 20%...

Please solve using excel. If 200,000 is available for investment and 60,000 is invested at 20% per year with the remainder is invested at 12% per year. What is the overall rate of return on the 200,000?

I am using Excel to try and solve these problems but can find the answers or...

I am using Excel to try and solve these problems but can find the answers or figure out why my answers are wrong, please help. 1. Today, your roommate purchased an annual perpetuity of $1,000. The payments on his perpetuity will begin in one year. You purchased an annual perpetuity of $1,000. Your payments begin immediately. Assuming a 10% discount rate for these perpetuities, which of the following statements is true? A. Your perpetuity is worth $1,000 more than the...

Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel...

Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel formulas) Discount rate 0.08 0 1 2 3 System A Costs Hardware 14000 3000 3000 3000 Software 12000 2000 2000 1000 Services 2500 2500 2500 2500 Benefits Increased productivity 15000 10000 5000 Lower Error rates 18000 5000 6000 System B Costs Hardware 15000 3000 3000 3000 Software 12000 4000 2000 5000 Services 7000 3000 3000 1000 Benefits Increased productivity 7000 10000 10000 Reduced Work...

How to solve this question on Microsoft Excel The annual commissions earned by sales representatives of...

How to solve this question on Microsoft Excel The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery, follow the normal distribution. The mean yearly amount earned is $40,000 and the standard deviation is $5000. a. What percentage of sales representatives earn between $32,000 and $42,000 per year? b. What percentage of sales representatives earn more than $42,000 per year? c. The sales manager wants to award the sales representatives who earn the largest...

How do I complete this in Excel . Calculation ANOVA Using one-way analysis of variance on the...

How do I complete this in Excel . Calculation ANOVA Using one-way analysis of variance on the data assuming the populations have equal variances and the populations are normally distributed. Use alpha = 0.05. three samples obtained independently from 3 population Item Group A Group B Group C 1 14 17 17 2 13 16 14 3 12 16 15 4 15 18 16 5 16 14 6 16

Subjects