Hi! Please help with this question...I tried plugging these into Excel, but I guess something was missing on my IRR??

We are looking for the IRR and MIRR of M, N, and O! Thanks so much.

Internal rate of return and modified internal rate of

return.

Quark Industries has three potential projects, all with an initial cost of

$1 comma 800 comma 0001,800,000.

Given the discount rate and the future cash flow of each project, what are the IRRs and MIRRs of the three projects for Quark Industries?

Cash Flow	Project M		Project N		Project O
Year 1	$500 comma 000500,000		$600 comma 000600,000		$1 comma 000 comma 0001,000,000
Year 2	$500 comma 000500,000		$600 comma 000600,000		$800 comma 000800,000
Year 3	$500 comma 000500,000		$600 comma 000600,000		$600 comma 000600,000
Year 4	$500 comma 000500,000		$600 comma 000600,000		$400 comma 000400,000
Year 5	$500 comma 000500,000		$600 comma 000600,000		$200 comma 000200,000
Discount rate	77%		1313%		1616%