1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
qwelly [4]
3 years ago
12

Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her mont

hly income. Since her monthly income is the same amount each month, she uses a(n)_____ to identify the cell containing the income value.
Business
1 answer:
Naily [24]3 years ago
4 0

Answer:

absolute reference

Explanation:

Based on the information provided within the question it can be said that in this scenario  she uses an absolute reference to identify the cell containing the income value. This refers to an actual fixed location within an excel sheet, and it is usually locked so that the rows and columns associated with it won't change when it is copied.

You might be interested in
Here are returns and standard deviations for four investments. Return (%) Standard Deviation (%) Treasury bills 4.5 0 Stock P 8.
Jlenok [28]

Answer:

a. Standard deviation of the portfolio = 7.00%

b(i) Standard deviation of the portfolio = 30.00%

b(ii) Standard deviation of the portfolio = 4.00%

b(iii) Standard deviation of the portfolio = 21.40%

Explanation:

Note: This question is not complete. The complete question is therefore provided before answering the question as follows:

Here are returns and standard deviations for four investments.

                                  Return (%)           Standard Deviation (%)

Treasury bills                4.5                                    0

Stock P                          8.0                                   14

Stock Q                        17.0                                  34

Stock R                       21.5                                    26

Calculate the standard deviations of the following portfolios.

a. 50% in Treasury bills, 50% in stock P. (Enter your answer as a percent rounded to 2 decimal places.)

b. 50% each in Q and R, assuming the shares have:

i. perfect positive correlation

ii. perfect negative correlation

iii. no correlation

(Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)

The explanation to the answer is now provided as follows:

a. Calculate the standard deviations of 50% in Treasury bills, 50% in stock P. (Enter your answer as a percent rounded to 2 decimal places.)

Since there is no correlation between Treasury bills and stocks, it therefore implies that the correlation coefficient between the Treasury bills and stock P is zero.

The standard deviation between the Treasury bills and stock P can be calculated by first estimating the variance of their returns using the following formula:

Portfolio return variance = (WT^2 * SDT^2) + (WP^2 * SDP^2) + (2 * WT * SDT * WP * SDP * CFtp) ......................... (1)

Where;

WT = Weight of Stock Treasury bills = 50%

WP = Weight of Stock P = 50%

SDT = Standard deviation of Treasury bills = 0

SDP = Standard deviation of stock P = 14%

CFtp = The correlation coefficient between Treasury bills and stock P = 0.45

Substituting all the values into equation (1), we have:

Portfolio return variance = (50%^2 * 0^2) + (50%^2 * 14%^2) + (2 * 50% * 0 * 50% * 14% * 0) = 0.49%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (0.49%)^(1/2) = (0.49)^0.5 = 7.00%

b. 50% each in Q and R

To calculated the standard deviation 50% each in Q and R, we first estimate the variance using the following formula:

Portfolio return variance = (WQ^2 * SDQ^2) + (WR^2 * SDR^2) + (2 * WQ * SDQ * WR * SDR * CFqr) ......................... (2)

Where;

WQ = Weight of Stock Q = 50%

WR = Weight of Stock R = 50%

SDQ = Standard deviation of stock Q = 34%

SDR = Standard deviation of stock R = 26%

b(i). assuming the shares have perfect positive correlation

This implies that:

CFqr = The correlation coefficient between stocks Q and = 1

Substituting all the values into equation (2), we have:

Portfolio return variance = (50%^2 * 34%^2) + (50%^2 * 26%^2) + (2 * 50% * 34% * 50% * 26% * 1) = 9.00%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (9.00%)^(1/2) = (9.00%)^0.5 = 30.00%

b(ii). assuming the shares have perfect negative correlation

This implies that:

CFqr = The correlation coefficient between stocks Q and = -1

Substituting all the values into equation (2), we have:

Portfolio return variance = (50%^2 * 34%^2) + (50%^2 * 26%^2) + (2 * 50% * 34% * 50% * 26% * (-1)) = 0.16%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (0.16%)^(1/2) = (0.16%)^0.5 = 4.00%

