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 01:40
Costs of production that do not change when output changes.question 17 options: total revenuefixed incometotal costfixed cost
Answers: 1
question
Business, 22.06.2019 11:40
Zachary company produces commercial gardening equipment. since production is highly automated, the company allocates its overhead costs to product lines using activity-based costing. the costs and cost drivers associated with the four overhead activity cost pools follow: activities unit level batch level product level facility level cost $ 64,800 $ 27,730 $ 15,000 $ 154,000 cost driver 2,400 labor hrs. 47 setups percentage of use 11,000 units production of 780 sets of cutting shears, one of the company’s 20 products, took 240 labor hours and 7 setups and consumed 15 percent of the product-sustaining activities. required: (a) had the company used labor hours as a company wide allocation base, how much overhead would it have allocated to the cutting shears? (b) how much overhead is allocated to the cutting shears using activity-based costing? (c) compute the overhead cost per unit for cutting shears first using activity-based costing and then using direct labor hours for allocation if 780 units are produced. if direct product costs are $150 and the product is priced at 30 percent above cost for what price would the product sell under each allocation system? (d) assuming that activity-based costing provides a more accurate estimate of cost, indicate whether the cutting shears would be over- or underpriced if direct labor hours are used as an allocation base. explain how over-or undercosting can affect vaulker's profitability. (e) comment on the validity of using the allocated facility-level cost in the pricing decision. should other costs be considered in a cost- plus pricing decision? if so, which ones? what costs would you include if you were trying to decide whether to accept a special order?
Answers: 1
question
Business, 22.06.2019 12:10
The cost of the beginning work in process inventory was comprised of $3,000 of direct materials, $10,000 of direct labor, and $10,000 of factory overhead. costs incurred during the period were comprised of $15,000 of direct materials costs, and $100,000 of conversion costs. the equivalent units of production (eup) for the period were 9,000 for direct materials and 6,000 for conversion. the costs per eup were:
Answers: 3
question
Business, 22.06.2019 20:00
Acompetitive market in healthcare would a. overprovide healthcare because the marginal social benefit of healthcare exceeds the marginal benefit perceived by consumers b. underprovide healthcare because it would eliminate medicare and medicaid c. underprovide healthcare because the marginal social benefit of healthcare exceeds the marginal benefit perceived by consumers d. overprovide healthcare because it would be similar to the approach used in canada
Answers: 1
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
Chemistry, 19.10.2020 23:01
question
Computers and Technology, 19.10.2020 23:01
question
Mathematics, 19.10.2020 23:01
Questions on the website: 13722359