Reference no: EM13839743

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.