Business Analytics Mcq: Solved Exam with Answers

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
(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

_____________________________________________________