Good Evening,
Can anyone help me with the mathematical formula for investment. This the problem that I have to workout
Write a program to find future value of monthly investments. Start with an initial investment, make a deposit every 30days, calculate interest on principle compounded daily, display a table showing beginning balance, deposit for the year, interest earned for the year, and ending balance. The table should display the aforementioned information for a duration of your present age to 65. Display result in a table format as shown below.
Future Value Calculation
Initial Investment: $2000
Interest Rate: 12%
Deposit every 30 days: $100
Investment started: 50
Age Beg Bal Interest Deposits Ending Bal
51 2000 324.65 1200 3524.65
52 3524.65 519.01 1200 5243.66
53 5243.66 738.14 1200 7181.79
54 7181.79 985.2 1200 9366.99
55 9366.99 1263.76 1200 11830.74
56 11830.74 1577.82 1300 14708.57
57 14708.57 1944.67 1200 17853.24
58 17853.24 2345.54 1200 21398.77
59 21398.77 2797.5 1200 25396.28
60 25396.28 3307.08 1200 29903.36
61 29903.36 3881.62 1200 34984.98
62 34984.98 4529.4 1300 40814.38
63 40814.38 5272.5 1200 47286.88
64 47286.88 6097.58 1200 54584.46
65 54584.46 7027.83 1200 62812.29
poloblue
-3
Newbie Poster
Recommended Answers
Jump to PostThis is homework. Show us what you've done.
Jump to PostI'd make a form out of this, with number texboxes for all your variables (initial investment, interest rate etc.) and add a calculate button.
When you press the calculate button, the (on)click event gets then values and starts processing the data, concatenating an inital html string for each iteration of …
Jump to Postso what you're saying is you don't know....
Not at all. If the OP wants to come back, I'll be glad to help, but I won't do the work for him. So do you have anything to add?
Jump to PostCreating the output rows from input vars (via form) is trivial except for the calculation of the interest and therefore the balance at the end of each year.
If I understand the OP, this requires a daily compound interest calculation.
This is complicated by the fact that payments are made …
All 13 Replies
diafol
poloblue
-3
Newbie Poster
diafol
better.atbcs
0
Newbie Poster
diafol
Drac
0
Newbie Poster
Drac
0
Newbie Poster
poloblue
-3
Newbie Poster
Drac
0
Newbie Poster
diafol
Drac
0
Newbie Poster
diafol
poloblue
-3
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.