Question: Consider the cash flows presented in the table below. What is the value of the cash flows in year 5 if the interest rate is

Consider the cash flows presented in the table below. What is the value of the cash flows in year 5 if the interest rate is 7 percent compounded annually?

Year Cash Flow

1 12,000

2 8,500

3 11,000

4 7,000

5 3,000

Using excel !!

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!

You have $12,000 to invest. You need the money in 13 years, and you expect to earn 6% per year. How much will you have in 13 years? Steven needs $180,000 in 10 years for his daughter's education. If...

Consider the cash flows presented in the table below. What is the value of the cash flows in year 5 if the interest rate is 5.5 percent compounded annually? Year Cash Flow 1 16,000 2 14,000 3 29,000...

You have $75,000 to invest. You need the money in 12 years and you expect to earn 7% per year. How much will you have in 12 years? Owen needs $260,000 in 9 years for his daughter's education. If he...

Solve through excel per year. How much will you have in 10 years? 2. Bernard needs $140,000 in 9 years for his daughter's education. If he can earn 7.5% per year, how much does he need to invest...

Solve through excel 2. Bernard needs $140,000 in 9 years for his daughter's education. If he can earn 7.5% per year, how much does he need to invest today? 3. You have $38,000 to invest and you need...

In an Excel spreadsheet, solve the TVM problems below. 1. You have $13,000 to invest. You need the money in 14 years, and you expect to earn 7% per year. How much will you have in 14 years? (Assume...

TVM HOMEWORK ASSIGNMENT This homework is due by the end of day on November 9 (Excerpt from the course outline: ., a separate homework, Excel for TVM (homework assignment on TVM using excel, will be...

5. Consider the cash flows presented in the table below. What is the value of the cash flows in year 5 if the interest rate is 4 percent compounded annually? Year Cash Flow 1 8,000 2 4,000 3 9,000 4...

How do you calculate this in excel ?? 5 3 ,000 Consider the cash flows presented in the table below. What is the present value if the appropriate intere rate is 7 percent compounded annually? Year...

how would I calculate those problems in excel ? Times 19 TVM Excel Homework_BUS230B_S2020.docx Locked Regular 12 VOYB I U EEID 1.0 0 EV T2 1 HOMEWORK ASSIGNMENT You have $150,000 to invest. You need...

Starting with the data from problem 17 in the file P08_17.xlsx, restructure the data so that you have a table of counts. Then use StatTools on the counts to answer the same questions as in problem 17.

Compute the first and second derivatives of the following function. l +e

QUESTION 3 6 ASFA prohibits the child protection agency from pursuing the Termination of Parental Rights ( except for in rare and egregious circumstances ) unless the child has been in foster care...

What are three reasons why companies purchase investments in debt or stock securities