20 points Skipped eBook Print References XS FILE X Paste V Clipboard G F9 A 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 Calculating future values - Excel FORMULAS DATA REVIEW VIEW % Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles X fx B D E F G For each of the following, compute the future value: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Present value Years Interest rate Future value 11 13% 9% 12% 6% HOME Arial BIU I READY Attempt(s) 3/3 INSERT $ Sheet1 12 T PAGE LAYOUT A -A- 1,975 6,734 81,346 192,050 G 7 14 8 FE Cells H B E Editing 23 6 Sign In 100% Hint 2 20 points eBook Print References 6 FILE * Paste Clipboard A1 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 READY Attempt(s) Calculating interest rates - Excel FORMULAS DATA REVIEW VIEW % Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles B D E F Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Present value Years Interest rate Future value 181 $ 297 335 $ 1,080 48,000 $ 185,382 40,353 $ 531,618 + HOME Calibri BIU- $ $ INSERT GA GA GA GA $ Sheet1 11 PAGE LAYOUT -A A - A fx 4 18 19 25 LA LA LA LA G H B Cells I ? Editing 5 Sign In + X 100% Hint 3 20 points Skipped eBook Print References XS- FILE Ce Paste Clipboard A1 1 2 A 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 READY Attempt(s) Calculating present values - Excel FORMULAS DATA REVIEW VIEW % Cells Alignment Number Conditional Format as Cell Formatting Table Styles T Font G Styles X fx B D E F G H I J K You have just received notification that you have won the $2 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday (assuming you're around to collect), 80 years from now. What is the present value of your windfall if the appropriate discount rate is 7.5 percent? 2,000,000 Future value $ Years 80 Discount rate 7.5% Complete the following analysis. Do not hard code values in your calculations. Your answer should be a positive value. Present value Sheet1 + B I 100% HOME INSERT Calibri BIU Y I 11 PAGE LAYOUT A A A- Editing G 6 Sign In X v Hint 4 20 points eBook Print References FILE Paste Clipboard A1 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 & READY Attempt(s) 2 HOME Calculating rates of return - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW A A % CB &-A- Cells Alignment Number Conditional Format as Cell Table Styles Formatting F Styles I X fx B D E F G H I J Although appealing to more refined tastes, art as a collectible has not always performed so profitably. During 2003, Sotheby's sold the Edgar Degas bronze sculpture Petite Danseuse de Quatorze Ans at auction for a price of $10,311,500. Unfortunately for the previous owner, he had purchased it in 1999 at a price of $12,377,500. What was his annual rate of return on this sculpture? Beginning year 1999 2003 Ending year Present value $ 12,377,500 Future value $ 10,311,500 Complete the following analysis. Do not hard code values in your calculations. Annual interest rate Sheet1 + I INSERT Calibri BIU- - 11 HH Font ww ? A Editing 5 X Sign In K + 100% Hint 5 20 points Skipped eBook Print References S. FILE Paste Clipboard A1 A A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 4 READY Attempt(s) Calculating future values - Excel FORMULAS DATA REVIEW VIEW % R Editing Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles X fx B D E F G H I J You have just made your first $5,000 contribution to your retirement account. Assuming you earn a return of 10 percent per year and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing? Contribution amount $ 5,000 Rate of return 10% Years remaining: Deposit today 45 Wait 10 years 35 Complete the following analysis. Do not hard code values in your calculations. Your answer should be a positive value. Future value: Deposit today Wait 10 years Sheet1 + 4 M + 100% HOME INSERT Calibri BIU. V E www -11 FA - PAGE LAYOUT A A A- CO Cells ? 6 Sign In X Hint