What excel formulas can I apply to discount rate and NPV columns to get those numbers?

Capital Budgeting Problem Parameters Market risk premium 5.00% US-Treasury Yield Curve Year 2 2 3 3 4 5 Yield 0.50% 0.99% 1.26% 1.45% 1.65% Cash Flow Project Project Discount Beta Life Rate Project Indicator Project Managers S(000) NPV S(000) 2 ###### 5 5 5 5 S 5 1 1 1 1 2 3 4 S 6 7 8 9 10 10 11 12 13 14 15 Time 0 Time 1 Time 2 Time 3 Time 4 Time 5 $(000) ( $(000) $(000) ) S (550.0) S(100.0) S (100.0) $ (100.0) $(100.0) $(100.0) S (700.0) $ (75.0) S (75.0) $ (75.0) $ (75.0) $ (75.0) $ (600.0) $ 400.0 S 250.0 $ 200.0 $ 200.0 $ 200.0 $ $ (700.0) $ 300.0 S s 300.0 $ $ 300.0 $ 300,0 $ 300.0 $ $ (800.0) $ 300.0 s S 300.0 $ 300,0 $ 300,0 $ 300.0 $ $ $ (600.0) $ 400.0 S 400,0 $ 150,0 $ 150,0 $ 100.0 ) $ $ 000 2000s 2000 $ (1,000.0) $ 300.0 S 300.0 $ 300,0 $ 300.0 $ 0 0 $ $ S (800.0) S 300.0 S 300.0 $ 250,0 $ 250.0 $ $ coon $ (400.0) $ 100.0 S 300.0 $ 300.0 S 4000 1000 $ (400,0) $ 400.0 S 100.0 $ 100.0 2500 2500 S (500.0) $ 250.0 S 250.0 $ 250.0 $ (500.0) $ 300.0 S 300.0 S $ 100.0 $ (700.0) $ 400.0 S 400.0 S S (700.0) $ 400.0 S 400.0 S $ (400.0) $ 300.0 S 250.0 1 1 2 3 3 4 4 2 2 3 2 2 3 2 2 3 3 1.10 1.10 1.15 1.15 0.90 0.90 tas 1.25 1.25 1990 1.30 0.95 0.95 1.00 1.00 1.10 1.20 4 4 3 3 3 3 2 2 2 1 Total NPVI Total Used Total Available 27 $ 5,000.0 Mutually exclusive & must choose 1 & 2 O Mutually exclusive 3 or 4 Time O investment reduction $(000) 5 & 6