Calculate the six-month 98% VaR for QAN.ASX (01.01.2000 to 01.06.2020)

stock using a bootstrapping procedure in Excel assuming independence in monthly returns. Use 200 bootstrapped samples. Present a histogram of the bootstrap distribution of portfolio values. Comment on your findings.

What is the discount rate at which the following cash flows have a NPV of $0? Answer in %, rounding to 2 decimals.

Year 0 cash flow = -116,000

Year 1 cash flow = 28,000

Year 2 cash flow = 43,000

Year 3 cash flow = 38,000

Year 4 cash flow = 41,000

Year 5 cash flow = 40,000

Year 6 cash flow = 37,000