Question

INVESTMENT END OF YEAR A B C 1 ​$14,000 ​$14,000 2   14,000 3   14,000 4   14,000...

INVESTMENT

END OF YEAR

A

B

C

1

​$14,000

​$14,000

2

  14,000

3

  14,000

4

  14,000

5

  14,000

​$14,000

  

6

  14,000

  70,000

7

 14,000

8

  14,000

9

  14,000

10

 14,000

  14,000

What is the present value of investment A at a 23 percent annual discount​ rate?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution

The present value of investment A at a 23 percent annual discount rate = $ 39248.62

= $ 39249 [ when rounded off to the nearest whole number ]

The present value of investment B at a 23 percent annual discount rate = $ 18913.98

= $ 18914 [ when rounded off to the nearest whole number ]

The present value of investment C at a 23 percent annual discount rate = $ 21981.05

= $ 21981 [ when rounded off to the nearest whole number ]

Please find the attached screenshots of the excel sheet containing the detailed calculations for the solution.

06.01.2020 03.01.2020 - Microsoft Excel XES FILE HOME A B INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW C Sl.No. (5) Statement

06.01.2020 - Microsoft Excel XES FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sl.No. (5) Hamnogle Statement showing

06.01.2020 - Microsoft Excel X FILE 5 HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sl.No. Statement showing Calculation

Add a comment
Know the answer?
Add Answer to:
INVESTMENT END OF YEAR A B C 1 ​$14,000 ​$14,000 2   14,000 3   14,000 4   14,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
  • The cash flows from these three investments are as​ follows: End of Year              A ____B...

    The cash flows from these three investments are as​ follows: End of Year              A ____B ____ C 1   $1,000   $2,000   $4,000 2   2,000   2,000   4,000 3   3,000   2,000   (4,000) 4   -4,000   2,000   (4,000) 5   4,000   4,000   14,000 a. What is the present value of investment A at an annual discount rate of 11 ​percent?(Round to the nearest​ cent.) b.  What is the present value of investment B at an annual discount rate of 11 percent?​(Round to the nearest​ cent.)...

  • Your investment will pay you $15,000 at the end of one year, $14,000 at the end...

    Your investment will pay you $15,000 at the end of one year, $14,000 at the end of the following year, and $24,000 at the end of the year after that (three years from today). The interest rate is 4%. (a) What is the present value? (b) What will be the future value three years later ? (c) Assuming that the investment costs $40,000 today, what is the net present value (NPV) of the investment?

  • ​(Present value of an uneven stream of payments​) You are given three investment alternatives to analyze....

    ​(Present value of an uneven stream of payments​) You are given three investment alternatives to analyze. The cash flows from these three investments are as​ follows: End of Year A B C 1 $1,000 $3,000 $5,000 2 2,000 3,000 5,000 3 3,000 3,000 (5,000) 4 -4,000 3,000 (5,000) 5 4,000 5,000 15,000 a.  What is the present value of investment A at an annual discount rate of 9 ​percent?  ​(Round to the nearest​ cent.) What is the present value of...

  • Investment End of Year ܢ 2 3 4 5 A $ 2,000 3,000 4,000 (5,000) 5,000...

    Investment End of Year ܢ 2 3 4 5 A $ 2,000 3,000 4,000 (5,000) 5,000 B $3,000 3,000 3,000 3,000 5,000 C $ 5,000 5,000 (5,000) (5,000) 15,000 What is the present value of each of these three investments if the appropriate discount rate is 12 percent?

  • You are given an investment to analyze. The cash flows from this investment are End of year 1. $11,550 2. $2,550 3. $25,...

    You are given an investment to analyze. The cash flows from this investment are End of year 1. $11,550 2. $2,550 3. $25,510 4. $16,130 5. $2,360 What is the present value of this investment if 15 percent per year is the appropriate discount rate? Round the answer to two decimal places.

  • 1. Determine the discount rate assuming the present value of $940 at the end of 1-year...

    1. Determine the discount rate assuming the present value of $940 at the end of 1-year is $865? 2. $9,800 is deposited for 12 years at 5% compounded annually, determine the FV? 3. If $2,800 is discounted back 4 years at an interest rate of 8% compounded semi-annually, what would be the present value? 4. Consider a newlywed who is planning a wedding anniversary gift of a trip to Canada for her husband at the end of 10 years.   She...

  • You are given an investment to analyze. The cash flows from this investment are End of year 1.   $6,100 2.&nbs...

    You are given an investment to analyze. The cash flows from this investment are End of year 1.   $6,100 2.   $2,110 3.   $3,450 4.   $6,290 5.   $2,490 What is the present value of this investment if 15 percent per year is the appropriate discount rate?

  • 1 Data Description 2 Annual Discount Rate 10% 3 Initial Investment cost – $5,000 4 Cash...

    1 Data Description 2 Annual Discount Rate 10% 3 Initial Investment cost – $5,000 4 Cash inflow from year 1 $1,800 5 Cash inflow from year 2 $2,100 6 Cash inflow from year 3 $1,950 7 8 Net Present Value =

  • 16) You are offered an investment that will pay the following cash flows at the end...

    16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...

  • You are given three investment alternatives to analyze. The cash flows from these three investments are...

    You are given three investment alternatives to analyze. The cash flows from these three investments are as​ follows: Investment End 0f Year A B C 1 $3,000 $1,000 $6,000 2 4,000 1,000 6,000 3 5,000 1,000 (6,000) 4 (6,000) 1,000 (6,000) 5 6,000 5,000 16,000 a.  What is the present value of investment A at an annual discount rate of 15 percent? b.  What is the present value of investment B at an annual discount rate of 15 percent? c.  ...

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