answer.
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
Sindrei [870]
2 years ago
15

Present value calculations The present value or "PV function" in Excel is used to calculate the current value of future payments

. Consider this example: Suppose your uncle sends you a $10,000 certificate of deposit in your name which will earn 4% interest for the investment period. Under the terms of his gift, you can withdraw the funds after 4 years on the day of your graduation. Use Excel functions to calculate the value of the amount your uncle deposited today to have $10,000 after you graduate. (Note: The certificate of deposit calculates and pays any earned interest at the beginning of each year.)
Business
1 answer:
FromTheMoon [43]2 years ago
6 0

Answer:

PV= $8,548.04

Explanation:

Giving the following information:

Final value= $10,000

n= 4 years

i= 4% compounded annually.

We need to use the following formula:

PV= FV/(1+i)^n

PV= 10,000/(1+0.04)^4

PV= $8,548.04

Your uncle needs to deposit $8,548.04 today in order to have $10,000 in four years.

You might be interested in
Consider two points on the PPF: point A, at which there are 10 apples and 20 pears, and point B, at which there are 7 apples and
lorasvet [3.4K]

Answer:

c. 3 apples.

Explanation:

The opportunity cost is the alternative forgone. It is the item on the scale of preference that had to be let off in the fulfillment of other wants.

Given the two points A, at which there are 10 apples and 20 pears, and point B, at which there are 7 apples and 21 pears, moving from point A to B would mean that the number of apples will decrease from 10 to 7 while the number of pears will increase by 1.

As such, the opportunity cost is 3 apples (10 - 7).

8 0
2 years ago
What do you feel would be a minimally acceptable rate of pay? (ex. $X.XX or $XX,XXX):_______.
Veronika [31]

Correct question: I do not know if this question is complete or not but if i understand you well enough, I'd say that the minimally acceptable rate of pay will be in accordance to what is obtainable in yur state or area. $X.XX represents pay per hour while $XX.XXX represents pay per year.

Answer:

I would say Negotiable to be on the safe side if you can't come up with a certain amount by yourself.

Explanation:

When you have to fill on an application and it gets to the rate of pay, you either be on the safer side and write Negotiable if you do not want to sell yourself short or be too pricey. But it is almost certain that the rate of pay applicable in your state or area is what you will be getting per hour.

I hope this helps.

5 0
2 years ago
A North Face retail store in Chicago sells 500 jackets each month. Each jacket costs the store $100 and the company has an annua
algol13

Answer:

1) What is the annual holding and ordering cost?

annual ordering cost = $100 x 12 = $1,200

annual holding cost = ($100 x 25%) x [500 x 1/2(average inventory)] = $6,250

total $7,450

2) On average, how long does a jacket spend in inventory?

= 30 days / 2 = 15 days

3) If the retail store wants to minimize ordering and holding cost, what order size do you recommend?

economic order quantity (EOQ) = √[(2 x annual demand x order cost) / annual holding cost per unit]

EOQ = √[(2 x 6,000 x 100) / 25] = √48,000 = 219.09 units ≈ 219 units

4) How much would the optimal order reduce holding and ordering cost relative to the current policy?

EOQ = 219

total number of orders = 6,000 / 219 = 27.4 per year

average inventory = 219 / 2 = 109.5 units

annual ordering cost = $100 x 27.4 = $2,740

annual holding cost = ($100 x 25%) x 109.5 = $2,737.50

total $5,477.50

annual savings = $7,450 - $5,477.50 = $1,972.50

6 0
2 years ago
PLZ HELP!! 20 POINTS BRAINLIEST PLZ HELP IM FAILING!!
Westkost [7]

。☆✼★ ━━━━━━━━━━━━━━  ☾  

The correct answer is option D

Have A Nice Day ❤    

Stay Brainly! ヅ    

- Ally ✧    

。☆✼★ ━━━━━━━━━━━━━━  ☾

5 0
2 years ago
Read 2 more answers
TEME is a manufacturer of toy construction equipment. If it pays out all of its earnings as dividends, it will have earnings of
Virty [35]

Answer:

$8.078 million

Explanation:

we must use the same time periods, so instead of using an annual discount rate, we should use a quarterly rate:

effective quarterly interest = (1 + 0.16)¹/⁴ - 1 = 0.0378 = 3.78%

dividends per quarter = 0.3 million + 0.05 million = $0.35 million

terminal value of firm in quarter 4 = 0.35 / 0.0378 = $9.26 million

present value of terminal value = $9.26 / (1.0378)⁴ = $7.983 million

present value of 4 quarterly dividends = $0.3 x 3.64879 (PVIFA, 3.78%, 4 periods) = $1.095 million

NPV = -$1 + $1.095 + $7.983 = $8.078 million

4 0
2 years ago
Read 2 more answers
Other questions:
  • Consider this information about an activity: es = 12, ef = 18, ls = 14, lf = 20. what is the amount of slack associated with thi
    6·2 answers
  • .Rhonda has agreed to invest $16,000 in a partnership with her sister and brother-in-law. Rhonda does not plan to work in the pa
    8·1 answer
  • After sugar refiner has produced fine sugar for baking purposes, what is left over is used to produce molasses. This technology
    9·1 answer
  • An organizational decision maker assesses conditions of certainty, uncertainty, and risk during the process of a. determining th
    6·1 answer
  • Rather than acquire an existing textile manufacturer in Jakarta, FauxFabric Inc. chose to establish new operations in Indonesia.
    14·1 answer
  • 1. Describe Village Volvo's service package.
    5·1 answer
  • The following condensed balance sheet is for the partnership of Miller, Tyson, and Watson, who share profits and losses in the r
    14·1 answer
  • Suppose Asarta Inc. is polluting yucko and they have been tasked with cleaning up some of their waste. The company decides to cl
    13·1 answer
  • Justin and Neil both exhibit behavior that Kimberly calls unethical. What is ethical behavior in business?
    7·2 answers
  • Halliford Corporation expects to have earnings this coming year of per share. Halliford plans to retain all of its earnings for
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!