Question: True or False 1. Your venture has signed a new consulting contract that will require you to invest in new analytical software and a new

True or False

1. Your venture has signed a new consulting contract that will require you to invest in new analytical software and a new computer. The contract will generate the cash flows at specific times. Your cost of capital is 12%. In the XNPV function you can include the initial time and initial cash flow in the Excel formula so no need to net it out as in the NPV formula.

This project adds value to your company. True / False

dates

cash flows

12/10/2022

-$12,000.00

4/10/2023

$4,000.00

8/10/2023

$4,000.00

12/10/2023

$4,000.00

4/10/2024

$4,000.00

2.

principal

time

returns

$200,000

0

1

5.3500%

2

5.7000%

3

6.0500%

4

6.4000%

5

6.7500%

6

7.1000%

7

7.4500%

8

7.8000%

9

8.1500%

10

8.5000%

You have $200,000 today. There is a project that you believe will return increasing returns over the next ten years. In fact you have come up with the return schedule that you believe is the best forecast of rates of return on your investment. Based on these returns the FV of your $200,000 investment at the end of 10 years will be between $390,500 and $390, 510.

You make the investment at time zero and first interest is earned over the fist year so it is earned from time 0 to time 1. The FVSCHEDULE starts at time 1 not time 0. True / False

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!