The Strelema MIS Executive and Analyst Interview Questions and Answers

Q1. Qn on fin statements. Given a situation how it would impact three fin statements
Ans. 
Changes in a situation can impact financial statements differently
• Changes in revenue will impact income statement by affecting net income

• Changes in inventory levels will impact balance sheet by affecting assets

• Changes in debt levels will impact cash flow statement by affecting financing activities
Answered by AI
Add your answer
Q2. Qn on DCF
Ans. 
Discounted Cash Flow (DCF) is a valuation method used to estimate the value of an investment based on its future cash flows.
• DCF calculates the present value of expected future cash flows by discounting them back to their current value.

• It takes into account the time value of money, risk, and opportunity cost of capital.

• The formula for DCF is: DCF = CF1/(1+r)^1 + CF2/(1+r)^2 + ... + CFn/(1+r)^n, where CF is cash flow and...read more
Answered by AI
Add your answer

Q1. Case interview focused on calculating the financial aspects of a coffee shop, from fund sourcing to profit calculation,EDA (Excel or paper were not permitted for calculations). the interviewer aimed to a...read more
Add your answer

Technology making ours less human ( 15 min) online

Q1. Tell me about yourself
Add your answer
Q2. Tell me about you inters hip
Add your answer
Q3. Fixed assets with example
Ans. 
Fixed assets are long-term tangible assets that are used in the production of goods or services and are not intended for sale.
• Fixed assets are physical assets such as buildings, machinery, equipment, vehicles, and land.

• They are not intended for sale and are used for the production of goods or services over a long period of time.

• Examples of fixed assets include manufacturing plants, office buildings, delivery trucks, an
Answered by AI
Add your answer
Q4. Capital assets with example
Ans. 
Capital assets are long-term assets that are used in the production of goods or services and are not easily converted into cash.
• Capital assets are typically tangible assets such as buildings, machinery, equipment, and vehicles.

• They are used by a company to generate revenue over an extended period of time.

• Examples of capital assets include manufacturing plants, delivery trucks, office furniture, and computer systems.
Answered by AI
Add your answer
Q5. Why we use current ration
Ans. 
Current ratio is used to assess a company's ability to pay its short-term obligations with its short-term assets.
• Current ratio is a liquidity ratio that measures a company's ability to cover its short-term liabilities with its short-term assets.

• It is calculated by dividing current assets by current liabilities.

• A current ratio of 1 or higher is generally considered healthy, as it indicates that a company has enough curr...read more
Answered by AI
Add your answer

Topic - general affairs swiggy vs zomato

Q1. Tell me about yoursleg
Add your answer
Q2. Strenth weakness , hobbies, credit questions
Add your answer

Q1. What is vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Used in Excel to search for a value in the first column of a table and return a value in the same row from another column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the first column of the ra...read more
Answered by AI
Add your answer
Q2. What is hlookup
Ans. 
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
• Used in Excel to search for a value in the top row of a table

• Returns a value in the same column from a specified row

• Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• Example: =HLOOKUP(123, A1:D4, 3, FALSE) - searches for 123 in the top row of the table A1
Answered by AI
Add your answer

Q1. Sum and sumif, date functions, text join, pivot tables
Add your answer

Nice and good problem solving interview process

Aptitude test has totalof 5 set of rounds..first round is algebra, second round is trigonometry third round is maths fourth round is infinity stones solving puzzles containing the process related probl ms

Q1. About myself and family income occupation and other things
Add your answer
Q2. About the scope of this current job and future of the applied job forthis company with salary negotiations
Add your answer

Q1. About pharmacology
Add your answer