You need $82,000 in 12 years. If you can earn .49 percent per month, how much will you have to deposit today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Deposit today

You have $15,852.43 in a brokerage account, and you plan to deposit an additional $6,000 at the end of every future year until your account totals $240,000. You expect to earn 14% annually on the account. How many years will it take to reach your goal? Round your answer to the nearest whole number. years

you need $8,000 four years from now for a down payment on your future house. How much money must you deposit today if your credit union pays 5% interest compounded annually? Pick the closest answer.

You are planning to make monthly deposits of $340 into a retirement account that pays 9 percent annual interest compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 35 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Future value

You will require $650 in 5 years. If you earn 5% interest on your funds, how much will you need to invest today in order to reach your savings goal? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Suppose you'd like to save enough money to pay cash for your next car. The goal is to save an extra $⁢28,000 over the next 33 years. What amount must be deposited quarterly into an account that earns 4.7% interest, compounded quarterly, in order to reach your goal? Round your answer to the nearest cent, if necessary.

You would like to put some money into an account so that you will have $6000 in the account 13 years from now. If the account earns 3.5% interest per year, compounded quarterly, how much should you invest now in order to reach your goal? Give the answer correctly to 2 decimal places. dollars Do NOT use the dollar sign in the answer box. ns

You want to have $49,000 in your savings account 4 years from now, and you're prepared to make equal annual deposits into the account at the end of each year. If the account pays 6.7 percent interest, what amount must you deposit each year? Multiple Choice $3,282.96 $11,085.33 $14,206.71

If you put $1,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in 7 years? Round the answer to the nearest cent. Round FV-factor to three decimal places or use the Appendix A . (Hint: Use the future value formula.)   $     How much interest will you earn during the 7 years? Round the answer to the nearest cent.   $     If you put $1,000 at the end of each year into a savings account that pays interest at the rate of 3 percent a year, how much would you have after 7 years? Use the Appendix B . Round the answer to the nearest cent. Round FV-factor to three decimal places.   $

How to set this up in Excel?