Screenshot 2023-11-08 9.00.23 PM

Suppose that you are planning to buy a boat in in 28 years [cell B3] for $100,000 [cell B2], and you deposit into your account the amount of $26,000 CAD [cell B1]. (a) What average annually compounding rate of return (as a percentage, correct to 2 decimals) should you earn so you can accumulate the lump sum needed to achieve your goal [cell B5]? Use the RATE function.(Note: You might have to modify the format of cell B5 so that it shows 2 decimals.) (b) What is the correct formula (using 18 characters or less) that should be placed in cell B5?Note: There are to be NO numbers in the function call (apart from a 0 if appropriate), only cell references, or negative cell references where appropriate. In excel pls.

You are calculating the present value of $1,000 that you will receive five years from now.Which table will you use to obtain the present value factor to multiply to calculate thepresent value of that $1,000?a. Present Value of $1 tableb. Future Value of $1 tablec. Present Value of Ordinary Annuity of $1d. Future Value of Ordinary Annuity of $1

How much must be invested now to receive $23,000 for 10 years if the first $23,000 is received one year from now and the rate is 10%? Round your present value factor to three decimal places and final answer to the nearest dollar. (Click here to see present value and future value tables) $fill in the blank 1

If you invest $9,700 per period for the following number of periods, how much would you have received at the end? Use Appendix C. (Round "Factor" to 3 decimal places. Round the final answers to the nearest whole dollar.) a. 11 years at 9 percent Future value $ b. 16 years at 11 percent Future value $ c. 30 periods at 10 percent Future value $

If you invest $15,000 today, how much will you have in each of the following instances? Use Appendix A as an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. In 6 years at 8 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)       b. In 17 years at 9 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)       c. In 15 years at 8 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)       d. In 14 years at 8 percent (compounded semiannually)? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

If you invest $10,000 per period for the following number of periods, how much would you have in each of the following instances? Use Appendix C for an approximate answer, but calculate your final answer using the formula and financial calculator methods.  In 50 years at 8 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

Using time value of money tables, calculate the following: The amount a person would have to deposit today (present value) at an interest rate of 5 percent to have $1,000 five years from now.

Find the future value of the given present value. Use 360 days per year for your calculation.The present value of $3684 at 11% for 240 days.

Suppose you are going to invest $11,000 per year for six years. The appropriate interest rate is 9 percent. What is the future value if the payments are made on the last day of the year? What if the payments are made on the first day of the year? a) $82,756.68; $90,204.78 b) $90,204.78; $82,756.68 c) $49,345.10; $53,786.16 d) $53,786.16; $49,345.10

how to approach this question ?

If you invest $8,300 per period for the following number of periods, how much would you have received at the end? (Use a Financial calculator to arrive at the answers. Round the final answers to the nearest whole dollar.)a. 12 years at 6 percent.Future value$b. 20 years at 9 percent.Future value$c. 20 periods at 14 percent.Future value$

If you invest $17,500 today, how much will you have in each of the following instances? Use Appendix A as an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. In 7 years at 8 percent? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. Future value b. In 18 years at 7 percent? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. Future value c. In 25 years at 6 percent? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. Future value d. In 20 years at 6 percent (compounded semiannually)? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. Future value

If you invest $17,500 today, how much will you have in each of the following instances? Use Appendix A as an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. In 7 years at 8 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Future value b. In 18 years at 7 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Future value Future value Val HOME c. In 25 years at 6 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) 1 ARNE Inil STA Boll Com te doen Monta Panta BBELL Aaron Alfal amphenie dit ou Munimin is magna. Menin that dimin ilmais mmmmm ana multzal mmmmm

(Complex present value) You would like to have $44,000 in 11 years. To accumulate this amount, you plan to deposit each year an equal sum in the bank, which will earn 9 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn 9 percent on this deposit.) c. At the end of 6 years you will receive $11,000 and deposit this in the bank toward your goal of $44,000 at the end of 11 years. In addition to this deposit, how much must you deposit in equal annual deposits to reach your goal? (Again assume you can earn 9 percent on this deposit.) a. How much must you deposit annually to accumulate $44,000 in 11 years?