Question: 7. Present Values. What is the total present value of the following cash-flow stream if the interest rate is 5 percent? Year Cash Flow 1

7. Present Values. What is the total present value of the following cash-flow stream if the interest rate

is 5 percent?

Year Cash Flow

1 $200

2 $400

3 $300

Can someone please show me the work in Excel please? Thank you!

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:

For each item listed in the table below, input the balance for the date range 10/1/20XX to 12/1/20XX. For the Journal, input the balance for the date range 11/13/20XX to 12/1/20XX. Note: Enter your...

Q:

Saved Problem 5-14 Present Values (LO2) What is the present value of the following cash-flow stream if the interest rate is 5%? (Do not round intermediate calculations, Round your answer to 2 decimal...

Q:

any help is appreciated! will thumbs up! Question 6 (of 8) Save & Exit Submi 6. value: 1.25 points Problem 5-13 Present Values (LO2) What is the present value of the following cash-flow stream if the...

Q:

Problem 5-14 Present Values (LO2) what is the present value of the following cash-flow stream if the interest rate is 4%? (Do not round intermediate calculations. Round your answer to 2 decimal...

Q:

Find the present values of the following cash flow streams under the following conditions: a. The appropriate interest rate is 8 percent. b. The appropriate interest rate is 0percent. Cash Stream A...

Q:

show all work a. determine the NPV of the following cashflow stream? The interest rate is 13%. Year 1: $-400 Year 7: $300 Year 13: $400 b. What is the IRR for the following cash flow stream? Year 0:...

Q:

Part A. Using a discount rate of 9.3 percent, compute the present value of the following cash flows to the nearest dollar: Year Cash Flow 1 $7,745 2 $8,167 3 $15,601 4 $18,300 5 $9,206 Part B....

Q:

Part A. Using a discount rate of 9.6 percent, compute the present value of the following cash flows to the nearest dollar: Year Cash Flow 1 $9,958 2 $9,622 3 $15,438 4 $16,723 5 $8,189 Part B....

Q:

End of chapter problem # 2 and 8 Balance sheet and income statement Kuipers, Inc. 2010 Income Statement ($ in millions) Net sales Less: Cost of goods sold Less: Depreciation Earnings before interest...

Q:

Investments in the stock market have increased at an average compound rate of about 10 percent per year since 1926. - If you invested $1,000 in the stock market 50 years ago, how much would that...

Q:

What is the present value of the following cash-flow stream if the interest rate is 6%? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Year Cash Flow $ 200 400...

Q:

A) Determine VL, IL, IZ, and IR for the network of Fig. 2.181 if RL = 180 B. Repeat part an if RL = 470 H. C. Determine the minimum value of RL, to ensure that the Zener diode is in the "on" state....

Q:

When youre a global company that keeps expanding into new countries, how do you keep all of your consumer sites updated in the local languagewithout spending a ton of time and money? PayPal realized...

Q:

A manufacturer of aluminum doors currently is able to sell 5 5 0 doors per week at a price of \ ( \ $ 8 5 \ ) each. If the price were lowered to \ ( \ $ 7 5 \ ) each, an additional 7 0 doors per week...

Q:

What is non-coding RNAs? What are the important non-coding RNAs in bacteria? What are their regulatory functions? How to study the regulatory function of the non-coding RNAs

Q:

Please compare and contrast the microbial communities that reside in a ruminant with those in the human gut

Q:

Suppose that the price index for year 2000 is set to 100. Suppose also that gasoline prices in the year (in cents per gallon) 2000 are as follows: Premium: 114 Plus: 103 Regular: 93 Suppose the...

Q:

If Japan's government wants to close the above gap by increasing government purchases of goods and services (G). Suppose marginal propensity to consumer is 0.75. a. Calculate by how much government...

Q:

Recentlysome research reported that GM crops can affect the microorganisms in animal gastrointestinal system with secondary effects on their production and health. Please give the explanation about...

Q:

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Q:

Latest Styles, Inc. (LSI), supplies a limited range of garments to several boutiques in New York. LSI produces these garments in a small factory owned and operated in Nuevo Laredo, Mexico. LSI has...

Q:

The U.S. division of MegaBig, Inc., has excess capacity. MegaBig's European division, lo cated in Lisbon, has offered to buy a component that would increase the U.S. division's uti lization of...

Q:

Diamond Company manufactures riding lawn mowers at plants in Arkansas, Delaware, and Wyoming. It also has distribution centers in Brussels, Belgium, and Montreal, Quebec in Canada. The market price...