Question

Douglass Inc. wants to establish an employee reward program whereby they can pay five employees $1,000 a year each for twenty
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Your required answer is option A i.e. $72,697

Explanation:

To calculate the deposit amount today use the formula of Present Value (PV) in excel:

=PV(rate,nper,pmt,fv,type)

Where:

rate = 3.25%

nper = 20 years

pmt = $1000 X 5 Employee = $5,000 (use - sign before this since this is an outflow)

fv = $0

type = 0 (for end of the period)

=PV(3.25\%,20,-\$5,000,0,0)

Present Value (PV) = \$72,6396.73

So your final answer is $72,697 (Rounded off)

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this helpful.

Add a comment
Know the answer?
Add Answer to:
Douglass Inc. wants to establish an employee reward program whereby they can pay five employees $1,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • David inherited an annuity worth $4,169.87 from his uncle. The annuity will pay him five equal...

    David inherited an annuity worth $4,169.87 from his uncle. The annuity will pay him five equal payments of $1,100 at the end of each year. The annuity fund is offering a return of _______. David's friend, Sagar, wants to go to business school. While his father will share some of the expenses, Sagar still needs to put in the rest on his own. But Sagar has no money saved for it yet. According to his calculations, it will cost him...

  • The present value of an annuity is the sum of the discounted value of all future...

    The present value of an annuity is the sum of the discounted value of all future cash flows. You have the opportunity to invest in several annuities. Which of the following 10-year annuities has the greatest present value (PV)? Assume that all annuities earn the same positive interest rate. bevinning of each year An annuity that pays $500 at the end of every six months An annuity that pays $1,000 at the beginning of each year An annuity that pays...

  • i need questions 4,5,6a,b,c,d,11 4. Ben Collins plans to buy a house for $220,000. If the...

    i need questions 4,5,6a,b,c,d,11 4. Ben Collins plans to buy a house for $220,000. If the real estate in his area is expected to increase in value 2 percent each year, what will its approximate value be Page 25 seven years from now? (L012 ) 5. What would be the yearly earnings for a person with $8,000 in savings at an annual interest rate of 15 percent? (L013 ) 6. Using a financial calculator, Excel, or the time value of...

  • What would you pay for a $200,000 debenture bond that matures in 15 years and pays...

    What would you pay for a $200,000 debenture bond that matures in 15 years and pays $10,000 a year in interest if you wanted to earn a yield of: 2%? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) Amount to Pay 3%? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) Amount to Pay 4%? (Round factor values to 5 decimal...

  • Bridgette wants to retire 36 years from now. She decides to start saving $400 each month...

    Bridgette wants to retire 36 years from now. She decides to start saving $400 each month into a Roth IRA starting at the end of this month. If the IRA is expected to earn an average return of 9% annually, how much will she have in the account at the end of 36 years? Round to two decimal places 5. 6. Durran has recently acquired a rare art piece that he plans to put on display in his private collection....

  • In five years your oldest child will be in 8th grade, at which point you and...

    In five years your oldest child will be in 8th grade, at which point you and your family plan to vacation in Europe. You estimate that you will need $20,000 for the trip. How much do you need to set aside today if you can place your money in an investment vehicle earning an average of 4.50% per year? Four years ago, Robert's annual salary was $52,500. Today, he earns $73,800. What has been the average annual rate of growth...

  • 1. Steve Fowler borrowed $94,900 on March 1, 2018. This amount plus accrued interest at 6%...

    1. Steve Fowler borrowed $94,900 on March 1, 2018. This amount plus accrued interest at 6% compounded semiannually is to be repaid March 1, 2028. To retire this debt, Steve plans to contribute to a debt retirement fund five equal amounts starting on March 1, 2023, and for the next 4 years. The fund is expected to earn 5% per annum. How much must be contributed each year by Steve Fowler to provide a fund sufficient to retire the debt...

  • Use program control statements in the following exercises: Question 1 . Write pseudocode for the following:...

    Use program control statements in the following exercises: Question 1 . Write pseudocode for the following: • Input a time in seconds. • Convert this time to hours, minutes, and seconds and print the result as shown in the following example: 2 300 seconds converts to 0 hours, 38 minutes, 20 seconds. Question 2. The voting for a company chairperson is recorded by entering the numbers 1 to 5 at the keyboard, depending on which of the five candidates secured...

  • “Boy, this is all so confusing,” said Ryan as he stared at the papers on his...

    “Boy, this is all so confusing,” said Ryan as he stared at the papers on his desk. If only I had taken the advice of my finance instructor, I would not be in such a predicament today.” Ryan Daniels, aged 27, graduated five years ago with a degree in food marketing and is currently employed as a middle-level manager for a fairly successful grocery chain. His current annual salary of $70,000 has increased at an average rate of 5 percent...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT