Please answer cell E17, E25, E34, and E35 by using excel functions

1 2 Arguments Number of periods Payment each period Present value Future value 7 Type Guess Rate Value 601 $ (1,000.00) 45,000.00 $ ol 1096 1.00% Argument Issue Date First Interest Date Settlement Date Annual Rate Par Value Frequency Value 2016-06-01 2016-09-01 2016-07-01 596 5 10,000 9 Basis 0 10 TRUE Calculation method Accrued Interest 50 Value 11 Argument 12 Rate Number of periods 1 Present value s starting period 14 Ending period 17 Type in Total principal 19 Total interest Value 6.125% 360 $ 7,320,000.00 1 12 0 Argument Annual interest rate Present value Future value Number of Periods S 5 496 6,000 20,000 -53 80199.999 21 Arguments 22 Rate 2 Period 2 Number of periods Present value x Interest paid Value 6.125% 14 24 5 7,320,000 Argument Rate Number of periods Present value Future value Type Payment Value 5.62596 96 $ 7,320,000.00 0 0 5 -413,914.24 27 Value 6.12596 Value 2 Argument Annual interest rate Payment each period 22 Present value n Future value Payment due *Number of Periods 360 $ 7,320,000.00 $ $ S Argument Rate Period Number of periods Present value Future value Type Principal component Interest component 496 (250) (2,000 20,000 1 0 29