Instructions: Use Excel to do these problems and paste the answers into this Word Document – Include all calculations.

An investment project requires a net investment of $100,000. The project is expected to generate annual net cash flows of $28,000 for the next 5 years. The firm’s cost of capital is 12%.

Part 1 – Determine the payback period for the project.

Part 2 – Determine the payback period accounting for the present value of future cash flow (ie. Present value calculations). Should the project be done? After considering present value is the 100,000 investment recovered in 3-4 years, 4-5 years or over 5 years?

What is the IRR for a project that has a net investment of $14,600 and a single net cash flow of $25,750 in 5 years?

Red Lake Mines, Inc. is considering adoption of a new project requiring a net investment of $10 million. The project is expected to generate 5 years of net cash inflows of $5 million per year. In the project’s sixth, and final, year it is expected to have a net cash outflow of $1 million. What is the project NPV, using a discount rate of 12%?

Zimmer, a manufacturer of modular rooms, plans to expand its operations in Landshut, Germany. The expansion will cost $14.5 million and is expected to generate annual net cash flows of €2.15 million for a period of 12 years and then the operation will be sold for €1 million (net of taxes). The cost of capital for the project is 14%. Using a spot exchange rate of $1.25/€ as the forecast FX rate for the euro for the term of the project, compute the NPV of this expansion project.

Dupree Funds is considering the fees charged by two banks. First America charges a flat rate of $0.11 per payment and First Western requires a deposit of $500,000 (that does not pay interest to Dupree), plus $.05 per payment. What is the…