Question

NEED: VBA Subroutine Pls, do not use Class Exmp: Sub FutureAccountValue() Dim Deposit As Single Dim...

NEED: VBA Subroutine Pls, do not use Class

Exmp:

Sub FutureAccountValue()

Dim Deposit As Single

Dim AddContribution As Single

Dim Years As Single

Dim InterestRate As Single

.....

//

Sub

1) Write a subroutine that asks the user for:

  • The deposit Amount

  • The additional contribution (deposit) each year

  • The number of Years

  • The interest Rate (APR)

    Then, display the future value of the user’s account each year for some number of years. Also show the growth from the original investment only. You can do this using a loop inside your message box.

    Set your default deposit amount to $10,000 Set your default annual contribution to $500 Set the default term to 5 years
    Set your default interest rate to 2%

    So, if I use the default values above, I should get the following values in my message box:

1st Year: $10,700.00 2nd Year: $11,414.00 3rd Year: $12,142.28 4th Year: $12,885.13 5th Year: $13,642.83

Hints:

Growth $700.00 Growth $1414.00 Growth $2142.28

Growth $2885.13 Growth $3642.83

You will need several input boxes
Inside the message box which outputs the answers, you will want to output each future value and the growth from the original investment only (the growth amount will include interest and annual contributions).
You will want to use a loop to output the results
Chr(13) is the syntax for carriage return (new line)
Chr(9) is the syntax for tab (inserting a few spaces)

Homework Answers

Answer #1

Public Sub FutureAccountValue()
Dim Deposit As Single
Dim AddContribution As Single
Dim Years As Single
Dim InterestRate As Single
Dim FValue As Single
Dim i As Integer
Dim res As String


Deposit = 10000#
AddContribution = 500#
Years = 5
InterestRate = 2#
res = "FUTURE VALUE FOR EACH YEAR" & vbCrLf
For i = 1 To Years
FValue = -FV(InterestRate / 100, i, AddContribution, Deposit, 0)
res = res & vbNewLine + vbTab & i & " Year :" & vbTab & FValue
Next i
MsgBox res, , "Future Value"
End Sub
-------------------------------------


Private Sub btnExit_Click()
End
End Sub

-----------------------------------------

Private Sub btnFV_Click()
Call FutureAccountValue
End Sub

--------------------------------------------

OUTPUT:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. You want to take a vacation in 4 years and feel you’ll need $8,500 to...
1. You want to take a vacation in 4 years and feel you’ll need $8,500 to do so. If you can earn 5% on your deposits, how much will you need to deposit in each of the next four years to have the needed amount? PMT = 1972.10058   2. What is the effective annual rate on a credit card that states that their APR is 21%, compounded monthly? 23.144% 3. What is the present value of $1,000 to be received...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
In February 2012, the Pepsi Next product was launched into the US market. This case study...
In February 2012, the Pepsi Next product was launched into the US market. This case study provides students with an interesting insight into PepsiCo’s new product process and some of the challenging decisions that they faced along the way. Pepsi Next Case Study Introduction Pepsi Next was launched by PepsiCo into the US market in February 2012, and has since been rolled out to various international markets (for instance, it was launched in Australia in September 2012). The new product...
Exploring Innovation in Action Power to the People – Lifeline Energy Trevor Baylis was quite a...
Exploring Innovation in Action Power to the People – Lifeline Energy Trevor Baylis was quite a swimmer in his youth, representing Britain at the age of 15. So it wasn’t entirely surprising that he ended up working for a swimming pool firm in Surrey before setting up his own company. He continued his swimming passion – working as a part-time TV stuntman doing underwater feats – but also followed an interest in inventing things. One of the projects he began...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
Discuss ethical issues that can be identified in this case and the mode of managing ethics...
Discuss ethical issues that can be identified in this case and the mode of managing ethics Enron finds itself in this case. How would you describe the ethical culture and levels of trust at Enron? Provide reasons for your assessment. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among...
What role could the governance of ethics have played if it had been in existence in...
What role could the governance of ethics have played if it had been in existence in the organization? Assess the leadership of Enron from an ethical perspective. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among the top Fortune 500 companies, collapsed in 2001 under a mountain of debt...
Discuss how the respective organizations’ relations with stakeholders could have potentially been affected by the events...
Discuss how the respective organizations’ relations with stakeholders could have potentially been affected by the events that took place at Enron and how the situation could have been dealt with differently to prevent further damage? THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among the top Fortune 500 companies,...