Profitability Analysis of Aristocrats Stocks/ETF on Bi-Weekly Investment
In this analysis, we’ll examine the profitability of investing in a few Aristocrat Stocks/EFT with an initial investment of $5,000 and a bi-weekly investment of $200. How we calculated all below.
Methodology
Initial Investment: $5,000
Bi-Weekly Investment: $200
Investment Period: 1-1, 2010, to 4-27-2025
Investment Frequency: Bi-Weekly
Aristocrat Stocks
— O —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $25.29
Initial Number of Shares: 197.70
Total Shares: 1,841.25
Total Amount Invested: $85,000.00
Average Cost Basis: $46.16
Final Portfolio Value: $105,227.31
Total Dividend Paid: $44,849.22
Current Price: $57.15
Total Return Without Dividends: 23.80%
Total Return With Dividends: 76.56%
Yearly Average Return Without Dividends: 1.40%
Yearly Average Return With Dividends: 3.78%
Investment is profitable.
— BEN —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $36.00
Initial Number of Shares: 138.89
Total Shares: 2,591.01
Total Amount Invested: $85,000.00
Average Cost Basis: $32.81
Final Portfolio Value: $48,581.37
Total Dividend Paid: $23,130.96
Current Price: $18.75
Total Return Without Dividends: -42.85%
Total Return With Dividends: -15.63%
Yearly Average Return Without Dividends: -3.59%
Yearly Average Return With Dividends: -1.10%
Investment is not profitable.
— CVX —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $79.06
Initial Number of Shares: 63.24
Total Shares: 781.17
Total Amount Invested: $85,000.00
Average Cost Basis: $108.81
Final Portfolio Value: $108,637.38
Total Dividend Paid: $34,512.36
Current Price: $139.07
Total Return Without Dividends: 27.81%
Total Return With Dividends: 68.41%
Yearly Average Return Without Dividends: 1.62%
Yearly Average Return With Dividends: 3.46%
Investment is profitable.
— AMCR —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $7.70
Initial Number of Shares: 649.35
Total Shares: 7,241.26
Total Amount Invested: $72,800.00
Average Cost Basis: $10.05
Final Portfolio Value: $69,950.59
Total Dividend Paid: $23,073.87
Current Price: $9.66
Total Return Without Dividends: -3.91%
Total Return With Dividends: 27.78%
Yearly Average Return Without Dividends: -0.26%
Yearly Average Return With Dividends: 1.61%
Investment is profitable.
— TROW —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $54.40
Initial Number of Shares: 91.91
Total Shares: 1,024.33
Total Amount Invested: $85,000.00
Average Cost Basis: $82.98
Final Portfolio Value: $91,698.27
Total Dividend Paid: $36,109.21
Current Price: $89.52
Total Return Without Dividends: 7.88%
Total Return With Dividends: 50.36%
Yearly Average Return Without Dividends: 0.50%
Yearly Average Return With Dividends: 2.70%
Investment is profitable.
— SWK —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $52.71
Initial Number of Shares: 94.86
Total Shares: 923.12
Total Amount Invested: $85,000.00
Average Cost Basis: $92.08
Final Portfolio Value: $57,159.29
Total Dividend Paid: $22,515.34
Current Price: $61.92
Total Return Without Dividends: -32.75%
Total Return With Dividends: -6.27%
Yearly Average Return Without Dividends: -2.56%
Yearly Average Return With Dividends: -0.42%
Investment is not profitable.
— FRT —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $67.03
Initial Number of Shares: 74.59
Total Shares: 820.72
Total Amount Invested: $85,000.00
Average Cost Basis: $103.57
Final Portfolio Value: $78,386.54
Total Dividend Paid: $27,884.35
Current Price: $95.51
Total Return Without Dividends: -7.78%
Total Return With Dividends: 25.02%
Yearly Average Return Without Dividends: -0.53%
Yearly Average Return With Dividends: 1.47%
Investment is profitable.
— ADM —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $31.47
Initial Number of Shares: 158.88
Total Shares: 2,021.34
Total Amount Invested: $85,000.00
Average Cost Basis: $42.05
Final Portfolio Value: $98,600.94
Total Dividend Paid: $26,300.04
Current Price: $48.78
Total Return Without Dividends: 16.00%
Total Return With Dividends: 46.94%
Yearly Average Return Without Dividends: 0.97%
Yearly Average Return With Dividends: 2.55%
Investment is profitable.
— SJM —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $62.18
Initial Number of Shares: 80.41
Total Shares: 852.36
Total Amount Invested: $85,000.00
Average Cost Basis: $99.72
Final Portfolio Value: $98,609.73
Total Dividend Paid: $26,196.66
Current Price: $115.69
Total Return Without Dividends: 16.01%
Total Return With Dividends: 46.83%
Yearly Average Return Without Dividends: 0.97%
Yearly Average Return With Dividends: 2.54%
Investment is profitable.
— ED —
Date Range: 2010-01-01 to 2025-04-25
Initial Investment: $5,000.00
Initial Price: $45.38
Initial Number of Shares: 110.18
Total Shares: 1,258.31
Total Amount Invested: $85,000.00
Average Cost Basis: $67.55
Final Portfolio Value: $140,037.59
Total Dividend Paid: $33,685.76
Current Price: $111.29
Total Return Without Dividends: 64.75%
Total Return With Dividends: 104.38%
Yearly Average Return Without Dividends: 3.31%
Yearly Average Return With Dividends: 4.78%
Investment is profitable.
Description of Calculation
This performs a comprehensive analysis of an Stock investment over a specified time period by simulating both an initial lump-sum investment and regular bi-weekly contributions. The key steps involved in the calculation are as follows:
Initial Investment
The initial investment amount (e.g., $5,000) is divided by the Stocks closing price on the start date to calculate the initial number of shares purchased.
Periodic Investments
The daily closing prices are resampled to a bi-weekly frequency, taking the last available price in each two-week period.
At each bi-weekly interval, a fixed investment amount (e.g., $200) is divided by the Stock price at that time to determine the number of shares purchased.
Shares purchased through periodic investments are cumulatively summed over time to track total shares owned.
Dividend Adjustments
Dividend data for the Stock is fetched.
For each dividend payment date, the we calculates the number of shares owned on or before that date.
Total dividends received are computed by multiplying the dividend per share by the shares owned on the ex-dividend date and summing across all dividend payments.
Portfolio Valuation and Returns
The total shares owned at the end of the investment period (initial plus periodic shares) are multiplied by the current Stock price to determine the final portfolio value.
The total amount invested is the sum of the initial investment and all periodic contributions.
The average cost basis per share is calculated by dividing the total invested by the total shares owned.
Total returns are calculated both excluding and including dividends:
Without dividends: Percentage gain/loss based on portfolio value relative to total invested.
With dividends: Percentage gain/loss including the value of dividends received.
This also computes the annualized average return (CAGR) for both cases over the investment horizon.
Important Note on Purchase Timing
This simulation assumes purchases occur on specific dates based on the closing prices at bi-weekly intervals.
If you buy shares on different days or at different prices than those used in this calculation, your actual investment results will differ from the results shown here. Market prices fluctuate daily, and timing can significantly impact the number of shares acquired and overall returns.
This approach aims to provide a realistic simulation of an Stock investment strategy incorporating dollar-cost averaging and dividend reinvestment, offering valuable insights into potential investment performance over time while highlighting the importance of purchase timing and market variability.
Important Note: When performing these calculations, it’s essential to verify that the mathematical processes are accurate. We strive to provide the most precise information, but it’s always a good idea to double-check your calculations to ensure they align with your specific financial situation. We do our best to provide reliable guidance, but individual circumstances may vary.
Financial Disclaimer
This analysis is for informational and educational purposes only and does not constitute financial advice or a recommendation to buy or sell any securities. While every effort has been made to ensure the accuracy of the calculations and data used, the results are based on historical data and assumptions that may not reflect future market conditions. Investment decisions should be made based on your own research and consultation with a qualified financial advisor. The author and distributor of this script disclaim any liability for financial losses or damages resulting from the use of this information.
Thank you for your understanding as we work to improve our services!
FRED Disclaimer
This product uses the FRED® API but is not Sponsored, endorsed or certified by the Federal Reserve Bank of St. Louis.
Financial Disclaimer
Financial Disclaimer NEWS LETTER Disclaimer & Financial Disclaimer: The information provided on this website/Newsletter/email is for educational and informational purposes only and should not be construed as financial advice. We are not licensed financial advisors and we make no representations or warranties about the accuracy, completeness, or timeliness of the information contained on this newsletter / website / blog / social media platform and or any other media print or other wise. By using this platform, you agree to hold the author(s) harmless for any losses or damages that may result from the use of the information provided. You also agree to abide by the terms and conditions of the platform and any applicable laws and regulations This disclaimer may be updated from time to time, and it is your responsibility to review it regularly. Your continued use of this platform after any changes have been made will constitute your acceptance of the revised disclaimer. ALL LOGOS AND OR TRADE MARK, TRADEMARKS, NAME, NAMES BELONG TO THERE OWNS & OR COMPANY, COMPANYS. We are not Sponsored, endorsed or certified by any of the data source or sources. Report contains Free & Paid data and or content.
