Homework 1 F3512

.xlsx

School

Community College of Philadelphia *

*We aren’t endorsed by this school

Course

3512

Subject

Finance

Date

May 3, 2024

Type

xlsx

Pages

28

Uploaded by ibrahimhalimi05 on coursehero.com

Retirement Problem 0 PMT need - pmt of pv. Interest 7% $70,235.82 Annual Deposit 1601.17 $1,713 Annual Withdrawl $10,000 Age Beginning of Year End of Year Account Balance (Beginning) 40 1 0 0.00 41 2 1 1,713.26 42 3 2 3,546.44 43 4 3 5,507.95 44 5 4 7,606.76 45 6 5 9,852.49 46 7 6 12,255.43 47 8 7 14,826.56 48 9 8 17,577.68 49 10 9 20,521.37 50 11 10 23,671.13 51 12 11 27,041.36 52 13 12 30,647.51 53 14 13 34,506.10 54 15 14 38,634.78 55 16 15 43,052.47 56 17 16 47,779.40 57 18 17 52,837.22 58 19 18 58,249.08 59 20 19 64,039.77 60 21 20 70,235.82 61 22 21 65,152.32 62 23 22 59,712.99 63 24 23 53,892.89 64 25 24 47,665.40 65 26 25 41,001.97 66 27 26 33,872.11 67 28 27 26,243.16 68 29 28 18,080.18 69 30 29 9,345.79 Instead of using Solver, use PV and PMT to solve for annual deposit: annual withdraw 10000 Interest rate 7% The key is that the future value of first 20 years' deposits (annuity due) at the end of year 20 is t
First solve for present value of all the withdrawals using PV function PV 70235.82 Then use PMT to solve for the annual deposit PMT 1601.17
119.927992085769 1,833.19 Deposit (Beginning) Interest Earned for the year Withdraw (End) Account Total (End) 1,601.17 112.08 0.00 1,713.26 1,601.17 232.01 0.00 3,546.44 1,601.17 360.33 0.00 5,507.95 1,601.17 497.64 0.00 7,606.76 1,601.17 644.56 0.00 9,852.49 1,601.17 801.76 0.00 12,255.43 1,601.17 969.96 0.00 14,826.56 1,601.17 1,149.94 0.00 17,577.68 1,601.17 1,342.52 0.00 20,521.37 1,601.17 1,548.58 0.00 23,671.13 1,601.17 1,769.06 0.00 27,041.36 1,601.17 2,004.98 0.00 30,647.51 1,601.17 2,257.41 0.00 34,506.10 1,601.17 2,527.51 0.00 38,634.78 1,601.17 2,816.52 0.00 43,052.47 1,601.17 3,125.76 0.00 47,779.40 1,601.17 3,456.64 0.00 52,837.22 1,601.17 3,810.69 0.00 58,249.08 1,601.17 4,189.52 0.00 64,039.77 1,601.17 4,594.87 0.00 70,235.82 0.00 4,916.51 10,000.00 65,152.32 0.00 4,560.66 10,000.00 59,712.99 0.00 4,179.91 10,000.00 53,892.89 0.00 3,772.50 10,000.00 47,665.40 0.00 3,336.58 10,000.00 41,001.97 0.00 2,870.14 10,000.00 33,872.11 0.00 2,371.05 10,000.00 26,243.16 0.00 1,837.02 10,000.00 18,080.18 0.00 1,265.61 10,000.00 9,345.79 0.00 654.21 10,000.00 0.00 the same as the present value of the 10 years' withdraw (ordinary annuity) at the end of year 20 Quesito easier, y some m year. Aft the end each ye Require solve fo Seek wi
on 1 . You are currently 40 years old and intend to retire at age 60. To make your retirement you intend to start a retirement account. At the beginning of each of years, you will deposit money to your retirement account till your retire. You expect the account will earn 7% per fter retirement at age 60, you want to withdraw $10,000 from your retirement account at d of each year for 10 years. How much money should you plan to deposit in your retirement ear? ement: Use all the three methods (1) Solver, (2) Goal Seek, and (3) PV and PMT function to or annual deposit. Use snipping tool to screenshot the dialog windows of Solver and Goal ith the appropriate parameters.
99415
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help