Xperitus Insurance Brokers Interview Questions and Answers

Financial ratios test and MCQ test related to finance numericals

Q1. What is balance sheet, p&l and cash flow statement?
Ans. 
Balance sheet shows a company's assets, liabilities, and equity at a specific point in time. P&L shows a company's revenues, expenses, and profits over a period. Cash flow statement shows how cash flows in and out of a company.
• Balance sheet provides a snapshot of a company's financial position at a specific point in time.

• P&L (Profit and Loss) statement shows a company's revenues, expenses, and profits over a specific p...read more
Answered by AI
Add your answer
Q2. What is the negative item in the balance sheet?
Ans. 
The negative item in the balance sheet is liabilities.
• Liabilities represent the company's debts or obligations that must be paid off in the future.

• Examples of liabilities include loans, accounts payable, and accrued expenses.

• Having high levels of liabilities relative to assets can indicate financial risk.
Answered by AI
Add your answer

Q1. Scenario Based Questions.
Add your answer
Q2. Give Income statement format.
Ans. 
Income statement format includes revenue, expenses, and net income.
• Start with revenue at the top

• List all expenses below revenue

• Calculate net income by subtracting total expenses from revenue

• Include headings for each section such as 'Revenue', 'Expenses', and 'Net Income'

• Format should be: Revenue - Expenses = Net Income
Answered by AI
Add your answer

Q1. What is Vlookup?and if it's giving error then which symbol we use to remove the error?
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'.

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.

• If Vlookup is giving an error, the symbol '#' is used to remove the error.

• For example, if the formula '=VLOOKUP(A2, B2:...read more
Answered by AI
Add your answer
Q2. Why should we select you over other candidates
Add your answer

It is a test of total 150+ questions in which we have some java pseudocodes ,python ,aptitude reasoning questions as well and english questions.

Q1. Short inteoduction and project discussion.
Add your answer
Q2. Check the given sentence is palindrome or not by taking input by user.
Ans. 
The program checks if a given sentence is a palindrome or not.
• Prompt the user to input a sentence

• Remove all spaces and punctuation from the sentence

• Reverse the sentence and compare it with the original sentence to check for palindrome
Answered by AI
Add your answer
Q3. Final,Finally,finalize keywords
Add your answer

Q1. Introduce your self
Add your answer
Q2. Soft skills and other basic questions
Add your answer

Q1. Ducting types youed
Add your answer
Q2. Ducting any types of material
Add your answer
Q3. Mep for explain
Add your answer
Q4. Mep basic form housed property
Add your answer
Q5. Electrical line
Add your answer

There was a coding round and out of 75 students 28 got selected for next round

Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
Add your answer
Q2. Explain your project in detail and asking cross questions regarding project.
Add your answer

Q1. I was rejected in round 2.
Add your answer

Basic communication skills and have to know some system knowledge

Q1. Preferable locations and experience and communication
Add your answer

Q1. What is AML and primary and secondary research?
Ans. 
AML stands for Anti-Money Laundering. Primary research involves collecting data firsthand, while secondary research involves analyzing existing data.
• AML is a set of procedures, laws, and regulations designed to prevent the illegal generation of income through money laundering.

• Primary research involves conducting surveys, interviews, and experiments to gather new data.

• Secondary research involves analyzing existing data ...read more
Answered by AI
Add your answer

Q1. What was your contribution towards lead time improvement?
Ans. 
I implemented process improvements and streamlined workflows to reduce lead times by 20%.
• Analyzed current processes to identify bottlenecks

• Implemented automation tools to speed up tasks

• Trained team members on efficient time management techniques

• Collaborated with suppliers to optimize supply chain logistics
Answered by AI
Add your answer

Q1. How have you been able to successfully handle difficult stakeholders? Pls provide an example / case study
Ans. 
I have successfully handled difficult stakeholders by actively listening, addressing concerns, and finding common ground.
• Active listening to understand their concerns and perspectives

• Addressing their concerns with empathy and professionalism

• Finding common ground and working towards a mutually beneficial solution
Answered by AI
Add your answer

Q1. How do we improve lead time in fulfillment
Ans. 
Improving lead time in fulfillment involves optimizing processes, reducing bottlenecks, and enhancing communication.
• Implementing lean manufacturing principles to streamline operations

• Utilizing technology such as automation and inventory management systems

• Improving forecasting accuracy to better anticipate demand

• Enhancing communication between departments to reduce delays

• Regularly reviewing and optimizing the supply cha
Answered by AI
Add your answer

Q1. How have you been able to effectively improve the ER campaigns?
Ans. 
I have improved ER campaigns by analyzing data, implementing targeted strategies, and collaborating with cross-functional teams.
• Analyzed data to identify trends and areas for improvement

• Implemented targeted strategies based on data analysis

• Collaborated with cross-functional teams to ensure campaign success
Answered by AI
Add your answer

Q1. Overall summary with challenges and solutions towards the hurdles in improvement of recruitment process
Add your answer

Q1. Introduction to about your self
Add your answer
Q2. Experience and product knowledge
Add your answer