Business, 18.02.2021 21:30 ultimatesaiyan

You just turned 30 years old today, have just received your MBA, and have accepted your first job. You are permitted to put $19,500 per year into your 401-K plan. Assume that you make the payments at the end of each year (from the end of the year when you are age 30 to the end of the year when you are age 69; 40 payments in all). Every dollar in the plan earns 5% APR per year. You cannot make withdrawals until after you retire on your 70th birthday (40 years from today). During your retirement, you plan to withdraw funds from the account at the end of each year (so your first withdrawal is at the end of the year that you turn 70). a. How much will you have in your 401K when you retire at age 70?
b. What constant amount will you be able to withdraw each year if you want the funds to last until the end of the year that you turn 100? (31 payments)
c. Suppose that you want to make monthly withdrawals at the end of each month starting at the end of the month after you turn 70. Hence, you will be making 372 withdrawals.
If your savings still is earning 5% APR, how much can you withdraw at the end of each month?
d. Suppose that you want to make monthly withdrawals of $15,000 per month at the end of the month for 372 months, starting at the end of the month after you turn 70.
How much more must be saved at the end of each of your 40 years of working to enable you to make monthly withdrawals of $15,000 per month instead of the number that you found in part c, assuming that your savings earns the same 5% APR?
Part 2. Now assume that the amount you can contribute to your 401K retirement account grows 1% per year. Still assume that you make the payments at the end of each year (from the end of the year when you are age 30 to the end of the year when you are age 69; 40 payments in all)
You will make a payment of 19,500 at the end of the year you turn 30; then all future contributions will grow at 1% per year.
Every dollar in the plan earns 5% APR per year. You cannot make withdrawals until after you retire on your 70th birthday (40 years from today). During your retirement, you plan to withdraw funds from the account at the end of each year (so your first withdrawal is at the end of the year that you turn 70).
e. Now, how much will you have in your 401K when you retire at age 70?
You will make a payment of 19,500 at the end of the year you turn 30; then all future contributions will grow at 1% per year.
f. What constant amount will you be able to withdraw at the end of each year if you want the funds to last until you are age 100? (31 payments)
please answer in excel with functions

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 07:00, ladybugys

Pennewell publishing inc. (pp) is a zero growth company. it currently has zero debt and its earnings before interest and taxes (ebit) are $80,000. pp's current cost of equity is 10%, and its tax rate is 40%. the firm has 10,000 shares of common stock outstanding selling at a price per share of $48.00. refer to the data for pennewell publishing inc. (pp). pp is considering changing its capital structure to one with 30% debt and 70% equity, based on market values. the debt would have an interest rate of 8%. the new funds would be used to repurchase stock. it is estimated that the increase in risk resulting from the added leverage would cause the required rate of return on equity to rise to 12%. if this plan were carried out, what would be pp's new value of operations? a. $484,359 b. $521,173 c. $584,653 d. $560,748 e. $487,805

Answers: 1

continue

Business, 22.06.2019 11:20, murarimenon

Camilo is a self-employed roofer. he reported a profit of $30,000 on his schedule c. he had other taxable income of $5,000. he paid $3,000 for hospitalization insurance. his self-employment tax was $4,656. he paid his former wife $4,000 in court-ordered alimony and $4,000 in child support. what is the amount camilo can deduct in arriving at adjusted gross income (agi)?

Answers: 2

continue

Business, 22.06.2019 12:10, huangjianhe135

The following transactions occur for badger biking company during the month of june: a. provide services to customers on account for $32,000. b. receive cash of $24,000 from customers in (a) above. c. purchase bike equipment by signing a note with the bank for $17,000. d. pay utilities of $3,200 for the current month. analyze each transaction and indicate the amount of increases and decreases in the accounting equation. (decreases to account classifications should be entered as a negative.)

Answers: 1

continue

Business, 22.06.2019 23:50, christi1175

Jaguar has full manufacturing costs of their s-type sedan of £22,803. they sell the s-type in the uk with a 20% margin for a price of £27,363. today these cars are available in the us for $55,000 which is the uk price multiplied by the current exchange rate of $2.01/£. jaguar has committed to keeping the us price at $55,000 for the next six months. if the uk pound appreciates against the usd to an exchange rate of $2.15/£, and jaguar has not hedged against currency changes, what is the amount the company will receive in pounds at the new exchange rate?

Answers: 1

continue

You know the right answer?

You just turned 30 years old today, have just received your MBA, and have accepted your first job. Y...