Your uncle has $340,000 invested at 7.5%, and he now wants to retire. He wants to withdraw $35,000 at the end of each year, star
ting at the end of this year. He also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. For how many years can he make the $35,000 withdrawals and still have $25,000 left in the end
1 answer:
Answer:
17.27 years
Explanation:
For this question we use the NPER formula that is shown on the attachment below:
Provided that
Present value = $340,000
Future value = $25,000
PMT = $35,000
Rate of interest = 7.5%
The formula is shown below:
= NPER(Rate;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the number of year is 17.27 years
You might be interested in
Answer:
1003
Explanation:
Given:
Period= 30 years, Loan amount= $200,000,
Payments- Monthly,
Teaser rate for first 2 years = 4%,
Annual payment cap=5%, Composite rate on reset date= 6%
Annual rate for 2 years =4%
Monthly rate will be 4/12 = 0.3333% = 0.003333
n=30years=360 months
Monthly payment for first 2 years =
=
= 954.83
or by Excel function = PMT(0.003333,360,200000,0) = 954.83
Loan balance after 2 years = PV(0.003333,336,-954.83,0) = 192,812.36 or
Balance=
=
= 192,812.36
Composite rate is 6% but payment is capped at 5%. So new payment from year 3 is 954.83×1.05=1002.57=1003