Solution-Explore some option of msgbox style

Explore some option of msgbox style

Assignment Help Finance Basics

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

902_MsgBox style.jpg

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:

971_result in a message box.jpg

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

320_PMT button.jpg

Hint: User need to input required values via Input Boxes.

Reference no: EM13839743

Questions Cloud

Compare classical conditioning and operant conditioning : Compare and contrast classical conditioning and operant conditioning. According to the research you have undertaken, which theory is more effective in marketing?

Populate the gantt chart using given table : Use the data from the following table to populate the Gantt chart. You can either treat these as individual tasks, or just make these subtasks of a single task. Either way, you'll need to read the instructions in the spreadsheet to add some rows

What is length of runway required for the plane to take off : What is the length of runway required for the plane to take off

Algebraic time value of money equations : Please use Excel financial functions or algebraic time value of money equations in your Excel cell formulas to answer these questions in your spreadsheet in order to receive credit for correct answers.

Explore some option of msgbox style : 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.

Conduct a scenario analysis - what is its expected npv : Suppose that the project would be allocated $10,000 of existing overhead costs. Should these costs be included in the cash flow analysis? Explain.

How is phenol converted into salicylic acid : How is phenol converted into salicylic acid

Write about the example of it leveraging business advantage : Write a research report on actual example of IT leveraging business advantage at a managerial level. Your report will be judged on the quality of your research and report presentation.

What individual behaviors might be influenced by television : What individual behaviors might be influenced by television

User Account

All Pages

Explore some option of msgbox style

Reference no: EM13839743

Reference no: EM13839743

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT