Download the excel file named Bonds & Stocks. Use tab Shares to estimate the Per Share Gain, Total Gain, and the RoR. Classify for each case whether there was a gain or loss. Each a summary indicating both: the best 3 stocks and the worst 3 stocks. Do the same with the tab Bonds. Justify your response.

requirement

Bank account report

BANKS Bank 1 Bank 2 Bank 3 Bank 4 Bank 5 Bank 6 Bank 7 Bank 8 Bank 9 Bank 10 Rate 3% 6% 3% 5% 2% 4% 1% 3% 5% 4% Nper 12 8 15 4 10 14 17 9 19 5 Pmt FV PV Years 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Share Price $100.00 $149.77 $240.38 $99.75 $171.73 $140.56 $96.76 $243.79 $177.18 $148.34 $248.45 $137.34 $112.43 $216.51 $182.22 $161.15 $133.87 $126.74 $101.35 $190.19 Dividends Sell Price $5 $ $7 $ $12 $ $5 $ $9 $ $7 S $5 $ $12 $ $9 $ $7 $ $12 $ $7 $ $6 $ $11 $ $9 $ $8 $ $7 $ $6 $ $5 $ $10 $ 240 143 310 110 145 134 100 242 167 489 210 147 345 243 173 143 150 138 110 210 Per Share Gain Total Gain ROR Earning/Loosing Years 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 8 20 Bond $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Interest Rate Gain per intere Sell Price 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 $1,100.00 $1,127.65 $1,076.07 $1,069.49 $1,007.00 $558.02 $874.13 $552.06 $1,266.00 $634.30 $573.26 $1,217.11 $875.98 $1,103.29 $1,226.64 $743.58 $1,239.53 $879.81 $533.23 $1,145.21 Gain Total Gain ROR Earning/Loosing BANKS Bank 1 Bank 2 Bank 3 Bank 4 Bank 5 Bank 6 Bank 7 Bank 8 Bank 9 Bank 10 Rate 3% 6% 3% 5% 2% 4% 1% 3% 5% 4% Nper 12 8 15 4 10 14 17 9 19 5 Pmt FV PV Years 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Share Price $100.00 $149.77 $240.38 $99.75 $171.73 $140.56 $96.76 $243.79 $177.18 $148.34 $248.45 $137.34 $112.43 $216.51 $182.22 $161.15 $133.87 $126.74 $101.35 $190.19 Dividends Sell Price $5 $ $7 $ $12 $ $5 $ $9 $ $7 S $5 $ $12 $ $9 $ $7 $ $12 $ $7 $ $6 $ $11 $ $9 $ $8 $ $7 $ $6 $ $5 $ $10 $ 240 143 310 110 145 134 100 242 167 489 210 147 345 243 173 143 150 138 110 210 Per Share Gain Total Gain ROR Earning/Loosing Years 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 8 20 Bond $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Interest Rate Gain per intere Sell Price 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 $1,100.00 $1,127.65 $1,076.07 $1,069.49 $1,007.00 $558.02 $874.13 $552.06 $1,266.00 $634.30 $573.26 $1,217.11 $875.98 $1,103.29 $1,226.64 $743.58 $1,239.53 $879.81 $533.23 $1,145.21 Gain Total Gain ROR Earning/Loosing