<span>This is, in fact, true. What-if analysis is done by altering values in cells to see what outcomes are produced due to the changes. All data is kept on a worksheet to analyze. There are three types of What-if Analysis tools available in Excel, Data tables, Goal Seek, and Scenarios.</span>
Answer:
the opportunity cost is in the case when you choose to go to the movies is $20
Explanation:
The computation of the opportunity cost is in the case when you choose to go to the movies is shown below:
= Earning per hour × number of hours
= $10 × 2 hours
= $20
Hence, the opportunity cost is in the case when you choose to go to the movies is $20
Answer:
35 times
Explanation:
The price-earnings ratio is the financial ratio that compares the market price of a share with its earnings in order to determine whether the share gives earnings that makes it a good buy.
Price-earnings ratio=market price per share/earnings per share
market price per share for 2017 is $42
earnings per share=net income-dividends/average common stock outstanding
net income is $108,000
dividends is nil
average number of common stock is 90,000
earnings per share=$108,000-$0/90,000=$1.2
price earnings ratio=$42/$1.2=35 times