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

Reviews

Write a Review

Finance Basics Questions & Answers

  You decide project i have attached the assignment

i have attached the assignment instructions i need this assignment by friday afternoon. please provide your advise i

  Which one of the following is a project cash inflow

Which one of the following is a project cash inflow? Ignore any tax effects.

  How much of the gain is ordinary income

Jess sold a piece of equipment she used in her business. The equipment cost Jess $51,500 several years ago and had accumulated depreciation taken in the amount of $20,300. Jess sold the equipment for $35,000.

  What is the operating leverage effect and what causes it

what is the operating leverage effect and what causes it? what are the potential benefits and negative consequences of

  What is the average accounting rate of return

The equipment is expected to generate net income of $36,000 a year for the first four years and $22,000 a year for the last four years. What is the average accounting rate of return?

  Firm cost of capital

The firm's cost of capital is 12%, however projects in this risk class have a 14% required rate of return. The risk-free rate is 8%.

  What is the maximum amount you should pay for the annuity

You are offered an annuity that will pay $10,000 a year for 10 years starting after 5 years have elapsed. If you seek an annual return of 8 percent, what is the maximum amount you should pay for the annuity.

  The fixed cost is the money you need to build production

the fixed cost is the money you need to build production facilities before you have sold even your first product. what

  Accepting and rejecting the project

At what discount rate would you be indifferent between accepting the project and rejecting it?

  Consider a bond with par value of eur 1000 and maturity in

consider a bond with par value of eur 1000 and maturity in three years and that pays a coupon of 5 annually. the spot

  Determining the financing analysis

Given a property information. Research on loan terms and assumptions, calculations on equity vs. debt, use of special financing programs (like tax credits), calculation of effective borrowing costs and/or lender yields.

  Marcela needs to have 48000 in 8 years on a savings plan

marcela needs to have 48000 in 8 years on a savings plan that requires monthly contributions. if she can earn 10

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd