$
%
%
$
%
%
$
$
%
$
%

Future Purchase Price

Year 1 $ {{round(G82)}}
Year 5 $ {{round(G86)}}
Year 10 $ {{round(G91)}}
Year 25 $ {{round(G106)}}

Future Price Per Sq. Ft.

Year 1 $ {{round(G82/D6)}}
Year 5 $ {{round(G86/D6)}}
Year 10 $ {{round(G91/D6)}}
Year 25 $ {{round(G106/D6)}}
Monthly Yearly

Rental Income

Year 1 $ {{round(I82)}} $ {{round(I82*12)}}
Year 5 $ {{round(I86)}} $ {{round(I86*12)}}
Year 10 $ {{round(I91)}} $ {{round(I91*12)}}
Year 25 $ {{round(I106)}} $ {{round(I106*12)}}
Monthly Yearly

Annual Insurance

Year 1 $ {{round(K82/12)}} $ {{round(K82)}}
Year 5 $ {{round(K86/12)}} $ {{round(K86)}}
Year 10 $ {{round(K91/12)}} $ {{round(K91)}}
Year 25 $ {{round(K106/12)}} $ {{round(K106)}}
Monthly Yearly

Annual Property Taxes

Year 1 $ {{round(G82*D8/12)}} $ {{round(G82*D8)}}
Year 5 $ {{round(G86*D8/12)}} $ {{round(G86*D8)}}
Year 10 $ {{round(G91*D8/12)}} $ {{round(G91*D8)}}
Year 25 $ {{round(G106*D8/12)}} $ {{round(G106*D8)}}
Monthly Yearly

Monthly Maintenance Fees

Year 1 $ {{round(O82/12)}} $ {{round(O82)}}
Year 5 $ {{round(O86/12)}} $ {{round(O86)}}
Year 10 $ {{round(O91/12)}} $ {{round(O91)}}
Year 25 $ {{round(O106/12)}} $ {{round(O106)}}
Monthly Yearly

Annual Property Management Fee

Year 1 $ {{round(M82/12)}} $ {{round(M82)}}
Year 5 $ {{round(M86/12)}} $ {{round(M86)}}
Year 10 $ {{round(M91/12)}} $ {{round(M91)}}
Year 25 $ {{round(M106/12)}} $ {{round(M106)}}
Monthly Yearly

Total Expenses

Year 1 $ {{round((K82/12)+(G82*D8/12)+(O82/12)+(M82/12))}} $ {{round(((K82/12)+(G82*D8/12)+(O82/12)+(M82/12))*12)}}
Year 5 $ {{round((K86/12)+(G86*D8/12)+(O86/12)+(M86/12))}} $ {{round(((K86/12)+(G86*D8/12)+(O86/12)+(M86/12))*12)}}
Year 10 $ {{round((K91/12)+(G91*D8/12)+(O91/12)+(M91/12))}} $ {{round(((K91/12)+(G91*D8/12)+(O91/12)+(M91/12))*12)}}
Year 25 $ {{round((K106/12)+(G106*D8/12)+(O106/12)+(M106/12))}} $ {{round(((K106/12)+(G106*D8/12)+(O106/12)+(M106/12))*12)}}
Monthly Yearly

NOI

Year 1 $ {{round(I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))}} $ {{round((I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12)}}
Year 5 $ {{round(I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))}} $ {{round((I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))*12)}}
Year 10 $ {{round(I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))}} $ {{round((I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))*12)}}
Year 25 $ {{round(I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))}} $ {{round((I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))*12)}}
Monthly Yearly

Mortgage Payment

Year 1 $ {{round(V88)}} $ {{round(V88*12)}}
Year 5 $ {{round(V88)}} $ {{round(V88*12)}}
Year 10 $ {{round(V88)}} $ {{round(V88*12)}}
Year 25 $ {{round(V88)}} $ {{round(V88*12)}}
Avg. Monthly Over Term

Principal Repayment

Year 1 $ {{round(X104/12)}} $ {{round(X104)}}
Year 5 $ {{round(X152/60)}} $ {{round(X152)}}
Year 10 $ {{round(X212/120)}} $ {{round(X212)}}
Year 25 $ {{round(X392/300)}} $ {{round(X392)}}
Monthly Yearly

Net Profit

Year 1 {{round2(100* ((I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12 -V88*12 )/D2 )}} % $ {{round( (I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12 -V88*12 ) }}
Year 5 {{round2(100* ((I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))*12 -V88*12 )/D2 )}} % $ {{round( (I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))*12 -V88*12 ) }}
Year 10 {{round2(100* ((I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))*12 -V88*12 )/D2 )}} % $ {{round( (I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))*12 -V88*12 ) }}
Year 25 {{round2(100* ((I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))*12 -V88*12 )/D2 )}} % $ {{round( (I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))*12 -V88*12 ) }}

Capitalization Rate

Year 1 {{round2(((I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12)/G82*100)}} %
Year 5 {{round2(((I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))*12)/G86*100)}} %
Year 10 {{round2(((I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))*12)/G91*100)}} %
Year 25 {{round2(((I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))*12)/G106*100)}} %

Annual Return

Year 1 {{round2( ((I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12 -V88*12)/R82*100 )}} %
Year 5 {{round2( ((I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))*12 -V88*12)/R82*100 )}} %
Year 10 {{round2( ((I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))*12 -V88*12)/R82*100 )}} %
Year 25 {{round2( ((I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))*12 -V88*12)/R82*100 )}} %

Years to Recover Outlay

Year 1 {{round2( R82/((I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12 -V88*12) )}}
Year 5 {{round2( R82/((I86-((K86/12)+(G86*D8/12)+(O86/12)+(M86/12)))*12 -V88*12) )}}
Year 10 {{round2( R82/((I91-((K91/12)+(G91*D8/12)+(O91/12)+(M91/12)))*12 -V88*12) )}}
Year 25 {{round2( R82/((I106-((K106/12)+(G106*D8/12)+(O106/12)+(M106/12)))*12 -V88*12) )}}

Enter Desired CAP Rate

%
$ {{round2( ((I82-((K82/12)+(G82*D8/12)+(O82/12)+(M82/12)))*12)/ (C78/100) )}}
{{X}}