Question: how to find the return for the columns that are blank . -return for risky free weekly -return for portfolio weekly -return for market value

how to find the return for the columns that are blank . 

-return for risky free weekly 

-return for portfolio weekly 

-return for market value weekly 

-return for risk-free monthly 

-R(P) monthly 

-R(M) monthly 

arithmetic average 

standard deviation 

variance 

Geometric average  

Week Arithmetic Average Stdev Variance Geomatric average Portfolio (Value) 0 1 500095.8983 2 500536.7097 3 

Week Arithmetic Average Stdev Variance Geomatric average Portfolio (Value) 0 1 500095.8983 2 500536.7097 3 497800.9023 4 495260.9205 5 502178.4363 6 485254.2777 7 466992.1498 500000 Notes: 1 You ASX 200 (^AXJO) Risk-free rate (%) r(P) weekly r(M) weekly 1386.91 1393.62 1402.01 1396.69 1350.57 1350.7 1331.25 1303.31 2.31 0.000191797 0.004838093 2.31 0.000881454 0.006020292 2.31 -0.00546575 -0.003794552 2.76 -0.0051024 -0.033020928 2.76 0.013967417 9.62557E-05 2.76 -0.03370148 -0.014399941 2.76 -0.03763414 -0.020987793 any calculation for wook 0 r(f) weekly ? ? ? ? ? ? r(P) monthly ? ? ? ? ? ? ? r(M) monthly ? ? ? ? ? ? r(f) monthly R(P) monthly R(M) monthly ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? regression res

Step by Step Solution

3.38 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The formula to find the return for blank columns in the spreadsheet depends on what the blank cell represents There are two main interpretations Missing return data If the blank cells represent missin... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!