This quiz works best with JavaScript enabled. Home > Financial Analysis > Financial Modeling > Financial Modeling – Quiz 3 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Financial Modeling Quiz 3 (20 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is an example of cost of sales? A) Management salaries. B) Raw material cost used in the production process. C) Interest expense. D) Travel Costs. Show Answer Correct Answer: B) Raw material cost used in the production process. 2. The main inducer of EVA is WACC A) TRUE. B) Falso. Show Answer Correct Answer: B) Falso. 3. 5) What is the shortcut key for launching the Macros dialog box? A) Alt+F8. B) Ctrl+F8. C) Ctrl+Shift+M. D) Alt+M. Show Answer Correct Answer: A) Alt+F8. 4. Where can Financial Models & Forecasts be used to identify patterns in the data? A) Futures Markets. B) Money Markets. C) Equity Markets. D) All of the Above. Show Answer Correct Answer: D) All of the Above. 5. The best financial models should (choose the best option from below) A) Keep things as simple as possible while provides sufficient detail for decision making. B) Offer users a high degree of detail and precision. C) Be easy to follow and audit. D) Be very simple and have the minimum level of detail. Show Answer Correct Answer: A) Keep things as simple as possible while provides sufficient detail for decision making. 6. If debt is reduced, what is the corresponding transaction on the balance sheet? A) Equity is increased. B) Equity is reduced. C) Cash is increased. D) Cash is reduced. Show Answer Correct Answer: D) Cash is reduced. 7. Which of the following statements regarding NPV is true? A) If NPV is positive, the project is expected to earn more than the firm's cost of capital. B) Accepting negative NPV projects will reduce shareholders' wealth. C) If the NPV is positive, the project's cost is less than the project's expected benefit. D) All of the above. Show Answer Correct Answer: D) All of the above. 8. The following are the advantages of net present value, EXCEPT A) It can be used as a rough screening device to eliminate those projects whose returns do not materialize until later years. B) All positive NPVs will increase the value of the firm. C) It allows comparison of benefits and costs in a logical manner. D) It recognizes the timing of benefits resulting from the project. Show Answer Correct Answer: A) It can be used as a rough screening device to eliminate those projects whose returns do not materialize until later years. 9. 10) While busy recording a macro, you made a mistake. What is the best course of action? A) You can pause the macro and click Rewind to fix it. B) You should re-record the macro. C) You should press Undo. D) None of the options listed above are correct. Show Answer Correct Answer: B) You should re-record the macro. 10. Which of the following items are included in a cash budget? A) Depreciation. B) Accumulated depreciation. C) Cash receipts. D) Bad debts. Show Answer Correct Answer: C) Cash receipts. 11. What are the keyboard shortcut keys to insert Excel function arguments automatically?* A) Ctrl + A. B) Ctrl + F3. C) Ctrl + Shift + K. D) Ctrl + Shift + A. Show Answer Correct Answer: B) Ctrl + F3. 12. What metric states what is available for distribution to creditors and shareholders? A) Cash flow from operating activities. B) Cash flow from financing activities. C) Free Cash Flow. D) Net income. E) Cash flow from investing activities. Show Answer Correct Answer: C) Free Cash Flow. 13. Variable expenses may not be the same every month. A) True. B) False. Show Answer Correct Answer: A) True. 14. How do you calculate operating margin? A) Net Income / Revenue. B) Operating Income / Revenue. C) Gross Profit / Revenue. D) Operating Expenses / Revenue. E) Operating Expenses / Operating Income. Show Answer Correct Answer: B) Operating Income / Revenue. 15. 1) Which of the descriptions listed below best describe what a macro in Excel does? A) It is a type of formatting you can apply to enlarge the worksheet area. B) It is a file type that you save a workbook as. C) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. D) It is a recording function that allows you to save worksheets, audio recordings and videos that are displayed on the screen. Show Answer Correct Answer: C) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. 16. The ..... is a report of the revenue, expenses, and net income or net loss over an accounting period. A) Income statement. B) Accounts payable. C) Owner's equity. D) Financial statement. Show Answer Correct Answer: A) Income statement. 17. The disadvantage of the IRR method is that A) The IRR deals with cash flows. B) The IRR gives equal regard to all returns within a project's life. C) The IRR will always give the same project accept/reject decision as the NPV. D) The IRR requires long, detailed cash flow forecasts.Answer:D. Show Answer Correct Answer: D) The IRR requires long, detailed cash flow forecasts.Answer:D. 18. If you want to generate values for a target output by changing multiple inputs and setting multiple constraints on the inputs, you should use the ..... function in Excel. A) Solver. B) Scenario. C) Goal Seek. D) Data Table. Show Answer Correct Answer: C) Goal Seek. 19. New machine costing Php 100, 000 is purchased in August with a 20% deposit and 8 monthly instalments starting in September. What is the value of the first instalment to be shown in the cash budget? A) Php 20, 000. B) Php 10, 000. C) Php 1, 000. D) Php 12, 000. Show Answer Correct Answer: B) Php 10, 000. 20. EBITDA stands for: A) Earnings Behalf of Interest, Taxes, Depreciationand Amortization. B) Earnings Before Interest, Taxes, Depreciation and Amortization. C) Earnings Before Income Taxes, Depreciation and Amortization. D) Earnings Between Interest, Taxes, Depreciation and Amortization. Show Answer Correct Answer: B) Earnings Before Interest, Taxes, Depreciation and Amortization. ← PreviousNext →Related QuizzesFinancial Analysis QuizzesFinancial Modeling Quiz 1Financial Modeling Quiz 2Financial Modeling Quiz 4Financial Modeling Quiz 5Financial Modeling Quiz 6Financial Modeling Quiz 7Financial Modeling Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books