- How Much Money Is Needed To Invest In Rental Property?
- Should A Real Estate Investor Get An Agent’s License?
- 5 Big Factors That Affect The Costs Of Renovating Your Home
- SIBOR Hike – What You Can Do With Your Current Loan
- 6 Basic Don’ts Of Real Estate Negotiation Tactics
- Will New Condo Relaunches Trigger The Great Property Sale We Have All Been Waiting For?
- 10 Proximity Amenities That Add Value To Real Estate
- How To Get Personal Loans More Easily With Good Credit
Formula – Weighted Moving Average
When the moving average is needed for investment analysis and the most recent data carries a lot more weight than the earlier ones, the weighted moving average would be a more appropriate formula to use.
There are various methods used to calculate moving average. But 2 of which are the most commonly used by business analysts.
1) Double the latest value and adding 1 to total values
If we take for example, the value is month end and the period is a year, there would be a total of 12 month end values to work with.
(V+Vr)/(N+1) = A
V – Sum of values
Vr – Most recent value
N – Number of values
A – Weighted moving average
2) Use a reducing factor starting from the latest value
Using the previous scenario as example, the most recent value will multiply by 12, the second most recent multiply by 11, and so on until the last value.
Then divide the total sum of value by the number of value which is equivalent to 78. (12+11+10…)
(V1+V2+V3…)/N = A
V1 – Most recent value, V2 second most recent value, and so on
N – Number of values
A – Weighted moving average
If you have your own variables that carry a greater weight, use your own methods to give more weight to more important values.
Latest Singapore home loan rates |
Hidden items that bring up mortgage costs |
Hiring a competent agent |
How to burn more calories in the office |
0 comments