subject
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

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 17:00
Alpha company uses the periodic inventory system for purchase & sales of merchandise. discount terms for both purchases & sales are, 2/10, n30 and the gross method is used. unless otherwise noted, fob destination will apply to all purchases & sales. the value of inventory is based on periodic system. on january 1, 2016, beginning inventory consisted of 350 units of widgets costing $10 each. alpha prepares monthly income statements. the following events occurred during the month of jan.: dateactivitya.jan. 3purchased on account 350 widgets for $11 each.b.jan. 5sold on account 400 widgets for $30 each. paid freight out with petty cash of $150.c.jan. 10purchased on account 625 widgets for $12 each.d.jan. 11shipping cost for the january 10 purchased merchandise was $400 was paid with a cheque by alpha directly to the freight company.e.jan. 12returned 50 widgets received from jan. 10 purchase as they were not the correct item ordered.f.jan. 13paid for the purchases made on jan. 3.g.jan. 21sold on account 550 widgets for $30 each. paid freight out with petty cash of $250.h.jan. 22authorize credit without return of goods for 50 widgets sold on jan. 21 when customer advised that they were received in defective condition.i.jan. 25received payment for the sale made on jan. 5.j.jan. 26paid for the purchases made on jan. 10.k.jan. 31received payment for the sale made on jan. 21.use this information to prepare the general journal entries (without explanation) for the january events. if no entry is required then enter the date and write "no entry required."
Answers: 2
question
Business, 22.06.2019 20:30
(30 total points) suppose a firm’s production function is given by q = l1/2*k1/2. the marginal product of labor and the marginal product of capital are given by: mpl = 1/ 2 1/ 2 2l k , and mpk = 1/ 2 1/ 2 2k l . a) (12 points) if the price of labor is w = 48, and the price of capital is r = 12, how much labor and capital should the firm hire in order to minimize the cost of production if the firm wants to produce output q = 18?
Answers: 1
question
Business, 22.06.2019 20:50
Which of the statements best describes why the aggregate demand curve is downward sloping? an increase in the aggregate price level causes consumer and investment spending to fall, because consumer purchasing power decreases and money demand increases. as the aggregate price level increases, consumer expectations about the future change. as the aggregate price level decreases, the stock of existing physical capital increases. as a good's price increases, holding all else constant, the good's quantity demanded decreases.
Answers: 2
question
Business, 22.06.2019 21:00
There is just one person in our group, silvia, who seems to have radically different ideas about how to complete our project. she seems to purposely disagree with the majority opinions of the rest of us though yesterday she said something that made a lot of sense to us solve our production problem. i suggested to the entire group today that we hear silvia’s suggestions and asked silvia to share in-depth more of what she said yesterday. i am using which adaptive leader behavior?
Answers: 2
You know the right answer?
You just turned 30 years old today, have just received your MBA, and have accepted your first job. Y...
Questions
question
Mathematics, 18.03.2021 07:20
question
History, 18.03.2021 07:20
question
Business, 18.03.2021 07:20
question
Physics, 18.03.2021 07:20
Questions on the website: 13722362