I just need the answer to compare. YOU CAN USE EXCEL. THANKS

A good stock-based mutual fund should earn at least 6% per year over a long period of time. Consider the case of Barney and Lynn, who were overheard gloating (for all to hear) about how well they had done with their mutual fund investment." We turned a $27,500 investment of money in 1982 into $137,500 in 2007." a. What return (interest rate) did they really earn on their investment? Should they have been bragging about how investment-savvy they were? b. Instead, if $1,100 had been invested each year for 25 years to accumulate $137,500, what return did Barney and Lynn earn? 5 Click the icon to view the interest and annuity table for discrete compounding when i = 6% per year. i More Info a. The interest rate Barney and Lynn really earn on their investment is %. (Round to the one decimal place.) Barney and Lynne have been bragging about how investment-savvy they were. b. The interest rate Barney and Lynn earn on their investments is %. (Round to the one decimal place.) To Find F Given P FIP 1.0600 1.1236 1.1910 1.2625 1.3382 1.4185 1.5036 1.5938 1.6895 1.7908 1.8983 2.0122 2.1329 2.2609 2.3966 2.5404 2.6928 2.8543 3.0256 3.2071 3.3996 3.6035 3.8197 4.0489 4.2919 5.7435 To Find P Given F P/F 0.9434 0.8900 0.8396 0.7921 0.7473 0.7050 0.6651 0.6274 0.5919 0.5584 0.5268 0.4970 0.4688 0.4423 0.4173 0.3936 0.3714 0.3503 0.3305 0.3118 0.2942 0.2775 0.2618 0.2470 0.2330 0.1741 To Find F Given A FIA 1.0000 2.0600 3.1836 4.3746 5.6371 6.9753 8.3938 9.8975 11.4913 13.1808 14.9716 16.8699 18.8821 21.0151 23.2760 25.6725 28.2129 30.9057 33.7600 36.7856 39.9927 43.3923 46.9958 50.8156 54.8645 79.0582 To Find P Given A P/A 0.9434 1.8334 2.6730 3.4651 4.2124 4.9173 5.5824 6.2098 6.8017 7.3601 7.8869 8.3838 8.8527 9.2950 9.7122 10.1059 10.4773 10.8276 11.1581 11.4699 11.7641 12.0416 12.3034 12.5504 12.7834 13.7648 To Find A Given F A/F 1.0000 0.4854 0.3141 0.2286 0.1774 0.1434 0.1191 0.1010 0.0870 0.0759 0.0668 0.0593 0.0530 0.0476 0.0430 0.0390 0.0354 0.0324 0.0296 0.0272 0.0250 0.0230 0.0213 0.0197 0.0182 0.0126 To Find A Given P A/P 1.0600 0.5454 0.3741 0.2886 0.2374 0.2034 0.1791 0.1610 0.1470 0.1359 0.1268 0.1193 0.1130 0.1076 0.1030 0.0990 0.0954 0.0924 0.0896 0.0872 0.0850 0.0830 0.0813 0.0797 0.0782 0.0726 Enter your answer in each of the answer boxes