Answer:
a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.
b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.
c. In the formula bar type =365 days; +2 : E6
d. In the formula bar type =365 days ; +2 : C6
Explanation:
Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.
Answer:
Part 1).
The behavior that I am most involved in amplification, forecasting and persuading in the office is motivation between the team followers and staffs.
One the key persistence of association behavior is to manage staffs efficiently. This means that the employee administration is a large part of OB. In doing that administrations need to employee competent personnel and make sure they are sufficiently motivated. While the motivation can be of diverse types (internal and external), the administration of the motivation is what makes staffs efficient and creative. Thus in order to achieve effectiveness and productivity on association level, I believe it is significant to manage worker motivation efficiently.
There are various representations that can be used for this determination. For example, Maslow’s hierarchy, Herzberg’s’ theory, etc.
Part 2).
One of the significant steps to eliminate biases and preconceptions is to admit their presence and to vigorously avoid them. The staffs should receive discernment and diversity training on a regular basis. In addition to this stages of possible judgement/bias such as signing, raises, task, etc. needs to be totally objective. The valuation of staffs or possible personnel should follow objective procedure and assessment criteria.
This should allow plummeting, if not removing, the bias and judgement in the day to day process of the team and the association.
Answer:
Since the expected return and required return are different for both Stock X and Z, we say that they are not correctly priced
Explanation:
<em>To determine whether or not the stocks are correctly priced ,</em>
<em>we have to compare the r</em><em>equired return</em><em> and the </em><em>expected return on each of them.</em>
Required return = Rf +β (Rm-Rf)
Note that Rm-Rf is also known as market risk premium
<em>Stock Y Stock Z</em>
<em>Required return </em> 2.4% + 1.2(7.2%) 2.4% + 0.8(7.2%)
= 11% = 8.2%
<em>Expected return</em> <em>12.1% 7.85%</em>
Since the expected return and required return are different for both Stock X and Z, we say that they are not correctly priced
Answer:
247,500
Explanation:
The calculation showing the weighted average number of shares to be used in the calculation of the of the basic earning per share for 2018 is shown below:
= ![[(100,000 * \frac{12}{12}) + (30,000 * \frac{10}{12})] * 2 Stock splits - 10,000 * \frac{3}{12}](https://tex.z-dn.net/?f=%5B%28100%2C000%20%2A%20%5Cfrac%7B12%7D%7B12%7D%29%20%2B%20%2830%2C000%20%2A%20%5Cfrac%7B10%7D%7B12%7D%29%5D%20%2A%202%20Stock%20splits%20-%2010%2C000%20%2A%20%5Cfrac%7B3%7D%7B12%7D)
Answer:
Year Cashflow [email protected]% PV [email protected]% PV
$ $ $
0 (1,100) 1 (1,100) 1 (1,100)
1-8 47.4 5.3349 252.87 7.0197 332.73
8 1,000 0.4665 465.5 0.7894 789.4
NPV (381.63) NPV 22.13
Kd = LR + NPV1/NPV1+NPV2 x (HR – LR)
Kd = 3 + 22.13/22.13 + 381.63 x (10 – 3)
Kd = 3 + 22.13/403.76 x 7
Kd = 3 + 0.38
Kd = 3.38%
Explanation:
Cost of debt is calculated based on internal rate of return formula. In year 0, we will consider the current market price of the bond as cashflow. In year 1 to 8, we will consider the after-tax coupon as the cashflow. The after-tax coupon is calculated as R(1 - T). R is 6% x $1,000 = $60 and tax is 21%. Thus, we have $60(1 - 0.21) = $47.4. then we will discount the cashflows for 8 years so as to obtain the internal rate of return. The internal rate of return represents cost of debt.
