How Clik.ai Supports Agency Underwriting — In a Live Environment
Real examples of how our team collaborates with lender underwriting analysts to populate Fannie Mae and Freddie Mac workbooks — from request to delivery, all within hours.
Comprehensive agency underwriting support
Each deal typically involves populating multiple Excel workbook tabs from third-party reports — appraisals, PCAs, ESAs, zoning, and financial statements.
IE (Income/Expense)
T-12, annual & monthly P&L spreads from borrower financials
Market Analysis
Market data from appraisals and REIS reports
Rent Comps
Comparable rental data from appraisal comparables
Rent Roll
Unit-level tenant data, lease dates, SF, and charges
PNA (Physical Needs)
Capital expenditure data from PCA reports
ESA (Environmental)
Environmental Site Assessment summaries
Zoning
Zoning compliance from third-party zoning reports
Appraisal Tab
Key appraisal data points and valuation summaries
Expense Analysis
Borrower's and appraiser's expense comparables
Sales Comps
Comparable sales data for valuation analysis
Repair Table
Required repairs from property condition assessments
Narrative Tabs
Property manager interviews, market write-ups
Request → Process → Deliver
Below are real anonymized examples from a live agency lending client — showing exactly how the day-to-day collaboration works.
Underwriter emails Clik.ai with workbook tab requests
Analysts email the Clik.ai team directly, specifying which workbook tabs need to be populated and which source documents to use. Reports are shared via a Microsoft Teams channel dedicated to each deal.
All names, property names, and identifying details below have been anonymized. Examples are based on a real live client engagement.
Senior Fannie Mae Underwriting Analyst
Thursday, September 12, 2025 6:48 PM
RE: 415 Maple Ridge - ClikAI Update Request
To: clik.ai team <support@clik.ai>
For 415 Maple Ridge, we received the zoning report, 8/31/2025 T-12 and 9/10/2025 RR, which have been added to the Teams file. Will you update the following tabs in the workbook? Please utilize the 9/12 workbook in the file to complete.
- IE — T-12, monthly & annual
- Zoning Tab
- RR Tab
- Unit SF
- Lease Start & End Dates
- Rent Roll Rent — please use the column titled "Total Charges" for rent roll rent
- Confirm unit bedrooms
Senior Fannie Mae Underwriting Analyst
Charlotte, NC
RE: 415 Maple Ridge - ClikAI Update Request
Workbook RequestSenior Fannie Mae Underwriting Analyst
For 415 Maple Ridge, we received the zoning report, 8/31/2025 T-12 and 9/10/2025 RR, which have been added to the Teams file. Will you update the following tabs in the workbook? Please utilize the 9/12 workbook in the file to complete.
- IE — T-12, monthly & annual
- Zoning Tab
- RR Tab
- Unit SF
- Lease Start & End Dates
- Rent Roll Rent — please use the column titled "Total Charges" for rent roll rent
- Confirm unit bedrooms
Senior Fannie Mae Underwriting Analyst
Charlotte, NC
Files & data are shared through dedicated deal channels
Each deal gets its own Microsoft Teams channel where documents are uploaded and workbooks are exchanged. The Clik.ai team has direct access to process the files.
Uploading all third-party reports for Ridgewood 300. Please use these for the workbook population.
Ridgewood_300_Appraisal_2026.pdf
4.2 MB
Ridgewood_300_PCA_ESA_Zoning.pdf
8.7 MB
Ridgewood_300_UW_Workbook_03-16.xlsx
1.8 MB
Also adding the borrower’s 2024 financial statements and the most recent rent roll dated 3/10/2026. Please use these for the IE and RR tabs.
Ridgewood_300_Borrower_Financials_2024.pdf
2.1 MB
Ridgewood_300_RR_03-10-2026.pdf
890 KB
Hi Jenny — received all files. Working on the 8 tabs now (ExpAnalysis, Market, Rent Comps, Zoning, PNA, Repair Table, ESA, Appraisal). Will update the workbook and save it back here once complete.
Quick update — 5 of 8 tabs complete (ExpAnalysis, Market, Rent Comps, Zoning, PNA). Working on Repair Table, ESA, and Appraisal now. ETA ~2 hours.
✅ Ridgewood 300 workbook is complete. All 8 tabs have been populated and the updated workbook has been saved to the channel files. A few notes on items I flagged during processing — see the Comments tab.
Ridgewood_300_UW_Workbook_03-17_COMPLETE.xlsx
2.4 MB
This looks great, thank you! One quick question — for the Expense Analysis tab, did you use the appraiser’s comps from page 47 or the summary on page 12?
Good question — I used the detailed breakdown from pages 47-49 as it includes per-unit figures. The page 12 summary only has totals. Let me know if you’d prefer the other format.
UW Collaboration
Agency Lending
Uploading all third-party reports for Ridgewood 300. Please use these for the workbook population.
Ridgewood_300_Appraisal_2026.pdf
4.2 MB
Ridgewood_300_PCA_ESA_Zoning.pdf
8.7 MB
Ridgewood_300_UW_Workbook_03-16.xlsx
1.8 MB
Also adding the borrower’s 2024 financial statements and the most recent rent roll dated 3/10/2026. Please use these for the IE and RR tabs.
Ridgewood_300_Borrower_Financials_2024.pdf
2.1 MB
Ridgewood_300_RR_03-10-2026.pdf
890 KB
Hi Jenny — received all files. Working on the 8 tabs now (ExpAnalysis, Market, Rent Comps, Zoning, PNA, Repair Table, ESA, Appraisal). Will update the workbook and save it back here once complete.
Quick update — 5 of 8 tabs complete (ExpAnalysis, Market, Rent Comps, Zoning, PNA). Working on Repair Table, ESA, and Appraisal now. ETA ~2 hours.
✅ Ridgewood 300 workbook is complete. All 8 tabs have been populated and the updated workbook has been saved to the channel files. A few notes on items I flagged during processing — see the Comments tab.
Ridgewood_300_UW_Workbook_03-17_COMPLETE.xlsx
2.4 MB
This looks great, thank you! One quick question — for the Expense Analysis tab, did you use the appraiser’s comps from page 47 or the summary on page 12?
Good question — I used the detailed breakdown from pages 47-49 as it includes per-unit figures. The page 12 summary only has totals. Let me know if you’d prefer the other format.
👁Seen by 5
Clik.ai notifies the team when work is complete
When workbook tabs are populated, the Clik.ai team notifies the underwriter via email and Teams. Items of note, clarifications, and follow-up items are proactively flagged.
Senior Analyst, Clik.ai
Monday, March 17, 2026 9:34 AM
RE: ClikAI Request - Ridgewood 300 & Ridgewood 500
To: Jenny S. <jenny.s@lendercorp.com>
Both Ridgewood 300 and Ridgewood 500 workbooks are now complete. Here's a summary of what was populated:
Ridgewood 300 (8 tabs):
- ExpAnalysis — Borrower's & Appraiser's expense comps populated from appraisal pages 47-49
- Market — Market data extracted from REIS report and appraisal
- Rent Comps — 8 comparable properties from appraisal
- Zoning — Compliance data from zoning report
- PNA — Capital expenditure schedule from PCA report
- Repair Table — Required repairs itemized from PCA
- ESA — Environmental assessment summary (no RECs identified)
- Appraisal Tab — Key valuation data points
- The appraisal for Ridgewood 300 shows an effective date of 2/15/2026 but references market data through 1/31/2026
- PCA for Ridgewood 500 flags a roof replacement needed within 3 years (~$285K estimated)
Updated workbooks have been saved to the Teams channel files. Please review and let me know if any adjustments are needed.
Senior Analyst, Clik.ai
RE: ClikAI Request - Ridgewood 300 & Ridgewood 500
DeliveredSenior Analyst, Clik.ai
Both Ridgewood 300 and Ridgewood 500 workbooks are now complete. Here's a summary of what was populated:
Ridgewood 300 (8 tabs):
- ExpAnalysis — Borrower's & Appraiser's expense comps populated from appraisal pages 47-49
- Market — Market data extracted from REIS report and appraisal
- Rent Comps — 8 comparable properties from appraisal
- Zoning — Compliance data from zoning report
- PNA — Capital expenditure schedule from PCA report
- Repair Table — Required repairs itemized from PCA
- ESA — Environmental assessment summary (no RECs identified)
- Appraisal Tab — Key valuation data points
- The appraisal for Ridgewood 300 shows an effective date of 2/15/2026 but references market data through 1/31/2026
- PCA for Ridgewood 500 flags a roof replacement needed within 3 years (~$285K estimated)
Updated workbooks have been saved to the Teams channel files. Please review and let me know if any adjustments are needed.
Senior Analyst, Clik.ai
Ready to scale your underwriting capacity?
Our team integrates directly into your existing workflow — email, Teams, and your lender workbook templates. No disruption, immediate capacity.
Based on anonymized data from a live agency lending engagement