Question

In: Statistics and Probability

Kevin retired on 1/1/2020 and started to withdraw $2500 at the end of each month from...

Kevin retired on 1/1/2020 and started to withdraw $2500 at the end of each month from an account (which earns 2.35% interest compounded monthly) containing $439,979.16. If Kevin keeps on making the set withdrawal and the interest rate remains the same, then the account should last for ___ years. The total interest that Kevin earns from the account (from the time that he starts withdrawing the $2500 to the very last withdrawl that he makes) would be $____.

Solutions

Expert Solution

Use the formula NPER(2.35%/12,-2500,439979.16) in Excel to get to know the time period. The number of months would come as 216 which is 18Y roughly. Total interest can be found by multiplying the number of months * monthly withdrawal (2500 USD) - Principal Amount = (216*2500) - 439,979.16 = 540000-439979.16 = $100020.85 (Rounded up)

We can also see it by simulation (Please see it on the right side of the sheet)


Related Solutions

Wants to be able to withdraw $80,000 per year at the end of each year from...
Wants to be able to withdraw $80,000 per year at the end of each year from his retirement account for 30 years after he retires. Assuming a 7% annual compound interest rate, what is the minimum amount Mr. Smith must-have in this account when he retires? Please indicate what you entered into your calculator to solve these problems.
You have just started to deposit $250 at the end of each month into a bank...
You have just started to deposit $250 at the end of each month into a bank account. The bank manager states that you can receive $20,000 after 6 years from that account, if there is no transaction other than monthly deposits. What is interest rate provided by the bank for this account?
Question 61 You are going to withdraw $1,025 at the end of each year for the...
Question 61 You are going to withdraw $1,025 at the end of each year for the next three years from an account that pays interest at a rate of 7% compounded annually. The account balance will reduce to zero when the last withdrawal is made. How much money will be in the account immediately after the second withdrawal is made? Select one or more: a. $1,000.00 b. $2,000.00 c. $934.60 d. $925.93 e. $957.94 Question 62 If the rate at...
Kevin Company issues bonds on 1/1/20. Suppose, for Kevin Company (fiscal year end of 12/31), the...
Kevin Company issues bonds on 1/1/20. Suppose, for Kevin Company (fiscal year end of 12/31), the carrying value of Kevin Company bonds at 12/31/20 and 12/31/21 are $106,461 and $105,073 respectively. Please give the journal entries to mark to market at 12/31/20 and 12/31/21 and supporting calculations in each year for the following scenarios: 1: FMV at 12/31/20 = $107,500; FMV at 12/31/21 = $106,500 2: FMV at 12/31/20 = $107,500; FMV at 12/31/21 = $106,000 3: FMV at 12/31/20...
Maya started her business on July 1, 2020. The following transactions occurred during the month of...
Maya started her business on July 1, 2020. The following transactions occurred during the month of July. Identify the effects of the following transactions on the accounting equation: July Transactions 1 Maya started her agriculture business with RM150,000 cash. 3 Paid RM1,000 in the month for rent of office space. 4 Purchased RM1,500 chemicals on credit terms from BioLogic Company. 5 Paid RM700 for publicity in the Malaysia Business newspaper. 8 Interviewed candidates who applied for a marketing executive position...
you invest 2500 in your child's college fund at the end of each year for the...
you invest 2500 in your child's college fund at the end of each year for the next 12 years. at that time your kid will withdraw equal amounts at the end of the next four years. what is the annual withdrawal amount if the appropriate interest rate is 8%?
The Canadian Government withholds $2500 of tax from a payment made to Emilia made in 2020....
The Canadian Government withholds $2500 of tax from a payment made to Emilia made in 2020. Under the tax treaty between the United States and Canada, Emelia owes only $1,500 and can claim a refund for the other $1,000. What amount is eligible for the Foreign Tax Credit (regardless of whether or not Emelia applies for the credit) on her United States income tax return? A. $0 B. $500 C. $1,000 D. $1,500
How much would you have to invest today to be able to withdraw $4,956 each month,...
How much would you have to invest today to be able to withdraw $4,956 each month, for 45 months, (starting next month), if your investments earn 4.14% APR (compounded monthly)?
How much would you have to invest today to be able to withdraw $3,170 each month,...
How much would you have to invest today to be able to withdraw $3,170 each month, for 19 months, (starting next month), if your investments earn 4.57% APR (compounded monthly)? How much would you have to invest today to be able to withdraw $9,123 each month, for 8 months, starting 7 months from now, if your investments earn 4.6% APR (compounded monthly)?
How much would you have to invest today to be able to withdraw $6,814 each month,...
How much would you have to invest today to be able to withdraw $6,814 each month, for 6 months, starting 9 months from now, if your investments earn 5.37% APR (compounded monthly)?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT