 |
Cash Flow Table
Once
relevant land development components are entered to the LDM input page,
several model output tables are generated. The cash flow table provides annual projections of cash flow on a calendar year basis. Simply click on the links or page tabs on
the LDM input page to activate the tables and schedules.
| |
|
|
|
|
|
|
|
|
| |
|
|
CASH
FLOW
TABLE |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
|
|
|
|
|
|
|
|
|
|
| Beginning
Cash Balance |
|
-$16,094 |
$84,038 |
$233,617 |
$1,296,410 |
|
|
|
|
|
|
|
|
|
|
|
|
| Gross
Revenue |
$290,000 |
$1,740,000 |
$1,761,000 |
$1,776,000 |
$518,000 |
|
|
|
|
|
|
|
|
|
|
|
|
| Loan
Reduction |
$246,500 |
$1,479,000 |
$1,496,850 |
$627,575 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales/Closing
Costs |
$11,600 |
$69,600 |
$70,440 |
$71,040 |
$20,720 |
|
|
|
|
|
|
|
|
|
|
|
|
| Interest
Paid |
$47,994 |
$91,268 |
$44,131 |
$14,592 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash
Flow Before Return of Equity |
-$16,094 |
$84,038 |
$233,617 |
$1,296,410 |
$1,793,690 |
|
|
|
|
|
|
|
|
|
|
|
|
| Return
of Equity |
|
|
|
|
$245,075 |
|
|
|
|
|
|
|
|
|
|
|
|
| Cash
Flow Before Tax |
-$16,094 |
$84,038 |
$233,617 |
$1,296,410 |
$1,548,615
|
|
|
|
|
|
|
|
|
|
|
|
|
Land Development Model, LLC 302 West Lafayette Road Medina, OH 44256 330.441.1690
|