| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | NORTH EUSTIS MEDICAL PLAZA — MODEL ASSUMPTIONS | |||||||||||||||||||||||||
2 | Blue-font cells are editable inputs. The base case assumes separately platted fee-simple bays, refundable reservations before final plat recordation, binding purchase contracts in Month 13, and a private equity raise to acquire the land and fund pre-loan development costs. | |||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | PROJECT DATA | |||||||||||||||||||||||||
5 | Assumption | Value | Units | Source / Comment | ||||||||||||||||||||||
6 | Project Name | North Eustis Medical Plaza | User-provided | |||||||||||||||||||||||
7 | Model Start Date | 08/01/2026 | date | Preliminary; editable | ||||||||||||||||||||||
8 | Construction / Hold Period | 24 | months | Two-year development period | ||||||||||||||||||||||
9 | Gross Building Area | 37,500 | GSF | User-provided | ||||||||||||||||||||||
10 | Rentable / Sellable Efficiency | 99.0% | % | User-provided | ||||||||||||||||||||||
11 | Rentable / Sellable Area | 37,125 | SF | Gross SF × efficiency | ||||||||||||||||||||||
12 | Building Type | Class A Medical Office — separately platted fee-simple bays | Confirmed structure | |||||||||||||||||||||||
13 | Parking Spaces | 130 | spaces | Site Plan C1 | ||||||||||||||||||||||
14 | Parking Ratio | 3.50 | spaces / 1,000 SF | Parking spaces ÷ sellable SF × 1,000 | ||||||||||||||||||||||
15 | ||||||||||||||||||||||||||
16 | SALES, PLATTING & DEPOSIT ASSUMPTIONS | |||||||||||||||||||||||||
17 | Assumption | Value | Units | Source / Comment | ||||||||||||||||||||||
18 | Sale Price | $550.00 | $ / sellable SF | Target pricing assumption | ||||||||||||||||||||||
19 | Gross Sellout | $20,418,750 | $ | Sellable SF × sale price | ||||||||||||||||||||||
20 | Refundable Reservation Target | 100.0% | % of sellable SF | Months 1–12; no project cash assumed | ||||||||||||||||||||||
21 | Binding Contract Deposit | 30.0% | % of purchase price | Collected after final plat recordation | ||||||||||||||||||||||
22 | Restricted Deposit Portion | 10.0% | % of purchase price | Held restricted until closing | ||||||||||||||||||||||
23 | Usable Deposit Portion | 20.0% | % of purchase price | Potentially available for qualifying project costs; counsel/lender to confirm | ||||||||||||||||||||||
24 | Balance Due at Closing | 70.0% | % of purchase price | 1 − binding contract deposit | ||||||||||||||||||||||
25 | Broker Commission | 5.0% | % of gross sales | Paid at unit closings | ||||||||||||||||||||||
26 | Other Sales Closing Costs | - | % of gross sales | Editable placeholder | ||||||||||||||||||||||
27 | ||||||||||||||||||||||||||
28 | PROJECT COST & CONSTRUCTION LOAN ASSUMPTIONS | |||||||||||||||||||||||||
29 | Assumption | Value | Units | Source / Comment | ||||||||||||||||||||||
30 | Shell Construction Cost | $185.00 | $ / GSF | Construction budget basis | ||||||||||||||||||||||
31 | Hard Cost Contingency | 10.0% | % of hard-cost subtotal | Original budget assumption | ||||||||||||||||||||||
32 | Development Fee | 5.0% | % of hard costs total | Sponsor/developer fee for entitlement, design, financing, sales coordination and overall development | ||||||||||||||||||||||
33 | Sponsor Co-Invest | - | $ | Editable; PPM investors fund base-case equity requirement | ||||||||||||||||||||||
34 | Construction Loan Commitment | $7,500,000 | $ | Preliminary; model calculates maximum required balance | ||||||||||||||||||||||
35 | Construction Loan Interest Rate | 7.5% | % annually | User assumption | ||||||||||||||||||||||
36 | Loan Origination Fee | 1.0% | % of commitment | Preliminary | ||||||||||||||||||||||
37 | Construction Loan Closing Month | 13 | month number | Construction financing closes after the shovel-ready milestone | ||||||||||||||||||||||
38 | Annual Property Tax Carry | $126,092.97 | $ / year | User analysis; confirm assessed value and timing | ||||||||||||||||||||||
39 | Construction Management Fee | 2.0% | % of hard costs total | Owner-side construction administration; separate from GC overhead and profit | ||||||||||||||||||||||
40 | PPM, PLATTING & INVESTOR RETURN ASSUMPTIONS | |||||||||||||||||||||||||
41 | Assumption | Value | Units | Source / Comment | ||||||||||||||||||||||
42 | PPM Launch Month | 1 | month number | August 2026; offering documents assumed ready and marketing begins | ||||||||||||||||||||||
43 | Final Plat Recordation Month | 12 | month number | Final plat recordation included in the 12-month shovel-ready target | ||||||||||||||||||||||
44 | Binding Contract / Deposit Month | 13 | month number | Binding contracts and deposits begin after recordation | ||||||||||||||||||||||
45 | Scheduled Unit Closing Month | 24 | month number | Assumes CO and deed closings at project completion | ||||||||||||||||||||||
46 | PPM Legal, Offering & Administration Costs | $100,000 | $ | Placeholder — securities counsel to confirm | ||||||||||||||||||||||
47 | PPM Working Capital Reserve | $100,000 | $ | Liquidity buffer included in equity target | ||||||||||||||||||||||
48 | Placement Agent / Capital-Raising Fee | 7.5% | % of gross PPM raise | Base case; pay only through a properly registered broker-dealer / placement agent | ||||||||||||||||||||||
49 | Investor Preferred Return | 8.0% | % annually | Illustrative; final PPM and operating agreement control | ||||||||||||||||||||||
50 | GP Promote / Residual Profit Share | 20.0% | % of residual profit | After return of investor capital and preferred return | ||||||||||||||||||||||
51 | Proposed Securities Exemption | Rule 506(c) — counsel to confirm | General solicitation only if all purchasers are accredited and status is verified | |||||||||||||||||||||||
52 | Investor Marketing / Digital Lead Generation | $100,000 | $ | Website, creative, compliant digital campaigns and investor materials | ||||||||||||||||||||||
53 | Hotel Presentations / Investor Roadshows | $50,000 | $ | Venue, audiovisual, catering and presentation costs | ||||||||||||||||||||||
54 | Domestic & Foreign Investor Travel | $50,000 | $ | Investor meetings and travel; foreign offering laws require counsel review | ||||||||||||||||||||||
55 | Investor Residual Profit Share | 80.0% | % of residual profit | Formula: 1 − GP promote | ||||||||||||||||||||||
56 | Placement Fee — Low Case | 5.0% | % of gross raise | Sensitivity only | ||||||||||||||||||||||
57 | Placement Fee — High Case | 10.0% | % of gross raise | Sensitivity only | ||||||||||||||||||||||
58 | Fundraising Period | 6 | months | August 2026 through January 2027 | ||||||||||||||||||||||
59 | Construction Loan Closing Month | 13 | month number | After the 12-month shovel-ready period | ||||||||||||||||||||||
60 | Minimum Offering Amount | - | $ | Best-efforts rolling closes; counsel to confirm | ||||||||||||||||||||||
61 | Use of Offering Proceeds | Immediately after each rolling closing | Entitlements, design, permitting, legal, marketing, land closing and disclosed development expenses | |||||||||||||||||||||||
62 | Minimum Fixed Cash Reserve | - | $ | Dynamic entitlement reserve is calculated separately | ||||||||||||||||||||||
63 | Fundraising Structure | Best efforts; rolling closings — counsel to confirm | Accepted subscriptions are released periodically rather than waiting for the full raise | |||||||||||||||||||||||
64 | Gross PPM Maximum Offering | $4,500,000 | $ | Editable base-case maximum offering | ||||||||||||||||||||||
65 | Land Seller Entity | Related-Party Land Seller LLC | Company owned by Johann Puruncajas and partner; replace with exact legal name | |||||||||||||||||||||||
66 | Title Transfer / Seller Note Month | 1 | month number | Title transfers early to provide the project and investors direct ownership security | ||||||||||||||||||||||
67 | Land Seller Note Principal | $3,000,000 | $ | Fixed related-party land purchase price | ||||||||||||||||||||||
68 | Land Seller Note Interest Rate | - | % annually | User instruction: no interest in base case | ||||||||||||||||||||||
69 | Land Closing Costs | $45,000 | $ | Estimated closing, title and recording costs | ||||||||||||||||||||||
70 | Entitlement Liquidity Reserve | 3 | months of forecast costs | Before paying the seller note, preserve near-term shovel-ready expenses | ||||||||||||||||||||||
71 | Seller Note Payoff Required at Construction Loan Closing | - | % of outstanding balance | Base case assumes subordination rather than mandatory payoff | ||||||||||||||||||||||
72 | Seller Note Payoff from Final Unit Closings | 100.0% | % of remaining balance | Paid after construction-loan repayment and before equity distributions | ||||||||||||||||||||||
73 | Construction-Lender Collateral | Seller note subordinated; designated unsold units may be pledged if required | Informational assumption; lender and counsel to finalize | |||||||||||||||||||||||
74 | Development Fee Earned During Shovel-Ready Period | 50.0% | % of total development fee | Remaining 50% paid during construction | ||||||||||||||||||||||
75 | Sales Marketing Spent During Shovel-Ready Period | 50.0% | % of project marketing budget | Remaining 50% spent during construction and unit sales | ||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||