Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

text me at 8608743820, venmo for some good work multiple questions. Download closing prices using Yahoofinance on two ETFS: BND and VTI for that of

text me at 8608743820, venmo for some good work multiple questions.
image text in transcribed
Download closing prices using Yahoofinance on two ETFS: BND and VTI for that of the last 10 years on a MONTHLY basis (09/01/2013 - 08/31/2023) For VTI and BND individually (one spreadsheet using two tabs): 1) Calculate the monthly Holding Period Returns (HPRs) - THERE ARE MANY (P1P0)/P0) calculation for EACH month. i.e. HPR of Aug 23 = (Aug 23 ETF price - July 23 ETF price)/ July 23 ETF price) 2) Calculate the monthly arithmetic average and monthly sample standard deviation Annualize the AA=((1+monthlyarithmeticaverage)12)1 Annualize the SD monthly standard deviation"(SQRT(12)) 3) What range of returns can you expect 68% of the time using annualized risk \& return figures? 95% of the time? 99.9996% of the time? 4) Calculate geometric average (also known as CAGR)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Innovation Regulation And Crises In History

Authors: Harold James

1st Edition

0367669528, 978-0367669522

More Books

Students also viewed these Finance questions