i need excel formula to solve this # thanks

fx M13 A E H Problem 6-13 1 2. Valuation of assets. Using the information provided in the following table, find the value of each asset Cash flow Appropriate required return End of year Asset Amount 6 A 5,000 1 18% 7 5,000 2 5,000 15% 1 through o 300 B 10 16% C 1 11 2 12 3 13 4 14 35,000 5 15 1 through 5 1,500 12% 16 6 8,500 17 1 2,000 14% 18 2 3,000 19 3 5.000 20 Problem 6-13 . SAMSUNG Esc FT F2 F3 F4 F5 F6 F7 FB F9 FII F10 F12 4+ ! & 2 3 4 6 5 8 E R W T M Y CC OH P G F E D C A Cash flow Appropriate required return 18% End of year Amount Asset 5,000 1 5,000 2 5,000 3 1 through o 15% 300 B 10 16% 1 C 11 12 3 13 14 $ 5 35,000 15 1 through 5 $ 1,500 12% 16 6 8,500 17 E 1 $ 18 2,000 14% 2 19 3,000 20 3 5,000 21 7,000 22 4.000 23 6 1,000 24 Problem 6-13 . SAMSUN D 00 o H G E D AAB C 24 Solution 25 26 PV of 27 Cash Flows End of Year Amount Asset 28 3 1 5,000 A 29 I 18% 5,000 30 3 5,000 31 32 I 15% 1 S 300 B 33 34 N = 1 C 16% 36 35,000 40 1-5 D 41 1,500 8.500 N - 6 I - 12 6 42 PMT 43 1,500 44 FV 7,000 2,000 3,000 I 8.000 49 7,000 4,000 1,000 Hequirements Points Problem 6 1