Business, 03.02.2021 01:00 kevenluna10oytivm

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.) A B C D E F 1 Enter the given values here 2 Rate per period 3 Number of periods 4 Future Value

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 17:10

Diggity dank corporation uses an activity-based costing system with two activity cost pools. diggity dank uses direct labor hours as the measure of activity in the first activity cost pool and the number of orders in the second activity cost pool. the following information relates to these two activity cost pools for last year: what was diggity dank's under- or overapplied overhead for last year? a. $17,000 overapplied b. $20,000 underapplied c. $27,000 underapplied d. $73,000 overapplied

Answers: 1

Answer

Business, 22.06.2019 07:00

Ireally need with these questions.6. what level of job security do athletes and sports competitors have? why do you think this is? 22. do you think a musician has more job security than an athlete? explain.37. what is the difference between a public relations specialist and a marketing professional? 47. do you think gender inequalities still exist in the sports industry? explain.50. what are the advantages and disadvantages of labor unions? do you think labor unions are fair to employers? how might they be taken advantage of?

Answers: 1

Answer

Business, 22.06.2019 08:00

Why do police officers get paid less than professional baseball players?

Answers: 2

Answer

Business, 22.06.2019 13:30

On january 2, well co. purchased 10% of rea, inc.’s outstanding common shares for $400,000, which equaled the carrying amount and the fair value of the interest purchased in rea’s net assets. well did not elect the fair value option. because well is the largest single shareholder in rea, and well’s officers are a majority on rea’s board of directors, well exercises significant influence over rea. rea reported net income of $500,000 for the year and paid dividends of $150,000. in its december 31 balance sheet, what amount should well report as investment in rea?

Answers: 3

Answer

You know the right answer?

The present value or “PV function” in Excel is used to calculate the current value of future payment...

Questions