b(iii). assuming the shares have no correlation

This implies that:

CFqr = The correlation coefficient between stocks Q and = 0

Substituting all the values into equation (2), we have:

Portfolio return variance = (50%^2 * 34%^2) + (50%^2 * 26%^2) + (2 * 50% * 34% * 50% * 26% * 0) = 4.58%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (4.58%)^(1/2) = (4.58%)^0.5 = 21.40%

8 0
3 years ago
Fiedler's contingency theory of leadership suggests that leaders should be placed in leadership situations that best fit with th
rodikova [14]

Answer:

Explanation:

Suppose, you are a team leader & perhaps your opinion is huge and respected by your workers. Then;

Opinion is better-suited for relationship-motivated leadership

However, let say you're promoted from your post to another position to lead a team, it is possible that your followers will get bitter due to the fact that you're being promoted. In this case;

Confident is better-suited for  relationship-motivated leadership

Similarly, a scenario where we can have a task motivated leadership is as follows:

Let assume that, your workers are working on a project and you're not present there as a team leader.

Then, Achieve is better suited for task-motivated leadership

8 0
3 years ago
3<br>Hame and explain<br>of skills that should be possess by an entrepreneur <br>​
vaieri [72.5K]

Answer:

1. Curiosity. Great entrepreneurs are tasked with identifying new problems, identifying potential niche opportunities, refactoring their existing business processes, and innovating. This necessitates a passion for various fields of study and business cases that are outside of one's comfort zone.

2. Time management. Prioritization, milestone definition, execution, and iteration are all critical. None of this would be possible without the proper project management and time allocation methodologies in place to complete the work.

3. Strategic thinking. Learning to break down a problem to its simplest components and identify growth opportunities. Inventive problem-solving and spotting the low-hanging fruit. Defining an MVP's scope and testing concepts in a short amount of time and on a tight budget.

7 0
3 years ago
Selma deposited a paycheck for $378.42. she’ll use the check register to record her transaction. What will be her new balance?
stepladder [879]

Selma’s new balance will be $378.42. A paycheck also known as a pay check or pay cheque, is a paper document issued by an employer to pay an employee for services rendered. However, the physical paycheck is increasingly being replaced by electronic direct deposits to the employee's designated bank account or loaded onto a payroll card.

Employees may still receive a pay slip detailing the final payment amount calculations. A salary statement, also known as a payslip, pay stub, paystub, pay advice, or sometimes paycheck stub or wage slip, is a document received by an employee that either includes or is attached to the paycheck.

Each country has laws governing what information must be included on a payslip .

To learn more about paycheck, click here

brainly.com/question/8657860

#SPJ4

5 0
2 years ago
How many Districts is our FED split into?<br> 08<br> O 10<br> O 12<br> O 15
irina1246 [14]

Answer:

12

Explanation:

because the United States qas divided geographically into 12 districts

3 0
3 years ago
Other questions:
  • The span of control for a manager:
    10·1 answer
  • Frances had a wonderful product, but her salesforce frequently argued over sales tactics and territories. Conflicts arose over i
    11·1 answer
  • Excey Corp. has 8 percent coupon bonds making annual payments with a YTM of 7.2 percent. The current yield on these bonds is 7.5
    7·1 answer
  • Define logistics management. Click the answer you think is right. It is the management of the movement of materials and informat
    13·1 answer
  • Jeff has the opportunity to receive​ lump-sum payments either now or in the future. Which of the following opportunities is the​
    14·1 answer
  • When you are shopping for a loan, the __________ is the important rate to compare.
    13·1 answer
  • Concord Corporation had the following transactions during 2022: 1. Issued $190000 of par value common stock for cash. 2. Recorde
    15·1 answer
  • John, who has just completed his first finance course, is unsure whether he should take a course in business analysis and valuat
    9·1 answer
  • Gabbe Industries is a division of a major corporation. Last year the division had total sales of $23,826,400, net operating inco
    13·1 answer
  • An increase in revenues increases net income, and net income increases stockholders’ equity. True or false?.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!