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
suter [353]
3 years ago
5

Suppose you just won the state lottery, and you have a choice between receiving $2,575,000 today or a 20-year annuity of $250,00

0, with the first payment coming one year from today. What rate of return is built into the annuity? Disregard taxes.
Business
1 answer:
Shkiper50 [21]3 years ago
8 0

Answer:

Ans. rate of return= 7.37%

Explanation:

The easiest way to find this discount rate is to set a MS Excel sheet and use the function "Find Goal". In the attachments, there is a spreadsheet that I got ready for you. There are 2 cells in color, one is yellow and the other one is green. You just go ahead and replace the value of the green cell with any percentage that you want, for example, 2%, then use the function "find goal" and set the objective cell to be the yellow cell (B5), changing the cell in green (B7), and hit enter.

Best of luck.

Download xlsx
You might be interested in
The Freed Corporation produces three products, X, Y, Z, from a single raw material input. Product Y can be sold at the split-off
dexar [7]

Answer:

Increase in income= (68,000 - 16,000) - 50,000= 2,000

New income= 68,000 - 16,000= 52,000

Explanation:

Giving the following information:

Product Y can be sold at the split-off point for total annual revenues of $50,000, or it can be processed further at a total annual cost of $16,000 and then sold for $68,000.

Increase in income= (68,000 - 16,000) - 50,000= 2,000

New income= 68,000 - 16,000= 52,000

3 0
3 years ago
A 9%, $1000 bond matures in 16 years, pays interest semi-annually, and has a yield to maturity of 9.86%. What is the current mar
Mama L [17]

PMT = 1000*.09 = 90/2 = 45

Nper = 16*2 = 32

Rate = 9.86%/2 = 4.93%

FV =1000

PV =?

Price of Bond = PV(rate,per,pet,fv) = PV(4.93%,32,45,1000) = 931.48

Answer is 931.48

In mathematics, a rate is the ratio of two related quantities expressed in different units. If the denominator of a ratio is expressed as a single unit of one of these quantities, and that quantity is assumed to be systematically changing (that is, it is the independent variable), then the numerator of the ratio is the corresponding rate of change. represents Other (Dependent) Variables.

Rate is a special relationship in which the two terms have different units. For example, if a 12 oz can of corn costs 69 cents, the price is 69 cents for 12 oz. It is not a ratio of two equal units like this: B. Shirt. This is the ratio of his two unequal units, cents, and ounces.

Learn more about Rate here: brainly.com/question/1115815

#SPJ4

8 0
2 years ago
47.Acme Company has authorized 100,000 shares of common stock, of which 75,000 shares were originally issued. As of December 31,
kkurt [141]

Answer:

Number of shares outstanding on December 31, 20X1:

Number of shares issued                     75,000 shares

Less: Number of shares repurchased <u>5,000</u> shares

Number of shares outstanding           <u>70,000</u> shares

Explanation:

The number of shares outstanding on December 31, 20X1 is the difference between the number of shares issued and the number of shares repurchased by the company and held as treasury stock.

4 0
4 years ago
Serena Medavoy will invest $5,890 a year for 17 years in a fund that will earn 12% annual interest. Click here to view factor ta
Troyanec [42]

Answer:

$287,924.84

Explanation:

We are to calculate the future value of the annuity

The formula for calculating future value = A (B / r)

B = [(1 + r)^n] - 1

FV = Future value  

P = Present value  

R = interest rate  

N = number of years  

[(1.12)^17 - 1] / 0.12 = 48.883674

$5,890 x 48.883674 = $287,924.84

7 0
3 years ago
E. In cell L16, enter a formula using the AVERAGEIF function that averages the budget amounts for Action movie projects
mrs_skeptik [129]

The purpose of an AVERAGEIF function is to help one find the average of numbers that meet a certain criteria within a dataset.

<h3>What does an AVERAGEIF function do?</h3>

The full question is not provided so the best I can do is to provide a general overview.

An averageif function is available in spreadsheets and is used to find the average of numbers in a range of data that meet a certain criteria.

For instance, if you want to average the budget amounts for Action movie projects, a relevant formula would be:

= AVERAGEIF(Projects, "Action movie", Projects[Budgets])

Find out more on the Averagif function at brainly.com/question/19595618.

8 0
3 years ago
Other questions:
  • After tyrese and ryan move in together, ryan finds himself disappointed. he thought they'd spend all their time together, but ty
    11·1 answer
  • Mikalya put 500$ in the bank. The annual interest rate is 2 percent. How much money will mikalya earn in one year?
    5·1 answer
  • The "death benefit" associated with a variable annuity contract means that if the contract holder dies:__________.
    8·1 answer
  • Michele had been working as an executive assistant to the president for nearly 25 years, so when she retired, no one had a good
    15·1 answer
  • Companies use mail merge to send out advertisements to possible customers.<br><br> True<br> False
    5·2 answers
  • A customer's account appears as follows:
    15·1 answer
  • Pizza Express Inc. began the 2016 accounting period with $2,500 cash, $1,400 of common stock, and $1,100 of retained earnings. P
    9·1 answer
  • Sydney worked as an Urban Planner before switching to City Court Clerk. What most likely remained the same despite the job chang
    5·2 answers
  • What is SEO?
    15·1 answer
  • When freelancers sell to publisher the right to use a piece only once, and there is no guarantee that it has not been published
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!