please solve with formula not excel

(Complex prosont value) You would like to have $48,000 in 10 years. To accumulate this amount, you plan to deposit each year an equal sum in the bank, which will earn. 5 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 eam 5 percent on this deposit.) c. At the end of 6 years you will receive $9,000 and deposit this in the bank toward your goal of $48,000 at the end of 10 years. In addition to this deposit. how much must you deposit in equal annual deposits to reach your goal? (Again assume you can earn 5 percent on this deposit.) a. How much must you deposit annually to accumulate $48,000 in 10 years? \$ (Round to the nearest cent) 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 5 percent on this deposit.) (Round to the nearest cent.) c. At the end of 6 years you will receive $9,000 and deposit this in the bank toward your poal of $48,000 at the end of 10 years. In addition to this deposit, how much must you deposit in equal annual deposits to reach your goal? (Again assume you can earn 5 percent on this deposit) (Round to the nearest cent.)