problems36
Exercise 1x1 -2 Temp2 Then Bond = Temp1 Else Bond = Temp2End FunctionA B C D E F G H1234567891011121314 If Temp1 Temp2 Then Bond = Temp1 Else Bond = Temp2I1234567891011121314Exercise 7Deposit Years FT0 FT1100 1 110 125 2 Temp2 Then _ChooseBond = 1 Else ChooseBond = 2End FunctionA B C D E F123456789101112131415161718Exercise 8Deposit Years DFV1 1 #NUM! 100 ThenIf Years = 2 ThenRate = Y2GT100ElseIf Years = 3 ThenRate = Y3GT100ElseIf Years = 4 ThenRate = Y4GT100ElseIf Years = 5 ThenRate = Y5GT100ElseRate = CVErr(xlErrNum)End IfElseIf Years = 2 ThenRate = Y2LE100ElseIf Years = 3 ThenRate = Y3LE100ElseIf Years = 4 ThenRate = Y4LE100ElseIf Years = 5 ThenRate = Y5LE100ElseRate = CVErr(xlErrNum)End IfEnd IfIf IsError(Rate) ThenDFV = RateElseDFV = Application.FV(Rate, _Years * 12, -Deposit, 0, 1)End IfF1234567891011121314151617181920212223242526272829303132333435363738394041424344End FunctionF45Exercise 9DFV Years DEP-1000 2 -40.169 100 Then _Temp = -Application.Pmt(Y2GT100, 24, 0, DFV, 1)ElseIf Years = 3 ThenTemp = -Application.Pmt(Y3LE100, 36, 0, DFV, 1)If Temp 100 Then _Temp = -Application.Pmt(Y3GT100, 36, 0, DFV, 1)ElseIf Years = 4 ThenTemp = -Application.Pmt(Y4LE100, 48, 0, DFV, 1)If Temp 100 Then _Temp = -Application.Pmt(Y4GT100, 48, 0, DFV, 1)ElseIf Years = 5 ThenTemp = -Application.Pmt(Y5LE100, 60, 0, DFV, 1)If Temp 100 Then _Temp = -Application.Pmt(Y5GT100, 60, 0, DFV, 1)ElseTemp = CVErr(xlErrNum)End IfDEP = TempEnd FunctionF1234567891011121314151617181920212223242526272829303132