Answer:
13,710
Explanation:
The computation of the forecast for period 5 using a four period weighted moving average is shown below:
= Weights of period 1 × Period 1 + Weights of period 2 × Period 2 + Weight of period 3 × Period 3 + Weights of period 4 × Period 4
= .05 × 10000 + .15 × 12400 + .30 × 13250 + .50 × 14750
= 5,00 + 1,860 + 3,975 + 7,375
= 13,710
Answer:
7%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = 100 shares × $20 per share = $2,000
Future value = 100 shares × $30 per share = $3,000
PMT = 0
NPER = 6 years
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the answer would be 7%