This quiz works best with JavaScript enabled. Home > Financial Analysis > Financial Modeling > Financial Modeling – Quiz 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Financial Modeling Quiz 7 (20 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Who can benefit from Financial Modeling and Forecasting? A) Asset Managers. B) Investors. C) Accountants. D) All of the Above. Show Answer Correct Answer: D) All of the Above. 2. If Jonathan wants to save 20% of his income, how much money does he need save per month if he make $ 1, 600 per month. A) $ 400. B) $ 160. C) $ 320. D) $ 200. Show Answer Correct Answer: C) $ 320. 3. Which cash flow is accessible for a firm's investors? A) Free cash flow. B) Investing cash. C) Intrinsic stock. D) Extrinsic stock. Show Answer Correct Answer: A) Free cash flow. 4. How would you calculate dividend yield? A) Dividend Per Share / Net Income. B) Share Price / Dividends. C) Dividend Per Share / Share Price. D) Total Dividends / Share Price. E) Share Price / Earnings. Show Answer Correct Answer: C) Dividend Per Share / Share Price. 5. What is the most common calculation for corporate tax rate? A) Corporate Taxes x Revenue. B) Corporate Taxes / Net Earnings. C) Corporate Taxes / Operating Income. D) Corporate Taxes / Earnings Before Taxes. Show Answer Correct Answer: D) Corporate Taxes / Earnings Before Taxes. 6. If the liability and equity are greater than the assets (L + E > A) after forecasting the balance sheet, the excess cash available can be used to:I. Retire debt II. Repurchase shares III. Build extra cash reserves IV. Distribute excess as dividends A) I and II. B) I, II and III. C) II, III and IV. D) All of the above. Show Answer Correct Answer: D) All of the above. 7. Excel Data Tables Are Arrays. What does it mean? A) This means that Excel data tables are static in nature. B) This means that Excel data tables have multiple formulas linked together. C) This means that Excel data tables are grouped together. D) This means that Excel data tables are dynamically linked to your initial example. Show Answer Correct Answer: D) This means that Excel data tables are dynamically linked to your initial example. 8. A ..... is an estimate of a business's financial outlook for the few years. A) Financial plan. B) Financial forecast. C) Budget. D) Income statement. Show Answer Correct Answer: B) Financial forecast. 9. 6) Workbooks that contain macros must be saved in the following format: A) Excel Workbook (.xlsx). B) Microsoft Office Macro-Enabled File (.mef). C) Excel Template (.xltx). D) Excel Macro-Enabled Workbook (.xlsm). Show Answer Correct Answer: D) Excel Macro-Enabled Workbook (.xlsm). 10. Limitation of analysis of financial statements is A) Affected by window dressing. B) Difficulty in forecasting. C) Do not reflect changes in price level. D) All of the Above. Show Answer Correct Answer: D) All of the Above. 11. Expenses that stay the same every month are ..... expenses. Rent would be an example. A) Fixed. B) Discretionary. C) Variable. D) Intermittent. Show Answer Correct Answer: A) Fixed. 12. The Sources and Uses of Funds statement reflects changes in cash A) TRUE. B) Falso. Show Answer Correct Answer: B) Falso. 13. Which of the following is one step in financial planning for a budget? A) Use percentages to see how much of the total income should be set aside for each expense. B) Create a spending chart. C) Create a table for cash gifts and gift cards your received. D) None of above. Show Answer Correct Answer: A) Use percentages to see how much of the total income should be set aside for each expense. 14. Turning inventories faster improves liquidity A) TRUE. B) Falso. Show Answer Correct Answer: B) Falso. 15. Jackie is ready to reconcile her bank statement with her check register. What should she do? A) Subtract deposits made since the statement. B) Add outstanding checks made since the statement. C) Add outstanding deposits and subtract outstanding checks written since statement. D) She does not need to reconcile her bank statements. Show Answer Correct Answer: C) Add outstanding deposits and subtract outstanding checks written since statement. 16. Financial management aims at A) Ensuring availability of enough funds. B) Reducing the cost of funds procured. C) Effective deployment of funds. D) All of the above. Show Answer Correct Answer: D) All of the above. 17. Which of the following is an example of the type of financial data used to produce financial models and forecasts? A) Interest rates. B) Budgeting plans. C) Commodity prices. D) Business taxation rates. Show Answer Correct Answer: A) Interest rates. 18. Which of the following statement regarding NPV is true? A) An investment should be accepted if, and only if, the NPV equals the initial investment. B) An investment should be accepted if, and only if, the NPV equals zero. C) An investment should be accepted if the NPV is positive and rejected if it is negative. D) An investment with greater cash inflows than cash outflows, regardless of when the cash flows occur, will always have a positive NPV and therefore should always be accepted. Show Answer Correct Answer: C) An investment should be accepted if the NPV is positive and rejected if it is negative. 19. The term liquidity is the degree in which a business can turn its assets into cash A) True. B) False. Show Answer Correct Answer: A) True. 20. A worksheet range is a A) A command used for data modeling. B) A range of values such as from 23 to 234. C) A group of cells. D) A group of worksheets. Show Answer Correct Answer: C) A group of cells. ← PreviousNext →Related QuizzesFinancial Analysis QuizzesFinancial Modeling Quiz 1Financial Modeling Quiz 2Financial Modeling Quiz 3Financial Modeling Quiz 4Financial Modeling Quiz 5Financial Modeling Quiz 6Financial Modeling Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books