This quiz works best with JavaScript enabled. Home > Finance > Financial Analysis > Financial Modeling > Financial Modeling – Quiz 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Financial Modeling Quiz 1 (30 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) Falso. B) TRUE. Show Answer Correct Answer: A) 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) Debt. B) Equity. C) Long-term liabilities. 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) Falso. B) TRUE. Show Answer Correct Answer: A) 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) Move cursor to highlight a data region. B) Move cursor to prior / next worksheet. C) Shift from Excel file to Excel file while on pc. D) Move down/ up on one screen on the same worksheet. Show Answer Correct Answer: A) Move cursor to highlight a data region. 13. The statement of changes in the financial position allows us to understand the liquidity situation. A) Falso. B) TRUE. Show Answer Correct Answer: B) TRUE. 14. Which analysis is based only on one year's data: A) Horizontal Analysis. B) Cash Flow Statement. C) Vertical Analysis. D) Dividend Analysis. Show Answer Correct Answer: C) Vertical Analysis. 15. Which of the following describes dividend yield? A) The return on a share of common stock. B) Measures the value of common stock. C) The amount of earnings attributable to a share of common stock. D) Shows how much investors are willing to pay per dollar of earnings. Show Answer Correct Answer: A) The return on a share of common stock. 16. Which of the following does not fall into operating activities? A) Capital expenditures. B) Net income. C) Change in Working Capital. D) Depreciation. Show Answer Correct Answer: A) Capital expenditures. 17. Which of the following describes net debt? A) Debt plus cash. B) Cash less debt. C) Long-term debt plus cash. D) Debt less cash. Show Answer Correct Answer: D) Debt less cash. 18. Which of the following is not a financial modelling schedule? A) Balance sheet. B) Suspense account. C) Working capital. 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. 21. Excel data tables are array functions. What does it mean? A) Multiple cells of excel are merged together to create one group. B) An array is a group of excel cells. C) An array function is a formula that can perform multiple calculations on one or more items in an array. D) An array function has multiple formula embedded inside one formula. Show Answer Correct Answer: C) An array function is a formula that can perform multiple calculations on one or more items in an array. 22. What type of analysis can be conducted using Financial Modeling and Forecasting? A) Risk analysis. B) Analysis portfolio. C) Data analysis. D) All of the Above. Show Answer Correct Answer: D) All of the Above. 23. Jackson spends in gas changes every month, based upon the price of gas, this is an example of which of the following: A) Fixed Expense. B) Variable Expense. C) Periodic Expense. D) None of above. Show Answer Correct Answer: B) Variable Expense. 24. How do you access Data Table command in Excel? A) Data|Solver|Data Table. B) Data|What-if Analysis|Data Table. C) Data|Data Analysis|Data Table. D) Data|Analysis Toolpak|Data Table. Show Answer Correct Answer: B) Data|What-if Analysis|Data Table. 25. Which of the following falls into investing activities? A) Cost of goods sold. B) Change in working capital. C) Capital expenditures. D) Depreciation. Show Answer Correct Answer: C) Capital expenditures. 26. If the net present value of project A is +$ 50, and of project B is +$ 80, then the NPV of the combined project is: A) $ 130. B) $ 80. C) $ 30. D) $ 50. Show Answer Correct Answer: A) $ 130. 27. Purpose of a budget is to: A) Identify cash in and out flows of a business. B) Determine the actual cash on hand for a previous period. C) Identify revenue earned for the current period. D) Determine expenses incurred for the current period. Show Answer Correct Answer: A) Identify cash in and out flows of a business. 28. What will be the return on assets DuPont equation, given profit margin= 4.5% and total assets turnover= 1.8%. A) 0.025. B) 4 times. C) 0.004. D) 0.081. Show Answer Correct Answer: D) 0.081. 29. What is the calculation for revenue growth> A) Current year's revenue / last year's revenue-1. B) Current year's revenue/ last year's revenue. C) Current year's revenue / next year's revenue. D) Current year's revenue / next year's revenue-1. Show Answer Correct Answer: A) Current year's revenue / last year's revenue-1. 30. The primary goal of financial management is A) To minimize the risk. B) To maximize wealth of owners. C) To maximize the return. D) To maximize profit. Show Answer Correct Answer: B) To maximize wealth of owners. Next →Related QuizzesFinancial Analysis QuizzesFinance QuizzesFinancial Modeling Quiz 2Financial Modeling Quiz 3Financial Modeling Quiz 4Financial Modeling Quiz 5 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books