All categories

3 years ago

You manage the worksheet shown below and it contains information for the company's 1500 employees,

2 answers:

5 0

The best way for you to create the list of those who make more than $45000 a year and are full time is by using the filter option.

The filter option would be used to highlight the people that are in full employment. After this you have to use the sort to check the compensation column in order to establish those that make more than 45000.

The filter in a spreadsheet helps to put data in a particular category then arrange them based on the criteria that you selected.

The sorting method helps to arrange data based on ascending order or descending order.

kvv77 [185]3 years ago

3 0

Answer:

Explanation:

You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year.

You might be interested in

As winner of a breakfast cereal competition, you can choose one of the following prizes: a. $180,000 at the end of five years. b

Stolb23 [73]

Answer:

i. Discounted cashflow equations.

a. $180,000 at the end of five years.

This is a lump sum present value/ discounted cashflow which can be calculated as;

Formula = 180,000 / ( 1 + r)^n

= 180,000/ ( 1 + 12%)^5

= $102,136.83

b. $11,400 a year forever

This is a perpetuity. The present value/ discounted cashflow of a perpetuity is calculated as;

Formula = Amount/rate

= 11,400/12%

= $95,000

c. $19,000 for each of 10 years.

This is an annuity. The formula for calculating the Present value/ discounted cashflow of an annuity is;

$Formula = Annuity * [\frac{( 1 - (1 + i)^{-n} )}{i} ]$ where i is interest rate and n is number of periods

$= 19,000 * [\frac{( 1 - (1 + 0.12)^{-10} )}{0.12} ]$

= $107,354.24

d. $6,500 next year and increasing thereafter by 5% a year forever.

This is a growing perpetuity. The present value/ discounted cashflow formula is;

= Amount / ( discount rate - growth rate)

= 6,500 / ( 12% - 5%)

= $92,857.14

ii. Choose $19,000 for each of 10 years as it has the highest present value.

7 0

3 years ago

A competitive market economy with low barriers to entry affords an entrepreneur with:.

nalin [4]

A competitive market economy with low barriers to entry affords an entrepreneur with

the opportunity to bring new and different products and services to the market.

5 0

2 years ago

Assume the economy is on aggregate demand AD1. The Fed should attempt to raise investment by enough to shift aggregate demand fr

maw [93]

Answer:

AD2 and then to AD3

Explanation:

If the investment is continued to increase by federal reserve it would only be feasible when money creation decreases the interest rate.

The aggregate demand would then be expanded and the aggregate demand curve shifted to the right. The necessary increase in aggregate demand must be such that aggregate shifts in demand curve from AD1 to AD2 to AD3.

3 0

3 years ago

Your uncle is about to retire, and he wants to buy an annuity that will provide him with $75,000 of income a year for 20 years,

Nataly_w [17]

Answer:

The annuity will cost him $963,212.95.-

Explanation:

Giving the following information:

Cash flow= $75,000

Interest rate= 0.0525

n= 20

First, we need to calculate the final value. We will use the following formula:

FV= {A*[(1+i)^n-1]}/i + {[A*(1+i)^n]-A}

A= annual cash flow

FV= {75,000*[(1.0525^20) - 1]/0.0525} + {[75,000*(1.0525^20)] - 75,000}

FV= 2,546,491.88 + 133,690.82= $2,680,182.70

Now, the present value:

PV= FV/(1+i)^n

PV= 2,680,182.70/(1.0525^20)

PV= $963,212.95

4 0

3 years ago

Marcia buys a $3,000 high-definition plasma television for her home on credit extended by the seller, current city. current city

Alik [6]

That city has purchase money security interest.
purchase money security interest refers to a type of claiming rights that enables lender to make acquistion towards a certain asset in higher priority than other creditors. This type of rights is really important to secure the lender's profit in case the borrowers fail to return the credit (or went bankrupt)

4 0

2 years ago