Financial Modeling Quiz 3 (30 MCQs)

Quiz Instructions

Select an option to see the correct answer instantly.

1. A company is likely to declare higher dividends if
2. What add-in program serves as the data analyzing tool in Excel?
3. A firm anticipates that current growth projections for the next five years will require another RM80 million in funds to achieve. If the firm can generate RM30 million internally it will need to raise ..... in net new financing.
4. Retention Rate, which is (1-Payout Ratio), is also known as:
5. What is one advantage of preparing a cash budget?
6. Which of the following does not fall into financing activities?
7. Is depreciation cash?
8. XYZ Securities had a long-term stable debt-to-equity ratio of 0.65. Recentbank borrowing for expansion into North Luzon Expressway raised the ratio to 0.75.The increased leverage has what effect on the asset beta and equity beta of thecompany?
9. Canceling a long-term loan improves the company's liquidity
10. Which of the following is NOT an advantage of using Financial Modeling and Forecasting in the financial services industry?
11. Owner's equity is the owner's claim to the asset of the business. It is NEVER referred to as the owner's capital in the business.
12. What is a standard approach to calculating free cash flow?
13. 4) If you wanted to replace the INDEX-MATCH formula, used in question 3 above, with a VLOOKUP formula, which of the following would yield the same result as the INDEX-MATCH formula, when entered into the highlighted cell in the screenshot above question 3?
14. Capital budgeting related to
15. ..... represents the short-term liabilities that a business owes to creditors.
16. Working Capital increases. Which of the following is false?
17. When you set a budget, you should never revisit or adjust it.
18. Which of the following is an example of a non-current liability?
19. We compute the profitability index of a capital budgeting proposal by
20. Which of the following describes earnings per share?
21. The only balance sheet accounts a company has is cash of $ 850, 000, inventory of $ 50, 000. debt of $ 500, 000 and a building worth $ 100, 000. How much equity does the company have?
22. An organization purchases a tactor without financing. What impact does this purchase have on the balance sheet
23. An Annual Report is issued by a company to its:
24. Investment in fixed assets improves the company's liquidity
25. Which of the following is NOT a key element in creating effective financial models and forecasts?
26. A long term investment decision is called
27. Monthly fixed costs are Php 100, 000 excluding depreciation of Php 20, 000. Which figure should be shown in the Payments section of the cash budget?
28. The discount rate that makes the net present value of an investment exactly equal to zero is called the:
29. What is Financial Modeling and Forecasting?
30. The cost of equity is equal to the: