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
*	*	*	*	*	*
*
*	*	*	*	*	*	*
IRR	*	*	*	*	*	*

<tbody>
[TD="bgcolor: #cacaca, align: center"]107[/TD]
[TD="align: center"]Total Combined Net Income from Sales & Rental After Reserves[/TD]

[TD="bgcolor: #cacaca, align: center"]108[/TD]

[TD="align: right"] $ * * * * * * * * * * * 85,735[/TD]
[TD="align: right"] $ * * * * * * 202,684[/TD]
[TD="align: right"] $ * * * *(7,500,128)[/TD]
[TD="align: right"] $ * * * * * * * 725,181[/TD]
[TD="align: right"] $ * * * * 18,144,923[/TD]

[TD="bgcolor: #cacaca, align: center"]109[/TD]

[TD="bgcolor: #cacaca, align: center"]110[/TD]

[TD="bgcolor: #cacaca, align: center"]111[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"] $ * * *(6,350,000)[/TD]
[TD="align: right"] $ * * * * * * * * * * * 85,735[/TD]
[TD="align: right"] $ * * * * * * 202,684[/TD]
[TD="align: right"] $ * * * *(7,500,128)[/TD]
[TD="align: right"] $ * * * * * * * 725,181[/TD]
[TD="align: right"] $ * * * * 18,144,923[/TD]

</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?