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:
Communication plan.
Explanation:
Project management can be defined as the process of designing, planning, developing, leading and execution of a project plan or activities using a set of skills, tools, knowledge, techniques and experience to achieve the set goals and objectives of creating a unique product or service. Generally, projects are considered to be temporary because they usually have a start-time and an end-time to complete, execute or implement the project plan.
The fundamentals of Project Management are considered universal across most businesses and professions.
The fundamentals of Project Management includes;
1. Project initiation
2. Project planning
3. Project execution
4. Monitoring and controlling of the project
5. Adapting and closure of project.
A communication plan can be defined as a project plan which explicitly outlines or states the set of people who needs an information, when it is delivered and what communication channel should be used to deliver the information to the stakeholders.
Hence, a robust communication plan can go a long way to reducing project problems over the life of the project and will establish how, when and to whom information must be supplied.
Answer:
False
Explanation:
The GAAP established that when the benefits of obtaining accounting information are lower than the costs of providing that information, the information should not be provided.
For example, sometimes there are very small differences in certain accounts that don't allow a balance sheet to be balanced. If the accounting error is very small, e.g. just a few hundred dollars, then it is not reasonable to have a whole audit team check all the financial statements again to determine what caused the error. An adjusting entry could be made to close the account balances.
Imagine you are an auditor that must check the physical inventory of a factory and some boxes containing supplies are misplaced. It might take you a whole day to count again all the supplies and materials, but is it worth it? If the supplies were really expensive, probably yes, but if they were cheap components, then probably no.
Answer:
From the given Matrix we can see that if videotech is selecting a high price, movietonia has a higher profit when it is charging a low price and this profit is 18. Similarly when videotech is selecting a lower price movietonia again has a higher profit when it is selecting a lower price which is 10. This indicates that movie tonia has a dominant strategy of selecting a low price.
If movietonia is selecting a high price videotech has a a higher pay off of 18 when it is selecting a low price. In case movietonia is selecting a low price videotech again has a higher profit when it is selecting a low price and this profi is 10.
Therefore videotech and movietonia both have dominant strategy of selecting a low price and this implies that low price, low price will be the Nash equilibrium.
In case the two firms are not colluding, both of them will choose a low price.
This is definitely an example of business dilemma game. The statement is true.
Explanation:
Answer:
The WACC is 10.93%
Explanation:
The WACC or weighted average cost of capital is the cost of a firm's capital structure. The capital stricture may be formed of the following components namely debt, preferred stock and common stock. The WACC assigns the weights to each of these components based on the finance provided by each of the above components as a proportion of total capital structure or total assets.
The WACC is calculated by taking the market value of each component. The formula for WACC is as follows,
WACC = wD * rD * (1-tax rate) + wP * rP + wE * rE
Where,
- w represents the weight of each component
- r represents the cost of each component
- D, P and E represents debt, preferred stock and Common stock respectively.
- We take after tax cost of debt. So we multiply rD with (1-tax rate)
Debt = 377000 * 106.5% = $401505
Preferred stock = 6850 * 90.50 = $619925
Common stock = 27500 * 70 = $1925000
Total assets = 401505 + 619925 + 1925000 = $2946430
WACC = 401505/2946430 * 7.81% * (1-0.35) + 619925/2946430 * 6.9% +
1925000/2946430 * 13.45%
WACC = 0.1093 or 10.93%
