| PUERTO ITURBE LLC - START UP | |||||||||||||
| INITIAL STARTUP COSTS | |||||||||||||
| CASH: | |||||||||||||
| PURCHASES: | |||||||||||||
| LAND ACQISITION | 0 | ||||||||||||
| Phase 1 | 17,532,500 | ||||||||||||
| Organizational Costs | 10,000 | ||||||||||||
| Working Capital | 2,000,000 | ||||||||||||
| installation of green energy | 2,000,000 | ||||||||||||
| landscaping | 1000000 | ||||||||||||
| city costs/permits | 1,000,000 | ||||||||||||
| HARBOR | 1,300,000 | ||||||||||||
| Machinery | 1,438,000 | ||||||||||||
| campesinos | 695,000 | ||||||||||||
| total | 26,975,500 | ||||||||||||
| OVERHEAD | |||||||||||||
| top management | 1,080,000 | ||||||||||||
| utilities | 0 | ||||||||||||
| TOTAL OVERHEAD | $1,080,000.00 | ||||||||||||
| Start-Up Purchases: | 28,055,500 | ||||||||||||
| SALES | |||||||||||||
| 26 condos/casitas | 15,912,000 | ||||||||||||
| 30 mid grade | 15,300,000 | ||||||||||||
| 70 economy | 28,560,000 | ||||||||||||
| TOTAL SALES | $59,772,000.00 | ||||||||||||
| TOTAL PROFIT | $31,716,500.00 | ||||||||||||
| MONTH | Jan | Feb | Mar | Apr | May | June | July | Aug | SEPT | Oct | Nov | Dec | |
| events | deal closes | loan/finances | permits/team | permits/finances/team | permitting and start-up overhead | permitting and start-up overhead | permitting and start-up overhead | permitting and start-up overhead | construction starts | ||||
| Revenue | |||||||||||||
| 0 | |||||||||||||
| Total Revenue: | |||||||||||||
| Cost of Goods Sold | |||||||||||||
| Cost of Goods Sold | |||||||||||||
| Subtotal: | |||||||||||||
| Net Sales | |||||||||||||
| Expenses | |||||||||||||
| Loan Payback | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| construction | $1,000,000 | $500,000 | $500,000 | $1,500,000 | $1,500,000 | $1,000,000 | $1,000,000 | $1,000,000 | $8,000,000 | ||||
| Salaries Top Execs | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 540,000 |
| energy | 50,000 | 1,550,000 | |||||||||||
| Payroll Taxes and Benefits | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 66,960 |
| Utilities | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Organizational Costs | 10,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10,000 | ||
| Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Travel | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 24,000 | ||||
| Office Supplies | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 1,400 | ||||
| Accounting & Legal | 0 | 0 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 1,600 | ||
| Misc. Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 250 | 350 |
| Marketing | 20,000 | 20,000 | 20,000 | 20,000 | 600,000 | 20,000 | 20,000 | 20,000 | 740,000 | ||||
| Depreciation | 11,042 | 11,042 | 20,417 | 20,417 | 20,417 | 29,792 | 29,792 | 29,792 | 172,711 | ||||
| Total: | $60,580 | $50,580 | $50,580 | $50,580 | $1,084,997 | $584,997 | $594,372 | $1,644,372 | $3,724,372 | $1,103,747 | $1,103,847 | $1,103,997 | $9,557,021 |
| Net Profit | ($60,580) | ($50,580) | ($50,580) | ($50,580) | ($1,084,997) | ($584,997) | ($594,372) | ($1,644,372) | ($3,724,372) | ($1,103,747) | ($1,103,847) | ($1,103,997) | ($9,557,021) |
| Project Puerto Iturbe. - Year 2 Monthly Breakdown | |||||||||||||
| MONTH | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL |
| Revenue | |||||||||||||
| 0 | |||||||||||||
| sales of time shares | 0 | ||||||||||||
| Total Revenue: | $0 | $0 | $0 | $5,000,000 | $5,000,000 | $8,000,000 | $8,000,000 | $8,000,000 | $8,000,000 | $8,000,000 | $9,772,000 | $59,772,000 | |
| Cost of Goods Sold | |||||||||||||
| Cost of Goods Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Subtotal: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Sales | $0 | $0 | $0 | $0 | $5,000,000 | $5,000,000 | $8,000,000 | $8,000,000 | $8,000,000 | $8,000,000 | $8,000,000 | $9,772,000 | $59,772,000 |
| Expenses | |||||||||||||
| Salaries & Wages | |||||||||||||
| Payroll Taxes and Benefits | |||||||||||||
| Utilities | |||||||||||||
| Communications | |||||||||||||
| Insurance | |||||||||||||
| construction | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | $1,500,000 | $2,555,550 | $1,500,000 | $1,500,000 | $1,500,000 | $2,500,000 | $3,000,000 | $2,000,000 | 20,055,550 |
| Salaries Top Execs | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 540,000 |
| Office Supplies | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 2,100 |
| Accounting & Legal | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2,400 |
| Misc. Expenses | |||||||||||||
| Marketing | 600,000 | 400,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 20,000 | 20,000 | 20000 | 20000 | 1,330,000 | |
| Depreciation | |||||||||||||
| Total: | $1,645,375 | $1,445,375 | $1,095,375 | $1,095,375 | $1,595,375 | $2,650,925 | $1,595,375 | $1,565,375 | $1,565,375 | $2,565,375 | $3,065,375 | $2,045,375 | $21,930,050 |
| Net Profit | ($1,645,375) | ($1,445,375) | ($1,095,375) | ($1,095,375) | $3,404,625 | $2,349,075 | $6,404,625 | $6,434,625 | $6,434,625 | $5,434,625 | $4,934,625 | $7,726,625 | $37,841,950 |
| INITIAL STARTUP COSTS – Phase 2 | |||||||||||||
| CASH: | |||||||||||||
| PURCHASES: | |||||||||||||
| Land Acquisition | 0 | ||||||||||||
| Phase 2 | 33,661,500 | ||||||||||||
| Organizational Costs | 0 | ||||||||||||
| Working Capital | 2,000,000 | ||||||||||||
| Installation of green energy | 0 | ||||||||||||
| Landscaping | 1500000 | ||||||||||||
| City costs/permits | 1,000,000 | ||||||||||||
| Harbor | 0 | ||||||||||||
| total | 38,161,500 | ||||||||||||
| OVERHEAD | |||||||||||||
| top management | 1,080,000 | ||||||||||||
| utilities | 0 | ||||||||||||
| TOTAL OVERHEAD | $1,080,000.00 | ||||||||||||
| Start-Up Purchases: | 39,241,500 | ||||||||||||
| SALES | |||||||||||||
| condos/casitas | 33,048,000 | ||||||||||||
| mid grade | 25,500,000 | ||||||||||||
| economy | 44,880,000 | ||||||||||||
| TOTAL SALES | $103,428,000.00 | ||||||||||||
| TOTAL PROFIT | $64,186,500.00 | ||||||||||||
| Total sq. ft. of buildings (all phases) | 371800 | ||||||||||||
| Project Puerto Iturbe. - Year 3 Monthly Breakdown | |||||||||||||
| MONTH | Jan | Feb | Mar | Apr | May | June | July | Aug | SEPT | Oct | Nov | Dec | |
| events | construction starts | construction | construction | construction | construction | construction | construction | construction | construction | construction | construction | construction | |
| Revenue | |||||||||||||
| 0 | |||||||||||||
| sales of time shares | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | |||||
| Total Revenue: | $0 | $0 | $0 | $0 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | $41,371,200 |
| Cost of Goods Sold | |||||||||||||
| Cost of Goods Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Subtotal: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Sales | $0 | $0 | $0 | $0 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $41,371,200 |
| Loan Payback | $0 | $0 | $0 | $0 | |||||||||
| construction | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $1,635,062 | $19,620,744 |
| Salaries Top Execs | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 540,000 |
| energy | 50,000 | 1,550,000 | |||||||||||
| Payroll Taxes and Benefits | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 5,580 | 66,960 |
| Utilities | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Organizational Costs | 10,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10,000 | ||
| Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Travel | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 36,000 |
| Office Supplies | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 2,100 |
| Accounting & Legal | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2,400 |
| Misc. Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 250 | 350 |
| Marketing | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 300,000 | 20,000 | 20,000 | 20,000 | 520,000 |
| Depreciation | 0 | ||||||||||||
| Total: | $83,955 | $73,955 | $73,955 | $73,955 | $1,709,017 | $1,709,017 | $1,709,017 | $1,759,017 | $3,539,017 | $1,709,017 | $1,709,117 | $1,709,267 | $20,798,554 |
| Net Profit | ($83,955) | ($73,955) | ($73,955) | ($73,955) | $3,462,383 | $3,462,383 | $3,462,383 | $3,412,383 | $1,632,383 | $3,462,383 | $3,462,283 | $3,462,133 | $20,572,646 |
| Project Puerto Iturbe. - Year 4 Monthly Breakdown | |||||||||||||
| MONTH | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL |
| Revenue | |||||||||||||
| 0 | |||||||||||||
| sales of time shares | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 62,056,800 |
| Total Revenue: | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | 5,171,400 | $62,056,800 |
| Cost of Goods Sold | |||||||||||||
| Cost of Goods Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Subtotal: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Net Sales | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $5,171,400 | $62,056,800 |
| Expenses | |||||||||||||
| Salaries & Wages | |||||||||||||
| Payroll Taxes and Benefits | |||||||||||||
| Utilities | |||||||||||||
| Communications | |||||||||||||
| Insurance | |||||||||||||
| construction | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 1,635,063 | 19,620,756 |
| Salaries Top Execs | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 540,000 |
| Office Supplies | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 175 | 2,100 |
| Accounting & Legal | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2,400 |
| Misc. Expenses | |||||||||||||
| Marketing | 600,000 | 400,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 20,000 | 20,000 | 20000 | 20000 | 1,330,000 | |
| Depreciation | |||||||||||||
| Total: | $2,280,438 | $2,080,438 | $1,730,438 | $1,730,438 | $1,730,438 | $1,730,438 | $1,730,438 | $1,700,438 | $1,700,438 | $1,700,438 | $1,700,438 | $1,680,438 | $21,495,256 |
| Net Profit | $2,890,962 | $3,090,962 | $3,440,962 | $3,440,962 | $3,440,962 | $3,440,962 | $3,440,962 | $3,470,962 | $3,470,962 | $3,470,962 | $3,470,962 | $3,490,962 | $40,561,544 |
| Project Details and Financial Assumptions: | |||||||||||||
| Phase 1 - 11 luxury suites + 15 casitas (12,000/wk.)~ 30 mid-grade rooms (10,000/wk.) ~70 basic rooms (8,000/wk.) | |||||||||||||
| All Phases - 40 luxury suites + 40 casitas (12,000/wk.)~ 80 mid-grade rooms (10,000/wk.) ~180 basic rooms (8,000/wk.) | |||||||||||||
| Sales based on 51 weeks a year with one week for maintenance | |||||||||||||
| we will always consider our impact on the environment and social responsibility over profit. (These projections already account for this.) | |||||||||||||
| Event rooms can also be converted to conference rooms and will vary in size.. *sq. ft. of each is an average of all | |||||||||||||
| A small percentage of mid-grade rooms will be able to be combined with standard and luxury suites to form bigger rooms. | |||||||||||||
| High end suites will include a view deck, full kitchens, and water features. | |||||||||||||
| Revenue: | |||||||||||||
| Projections based on selling out time shares/ not hotel | |||||||||||||
| We will offer a 3 day rescison period on purchased time shares for transparency reasons. | |||||||||||||
| We will also offer starter packages which will be for a week every other year to customers. | |||||||||||||
| We will link up with other resort cooperatives if needed. | |||||||||||||
| We will offer financing for our prospective customers. | |||||||||||||
| Pre-sales is in form of an interest bearing refundable down payment to be put in escrow, due upon project completion. | |||||||||||||
| Expenses: | |||||||||||||
| All expenses past project completion such as: insurance, maintenance, H.O.A., taxes, etc.. will be covered by time share owners | |||||||||||||
| The destination resort will initially invest in infrastructure for the campesinos to feed the resort. This will be a separate entity ran by the campesinos | |||||||||||||
| All top executives for project will be payed 60,000/yr and have travel covered. | |||||||||||||
| The following expenses are estimated to increase at regional market average of 5%: Office Suppies, Legal & Accounting, and Misc. Expenses. | |||||||||||||
| The following expenses are estimated to increase at regional market average of 3%: Communications | |||||||||||||
| The following expenses are estimated to remain constant due to contracts or managerial budget constraints: Insurance, and Travel. | |||||||||||||
| Operating capital after all sales of time shares are final will be covered by Puerto Iturbe Trust, sources of revenue include hotel, restraunt, and club membership. | |||||||||||||
| Depreciation & Amortization | |||||||||||||
| Resort Construction and Equipment are depreciated utilizing S/L Method over a period of 40 year. | |||||||||||||
| Organizational Costs are amortized utilizing S/L method over a period of 40 years. | |||||||||||||
| Payback: | |||||||||||||
| Payback period of 3-6 years with 35% of profits going to investor. | |||||||||||||
| Willing to re-finance land mixed with capital upon projects initiation. | |||||||||||||
| Investment fully backed by land and improvements to eliminate risk | |||||||||||||
| High Density | # OF ROOMS | sq. ft each | total sq ft | price per sq ft | TOTAL COST | ||||||||
| SUITES | 11 | 1100 | 12,100 | 145 | 1754500 | ||||||||
| MID GRADE | 30 | 850 | 25,500 | 135 | 3442500 | ||||||||
| STANDARD | 70 | 750 | 52,500 | 135 | 7087500 | ||||||||
| restraunt | 3000 | 3,000 | 210 | 630000 | |||||||||
| hotel | 100 | 400 | 0 | 135 | 0 | ||||||||
| other businesses | 6 | 1000 | 6,000 | 125 | 750000 | ||||||||
| lounge rooms | 4 | 300 | 0 | 80 | 0 | ||||||||
| kitchen and utility | 1 | 1200 | 1200 | 210 | 252000 | ||||||||
| water park indoor | 0 | 600 | 0 | ||||||||||
| water park outdoor and pools | 0 | 500 | 0 | ||||||||||
| indoor event center | 4,000 | 125 | 500000 | ||||||||||
| outdoor event center | 2000 | 40 | 80000 | ||||||||||
| event rooms | 6 | 350 | 0 | 100 | 0 | ||||||||
| beachfront huts,etc… | 20 acres | 100,000 | |||||||||||
| spa and healing center | 5000 | 185 | 925000 | ||||||||||
| gift,rental, and tour shop | 800 | 120 | 96000 | ||||||||||
| tennis | 20,000 | ||||||||||||
| raquetball gym | 2000 | 220 | 440000 | ||||||||||
| conference center | 2 | 2000 | 0 | 100 | 0 | ||||||||
| market | 1 | 4000 | 0 | 80 | 0 | ||||||||
| internet cafe | 1 | 1000 | 1000 | 135 | 135000 | ||||||||
| casitas | 15 | 800 | 12000 | 110 | 1320000 | ||||||||
| total | 127100 | 17532500 | |||||||||||
| total sq ft including height | |||||||||||||
| total cost ext walls aac | |||||||||||||
| aac prices calculated on $4/sq. ft - average wall height of 12' - exterior walls only calculated | |||||||||||||
| Phase 1 consists of a 90,000 sq. ft. resort living quarters, one indoor event center, one outdoor event center, a gym, a 5,000 sq. ft. spa/healing center, a restruant, and | |||||||||||||
| 30,000 more sq. ft. of mixed use indoor space. It also Includes power, a harbor, and $1,000,000 in landscaping and orchards. | |||||||||||||
| Phase 1 will also include all organizational costs and any others necessary at this point relating to the project. | |||||||||||||
| Top Executives (for 2 years) | 1080000 | ||||||||||||
| Machinery | 1438000 | ||||||||||||
| Total Extras | 2518000 | ||||||||||||
| starting capital | TOTAL | ||||||||||||
| campesinos | |||||||||||||
| 20,000 septic | 55,000 energy | 20,000 water | 100,000 equipment and material | 100,000 greenhouse | |||||||||
| 300,000 main lodge | 695,000 | ||||||||||||
| top execs | |||||||||||||
| Ramon Iturbe | 60,000 | ||||||||||||
| Raquel Iturbe | 60,000 | ||||||||||||
| Josh Pasmore | 60,000 | ||||||||||||
| Jim Burghorn | 60,000 | ||||||||||||
| david | 60,000 | ||||||||||||
| Mohsen | 60,000 | ||||||||||||
| mark kaski | 60,000 | ||||||||||||
| ?? | 60,000 | ||||||||||||
| ?? | 60,000 | ||||||||||||
| total per year | 540,000 | ||||||||||||
| machinery for D.R. | |||||||||||||
| 3 backhoes | 300,000 | ||||||||||||
| 6 booms | 320,000 | ||||||||||||
| 3 dumptrucks | 285,000 | ||||||||||||
| 3 bobcats | 33,000 | ||||||||||||
| misc | 500,000 | ||||||||||||
| total | 1,438,000 | ||||||||||||
| depreciation | |||||||||||||
| may | 0 | start of construction | |||||||||||
| june | |||||||||||||
| july | |||||||||||||
| aug | |||||||||||||
| sept | |||||||||||||
| oct | |||||||||||||
| nov | |||||||||||||
| dec | |||||||||||||
| starts yr 2 march | |||||||||||||
| apr | |||||||||||||
| may | |||||||||||||
| june | |||||||||||||
| july | |||||||||||||
| aug | 81699 | based on 50,000,000 | |||||||||||
| sept | 81699 | ||||||||||||
| nov | 81699 | ||||||||||||
| dec | 81699 | ||||||||||||
| 81699 | |||||||||||||
| Yr 3 | 81699 | ||||||||||||
| jan | 81699 | ||||||||||||
| feb | 81699 | ||||||||||||
| mar | 81699 | ||||||||||||
| apr | 81699 | ||||||||||||
| may | 81699 | ||||||||||||
| june | 81699 | ||||||||||||
| july | 81699 | ||||||||||||
| aug | 81699 | ||||||||||||
| sept | 81699 | ||||||||||||
| oct | 81699 | ||||||||||||
| nov | 81699 | ||||||||||||
| dec | 81699 | ||||||||||||
| Total | 980388 | ||||||||||||