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
UkoKoshka [18]
3 years ago
12

A computerized spreadsheet programs is useful for

Business
1 answer:
Oksana_A [137]3 years ago
8 0
I think the answer is A. Sorting and charting data from surveys
You might be interested in
You are considering the purchase of a common stock that paid a dividend of $3.00 yesterday. You expect this stock to have a grow
Ray Of Light [21]

Answer:

$50.8

Explanation:

As per given Data

Dividend Paid = $3

Worth of the stock is the present value of all the cash flows associated with the stock. Dividend is the only cash flow that a stock holder receives against its investment in the stocks. We need to calculate the present values of all the dividend payments.

Formula for PV of dividend

PV of Dividend = Dividend x ( 1 + growth rate )^n x ( 1 + r )^-n

1st year

PV of Dividend = $3 x ( 1 + 20%)^1 x ( 1 + 14% )^-1 = $3.16

2nd year

PV of Dividend = $3 x ( 1 + 20%)^2 x ( 1 + 14% )^-2 = $3.32

3rd year

PV of Dividend = $3 x ( 1 + 20%)^3 x ( 1 + 14% )^-3 = $3.50

After three years the dividend will grow at a constant rate of 5%, so we will use the following formula to calculate the present value

PV of Dividend = [ $3 x ( 1 + 20%)^3 x ( 1 + 5%) / ( 14% - 5% ) ] x [ ( 1 + 14% )^-3 ]

PV of Dividend = $40.82

Value of Stock = $3.16 + $3.32 + $3.50 + $40.82 = $50.8

6 0
3 years ago
In which situation would it be most appropriate to use money you have set aside in your emergency fund?
Law Incorporation [45]

The money that has been set aside for emergency situations can be ideally used for paying the phone bill at first.

Option C is the correct answer.

<h3>What is an emergency fund?</h3>

An emergency fund is an amount that is kept by an individual out of their earned income which is further to be used in uncertain times.

An emergency fund has been created to meet the contingencies in life that can be in the form of repairs of any equipment, medical problems, loss of job, etc. This fund helps the individual in uncertain times when he/she is in need of funds.

Therefore, the phone bill should be paid first from the emergency fund then the rest of the expenses to be considered.

Learn more about the emergency fund in the related link:

brainly.com/question/14826786

#SPJ1

3 0
1 year ago
A real estate agent is considering changing her land line phone plan. There are three plans to choose from, all of which involve
Yakvenalex [24]

Answer:

PLAN A:

(120 * 0.39) + (40 * 0.19) + 20 = $74.40

PLAN B:

(120 * 0.49) + (40 * 0.14) + 20 = $84.40

PLAN C:

$20 + $75 = $95 ;

PLAN A is optimal from 0 to 192 minutes

PLAN C is optimal from 192 minutes onward ;

Explanation:

PLAN A :

Service charge = $20

Daytime = $0.39 per minute

Evening = $0.19 per minute

PLAN B :

Service charge = $20

Daytime = $0.49 per minute

Evening = $0.14 per minute

PLAN C :

Service charge = $20

225 minutes = $75

Minutes beyond 225 = $0.36 per minute

A.)

Determine the total charge under each plan for this case: 120 minutes of day calls and 40 minutes of evening calls in a month.

PLAN A:

(120 * 0.39) + (40 * 0.19) + 20 = $74.40

PLAN B:

(120 * 0.49) + (40 * 0.14) + 20 = $84.40

PLAN C:

$20 + $75 = $95

b. If the agent will use the service for daytime calls, over what range of call minutes will each plan be optimal?

PLAN A:

20 + 0.39D = 95

0.39D = 95 - 20

D = 75 / 0.39

D = 192.31

5 0
3 years ago
When looking for a job, taking initiative will help your search efforts. true or false?
BartSMP [9]
The answer is true. Hope this helps.
3 0
3 years ago
A bond with a $1,000 par value sells for $895. The coupon rate is 7%, the bonds mature in 20 years, and coupon interest is paid
LuckyWell [14K]

Answer:

After tax cost of debt is 5.239%

Explanation:

Given:

Face value = $1,000

Bond price = $895

Coupon payments = 0.035×1,000 = $35 (coupon payment is paid semi-annually so 7% is divided by 2)

Maturity = 20×2 = 40 periods

Using bond price formula:

Bond price = Present value of face value + present value of coupon payments

Use excel function =RATE(nper,pmt,PV,FV) to calculate cost of debt.

substituting the values:

=RATE(40,35,-895,1000)

we get Pre-Tax cost of debt = 4.03% semi- annual

Annual rate is 4.03%×2 = 8.06%

Note: PV is negative as bond price is cash outflow.

After tax cost of debt = 8.06(1 - 0.35)

                                     = 5.239%

3 0
3 years ago
Other questions:
  • You are trying to decide what you want to major in during your college years. How should you go about making the decision?
    5·2 answers
  • During the current month, Sheffield Company incurs the following manufacturing costs. (a) Purchased raw materials of $17,800 on
    14·1 answer
  • Praetorian Industries will pay a dividend of $2.50 per share this year and has an equity cost ofcapital of 8%. Praetorianʹs stoc
    10·1 answer
  • On January 1 of this year, Olive Corporation issued bonds. Interest is payable once a year on December 31. The bonds mature at t
    9·1 answer
  • A company's financial statements may contain errors even if debits and credit balance because:
    14·1 answer
  • A fancy steak house in a shopping mall offers a 20 percent discount to employees of other stores in the mall, provided that they
    6·1 answer
  • The laws passed by Congress and by state legislatures are called:
    12·2 answers
  • The Phillips curve was first suggested as a description of the relationship between inflation and unemployment in the late 1950s
    6·2 answers
  • One exabyte = 1,000 <br>A. petabytes <br>B.megabytes <br>C. gigabytes <br>D. nanobytes​
    6·1 answer
  • This is my mom channel please subscribe​
    11·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!