Before Tax Cash Flow Projection --- Navajo Professional Building
Before Tax Cash Flow Projection
Navajo Professional Building


Time
Investment
and Sale
Effective
Income
Operating
Expense
Cash Flow
Before Debt
Debt
Service
Cash Flow
Before Tax
Buy (1,087,713) 0 0 (1,087,713) 759,500 (328,213)
2014 0 111,420 (25,176) 86,244 (62,694) 23,550
2015 0 114,763 (25,931) 88,831 (62,694) 26,137
2016 0 118,205 (26,709) 91,496 (62,694) 28,802
2017 0 121,752 (27,510) 94,241 (62,694) 31,547
2018 0 125,404 (28,336) 97,068 (62,694) 34,374
Sell 1,182,343 0 0 1,182,343 (639,408) 542,935
Total 94,631 591,544 (133,663) 552,512 (193,379) 359,133


Rate of Return Before Debt (IRR) 10.2%
Rate of Return Before Tax (IRR) 18.4%
Net Present Value Before Debt @10% 8,615
Net Present Value Before Tax @10% 121,739


     

Taxable Income Projection --- Navajo Professional Building
Taxable Income Projection
Navajo Professional Building


Time
Taxable
Revenue
Taxable
Expense
Interest
Expense
Depre-
ciation
Ordinary
Income
Buy 0 0 0 0 0
2014 111,420 (25,176) (41,237) (21,329) 23,678
2015 114,763 (25,931) (40,027) (22,256) 26,548
2016 118,205 (26,709) (38,748) (22,256) 30,492
2017 121,752 (27,510) (37,397) (22,256) 34,588
2018 125,404 (28,336) (35,970) (21,329) 39,769
Sell 0 0 0 0 0
Total 591,544 (133,663) (193,379) (109,427) 155,075


     

After Tax Cash Flow Projection --- Navajo Professional Building
After Tax Cash Flow Projection
Navajo Professional Building


Time
Cash Flow
Before Tax
Ordinary
Income
Capital
Gains
Taxable
Income

Taxes
Cash Flow
After Tax
Buy (328,213) 0 0 0 0 (328,213)
2014 23,550 23,678 0 23,678 (8,287) 15,263
2015 26,137 26,548 0 26,548 (9,292) 16,845
2016 28,802 30,492 0 30,492 (10,672) 18,130
2017 31,547 34,588 0 34,588 (12,106) 19,441
2018 34,374 39,769 0 39,769 (13,919) 20,455
Sell 542,935 0 204,058 204,058 (41,551) 501,383
Total 359,133 155,075 204,058 359,133 (95,828) 263,305


Rate of Return Before Tax (IRR) 18.4%
Rate of Return After Tax (IRR) 13.8%
Net Present Value Before Tax @10% 121,739
Net Present Value After Tax @10% 53,836


     
David Parker
David Parker
Broker/Owner