Problem 1 write a sub routine to display the following

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.

#### Solution Preview :

##### Reference No:- TGS01119968

Now Priced at \$40 (50% Discount)

Recommended (96%)

Rated (4.8/5)