Magistral Analyst Interview Questions and Answers

Asking Questions related to their profile and work

About basic understanding of accounting and excel

Q1. Excel understanding
Add your answer
Q2. Accounting process and golden principles of accounting
Ans. 
The accounting process involves recording, summarizing, analyzing, and reporting financial transactions. Golden principles include consistency, relevance, reliability, and comparability.
• Accounting process involves recording financial transactions, summarizing them into financial statements, analyzing the data, and reporting the results.

• Golden principles of accounting include consistency (using the same accounting metho...read more
Answered by AI
Add your answer

Q1. HR session then main panel of partners take interview.
Add your answer

Q1. Introduction , Qualifications and Experiences
Add your answer

Q1. Excel Formulas - VLOOKUP, HLOOKUP, Difference Between Sum / Sumif / Sumifs GST Implementation Year, Types of GST, Golden Rules of Accounting, Journal Entry of Sale and Purchase with GST and Bad debt journa...read more
Add your answer

How to use vloolup in 2 sheet

Q1. Introduction round nothing special
Add your answer
Q2. Basic general entries and basic Excel questions
Add your answer

Q1. What are the accounting principles?
Ans. 
Accounting principles are the foundational guidelines that govern financial reporting and accounting practices.
• 1. Accrual Principle: Revenues and expenses are recorded when they are earned or incurred, not when cash is exchanged. Example: A company recognizes revenue when a service is provided, not when payment is received.

• 2. Consistency Principle: Companies should use the same accounting methods from period to period....read more
Answered by AI
Add your answer
Q2. What is the purpose of using a pivot table in Excel, and how do you utilize it?
Ans. 
Pivot tables in Excel summarize and analyze data efficiently, allowing for dynamic data exploration and reporting.
• Summarize large datasets: For example, you can summarize sales data by region and product category.

• Dynamic data analysis: Easily rearrange data by dragging and dropping fields to view different perspectives.

• Calculate aggregates: Use functions like SUM, AVERAGE, or COUNT to analyze data, such as total sales ...read more
Answered by AI
Add your answer
Q3. If we purchase a share for 100 rupees, what selling price do we need to achieve a profit of 20%?
Ans. 
To achieve a 20% profit on a share bought for 100 rupees, the selling price must be 120 rupees.
• Profit is calculated as: Profit = Selling Price - Cost Price.

• To find the selling price for a desired profit percentage, use the formula: Selling Price = Cost Price + (Cost Price * Profit Percentage).

• In this case: Selling Price = 100 + (100 * 0.20) = 100 + 20 = 120 rupees.

• Thus, selling the share for 120 rupees will yield a 20%...read more
Answered by AI
Add your answer

Q1. Tell me something about yourself.
Add your answer

Q1. What is happening in the global industry right now? Current Trends in interest rates How will you increase profitability of swiggy? Market sizing guesstimate
Ans. 
Global industry is experiencing fluctuating interest rates, focus on increasing profitability of companies like Swiggy, and market sizing guesstimates.
• Interest rates are currently fluctuating due to economic uncertainties and central bank policies.

• To increase profitability of Swiggy, focus on optimizing operational efficiency, expanding customer base, and enhancing delivery services.

• Market sizing guesstimates involve e...read more
Answered by AI
Add your answer
Q2. Introduce yourself. Why Redseer. Why consulting
Add your answer