I ONLY NEED HELP CALCULATING MIRR. I HAVE THE ANSWER JUST DONT KNOW HOW TO CALCULATE OR WHAT FORMULA TO USE

Expansion project NPV

Get the depreciation using the MACRS table provided in the question.

		0	1	2	3	4
Cost		(650,000)
Inventory		(55,000)
Accounts Payable		20,000
Sales			300,000	300,000	300,000	300,000
Operating Cost			(150,000)	(150,000)	(150,000)	(150,000)
Deprecition			(214,500)	(292,500)	(97,500)	(45,500)
EBT			(64,500)	(142,500)	52,500	104,500
Tax	30%		(19,350)	(42,750)	15,750	31,350
NI			(45,150)	(99,750)	36,750	73,150
+ Deprection			214,500	292,500	97,500	45,500
After-tax salvage Value						21,000
Return NWC						35,000
After-tax CF		(685,000)	169,350	192,750	134,250	174,650

Note in Year 4 $35,000 of working capital is recovered plus the after tax salvage value of $21,000.

Enter the cash flows into the cash flow register and solve for the NPV using the WACC of 11%. NPV = $(162,782); IRR = -0.83%

• MIRR= __________3.72%_________

• Payback = _____________4.00__________________

ONLY NEED HELP CALCULATING MIRR.