Cash Flow Report
Cash Flow Report
Cash Flow Report
Example Project
1234 N. Main St, Kansas City, MO 64116
$4,000
CFBD CFAD
CASH FLOW FROM SALE $295,300
Year 0 Year 1
Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15
Acquisition Refinance
Rental Operation
Gross Operating Income $13,750 $13,888 $14,026 $14,167 $14,308 $14,451 $14,596 $14,742 $14,889 $15,038 $15,189 $15,340 $15,494 $15,649 $15,805
-Less Gross Operating Expenses -$6,500 -$6,565 -$6,631 -$6,697 -$6,764 -$6,832 -$6,900 -$6,969 -$7,039 -$7,109 -$7,180 -$7,252 -$7,324 -$7,398 -$7,472
Net Operating Income $7,250 $7,323 $7,396 $7,470 $7,544 $7,620 $7,696 $7,773 $7,851 $7,929 $8,009 $8,089 $8,169 $8,251 $8,334
Financing
Cash Flow Before Debt $7,250 $7,323 $7,396 $7,470 $7,544 $7,620 $7,696 $7,773 $7,851 $7,929 $8,009 $8,089 $8,169 $8,251 $8,334
-Less Debt Service -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473
Cash Flow After Debt -$223 -$150 -$77 -$3 $72 $147 $223 $300 $378 $457 $536 $616 $697 $779 $861
Levered COCR -0.5% -0.3% -0.2% 0.0% 0.2% 0.3% 0.5% 0.7% 0.9% 1.1% 1.2% 1.4% 1.6% 1.8% 2.0%
Cash Flow from Operations $0 -$223 -$150 -$77 -$3 $72 $147 $223 $300 $378 $457 $536 $616 $697 $779 $861
Total Cash Flow -$88,070 $44,377 -$150 -$77 -$3 $72 $147 $223 $300 $378 $457 $536 $616 $697 $779 $861
Total Cash Position -$88,070 -$43,693 -$43,843 -$43,919 -$43,922 -$43,850 -$43,703 -$43,480 -$43,179 -$42,801 -$42,345 -$41,809 -$41,193 -$40,496 -$39,717 -$38,856
Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Year 26 Year 27 Year 28 Year 29 Year 30
Rental Operation
Gross Operating Income $15,963 $16,123 $16,284 $16,447 $16,611 $16,778 $16,945 $17,115 $17,286 $17,459 $17,633 $17,810 $17,988 $18,168 $18,349
-Less Gross Operating Expenses -$7,546 -$7,622 -$7,698 -$7,775 -$7,853 -$7,931 -$8,011 -$8,091 -$8,172 -$8,253 -$8,336 -$8,419 -$8,503 -$8,588 -$8,674
Net Operating Income $8,417 $8,501 $8,586 $8,672 $8,759 $8,846 $8,935 $9,024 $9,114 $9,206 $9,298 $9,391 $9,485 $9,579 $9,675
Financing
Cash Flow Before Debt $8,417 $8,501 $8,586 $8,672 $8,759 $8,846 $8,935 $9,024 $9,114 $9,206 $9,298 $9,391 $9,485 $9,579 $9,675
-Less Debt Service -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473 -$7,473
Cash Flow After Debt $944 $1,029 $1,114 $1,200 $1,286 $1,374 $1,462 $1,552 $1,642 $1,733 $1,825 $1,918 $2,012 $2,107 $2,203
Levered COCR 2.2% 2.4% 2.6% 2.8% 3.0% 3.2% 3.4% 3.6% 3.8% 4.0% 4.2% 4.4% 4.6% 4.8% 5.1%
Cash Flow from Operations $0 $944 $1,029 $1,114 $1,200 $1,286 $1,374 $1,462 $1,552 $1,642 $1,733 $1,825 $1,918 $2,012 $2,107 $2,203
Total Cash Flow $944 $1,029 $1,114 $1,200 $1,286 $1,374 $1,462 $1,552 $1,642 $1,733 $1,825 $1,918 $2,012 $2,107 $252,902
Total Cash Position -$38,856 -$37,911 $1,029 $1,114 $1,200 $1,286 $1,374 $1,462 $1,552 $1,642 $1,733 $1,825 $1,918 $2,012 $2,107 $252,902