Problem 1: Write a sub routine to display the following message. The message should at the top of all other window, and it should prevent the user from doing anything in any application until one of the buttons is clicked.
Hint: You need to explore some option of MsgBox style
Problem 2: Write a subroutine to calculate present value. Your program should have InputBoxs for users to provide Cash Flow, Rate of return and the number of period; it should display the result in a message box. Your output should look as follows:
Problem 3: Write a subroutine to calculate bond value.
An investment company offers a bond linked to the FT100 index. On redemption the bond pays the face value plus the 5 percent yearly interest compounded monthly. Implement a VBA subroutine to calculate bon value
Hint: Your program should have input Boxes for users to provide
1) Face Value
2) Years
3) FT0
4) FT1
|
Deposit
|
Years
|
FT0
|
FT1
|
|
100
|
1
|
110
|
125
|
|
100
|
1
|
110
|
100
|
|
100
|
12
|
110
|
125
|
|
100
|
12
|
110
|
1387.5
|
|
100
|
12
|
110
|
1387.5
|
Problem 4: Write a subroutine to calculate PMY value once you click the PMT button
Hint: User need to input required values via Input Boxes.