NPV of Rental Payments

profiletom1622
ProceedsValue.xlsx

Example

Scenario Scenario Scenario Scenario
NUMBER 1 NUMBER 2 NUMBER 3 NUMBER 4
Proceeds From Sale of Lot ( Taco Bell ) 2,100,000.00 2,100,000.00 2,100,000.00 2,100,000.00
Less: Capital Gain Taxes 441,000.00 441,000.00 441,000.00 441,000.00
Net Proceeds 1,659,000.00 1,659,000.00 1,659,000.00 1,659,000.00
- - 0 - 0 - 0
5,000.00 5,000.00 5,000.00 5,000.00
Distribution Amount To Each Of
The 36 Unit Owners 10,000.00 15,000.00 20,000.00 25,000.00
Total Cost of Distribution 360,000.00 540,000.00 720,000.00 900,000.00
Balance To Reserve Fund 1,294,000.00 1,114,000.00 934,000.00 754,000.00
Reserve Fund Earnings Per Year
Amount in the Reserve Fund 1,294,000.00 1,114,000.00 934,000.00 754,000.00
Estimated Interest Earned on Reserve Funds 2% 2% 2% 2%
Earnings Applied to Reduction of Condo Fees 25,880.00 22,280.00 18,680.00 15,080.00