Best Gemini prompts for Loan Officers

Analyze the credit report of a borrower with a 650 FICO score, $50,000 annual income, and a $200,000 mortgage loan request, and provide a detailed risk assessment report including the likelihood of default, creditworthiness, and recommended interest rate, using the following parameters: loan-to-value ratio, debt-to-income ratio, and credit history, and compare the results to the industry benchmarks and regulatory requirements, and generate a PDF report with embedded charts and graphs.

Given a loan portfolio with 500 active loans, $100 million in outstanding balances, and an average interest rate of 5%, use clustering analysis and decision trees to identify the top 20% of high-risk loans, and provide a prioritized list of loans for review and potential modification, along with a detailed analysis of the potential impact on the overall portfolio performance, including expected loss, return on investment, and regulatory capital requirements, and generate a CSV file with the loan-level data and a summary report in Google Docs.

Conduct a comprehensive review of 20 loan files to ensure compliance with the Truth in Lending Act, Equal Credit Opportunity Act, and Dodd-Frank Wall Street Reform, and identify any potential violations or areas for improvement, and generate a detailed audit report with findings, recommendations, and corrective actions, including a summary of the loan-level data, compliance metrics, and risk assessments, and create a dashboard in Google Data Studio to track and monitor compliance performance over time.

Develop a comprehensive credit profile for a borrower with a thin credit file, including credit score simulation, credit history reconstruction, and alternative credit data analysis, and provide a detailed report with recommendations for credit improvement and loan structuring, using the following data sources: credit bureaus, public records, and social media, and generate a visual representation of the credit profile using Sankey diagrams and heat maps, and create a Google Sheets template for easy replication and updates.