Question

Use the table to find the value of each asset today ASSET Year Amount Appropriate required...

Use the table to find the value of each asset today

ASSET

Year

Amount

Appropriate required return

A

1

3,000

8%

2

3,000

3

3,000

B

1 through infinity

500

5%

C

1

0

6%

2

0

3

0

4

0

5

45,000

D

1 through 5

1,500

4%

6

8,500

E

1

2,000

7%

2

3,000

3

5,000

4

7,000

5

4,000

6

1,000

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

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy Σ AutoSum ー E ゴWrap Text Sort &Find & Insert Delete Format Cells в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Formatting as Table Styles2 Clear Edting Format Painter Number Alignment Clipboard H111 97 98 PV FACTOR AT 8% PVOF AMOUNT 100 101 102 103 104 105 106 107 108 109 110 ASSET A YEAR AMOUNT TABLE VALUES ARE UPTO 3 DECIMALS 3000 3000 3000 0.926 0.857 0.794 2778 2571 2382 7731 PRESENT VALUE PRESENT VALUE = AMOUNT/RATE PRESENT VALUE 500/0.05 ASSET B PERPETUITY 10000 112 113 114 115 11 1 r EAC MACRS RATIOCASHBUDGETwacc BOND EPS EBIT REPLACEMENT STats d external rate MIRR NPV İRR REPLACEMENT S -HPR GMAM 福 130% IRRnpv RATION PBP ARR 05:13 29-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Wrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Edting U123 110 111 ASSET C 112 113 114 115 116 PV FACTO PV OF PV FACTOR AT 6% PVOF AMOUNT ASSET D YEAR AMOUNT AMOUNT AT 4% AMOUNT 0 0.943 0.89 0.84 0.792 0 15000.962 15000.925 3 1500 0.889 15000.855 5 1500 0.822 8500 0.790 1443 1387.5 1333.5 1282.5 1233 6715 0 0 4 118 119 120 121 122 123 124 125 126 127 128 11 45000 0.747 33615 PRESENT VALUE 33615 PRESENT VALUE- 13394.5 : IRRnpv RATION PBP ARR ( external rate MIRR NPV İRR REPLACEMENT S HPR GMAM CEAC MACRS RATIOCASHBUDGET wacc BOND EPS EBIT REPLACEMENT STats 05:14 29-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy E AutoSum Wrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting 148 131 132 133 ASSETE 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 11 1 r IRRnpv RATION PBP ARR PV FACTOR PVOF YEAR AMOUNT AT 7% AMOUNT 0.935 0.873 2619 0.816 0.763 5341 0.713 2852 0.666 2000 3000 1870 4080 4 7000 4000 1000 PRESENT VALUE- 17428 external rate MIRR NPV İRR REPLACEMENT S -HPR GMAM EAC MACRS RATIOCASHBUDGETwacc BOND EPS EBIT REPLACEMENT STats d 福 130% 05:14 29-01-2019

Add a comment
Know the answer?
Add Answer to:
Use the table to find the value of each asset today ASSET Year Amount Appropriate required...
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
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
ADVERTISEMENT