Q 11 Write three finance function used in loan amortization table

Q12 Explain look up functions and their use.

Q13 What is Internal rate of return.

Q14 How to format a negative number in excel.

Q15 What is absolute reference and Relative reference. Write its importance and use.

Q16 what is the use of IF function. What input it requires?

Q17 state the advantages of VLOOKUP function over If function. Discuss three types of lookup functions

Q18 Write Five basic excel function.

Q19 what are logical function.

Q20 Give examples of 5 date functions and their use.

Q21 What are the best practices to be followed while building a financial model.

Q22 How to format a negative number in excel

Q23 What is the use of VLOOKUP function? Write the syntax required to call VLOOKUP function the function in Excel.

Q24 What is Internal rate of return. What parameters are required to call the IRR function in excel.

Q25 What is absolute reference and Relative reference? Write its importance and use.

Q26 state the advantages of VLOOKUP function over If function.

Q27. Write three finance function used in loan amortization table with their use and syntax.

Q28 What is the use of IF function. What parameters it requires as input. Explain with the help of an example.

Q29 What are the types and purpose of financial Model?

Q30. Give examples of 5 date functions and their use.

Q31. Discuss four key issues you need to think about before you start a model

Q32. What is the use of scenario analysis?

Q33. What are logical functions. Discuss any three logical functions with example.

Q34 What is the difference between spreadsheet and financial model?

Q35 illustrate the importance of Enterprise value and how it is calculated.

Q36 What is WACC and is its importance for the company?

Q37 What is the meaning of ratio analysis? How does it Picturises the position of a company.

Q38 What is base case, worst case and best-case Scenario. Explain their relevance with the help of two capital budgeting technique formulas.

Q39 What reports you are required to be make when you have make a income statement model.

Q40 Difference between sensitivity and scenario analysis.Steps of sensitivity analysis.

Q41 Dicuss Three advance excel functions with example, goal seek, scenario, data validation.

Q42 What are the various cell formatting option available in excel.

Q43 What is data validation. discuss with example.

Q44 what is the significance of EV/ EBIDTA, and EV/ Sales Multiple.

Q45 What are macros, discuss their purpose example and importance.