With the given information, calculate the #days, APR, EAR, and rcc for the following tickers.

IMPORTANT INFO: There are 252 trading days per year.

13 tr 14 15 1 16 17 18 2 3 Ticker NELX AMZN BRKB YUM DIA position LONG (buy) LONG (buy) LONG (buy) LONG (buyl LONG (buy) OPENING CLOSING/CURRENT" price date position price date $551.34 2/26/2021 HOLDING $522.88 3/22/2021 $3.086.00 2/26/2021 HOLDING $3,109.88 3/22/2021 $244.69 2/23/2021 HOLDING $250.42 3/22/2021 $105.80 2/23/2021 HOLDING $108.74 3/22/2021 $314.76 2/23/2021 HOLDING $327.24 3/22/2021 Dividend $0.00 $0.00 $0.00 $0.00 $0.00 HPR -5.1620% 0.7738% 2.3417% 2.7788% 3.96-19% 4 5 19 20 21 You need to do this for at least 4 tickets, and 6 at most. tr rading days per year HPR Additional Instructions These represent input fields These represent calculation fields. You must use formulas Transaction number. Just number your transaction in case I need to make comments Simple Holding Period Return. Please consider dividends if available. Be careful in your formula building to allow for long AND short Number of days between the opening and closing dates. If a stock was bought and sold in the same day, assume 1 day for of days. Annual Percentage Rate Effective Annual Rate - compounded based on the holding period. Assume the return is compounded and repeated for the whole year. Equivalent Continuously Compounded rate Ndays adays APR EAR APR EAR Remember: Use Excel formulas to receive credit and avoid hard-coding as much as possibly NOTE: A Formula will always start with an equal signs NOTE: You do not have to use specific Excel formulas like EFFECTI)