Answer:
1.41 Approx
Explanation:
The computation of the beta for the stock T is shown below:
Beta of portfolio = Respective betas × Respective investment weights
1.30 = (0.14 × 0.81) + (0.5 × 1.36) + (0.36 × beta of the Stock T)
1.30 =0.7934 + (0.36 × beta of the Stock T)
beta of the Stock T = (1.3 - 0.7934) ÷ 0.36
= 1.41 Approx
We simply multiplied the beta of each stock with its investment weights order to calculate the beta of the stock T as portfolio beta is given
Answer:
$5,790
Explanation:
As we know that
Future value = Present value × (1 + rate)^number of years
where,
Present value = $?
Future value = $12,500
Rate = 8%
Number of years = 10 years
So, the present value equal to
= $12,500 ÷ (1 + 0.08)^10
= $12,500 ÷ 2.1589249973
= $5,790
Basically we applied the future value formula so that the present value could come
Explanation:
To find :
Filter the data in order such that only rows where the sum of the type is food and the sum of the amount is greater than 20 are displayed. The selection of requirements has been set for you in cells a1:c2.
Now,
You clicked the Advanced button on the Data Ribbon Tab in the Sort & Filter Ribbon Section.
You tapped on cell A1.
You pressed the OK button in the Advanced Filter window.
Answer:
The correct answer is A.
Explanation:
Giving the following information:
Final value= 1,560,000
n= 3*12= 36 months
i= 0.038/12= 0.0031667
To calculate the annual deposit needed we need to use the following version of the final value formula:
FV= {A*[(1+i)^n-1]}/i
A= annual deposit
Isolating A:
A= (FV*i)/{[(1+i)^n]-1}
A=(1,560,000*0.0031667) / [(1.0031667^36)-1]= $40,849