Financial Modeling and Analysis Certification

free certificate

Financial modeling is the task of building an abstract representation of a real world financial situation. This is a mathematical model designed to represent the performance of a financial asset or portfolio of a business, project, or any other investment.

Exam Details :

  • Format: Multiple Choice Question
  • Questions: 20
  • Passing Score: 16/20 or 80%
  • Language: English

Click Here To Apply For Financial Modeling and Analysis Certification Quiz : CLICK HERE

here are the answer to questions:

Which Tools can be Used for Auditing the Financial Models in Excel?

  • Model structure
  • Go to special
  • Trace precedents & dependents
  • All of the above

What illustrates a Financial Model

  • Excel spreadsheet with numbers
  • Calculation tool
  • A decision making tool
  • Excel containing historical financial data

Which of the following results in increase of return on investment

  • Increasing Turnover
  • Reducing Expenses
  • Increasing Capital Utilization
  • All of these

What will be the ‘use’ of funds, if the following are balance sheet changes – Rs. 5,005 decrease in accounts receivable , Rs. 7,000 decrease in cash , Rs. 12,012 decrease in notes payable and Rs. 10,001 increase in accounts payable

  • Rs. 7000 decrease in cash.
  • Rs. 5005 decrease in accounts receivable.
  • Rs. 10001 increase in accounts payable.
  • Rs. 12012 decrease in notes payable

What does cash Inflows from a project usually includes

  • Tax Shield of Depreciation
  • After-tax Operating Profits
  • Raising of Funds
  • Both Tax Shield of Depreciation and Raising of Funds

What is mean by conglomeration?

  • Corporation that is the largest amongst its competitors
  • Corporation that sells its products and services in several countries
  • Acquisition strategy whereby a company makes acquisitions in relatively unrelated business areas
  • None of these

How to determine liquid assets

  • Current assets-stock-Prepaid expenses
  • Current assets +stock+ prepaid expenses
  • Current assets +Prepaid expenses
  • None of these

Also See Free Certiicate on: Game AI Developer Certificate https://articlebase.pk/ai-free-certificate/

Which of the following formula will you use to make a number in cell C1 10% smaller than the number in C3 you enter?

  • =C31.10 +C3110
  • =C3%10
  • =C3*.90

Find the return on total assets, given Net income available to stockholders = Rs. 150 and Total assets = Rs. 2,100.

  • 7.0E-4
  • 0.0714
  • 0.05 times
  • 7.15 times

What is a Greenfield?

  • Building a new factory from scratch
  • Modifying /upgrading a preexisting factory
  • Integrating a newly purchased company quickly and efficiently
  • All of the above

Which of the following also refer to turnover ratios

  • Activity ratios
  • Performance ratios
  • Both Activity ratios and Performance ratios
  • None of these

Which of the following can improve Debt to Total Assets Ratio

  • Borrowing More
  • Issue of Debentures
  • Issue of Equity Shares
  • Redemption of Debt.

___ helps to understand how the target variable is affected by the change in input variable.

  • Modeling Analysis
  • Financial Analysis
  • Sensitivity Analysis
  • Cash flow analysis

Which of the following is of interest to suppliers and creditors

  • Profitability Position
  • Liquidity Position
  • Share Position
  • Debt Position.

What is a valid statement

  • Cost of capital is based on market value and usually is stated in real terms.
  • Cost of capital is based on book value and usually is stated in real terms.
  • Cost of capital is based on market value and usually is stated in nominal terms.
  • Cost of capital is based on book value and usually is stated in nominal terms.

What is the basis of computing the return on equity capital

  • Funds of equity shareholders
  • Equity capital only
  • Either a or b
  • None of these

Which of the following is a disadvantage of Vertical Financial Model Layouts?

  • Excessive sheets that need to be interlinked
  • Tougher to navigate
  • Too much data management
  • All of these

What is the factor for operating leverage

  • Fixed Cost of Production
  • Fixed Interest Cost
  • Variable Cost

Which of the following is not a current asset?

  • Inventory
  • Bills Receivable
  • Land and Building
  • Cash at hand

Accounting entry of closing balance can be recorded for _

  • Asset a/c and Liability a/c
  • Liability a/c and Expenses a/c
  • Income a/c and Expenses a/c
  • Liability a/c and Owner’s equity a/c

One thought on “Financial Modeling and Analysis Certification

Leave a Reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.