Capgemini Senior Business Analyst Interview Questions, Process, and Tips

To plot an amortization schedule on Excel, use the PMT function to calculate monthly payments and create a table with columns for payment number, payment amount, interest, principal, and remaining balance.

• Use the PMT function to calculate the monthly payment based on the loan amount, interest rate, and loan term.

• Create a table in Excel with columns for payment number, payment amount, interest, principal, and remaining ...read more

Improved communication with stakeholders, streamlined project processes, identified areas for cost savings

• Implemented regular status updates to keep stakeholders informed

• Utilized project management tools to streamline processes and increase efficiency

• Conducted cost analysis to identify areas for cost savings, resulting in a 10% reduction in project expenses

Credit card transaction involves multiple parties and processes including authorization, settlement, and dispute resolution.

• Credit card transaction starts with authorization where the cardholder swipes or enters their card details for payment.

• The transaction is then processed by the acquiring bank and sent to the issuing bank for approval.

• If approved, the transaction is settled where the funds are transferred from the ...read more