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

  Disadvantage of using only a debit card

1) What is the main disadvantage of using only a debit card?

  What is the firm net operating working capital

The assets of Dallas & Associates consist entirely of current assets and net plant and equipment. The firm has total assets of $2.6 million and net plant and equipment equals $2.1 million.

  Prepare components of your ventures financial prospectus

Prepare the first seven components of your venture's Financial Prospectus. The Financial Prospectus should include the information you provided in the individual assignments.

  What will they be during her senior year

If Rachael's tuition, fees, and expenditures for books this year total $12,000, what will they be during her senior year (three years from now), assuming costs rise 4 percent annually?

  Perform a simple valuation analysis of community bank stock

perform a simple valuation analysis of community bank stock cbu. to do this i want to see a multi stage dividend

  Growth rate is expected to continue into the foreseeable

Growth rate is expected to continue into the foreseeable future.

  What is the amount of the firm’s net fixed assets

The Le Bleu Company has a ratio of long-term debt to long-term debt plus equity of .35 and a current ratio of 1.25. Current liabilities are $950, sales are $5,780, profit margin is 9.4 percent, and ROE is 18.2 percent. What is the amount of the fi..

  Bid-ask spread of penny stocks- your friend just told you

1. bid-ask spread of penny stocks- your friend just told you about a penny stock he purchased which increased in price

  Which of the following is not considered a permanent source

1 which of the following is not considered a permanent source of financing?a. commercial paperb. preferred stockc.

  Liabilities form part of a company

1. Which of the following liabilities form part of a company's "real" activities?

  Finance capital structure decision and cost of capital

Upon reviewing total debt/equity ratios, company betas, profitability ratios, company revenue, assets, and liabilities, and the nature of the operations of the companies including the nature of their customers and products.

  Determine the additional funds needed

Determine the additional funds needed. Round your answer to the nearest dollar. Total assets $ AFN $ What is the resulting total forecasted amount of notes payable? Round your answer to the nearest dollar.

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