**BUSINESS ANALYTICS MCQ QUESTIONS CONTENT**

~Questions 1 TO 9 ( Regression, coefficient)

~Questions 1 TO 7 ( Visualizing cash flow and excel )

~Questions 1 TO 13 (New)

**Disclaimer: **This is not for cheating purposes. This is useful to revise or prepare before the exam. It gives a rough idea about the exam

**Easy Tip**-:- If you need an answer of any particular, use this function

For Mobile – Use the Find in page option to search that MCQ.

( For Google / Chrome browser – Click on three dots on the upper right side and click on Find in page )**Laptop **– Use (Ctrl+f) and paste or write that MCQ statement or word to search

BUSINESS ANALYTICS MCQ QUESTIONS 1-9

**Question 1 of 9 Making a forecast can be done with regression by using what method?**

**(A) multiplying coefficients by expected values of Xs**

(B) dividing coefficients by expected values of Ys

(C) dividing coefficients by expected values of Xs

(D) multiplying coefficients by expected values of Ys

**Question 2 of 9 What type of variable can be used to capture fixed effects?**

(A) Random variables

(B) continuous variables

**(C) Dummy variables**

(D) all of these answers

**Question 3 of 9 What type of data should the Y variable be in a binary regression?**

(A)

**Discrete**

(B) Random

(C) Continuous

(D) none of these answers

**Question 4 of 9 Fixed effects regressions help to deal with what problem?**

(A) Statistical Insignificance

(B) Survey Bias

**(C) Omitted variables bias**

(D) Randomness in data

**Question 5 of 9 Which statistic offers a bounds on our estimate of the impact of an X variable on the Y variable?**

(A) T-statistic

(B) R-squared

**(C) 95% confidence interval**

(D) P-value

**Question 6 of 9 What is one type of time series forecasting?**

(A) Regressions

(B) The Delphi Method

**(C) Exponential Smoothing**

(D) Surveys

**Question 7 of 9 What is the term for the estimate of the impact an X variable have on the Y variable?**

(A) Coefficient

(A) Coefficient

(B) R-squared

(C) Standard Error

(D) P-value

**Question 8 of 9**

**What is one type of causal forecasting?**** (A) Multiple Regression **

(B) Exponential Smoothing

(C) Surveys

(D) The Delphi Method

**CORONA BLOG- WANT TO EARN MONEY ONLINE BY MAKING CORONA STATS BLOG IN 15 MIN**

Start Now and Earn Money

**Question 9 of 9 What is one good source of free data?**

(A) Thomson Reuters

(B) Friends

**(C) FRED**

(D) WARP

##### Business Analytics Mcq Questions 1 To 7

###### Visualizing cash flow and excel

**Question 1 of 7**** Which is the internal rate of return?**

(A) the interest rate at which all cash flows have a net present value of zero

(B) the interest rate at which all cash flows have a positive net present value

Correct answer**(C) the discount rate at which all cash flows have a net present value of zero**

(D) the discount rate at which all cash flows have a negative net present value

**Question 2 of 7 Which key will create an absolute instead of a relative cell reference?**

(A) Ctrl+A

(B) Esc

**(C) F4**

(D) F1

**Question 3 of 7 What is the future value for a fully amortized loan?**

**(A) zero**

(B) the value of the interest only

(C) the principal plus interest

(D) the outstanding principal

**Question 4 of 7 Which Excel formula can take up to five arguments and then calculate the future value of an investment?**

(A) RECEIVED

(B) PRICEMAT

**(C)**

**FV**

(D) FVSCHEDULE

**Question 5 of 7 What is the formula for calculating the value of a perpetuity?**

**(A) payment/(discount rate – growth rate)**

(B) (discount rate – growth rate)/payment

(C) payment/interest rate

(D) payment/(growth rate – discount rate)

**Question 6 of 7 Since the GEOMEAN formula does not accept negative numbers, how can you use it despite having some negative growth rates?**

(A) Subtract 1 from the growth rate, then add 1 to the result after using the GEOMEAN formula.

(B) Divide the growth rate by -1, then multiply the result by -1 after using the GEOMEAN formula.

**(C) Add 1 to the growth rate, then subtract 1 to the result after using the GEOMEAN formula.**

(D) Multiply the growth rate by -1 to make it positive, then divide the result by -1 after using the GEOMEAN formula.

Free download e-book Manifestation Magic Guide – The Ultimate Wealth Creation System

Click here to download ( Close if ad opens and double click on download )

**Question 7 of 7 If you invested $10,000 with an annual compound interest rate of 5 percent, how much will it be worth after 10 years?**

**(A)**

**16289**

(B) 11365

(C) 10761

(D) 15500

#### QUESTION 1 TO 13

**Question 1 of 13 James has a small company and is looking to get a loan from the bank. How will the bank deduce the company’s cash flow?**

(A) By using three years of profit and loss reports to create a statement of cash flows.

(B) By using the income statement alone to create a statement of cash flows.

Attempted correct option

**(C) By using the balance sheet and income statement to create a statement of cash flows**.

(D) By using the balance sheet alone to create a statement of cash flows.

**Question 2 of 13 You have worked on your balance sheet to figure out how to finance an expansion plan. Which of the following would be the most realistic plug figure to use?**

**(A) loans payable**

(B) paid-in capital

(C) liabilities

(D) investments

**Question 3 of 13 Which of the following tells you whether all of your forecasts, assumptions, marketing plans, and operating plans are internally consistent, practical, and achievable?**

**(A) assets = liability + equity**

(B) costs = assets + equity

(C) equity = liability + inventory

(D) liability = assets + equity

**Question 4 of 13 Padere’s preliminary assumptions in her income statement is that there will be an overall increase in expenses next year. What is the next logical step for Padere before presenting to her COO?**

**(A) Each of the forecasting assumptions must be researched, supported, justified, and explained.**

(B) No new steps are needed since the expected level of depreciation expense is tied to the expected level of property, plant, and equipment.

(C) Verify the forecasted increase in gross profit percentage is not impacted by changes in the competitive environment.

(D) No new steps are needed since the expected level of interest expense is tied to the expected level of loans.

**Question 5 of 13 Company A is significantly above the average value compared to other companies in the industry. You predict that next year the company will likely deliver to a number closer to the other companies. This is known as _.**

(A) deviate from the mean

(B) net income percentage

(C) gross profit percentage

**(D) reversion to the mean**

**Question 6 of 13 What should you consider when forecasting the level of property, plant, and equipment, and the associated amount of depreciation expense?**

(A) short- and long-term assets

**(B) current utilization level and future expansion plans**

(C) strategic plans and inventory

(D) sales and strategic plans

**Question 7 of 13 In a forecasted income statement, the amount of a company’s _ is determined by how much property, plant, and equipment the company has**.

(A) inventory

**(B) depreciation expense**

(C) assets

(D) accounts receivable

**Question 8 of 13 Derrick is creating a constructed forecasted financial statement. Which of the following would inhibit a more accurate statement?**

**(A) The amount of depreciation is driven by sales.**

(B) An increase level of activity will create the need for more cash.

(C) An increase in accounts receivable in inventory will create a need for more cash.

**Question 9 of 13 As you put together a forecasting model, it is important to remember that sales forecasting is _.**

(A) an exact science

(B) not faulty or full of skepticism

**(C) not an exact science**

(D) a true means to the future

**Question 10 of 13 Kiko is creating her sales forecast. Which of the following factors is the starting point for Kiko to view a forecast of future sales?**

(A) change in the competitive environment

**(B) historical trend**

(C) impact of current plans

(D) impact of a marketing plan

**Question 11 of 13 The most important and recommended starting point of any financial model exercise is the _**

**(A) sales forecast**

(B) cost of sales

(C) levels of inventory

(D) depreciation expenses

**Question 12 of 13 As an investor, you look to the DCF of a company before deciding to invest. Which of the following questions would lead you to use a higher interest rate in your analysis?**

(A) How large will the future cash flows be?

(B)

**How risky are the cash flows?**

(C) When will these cash flows occur?

**Question 13 of 13 Analyzing the _ performance of a company allows financial statement users to understand _ performance of a company.**

(A) historical; past

**(B) historical; future**

(C) present; future

(D) present; past

More MCQ- Financial Modeling Exam MCQ

For more MCQ with answers – Click here

ANY QUERIES, COMMENT DOWN

_____________________________________________________

Hi there, I found your web site by the use of Google at the same time as searching for a similar topic, your website came up, it appears to be like great. I have bookmarked it in my google bookmarks.

I am really impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you modify it yourself? Anyway keep up the excellent quality writing, it is rare to see a great blog like this one these days..

Thank you for sharing your info. I truly appreciate your efforts and I

will be waiting for your next post thanks once again.

This is the perfect blog for anybody who hopes

to find out about this topic. You definitely put a brand new spin on a

topic which has been discussed for decades.Wonderful stuff, just excellent!

This Post Is very Useful Learn English of Hindi Daily conversation Sentence