Allouez Corp. is thinking of investing in a project that will require an initial investment of $2,000,000. The investment will be fully depreciated using 5-year MACRS (use 20%, 32%, 19%, 12%, 12% and 5%). The project will provide annual revenues of $1,200,000 and annual operating costs (excluding depreciation) of $500,000. The project will generate cash flows for six (6) years. At the end of the sixth year, the company plans to abandon the project. There is no anticipated terminal cash flow. The company uses a 10% discount rate when analyzing capital projects. The projected tax rate is 30%. The CEO of the company has limited knowledge of capital budgeting and has asked you to do a quick analysis of the proposed project.

1. Prepare a depreciation schedule for the investment. (My Answer is below)

Year	Percentage	Depreciation	Ending Balance
1	20	$400,000	$1,600,000
2	32	$640,000	$960,000
3	19	$380,000	$580,000
4	12	$240,000	$340,000
5	12	$240,000	$100,000
6	5	$100,000	$0

2. Calculate the net operating cash flows for each of the 6 years of the project's life (My answer is below)

Year
1	=(1200000-400000)(1-.30)+400000	960000
2	=(1200000-640000)(1-.30)+640000	1032000
3	(1200000-380000)*(1-.30)+380000	954000
4	(1200000-240000)(1-.30)+240000	912000
5	(1200000-240000)(1-.30)+240000	912000
6	(1200000-100000)(1-.30)+100000	870000

This is where I question myself, I am not sure if my understanding of how to calculate the initial investment is correct; the Initial investment= $2,000,000+($500,000*6)=$3,000,000

3. Calculate the investment's net present value (my answer is below based on my initial investment calculation)

=960000(1.10)^-1+1032000(1.10)^-2+954000(1.10)^-3+912000(1.10)^-4+912000(1.10)^-5+870000(1.10)^-6-3000000=$1122654

4. Calculate the investment's discounted payback period

I got 3.90 years

CF	Sum	PV	Sum
960000	960000	8272727	872727
1032000	1992000	852892	1725619
954000	2946000	716754	2442373
912000	3858000	622908	3062581
=3 + (3000000-2442373/622908)=3.90

5. Calculate the investment's MIRR

=960000(1.10)⁵+1032000(1.10)⁴+954000(1.10)³+912000(1.10)²+912000(1.10)¹+870000(1.10)⁰=$7303535

7303535=3000000(1+MIRR)^6