1. An analyst is comparing two companies. Company A has a higher Gross Profit Margin, but Company B has a higher Net Profit Margin. This could suggest:

2. When cleaning data in Excel, what does "deduplication" refer to?

3. When a company writes off an uncollectible account using the allowance method, what is the effect on net accounts receivable?

4. Effective communication of financial analysis results typically involves:

5. Which of the following would generally lead to a higher WACC for a company?

6. The primary purpose of the Statement of Retained Earnings is to:

7. Which inventory costing method typically results in the lowest Cost of Goods Sold during a period of rising prices?

8. The "book value per share" is calculated as:

9. The primary goal of capital budgeting is to:

10. The direct method of preparing the Statement of Cash Flows directly reports:

11. What is a "put option"?

12. Which ratio is most useful for assessing how efficiently a company is using its assets to generate sales?

13. "Artificial Intelligence" (AI) in finance is being used for:

14. A company purchases a machine for $120,000. It has an estimated useful life of 10 years and a salvage value of $20,000. Using the straight-line depreciation method, what is the annual depreciation expense?

15. What does it mean if a company's stock has a beta of 1.5?

16. If a company's earnings per share (EPS) are $2.50 and its share price is $50, what is its P/E ratio?

17. What is the function of an "INDEX-MATCH" combination in Excel?

18. "Systematic risk" is typically measured by:

19. In the context of M&A, a "hostile takeover" occurs when:

20. What is "fiscal policy"?

21. What is the primary purpose of hedging in financial markets?

22. Which of the following would be recorded as an intangible asset?

23. The accounting concept that assumes a business will continue to operate indefinitely is the:

24.

1. Under the accrual basis of accounting, when are expenses recognized?

25. The principle that requires companies to report enough information for financial statement users to make informed decisions is the:

26. What does "ESG" investing aim to achieve?

27. What is the "agency cost" in corporate finance?

28. The "current yield" of a bond is calculated as:

29. Research and development costs are generally:

30. Which of the following is an example of a "non-performing asset" (NPA) in banking?

31. A company has a Current Ratio of 0.8. This typically indicates:

32. A "bull market" is characterized by:

33. What is the key difference between US GAAP and IFRS regarding the revaluation of fixed assets?

34. Which of the following investment alternatives typically carries the highest level of systematic risk?

35. A low Price-to-Book (P/B) ratio might indicate that:

36. If a company issues bonds at a premium, it means the stated interest rate is:

37. What is a key limitation of the payback period method in capital budgeting?

38. What is the concept of "disruptive technology" in finance?

39. What is a "macro" in Excel?

40.

1. Which financial statement reports a company's revenues, expenses, gains, and losses over a period of time?

41. Which of the following is an advantage of debt financing over equity financing?

42. Which of the following would result in an increase in a company's current ratio?

43. Which of the following is NOT a core principle of good financial model design?

44. Which profitability ratio measures how much net income a company generates for each dollar of sales revenue?

45. What is the purpose of an "annuity" in finance?

46. In financial modeling, a "driver" is typically:

47. The role of a "business intelligence (BI) analyst" in finance often involves:

48. What is the purpose of using "named ranges" in Excel?

49. If a company has a negative cash conversion cycle, what does it typically indicate?

50. The "working capital turnover" ratio measures:

51. What is the primary purpose of a "TERM SHEET" in finance?

52. The purpose of adjusting entries is to:

53. When using Comparable Company Analysis (Comps), why is it important to normalize earnings?

54. If a company's Enterprise Value (EV) is $500 million and its Market Capitalization is $400 million, what can be inferred about its net debt (Total Debt - Cash)?

55. In a financial model, what is the purpose of a "stress test"?

56. What is "Monte Carlo Simulation" in financial modeling?

57. A company's quick ratio (acid-test ratio) excludes which current asset from the numerator?

58. What is the effect of recording bad debt expense using the allowance method on the Income Statement and Balance Sheet?

59. When valuing a private company, which valuation method is often more challenging to apply compared to public companies?

60. What is the main objective of a "stock repurchase" program?

61. The Financial Accounting Standards Board (FASB) is primarily responsible for setting accounting standards in:

62. Which of the following factors would likely increase the beta of a company's stock?

63. What does a declining trend in a company's Debt-to-Equity ratio suggest?

64. What is a "portfolio"?

65. The primary role of the bond rating agencies (e.g., S&P, Moody's, Fitch) is to:

66. The "pecking order theory" of capital structure suggests that companies prefer to finance investments using:

67. In a Discounted Cash Flow (DCF) model, the Free Cash Flow to Firm (FCFF) represents cash available to:

68. If a project's Internal Rate of Return (IRR) is 15% and the company's cost of capital is 12%, should the project be accepted (assuming it's an independent project)?

69. What is the primary function of an "investment bank"?

70. The concept of "moral hazard" in finance often arises when:

71. The concept of "dilution" in equity valuation refers to:

72. What is the impact of paying a cash dividend on the financial statements?

73. If a company's earnings per share (EPS) are $2.50 and its share price is $50, what is its P/E ratio?

74. Which of these is classified as an "other comprehensive income" item?

75. What does "API" stand for in the context of financial technology?

76. The "lower of cost or market" rule is applied to:

77. A company receives $1,000 for services to be performed next month. How should this be recorded initially?

78. If a company's Cost of Goods Sold is $500,000 and its average inventory is $100,000, what is its inventory turnover ratio?

79. Which of the following transactions would decrease both assets and liabilities?

80. Which financial statement links the Income Statement and the Balance Sheet?

81. What is the "efficient frontier" in portfolio theory?

82. "Diversifiable risk" is also known as:

83. Which of the following valuation methods relies heavily on market multiples derived from similar companies that have recently been acquired?

84. What is the primary difference between EBITDA and EBIT?

85. A stock split primarily impacts:

86. A high "Days Sales Outstanding" (DSO) indicates:

87. If a company's Return on Assets (ROA) is 10% and its Asset Turnover is 2 times, what is its Net Profit Margin?

88. What is the concept of "Big Data" in finance?

89. A gain on the sale of an asset would appear on the income statement as:

90. What is the primary purpose of a "Dashboard" in Excel for financial analysis?

91. Which of the following is an example of a contra-liability account?

92. The concept of "Modigliani-Miller Theorem" with no taxes and no bankruptcy costs suggests that:

93. The "Terminal Value" in a DCF model is typically calculated using either the Gordon Growth Model (GGM) or the:

94. The yield to maturity (YTM) of a bond is

95. What does a higher discount rate imply in the context of Net Present Value (NPV) calculations?

96. The concept of "quantitative easing" (QE) by central banks involves:

97. Which Excel function is used to count the number of cells that contain numbers in a range?

98. In Excel, which function is used to calculate the present value of an investment?

99. The "discounted payback period" is an improvement over the traditional payback period because it:

100. Which account is credited when unearned revenue is earned?