All categories

3 years ago

What is the difference between independent variables and dependent variables in a spreadsheet?

1 answer:

6 0

On a spreadsheet there are two types of variables independent and dependent. Independent variables refer to those that can be changed and their value that is changing. A dependent variable is something that remains the same and the value of it does not change.

You might be interested in

In working on a bid for project you have determined that $245,000 of fixed assets will be required and that they will be depreci

mote1985 [20]

Answer:

Question 1:

required investment $245,000

depreciation expense per year = ($245,00 - $23,200) / 5 = $44,360

you will also require $15,000 in working capital

annual cash costs = $68,500

what is the minimum amount of cash sales for accepting the project:

net cash flow₁ = {[(sales revenue - $68,500 - $44,360) x 0.65] + $44,360} / 1.14 = (0.65SR - $28,999) / 1.14 = 0.5702SR - $25,437.72

net cash flow₂ = {[(sales revenue - $68,500 - $44,360) x 0.65] + $44,360} / 1.14² = (0.65SR - $28,999) / 1.14² = 0.5002SR - $22,313.79

net cash flow₃ = {[(sales revenue - $68,500 - $44,360) x 0.65] + $44,360} / 1.14³ = (0.65SR - $28,999) / 1.14³ = 0.4387SR - $19,573.50

net cash flow₄ = {[(sales revenue - $68,500 - $44,360) x 0.65] + $44,360} / 1.14⁴ = (0.65SR - $28,999) / 1.14⁴ = 0.3849SR - $17,169.74

net cash flow₅ = {[(sales revenue - $68,500 - $44,360) x 0.65] + $44,360 + $15,000} / 1.14⁵ = (0.65SR - $13,999) / 1.14⁵ = 0.3376SR - $7,270.64

NPV = -initial outlay + cash flows

NPV = 0

initial outlay = cash flows

$260,000 = 0.5702SR - $25,437.72 + 0.5002SR - $22,313.79 + 0.4387SR - $19,573.50 + 0.3849SR - $17,169.74 + 0.3376SR - $7,270.64

$260,000 = 2.2316SR - $91,765.39

$351,765.39 = 2.2316SR

sales revenue = $351,765.39 / 2.2316 = $157,629.23

the closest answer is B = $155,119, but its NPV will be negative.

<u>so we have to select C = $162,515.75 that results in an NPV = $10,887. </u>

Question 2:

<u>The correct answer is D. return on equity will increase.</u>

If you lower your costs while your sales remain the same, your profits will increase as well as your ROE.

7 0

3 years ago

Show how Cablevision can conduct an ROI analysis. Describe the information that the company should collect and how it should b c

Flauer [41]

Answer:

Explanation:

Cablevision can easily accomplish this by doing the following. First gather the number of sales of premium services and other products that non-trained individuals are accomplishing in a given time period (example, one month). Next, under the same conditions place the newly trained individuals and gather the same data from them (number of sales/subscribers gained, premium products, and other products). Finally, they would simply need to compare the difference in the number of sales to see if the training paid off. They would also need to calculate if the difference in sales surpasses the costs of training.

3 0

3 years ago

How could biotechnology affect your privacy?

svetlana [45]

<span>How could biotechnology affect your privacy? Biotechnology can be used to perform tests that weren't necessary. If these tests are performed health insurance companies may find issues that weren't presented at the time of insuring them and decide not to insure. Biotechnology is the growing of biological processes for different purposes to manipulate microorganisms int the production of antibiotics and hormones. These technology's are growing and giving more focus on what biotech can do for our country and those suffering from illness and hormone issues. </span>

8 0

3 years ago

Companies create a division of labor among employees in order to: 0 a. allow each employee to perform one task at a high level.

sergejj [24]

Companies create a division of labor among employees in order to allow each employee to perform one task at a high level

<h3>What is division of labor?</h3>

It involves Sharing of duties or job among individuals or employee.

An employee is allowed to handle a particular task for efficiency.

Therefore, Companies create a division of labor among employees in order to allow each employee to perform one task at a high level

Learn more on labor below?

brainly.com/question/25803580

#SPJ1

3 0

2 years ago

If demand increased by 100 units at each price level, and the government set a price ceiling of $40, then there will be

mel-nik [20]

Answer:

no surplus or shortage

Explanation:

Equilibrium price is the price at which quantity demand equal quantity supplied. Above equilibrium price there is a surplus - quantity supplied exceeds quantity demanded.

Below equilibrium price there is a shortage - quantity demanded exceeds quantity supplied

If demamd increases by 100, new equilibrium is 40

Thus, ceiling price equal equilibrium

Price ceiling is when the government or an agency of the government sets the maximum price for a product. It is binding when it is set below equilibrium price.

Effects of a binding price ceiling

It leads to shortages

it leads to the development of black markets

it prevents producers from raising price beyond a certain price

It lowers the price consumers pay for a product. This increases consumer surplus

4 0

3 years ago