Investment opportunity that will require cash outlay

Assignment Help Financial Management

Reference no: EM132041096

An engineer has been offered an investment opportunity that will require a cash outlay of $40,000 now for a cash inflow of $3500 for each year of investment. However, she must state not that number of years she plans to retain the investment. Additionally, if the investment is retained for 6 years, a lump-sum amount of $36,000 will be returned to her; after 10 years, the lump-sum return is anticipated to be $49,000, and after 15 years, it is estimated to be $55,000. Money is currently worth 10% per year. (a) Is the decision sensitive to the retention period? If so, what investment period is best? (b) Write the format of the spreadsheet function that will display the correct PW values.

Reference no: EM132041096

Questions Cloud

What is the project coefficient of variation : What is the project's coefficient of variation? Do not round your intermediate calculations. Round the final answer to 2 decimal places.

Role of investment banks in the underwriting process : What is the role of investment banks in the underwriting process? What is the uses and sources of cash?

The rolling stock led to uncontrolled cost increases : The procurement contract on the rolling stock led to uncontrolled cost increases because:

Higher or lower to bring the npv to zero : When NPV is positive, would the discount rate be higher or lower to bring the NPV to zero?

Investment opportunity that will require cash outlay : An engineer has been offered an investment opportunity that will require a cash outlay of $40,000 now for a cash inflow of $3500 for each year of investment.

Create the pro forma cash flow statement : When getting into a project of this type you generally consider a 5-year holding period and look for a 12% rate of return.

What can johnson do to set up a schedule and cost variance : Is Johnson over, on, or below schedule? Explain. Is Johnson using earned value as he was taught in his Project Management course? Explain.

Tenant pays all the operating expenses : The CPI is expected to grow by 2% for the next two years and 4% thereafter. The tenant pays all the operating expenses.

Manufacturer is planning to produce and sell new product : A manufacturer is planning to produce and sell a new product. Develop a spreadsheet model, and use it to find the project’s NPV, IRR, and payback.

User Account

All Pages