'

Steps to Perform: Always use cell references and formulas where appropriate to receive full credit. If Jou copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) Capital Investment Decisions and the Time Value of Money Solve various time value of money scenarios Review the time value of money scenarios listed below: 1. Suppose you invest a sum of $4,000 in an interest-bearing account at the rate of 10% per year. What will the investment be worth six years from now? 2. How much would you need to invest now to be able to withdraw $6,000 at the end of every year for the next 20 years? Assume a 12% interest rate. 3. Assume that you want to have $160,000 saved seven years from now. If you can invest your funds at a 6% interest rate, how much do you currently need to invest? 4. Your aunt Eugenia plans to give you $2,000 at the end of every year for the next 10 years. If you invest each of her yearly gifts at a 12% interest rate, how much will they be worth at the end of the 10 -year period? 5. Suppose you want to buy a small cabin in the mountains four years from now. You estimate that the property will cost $51,000 at that time. How much money do you need to invest each year in an interest-bearing account earning 6% per year to accumulate the purchase price? Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Requirement Solve the time value of money scenarios listed. a. Use the appropriate Excel formula function PV, FV, or PMT. b. Make sure all answers are positive values. Steps to Perform: Always use cell references and formulas where appropriate to receive full credit. If Jou copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) Capital Investment Decisions and the Time Value of Money Solve various time value of money scenarios Review the time value of money scenarios listed below: 1. Suppose you invest a sum of $4,000 in an interest-bearing account at the rate of 10% per year. What will the investment be worth six years from now? 2. How much would you need to invest now to be able to withdraw $6,000 at the end of every year for the next 20 years? Assume a 12% interest rate. 3. Assume that you want to have $160,000 saved seven years from now. If you can invest your funds at a 6% interest rate, how much do you currently need to invest? 4. Your aunt Eugenia plans to give you $2,000 at the end of every year for the next 10 years. If you invest each of her yearly gifts at a 12% interest rate, how much will they be worth at the end of the 10 -year period? 5. Suppose you want to buy a small cabin in the mountains four years from now. You estimate that the property will cost $51,000 at that time. How much money do you need to invest each year in an interest-bearing account earning 6% per year to accumulate the purchase price? Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Requirement Solve the time value of money scenarios listed. a. Use the appropriate Excel formula function PV, FV, or PMT. b. Make sure all answers are positive values