All categories

2 years ago

Provide an example of how businesses might apply a conditional formula to spreadsheet data

1 answer:

3 0

A business might apply conditional formula to calculate the payouts for the different employees of the organisation.

Explanation:

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. This helps you to differentiate and make difference between the values to be put in the different cells depending on the criteria.

Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

You might be interested in

Is Anna eligible to receive a Pell Grant? If she is, what is the maximum amount she can get from a Pell Grant?

weqwewe [10]

Answer:

$6,195 for te 20119-2020 year.

Explanation:

The Pell Grant is a financial aid given to students who have money needs and doesn't have an undergraduate degree. The amount a person can get changes every year depending on several factors like family contribution and if the student will be attending full-time or part-time but the maximum amount for the year 2019-2020 is $6,195.

4 0

2 years ago

Read 2 more answers

A graphics reproduction firm has four units of equipment that are automatic but occasionally become inoperative because of the n

elena55 [62]

Answer:

(a) Average number of unit in line = 0.256

(b) Average number of unit in operation= 3.209

Explanation:

Given Data:

Number of machine N = 4

Number of attendant (S) = 1

Service time (T)= 5 mins

Time required by the machine before servicing = 30 mins

Calculating the service factor (X) using the formula;

X = T/(T+U)

= 5/(5+30)

= 5/35

= 0.1429

(a) Calculating the average number of unit in line (L) using the formula;

L = N* (1-F)

where, N = Number of unit

F = efficiency factor

L = average number of unit in line

Using the finite queuing table at X = 0.1429 and S = 1,

Efficiency factor = 0.936

Substituting, we have;

L = 4*(1-0.936)

= 4* 0.064

= 0.256

H = N*F*X

= 4 *0.936*0.1429

= 0.535

(b) Calculating the average number of unit in operation using the formula;

Average number of unit in operation= Number of unit-down unit

But down unit = L+H

The formula becomes;

Average number of unit in operation= Number of unit-(L+H)

= 4 - (0.256+0.535)

= 4-0.791

= 3.209

6 0

2 years ago

FARO Technologies, whose products include portable 3D measurement equipment, recently had 36 million shares outstanding trading

erma4kov [3.2K]

Answer:

A. $117 million

B.13%

C. $21.75

Explanation:

B. Calculation to determine How large a loss in dollar terms will existing FARO shareholders experience on the announcement date

Expected Loss= 390*30%

Expected Loss= $117 millions

Therefore How large a loss in dollar terms will existing FARO shareholders experience on the announcement date will be $117 millions

B. Calculation to determine What percentage of the value of FARO’s existing equity prior to the announcement is this expected gain or loss

First step is to calculate the Existing Shares Value

Existing Shares Value =36*$25

Existing Shares Value= $900 millions

Now let calculate the Expected Loss %

Expected Loss % = $ 117/$ 900

Expected Loss % = 13%

Therefore the percentage of the value of FARO’s existing equity prior to the announcement is this expected gain or loss will be 13%

C. Calculation to determine At what price should FARO expect its existing shares to sell immediately after the announcement

Price Per Share: $ 25*(1 - 0.13)

Price Per Share$25*0.87

Price Per Share: $21.75

Therefore what price should FARO expect its existing shares to sell immediately after the announcement is $21.75

6 0

2 years ago

An investment project has annual cash inflows of $4,200, $5,300, $6,100, and $7,400, and a discount rate of 14 percent. If the i

Eva8 [605]

Answer:

An investment project has annual cash inflows of $4,200, $5,300, $6,100, and $7,400, and a discount rate of 14 percent. If the initial cost is $7,000, the discounted payback period for these cash flows is ___2_____ years. If the initial cost is $10,000, the discounted payback period for these cash flows is___3____years. If the initial cost is $13,000, the discounted payback period for these cash flows is__4_____years. (Round your answers to 2 decimal places. (e.g., 32.16))

Explanation:

a) Data and Calculations:

Annual cash inflows of

Cash Inflow Discount Factor PV Running Total

Year 1 $4,200 0.877 $3,683.40 $3,683.40

Year 2 $5,300 0.769 4,075.70 7,759.10

Year 3 $6,100 0.675 4,117.50 11,876.60

Year 4 $7,400 0.592 4,380.80 16,257.40

b) An investment project's discounted payback period is the number of years it takes for an investment to recover its costs. It is the period when the project's discounted cash inflows equals the project's discounted cash outflows. It is another version of the payback period that uses discounted cash flows.

3 0

2 years ago

Green Roof Inns is preparing a bond offering with a 6 percent, semiannual coupon and a face value of $1,000. The bonds will be r

belka [17]

Green Roof Inns is preparing a bond offering with a 6 percent, semiannual coupon and a face value of $1,000. The bonds will be repaid in 10 years and will be sold at par.-The correct statement is -The bonds will sell at a premium if the market rate is 5.5

Explanation:

The important point to be noted from the given question is that the bond is offered when the market rate is 6 percent.

So ,the bonds are said to selling at premium since the market rate has reduced from 6% to 5.5%

In this case it is right to say that -Green Roof Inns is preparing a bond offering with a 6 percent, semiannual coupon and a face value of $1,000. The bonds will be repaid in 10 years and will be sold at par.-The correct statement is -The bonds will sell at a premium if the market rate is 5.5

4 0

2 years ago