IRR with Loan Payoff

[TKB]

Hello,

So, i have the following cash flows in a financial model im creating for work.

The large negative number you see is where an $8 MM loan is paid off. The -$6.35 MM is the original investment, not including the additional $8 MM reflected in column F. Is this correct? I have never had to show an IRR with a loan payoff in the middle.

Thanks for any guidance.

Trey

*	B	C	D	E	F	G	H
107	Total Combined Net Income from Sales & Rental After Reserves	*	*	*	*	*	*
108	*	$ * * * * * * * * * * * 85,735	$ * * * * * * 202,684	$ * * * *(7,500,128)	$ * * * * * * * 725,181	$ * * * * 18,144,923
109	*	*	*	*	*	*	*
110	IRR	*	*	*	*	*	*
111	10%	$ * * *(6,350,000)	$ * * * * * * * * * * * 85,735	$ * * * * * * 202,684	$ * * * *(7,500,128)	$ * * * * * * * 725,181	$ * * * * 18,144,923

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D108 =D89+D92 E108 =E89+E92 F108 =IF(F49="Y",F89+F92-E56,F89+F92) G108 =G89+G92 H108 =H89+H92 B111 =IRR(C111:H111) C111 =D5*-1 D111 =D108 E111 =E108 F111 =F108 G111 =G108 H111 =H108 <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[TKB]

Anyone have any ideas? Or do i need more information?