# Question: How much must you put into a 5 percent investment

How much must you put into a 5 percent investment annually to have $ 75,000 eight years from now? Assume all payments are made at the end of each period. See earlier NOTE regarding requirements for Exercises.

A. Solve using a spreadsheet program such as Excel. Indicate the spreadsheet formula showing numeric values rather than cell references. For example, for the value that $ 100 today could grow to in two years, assuming 10 percent annual compounding, the spreadsheet solution formula would be: FV(10%, 2, 0, 100). Note that since there is no annuity payment (PMT) in this problem, it is necessary to show the blank between two commas or a zero after the number of periods. In addition, answer the questions using formulas with cell references.

B. Solve using a financial calculator. This is optional.

A. Solve using a spreadsheet program such as Excel. Indicate the spreadsheet formula showing numeric values rather than cell references. For example, for the value that $ 100 today could grow to in two years, assuming 10 percent annual compounding, the spreadsheet solution formula would be: FV(10%, 2, 0, 100). Note that since there is no annuity payment (PMT) in this problem, it is necessary to show the blank between two commas or a zero after the number of periods. In addition, answer the questions using formulas with cell references.

B. Solve using a financial calculator. This is optional.

**View Solution:**## Answer to relevant Questions

If you could put $ 5,000 into a 6 percent investment at the end of each year, how much money could you take out at the end of seven years? See earlier NOTE regarding requirements for Exercises.A. Solve using a spreadsheet ...Old Town needs to resurface a section of its roads this spring. The town council is considering using one of two technologies. The first involves putting down stone and gravel the first year and grading the road on an annual ...Rural Consolidated Fire Services (RCFS) is considering applying for a Federal Department of Energy (DOE) grant that would allow it to install solar panels on each of its four firehouses. The roofs on each of the firehouses ...Meals for the Homeless borrowed $ 10,000 to buy kitchen equipment. It used a mortgage arrangement with a bank, agreeing to repay the full amount plus interest at a 6 percent rate in 10 annual installments. How much will it ...Assume that HOS could issue a zero coupon bond at an annual interest rate of 4 percent with semiannual compounding for 20 years. If HOS receives $ 2,264.45 for the bond, how much would it have to pay at the maturity date?A. ...Post your question