Introduction: This case study aims to determine the financial feasibility of three projects and recommend one project for selection based on the analysis of the five-year cash flow statement, net present value (NPV), internal rate of return (IRR), payback period, and discounted payback period. The projects will be evaluated based on their potential for generating positive cash flows and maximizing return on investment. Use a discount factor of 10%

Note: Please break down the inflows and outflows to different line items. I expect each group to have a different cash flow table.

Project 1:

Construction of a New Office Building Project Description: The first project involves the construction of a new office building. The initial investment required for this project is $10 million, which will be used to cover the cost of land acquisition, construction, and equipment. The estimated revenue from the rental of the office building is $3 million per year, with an expected increase of 12% per year. The estimated operating costs are $700,000 per year, with an expected increase of 3% per year. The estimated life of the office building is 20 years.

Project 2:

Purchase of a new Equipment Project Description: The second project involves purchasing a piece of new equipment. The initial investment required for this project is $8 million, which will be used to purchase the equipment. The estimated revenue from the operation of the equipment is $4.5 million per year, with an expected increase of 6% per year. The estimated operating costs are $900,000 per year, with an expected increase of 2% per year. The estimated life of the equipment is 10 years.

Project 3:

Development of a new Mobile App Project Description: The third project involves the development of a new mobile app. The initial investment required for this project is $5 million, which will be used to cover the cost of research and development, marketing, and server costs. The estimated revenue from the sale of the app is $680,000 per year, with an expected increase of 17% per year. The estimated operating costs are $450,000 per year, with an expected increase of 9% per year. The estimated life of the app is 5 years.

Prepare the Cash Flow Statement and calculate the following:

1. Net Present Value

2. Payback Period

3. Discounted [Payback Period

4. Internal Rate of Return

Please complete the Cash Flow Statement and calculate the following of project 2