This quiz works best with JavaScript enabled. Home > Financial Analysis > Financial Modeling > Financial Modeling – Quiz 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Financial Modeling Quiz 1 (20 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. 8) How can you view and delete macros that have been created in a worksheet? A) Press Alt+F8, select the macro to be deleted and click delete. B) Under the Developer tab, click on the Macros button in the Code group. Select the macro to delete and click delete. C) Press Alt+F11. Click on Tools and select Macros. Select the macro to delete and click delete. D) All of the options listed above are correct. Show Answer Correct Answer: D) All of the options listed above are correct. 2. Liquidity is the cash that a company has A) TRUE. B) Falso. Show Answer Correct Answer: B) Falso. 3. A company has long-term debt of $ 500, 000 and EBITIDA of $ 10, 000. What conclusion could a financial analyst draw about the company? A) The company is potentially over levered. B) The company's profitability is low. C) The company does not use its assets efficently. D) The company may not be able to pay its short term liabilities. Show Answer Correct Answer: A) The company is potentially over levered. 4. Which of the following balance sheet items are included in working capital? A) Equity. B) Long-term liabilities. C) Debt. D) Accounts receivable. E) Cash. Show Answer Correct Answer: D) Accounts receivable. 5. What are the three main things that the financial manager can accomplish by building a long-term financial model for the firm? A) Identify important linkages among the components of the firm's financial statements. B) Analyze the impact of a potential business plan. C) Plan for future funding needs. D) All of the above. Show Answer Correct Answer: D) All of the above. 6. The objective of investors is to maximize profit. A) TRUE. B) Falso. Show Answer Correct Answer: B) Falso. 7. What is required to create a successful financial model and forecast? A) Experience & creativity. B) Growing data trends. C) Sufficient data and historical trends. D) Gritty determination. Show Answer Correct Answer: C) Sufficient data and historical trends. 8. Monthly fixed costs are Php 20, 000 excluding depreciation of Php 5, 000. Which figure should be shown in the Receipts section of the cash budget? A) Php 20, 000. B) Php 25, 000. C) Php 15, 000. D) None of the others. Show Answer Correct Answer: D) None of the others. 9. Which of the following is not accurate in regards to accounts receivable? A) It's the amount owed to an organization from the sale of its products or services. B) Accounts receivable is typically part of working capital. C) If an organization sends an invoice to customers, the invoice amount typically shows up in accounts receivable. D) All else being equal if accounts receivable increases, cash also increases. Show Answer Correct Answer: D) All else being equal if accounts receivable increases, cash also increases. 10. Have you read the course syllabus? A) And. B) No. Show Answer Correct Answer: A) And. 11. What is the main benefit of Financial Modeling and Forecasting? A) A method of predicting stock prices. B) A tool for managing a portfolio. C) A means of accurately predicting future outcomes. D) A means of creating financial forecasts with a high degree of accuracy and reliability. Show Answer Correct Answer: D) A means of creating financial forecasts with a high degree of accuracy and reliability. 12. What does Shift + Arrow do? A) Shift from Excel file to Excel file while on pc. B) Move cursor to highlight a data region. C) Move down/ up on one screen on the same worksheet. D) Move cursor to prior / next worksheet. Show Answer Correct Answer: B) Move cursor to highlight a data region. 13. The statement of changes in the financial position allows us to understand the liquidity situation. A) TRUE. B) Falso. Show Answer Correct Answer: A) TRUE. 14. Which analysis is based only on one year's data: A) Cash Flow Statement. B) Dividend Analysis. C) Vertical Analysis. D) Horizontal Analysis. Show Answer Correct Answer: C) Vertical Analysis. 15. Which of the following describes dividend yield? A) Shows how much investors are willing to pay per dollar of earnings. B) The return on a share of common stock. C) Measures the value of common stock. D) The amount of earnings attributable to a share of common stock. Show Answer Correct Answer: B) The return on a share of common stock. 16. Which of the following does not fall into operating activities? A) Capital expenditures. B) Depreciation. C) Change in Working Capital. D) Net income. Show Answer Correct Answer: A) Capital expenditures. 17. Which of the following describes net debt? A) Long-term debt plus cash. B) Debt plus cash. C) Debt less cash. D) Cash less debt. Show Answer Correct Answer: C) Debt less cash. 18. Which of the following is not a financial modelling schedule? A) Working capital. B) Suspense account. C) Balance sheet. D) Cash flow statement. Show Answer Correct Answer: B) Suspense account. 19. You can activate a cell by A) Pressing the Tab key. B) Clicking the cell. C) Pressing an arrow key. D) All of above. Show Answer Correct Answer: D) All of above. 20. What is green font used for? A) To link to cells in other tabs. B) To demonstrate cells that you need to come back and review. C) To demonstrate where the inputs are located. D) To demonstrate where the calculations are located. Show Answer Correct Answer: A) To link to cells in other tabs. Next →Related QuizzesFinancial Analysis QuizzesFinancial Modeling Quiz 2Financial Modeling Quiz 3Financial Modeling Quiz 4Financial Modeling Quiz 5Financial Modeling Quiz 6Financial Modeling Quiz 7Financial Modeling Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books