All categories

4 years ago

A formula is a math equation used in a spreadsheet....... true or false

Business

2 answers:

lisabon 2012 [21]4 years ago

6 0

True, you can use a formula in Excel spreadsheet!

nikdorinn [45]4 years ago

6 0

Ture Hope this helped

You might be interested in

Fitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as neede

bezimeni [28]

Answer:

1. 20%

2. 25.20%

3. 24.00%

Explanation:

1. The computation of return on investment is shown below:-

Return on investment = Operating income ÷ Average operating assets

= $70,000 ÷ $350,000

= 20%

2. The computation of return on investment (ROI) is shown below:-

Return on investment = Operating income ÷ Average operating assets

= ($70,000 + $18,200) ÷ $350,000

= $88,200 ÷ $350,000

= 25.20%

3. The computation of return on investment (ROI) is shown below:-

Return on investment = Operating income ÷ Average operating assets

= ($70,000 + $14,000) ÷ $350,000

= $84,000 ÷ $350,000

= 24.00%

So, we have applied the above formula.

7 0

3 years ago

Janine is 25 and has a good job at a biotechnology company. She currently has $5,000 in an IRA, an important part of her retirem

nexus9112 [7]

Answer:

$108,622.60

Explanation:

Calculation for the amount Janine's IRA will worth when she needs to start withdrawing money from it when she retires

Based on the information given we were told that She has the amount of $5,000 in an IRA, which is a vital part of her retirement nest egg in which She has well believes that her IRA will increase at an annual rate of 8%.

Secondly we were told that she is 25 age and plan to retire at the age of 65 which means that the number of years until her retirement will be 40 years(65 years-25 years)

Now let calculate how much she will be worth using this formula

Amount worth= Present value in IRA*(Annual rate increase)^ Numbers of years until retirement

Let plug in the formula

Amount worth=5,000 *(1 + 0.08)^40 =

Amount worth=5,000*(1.08)^40

Amount worth =5,000*21.72452

Amount worth= $108,622.60

Therefore Janine's IRA will be worth $108,622.60 when she needs to start withdrawing money from it when she retires.

7 0

3 years ago

Assume that the salespeople of Excellent Corp. are paid 3% of sales as commission. The level of sales is $290,000 for this month

GaryK [48]

Answer:

d. $28,700.

Explanation:

The computation of the budgeted selling cost for the given month is shown below:

= Fixed selling cost + variable selling cost

= $20,000 + $290,000 × 3%

= $20,000 $+ $8,700

= $28,700

We simply applied the above formula so that the correct value could come

And, the same is to be considered

Hence, the correct option is d. $28,700

8 0

3 years ago

You are trying to pick the least-expensive car for your new delivery service. You have two choices: the Scion xA, which will cos

PilotLPTM [1.2K]

Answer:

EAC of Scion xA= 12,429.24

EAC of Toyota = $11,922.02

The Toyota should selected because it has a lower EAC

Explanation:

Equivalent Annual cost = PV of cost/Annuity factor

<em>Scion xA</em>

PV of OCF= A × (1- (1+r)^(-n)/n

= 2,900 × (1 -(1.13)^(-3))/0.13=6847.342534

PV of total cost = 22,500 + 6847.34 = 29,347.34253

EAC = 29,347.34/ 2.361152598= 12429.24433

EAC = 12429.24

<em>EAC Toyota</em>

PV of OCF = 1500×(1 -(1.13)^(-4))/0.13= 4461.706988

PV of total cost = 31,000 + 4461.7069= 35,461.70699

EAC = 35,461.706/ 2.9744 = 11,922.02

EAC = $11,922.02

EAC of Scion xA= 12429.24

EAC of Toyota = $11,922.02

4 0

4 years ago

Assume you decide that you would like to open a restaurant in your community. Before taking the plunge, you go to work for a com

g100num [7]

Answer: it is ethical if the restaurant is to be opened outside the community.

Explanation:

7 0

4 years ago