Muthoot Microfin Analyst Interview Questions and Answers

My favourite tool in Excel is the PivotTable.

• PivotTable helps to summarize and analyze large amounts of data quickly.

• It allows for easy filtering, sorting, and grouping of data.

• PivotTable also provides visual representation of data through charts and graphs.

• It can be used for various purposes such as financial analysis, sales analysis, and inventory management.

Trend and forecasting can be calculated using statistical methods like regression analysis and time series analysis.

• Collect and analyze historical data

• Identify patterns and trends in the data

• Choose a suitable forecasting model

• Apply the model to the data to generate a forecast

• Evaluate the accuracy of the forecast

To check the repayment capacity of an applicant, I assess their income, credit history, and financial obligations.

• Evaluate the applicant's income and employment stability

• Review their credit history and credit score

• Assess their existing financial obligations such as loans, mortgages, and credit card debt

• Consider their debt-to-income ratio

• Analyze their repayment track record on previous loans or credit facilities

• Verify t

The loan amount is based on various factors such as credit score, income, collateral, and loan purpose.

• Credit score is a major factor in determining the loan amount.

• Income is also considered to ensure the borrower can repay the loan.

• Collateral can increase the loan amount as it provides security for the lender.

• Loan purpose can also affect the loan amount, such as a mortgage for a house.