Before Tax Cash Flow Projection --- The Pillars
Before Tax Cash Flow Projection
The Pillars


Time
Investment
and Sale
Effective
Income
Operating
Expense
Cash Flow
Before Debt
Debt
Service
Cash Flow
Before Tax
Buy (1,203,000) 0 0 (1,203,000) 900,000 (303,000)
2015 0 124,618 (39,894) 84,724 (63,136) 21,589
2016 0 132,095 (40,941) 91,154 (63,136) 28,019
2017 0 140,021 (42,024) 97,997 (63,136) 34,861
2018 0 148,422 (43,145) 105,278 (63,136) 42,142
2019 0 157,328 (44,304) 113,023 (63,136) 49,888
Sell 1,307,661 0 0 1,307,661 (797,221) 510,440
Total 104,661 702,485 (210,308) 596,839 (212,900) 383,938


Rate of Return Before Debt (IRR) 9.9%
Rate of Return Before Tax (IRR) 20.9%
Net Present Value Before Debt @10% (5,116)
Net Present Value Before Tax @10% 148,762


     

Taxable Income Projection --- The Pillars
Taxable Income Projection
The Pillars


Time
Taxable
Revenue
Taxable
Expense
Interest
Expense
Depre-
ciation
Ordinary
Income
Buy 0 0 0 0 0
2015 124,618 (39,894) (44,579) (33,455) 6,691
2016 132,095 (40,941) (43,629) (34,909) 12,616
2017 140,021 (42,024) (42,631) (34,909) 20,457
2018 148,422 (43,145) (41,582) (34,909) 28,787
2019 157,328 (44,304) (40,479) (33,455) 39,090
Sell 0 0 0 0 0
Total 702,485 (210,308) (212,900) (171,636) 107,641


     

After Tax Cash Flow Projection --- The Pillars
After Tax Cash Flow Projection
The Pillars


Time
Cash Flow
Before Tax
Ordinary
Income
Capital
Gains
Taxable
Income

Taxes
Cash Flow
After Tax
Buy (303,000) 0 0 0 0 (303,000)
2015 21,589 6,691 0 6,691 (2,342) 19,247
2016 28,019 12,616 0 12,616 (4,416) 23,603
2017 34,861 20,457 0 20,457 (7,160) 27,701
2018 42,142 28,787 0 28,787 (10,075) 32,067
2019 49,888 39,090 0 39,090 (13,681) 36,206
Sell 510,440 0 276,298 276,298 (58,608) 451,832
Total 383,938 107,641 276,298 383,938 (96,283) 287,656


Rate of Return Before Tax (IRR) 20.9%
Rate of Return After Tax (IRR) 16.5%
Net Present Value Before Tax @10% 148,762
Net Present Value After Tax @10% 84,629


     
David Parker
David Parker
Broker/Owner