PORTFOLIO REFINANCING ANALYSIS – DAVID CHEN

• PORTFOLIO OVERVIEW:
• Total Portfolio Value: $2,450,000
• Total Mortgage Debt: $1,255,000
• Total Equity: $1,195,000
• Combined LTV: 51.2%
• Total Monthly Payments: $8,086
• Total Rental Income: $9,400
• Net Cash Flow: $1,314/month
• PROPERTY A – PRIMARY RESIDENCE ANALYSIS:
• Current Situation:
• – Balance: $420,000 at 4.75%
• – Payment: $2,435/month
• – Equity: $430,000
• Refinance Option:
• – New Rate: 3.25% for 30 years
• – New Payment: $_____/month
• – Monthly Savings: $_____
• – Cash-Out Available (80% LTV): $_____
• – Closing Costs: $4,500
• – Break-Even: _____ months
• PROPERTY B – DUPLEX ANALYSIS:
• Current Situation:
• – Balance: $380,000 at 5.25%
• – Payment: $2,344/month
• – Income: $4,200/month
• – Cash Flow: $1,856/month
• Refinance Option:
• – New Rate: 3.75% for 30 years
• – New Payment: $_____/month
• – Cash Flow Improvement: $_____/month
• – Annual Cash Flow Gain: $_____
• – Break-Even: _____ months
• PROPERTY C – CONDO ANALYSIS:
• Current Situation:
• – Balance: $275,000 at 5.5%
• – Payment: $1,788/month
• – Income: $2,400/month
• – Cash Flow: $612/month
• Refinance Option:
• – New Rate: 3.75% for 30 years
• – New Payment: $_____/month
• – Cash Flow Improvement: $_____/month
• – Annual Cash Flow Gain: $_____
• – Break-Even: _____ months
• PROPERTY D – HOUSE ANALYSIS:
• Current Situation:
• – Balance: $180,000 at 6.0%
• – Payment: $1,519/month
• – Income: $2,800/month
• – Cash Flow: $1,281/month
• Refinance Option:
• – New Rate: 3.75% for 30 years
• – New Payment: $_____/month
• – Cash Flow Improvement: $_____/month
• – Note: Extends term from 15 to 30 years
• – Break-Even: _____ months
• OPTION 1 – INDIVIDUAL REFINANCING SUMMARY:
• Total New Monthly Payments: $_____
• Total Monthly Savings: $_____
• Total Annual Savings: $_____
• Total Closing Costs: $18,000
• Portfolio Break-Even: _____ months
• Cash-Out Potential: $_____
• New Portfolio Cash Flow: $_____/month
• OPTION 2 – BLANKET MORTGAGE ANALYSIS:
• Combined Loan Amount: $1,255,000
• New Rate: 3.875% for 30 years
• Single Monthly Payment: $_____
• Total Monthly Savings: $_____
• Closing Costs: $12,000
• Break-Even: _____ months
• Advantages:
• – Single payment simplicity
• – Lower total closing costs
• – Cross-collateralization flexibility
• – _______________________
• Disadvantages:
• – All properties tied together
• – Harder to sell individual properties
• – _______________________
• OPTION 3 – STRATEGIC COMBINATION:
• Strategy Details:
• – Cash-out refi on Property A: $200,000
• – Rate reduction on Properties B, C, D
• – Total Closing Costs: $18,000
• Cash-Out Investment Plan:
• – Two new rental properties at $400,000 each
• – Down payments: $100,000 each (25%)
• – Expected rental income: $2,000/property
• – New mortgages: $300,000 each at 4.0%
• – Monthly payments: $_____/property
• – Net cash flow: $_____/property
• Portfolio After Expansion:
• – Total Properties: 6
• – Total Value: $3,250,000
• – Total Debt: $_____
• – Total Equity: $_____
• – Total Rental Income: $13,400/month
• – Total Cash Flow: $_____/month
• CASH FLOW COMPARISON:
• Current Portfolio:
• – Rental Income: $9,400
• – Mortgage Payments: $8,086
• – Net Cash Flow: $1,314/month
• Option 1 Cash Flow:
• – Rental Income: $9,400
• – New Payments: $_____
• – Net Cash Flow: $_____/month
• – Improvement: $_____/month
• Option 3 Cash Flow (with expansion):
• – Rental Income: $13,400
• – All Payments: $_____
• – Net Cash Flow: $_____/month
• – Improvement: $_____/month
• 10-YEAR WEALTH PROJECTION:
• Option 1 (Individual Refis):
• – Cash Flow Gain: $_____ × 120 months = $_____
• – Interest Savings: $_____
• – Equity Growth (3% appreciation): $_____
• – Total Wealth Gain: $_____
• Option 3 (Strategic Expansion):
• – Cash Flow Gain: $_____ × 120 months = $_____
• – Additional Property Appreciation: $_____
• – Additional Equity Buildup: $_____
• – Total Wealth Gain: $_____
• TAX IMPLICATIONS:
• Mortgage Interest Deductions:
• – Current Annual Interest: $_____
• – New Annual Interest: $_____
• – Tax Bracket: 28%
• – Annual Tax Impact: $_____
• Cash-Out Considerations:
• – Cash-out amount is tax-free (not income)
• – Interest on cash-out portion: $_____/year
• – Deductible if used for investment: Yes/No
• RISK ASSESSMENT:
• Market Risks:
• – Interest rate increase exposure: _______
• – Property value decline impact: _______
• – Rental vacancy sensitivity: _______
• Leverage Risks:
• – Current portfolio LTV: 51.2%
• – Option 1 LTV: _____%
• – Option 3 LTV: _____%
• – Debt service coverage: _____
• IMPLEMENTATION TIMELINE:
• Phase 1 (Month 1-2):
• – Order property appraisals
• – Shop multiple lenders
• – Gather documentation
• – _______________________
• Phase 2 (Month 2-3):
• – Submit applications
• – Lock interest rates
• – Schedule closings
• – _______________________
• Phase 3 (Month 3-4):
• – Close refinances
• – If Option 3: Search for new properties
• – _______________________
• FINAL RECOMMENDATION:
• Recommended Strategy: Option _____
• Justification:
• 1. _______________________
• 2. _______________________
• 3. _______________________
• 4. _______________________
• Expected Outcomes:
• – Monthly cash flow increase: $_____
• – Annual income increase: $_____
• – 10-year wealth creation: $_____
• – Portfolio value in 10 years: $_____
• Risk Mitigation:
• – Maintain _____ months reserves
• – Set aside $_____ for maintenance
• – Review portfolio quarterly
• – _______________________
• PERFORMANCE MONITORING:
• Monthly Metrics to Track:
• – Actual vs projected cash flow
• – Occupancy rates
• – Maintenance expenses
• – _______________________
• Quarterly Reviews:
• – Property value assessments
• – Rental market analysis
• – Portfolio rebalancing needs
• – _______________________
• Annual Decisions:
• – Additional property acquisition
• – Debt paydown vs investment
• – Portfolio optimization
• – _______________________