Prepare and maintain detailed Excel-based financial models to evaluate property-level and loan-level cash flows, rent roll assumptions, lease-up timing, capital expenditures, debt service, loan sizing, pricing, debt yield, debt service coverage, loan-to-value, and other key credit metrics. Use Argus Enterprise to review, build, and sensitize property-level cash flows assumptions, including market rent, contractual rent steps, downtime, renewal probability, tenant improvement allowances, leasing commissions, expense reimbursements, recoveries, and terminal valuation assumptions.