Rehab & ConstructionExcel
Reconcile land equity, builder deposits and seller debt, then model development draws, lot sales and project cash month by month.
- Monthly cash and repayment schedule
- Peak senior debt and additional cash needed
- Editable sponsor project summary and downside assumptions
Preview & get free download → Checklists & GuidesPDF
Identify deposit terms, closing conditions and assignment questions.
- A printable checklist of items to confirm
Download PDF · no email required → Checklists & GuidesPDF
Separate repayment, completion, overrun and carve-out obligations.
- A printable checklist of items to confirm
Download PDF · no email required → Checklists & GuidesPDF
Organize site, budget, sponsor and financing documents.
- A printable checklist of items to confirm
Download PDF · no email required → Rental & DSCRExcel
Estimate rental cash flow, cap rate, cash-on-cash return and break-even occupancy before making an offer.
- Monthly cash flow after reserves
- Cap rate and cash-on-cash return
- Break-even occupancy
Preview & get free download → Rental & DSCRExcel
Size residential rental financing using rent-to-PITIA coverage and an assumed LTV limit.
- Coverage-limited and LTV-limited loan amounts
- Minimum rent for your requested loan
- Down payment and requested-loan coverage
Preview & get free download → Rental & DSCRExcel
Track acquisition cash, refinance proceeds and the cash remaining in a stabilized rental.
- Refinance capacity and net proceeds
- Cash recovered or additional cash required
- Cash remaining and rental cash flow
Preview & get free download → Rehab & ConstructionExcel
Build an offer from resale value, actual costs and your target profit, then check the projected cash return.
- Maximum offer at the entered loan amount
- Projected net profit
- Cash invested and cash return
Preview & get free download → Rehab & ConstructionExcel
Turn quantities, labor and materials into an itemized rehab budget and compare it with contracted costs.
- Line-item labor and material budget
- Total budget with contingency
- Cost variance and remaining contingency
Preview & get free download → Rehab & ConstructionExcel
Track completed work, retained amounts and lender reimbursements without treating an approved draw as cash received.
- Eligible reimbursement still outstanding
- Cash advanced before reimbursement
- Remaining work and undrawn allocation
Preview & get free download → Rehab & ConstructionExcel
See how planned and delayed project timelines affect carrying costs and your available cash.
- Base and delayed carrying costs
- Remaining cash by month
- First month with a funding shortfall
Preview & get free download → FinancingExcel
Separate funds paid at closing from reserves you must retain afterward.
- Estimated remaining closing payment
- Post-closing liquidity requirement
- Total cash commitment
Preview & get free download → FinancingExcel
Compare three loan quotes over the same planned holding period, including fees, interest and exit penalties.
- Payment and balance at exit
- Interest plus fees and penalty
- Cash paid and financing cost comparison
Preview & get free download → FinancingExcel
Compare keeping a loan with a same-balance refinance, including fees and the remaining balances at exit.
- Monthly payment savings
- Simple payment-savings break-even
- Net economic benefit including debt balances
Preview & get free download → Commercial & PortfolioExcel
Organize a 30-unit rent roll and twelve months of operating history with a traceable NOI summary.
- Scheduled and occupied monthly rents
- Trailing twelve-month operating statement
- NOI before debt and replacement reserves
Preview & get free download → Commercial & PortfolioExcel + PDF
Build a five-unit acquisition file with the existing editable model, a diligence checklist and a base/downside control.
- NOI, cash flow and cash required
- Debt coverage and acquisition returns
- Downside and maturity analysis
Preview & get free download → Commercial & PortfolioExcel + PDF
Underwrite a small apartment building with unit mix, capital projects, operating cash flow and multiple debt limits.
- Buyer cash requirement
- Supported acquisition debt
- Operating downside and refinance analysis
Preview & get free download → Commercial & PortfolioExcel + PDF
Review an owner-operated assisted living acquisition using capacity, collections, staffing and operating costs.
- Operating cash flow and coverage
- Occupancy break-even
- Acquisition funds and downside results
Preview & get free download → Commercial & PortfolioExcel
Track up to twenty properties, their cash flow, leverage, reserves and upcoming maturities.
- Portfolio monthly cash flow
- Weighted portfolio LTV
- Reserve gaps and upcoming maturities
Preview & get free download → Rental & DSCRExcel
Compare annual rental cash flow on the same property using explicit short-term operating costs.
- Annual net cash flow under each use
- STR break-even booked nights
- Cash-flow difference after shared debt
Preview & get free download → Rehab & ConstructionExcel + PDF
Reconcile remaining construction work, unpaid obligations, payoff and funds available to complete a project.
- Remaining completion budget
- Total refinance and completion uses
- Additional funding needed
Preview & get free download → Commercial & PortfolioExcel
Separate lot rent from park-owned home income and calculate property cash flow and debt coverage.
- Separated pad and home income
- NOI, coverage and buyer cash
- Cash flow after home and infrastructure reserves
Preview & get free download → WidgetsHTML widget
Explore how rent and rate changes affect residential rent-to-PITIA coverage and monthly rental cash flow.
- Interactive rent/rate coverage grid
- Monthly cash flow after reserves
- Target-coverage indicators
Preview & get free download → WidgetsHTML widget
Compare up to three rental purchases using consistent cash flow and cash-invested definitions.
- Cash flow, cap rate and cash-on-cash return
- Invested cash comparison
- Downside cash flow
Preview & get free download → Checklists & GuidesPDF
Document acquisition, rental readiness and reporting milestones before discussing bonus depreciation.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Compare quoted fees, incremental deductions, usable benefits and holding-period questions.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Keep booking records, participation evidence, property classification and personal use separate.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Reconcile purchase costs and CPA-classified improvements separately from appraisal and refinance proceeds.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Inventory prior schedules and missing records before a CPA determines the appropriate filing method.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Record apartment temperatures, times and follow-up actions.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Organize lease preparation records and questions for your closing team.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Gather records for review. This planning worksheet is not a legally operative notice.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Organize acquisition documents and a sources-and-uses worksheet.
- A printable worksheet for your file
Download PDF · no email required → Checklists & GuidesPDF
Five-document checklist for cash-flowing multifamily properties with 5+ units seeking additional capital supported by asset cash flow. Free PDF; no email required.
- An organized loan-file checklist
Download PDF · no email required → Checklists & GuidesPDF
Large new development loan checklist — entitlements, GC contract, budget, and takeout docs construction lenders request. View or download the PDF.
- An organized loan-file checklist
Download PDF · no email required → Checklists & GuidesPDF
Commercial property loan checklist — rent roll, leases, entity docs, and sponsor items office, retail, and industrial lenders request. View or download.
- An organized loan-file checklist
Download PDF · no email required → Checklists & GuidesPDF
Assisted living facility loan checklist — license, census, payor mix, and operator docs healthcare CRE lenders request. View online or download the PDF.
- An organized loan-file checklist
Download PDF · no email required → Checklists & GuidesPDF
Mobile home park loan checklist — pad count, POH vs TOH, utilities, and lot-rent docs MHP lenders request. View online or download the free PDF.
- An organized loan-file checklist
Download PDF · no email required → Checklists & GuidesPDF
Mobile home community loan checklist — amenities, 55+ HOPA, site rent, and community-owned home docs MHC lenders request. View online or download the PDF.
- An organized loan-file checklist
Download PDF · no email required → Checklists & GuidesPDF
RV park loan checklist — site mix, occupancy, seasonality, and utility docs campground lenders request. View online or download the free PDF.
- An organized loan-file checklist
Download PDF · no email required → City Closing ChecklistsPDF
Track Aurora open-account clearance, water readings, transfer stamps, rental questions, and applicable new-construction fees through possession.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Track Berwyn compliance inspections, covered sewer videos, repair obligations, water clearance and transfer stamps from sale preparation through possession.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate point-of-sale inspection, buyer repair consent, municipal tax and water clearance, stamp pickup, and rental follow-through in Calumet City.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate zoning, water clearance, transfer stamps, title, funding and the ownership handoff.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Plan compliance and zoning review, repair agreements, water clearance, transfer stamps, and the work remaining after a Cicero closing.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Track Evanston transfer stamps, municipal balances, property-specific requirements, funding, and possession from contract preparation through recording.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate Glenview utility payment, property records, required permit approvals, and the documents that support a complete handover.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate seller transfer stamps, municipal balances, exemption review, property checks, and the handover in Hoffman Estates.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate Naperville's municipal paperwork with title, financing, property review, utilities, and possession.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate the buyer’s tax, seller’s municipal clearance, rental paperwork, and any qualifying post-closing rebate.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Track Northbrook property records, zoning and permit questions, utility transitions, and buyer or seller evidence without a municipal stamp application.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate Oak Park seller stamps, utility clearance, condo documents, historic-property questions, and a documented possession handover.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Track Schaumburg's transfer stamp, water account, property holds, and the documents needed for a coordinated closing.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Plan Skokie rental inspections, corrections, final water clearance, seller transfer stamps and the new owner's remaining obligations.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Track the original deed, municipal balances, condo coordination, and rental approvals needed for a Wheeling closing.
- A printable closing coordination worksheet
Download PDF · no email required → City Closing ChecklistsPDF
Coordinate buyer transfer stamps, seller utility clearance, meter and permit questions, financing, and the property handover.
- A printable closing coordination worksheet
Download PDF · no email required → Checklists & GuidesPDF
Keep a copy of the Jaken Finance Group loan program overview.
- A printable loan program overview
Download PDF · no email required → No matching resources. Try a broader search or another category.