How would you approach this using the excel functions of pv and pmt?
Here's the question:
You want to accumulate $1 million by your retirement date, which is 25 years from now. you will make 25 deposits in your bank, with the first occurring today. The bank pays 8% interest, compounded annually. You expect to receive annual raises at 3%, which will offset inflation, and you will let the amount you deposit each year also grow by 3% (i.e, your second deposit will be 3% greater than your first, the third will be 3% greater than the second, etc.) How much must your first deposit be if you are to meet your goal.

Answers

Answer 1

To approach this using Excel functions, we can use the PV (present value) and PMT (payment) functions to calculate the amount of the first deposit. Here are the steps:

1. Calculate the future value of the $1 million using the FV (future value) function:

=FV(8%, 25, 0, -1000000)

This returns a value of $4,660,962.91, which is the amount that will accumulate in 25 years at 8% interest.

2. Calculate the present value of the future amount using the PV function:

=PV(8%-3%, 25, -1*FV(8%, 25, 0, -1000000), 0, 1)

This returns a value of $1,257,407.11, which is the amount that needs to be deposited today to accumulate to $4,660,962.91 in 25 years at 8% interest with 3% annual raises.

3. Calculate the payment amount using the PMT function:

=PMT(8%, 25, -1*PV(8%-3%, 25, 0, 1257407.11, 1), 0, 1)*(1+3%)

This returns a value of $68,527.78, which is the amount of the first deposit.

So, the first deposit should be $68,527.78 to accumulate $1 million in 25 years with 8% interest, 3% annual raises, and 3% increase in deposit each year.


Related Questions

Consider two different potential projects at a company where you have worked, and do the following:

Discuss the benefits and costs that you would consider in deciding which is better for the company
Reflect on how information technology would affect this decision

Answers

Benefits, costs, and IT impact should be considered when deciding between two potential projects at a company.

The decision to choose between two potential projects should consider their benefits and costs, as well as the impact of information technology. Factors such as return on investment, time frame, risk, and strategic alignment should be evaluated. Additionally, information technology can affect the decision through factors such as project management, data analysis, and communication. IT can improve project success rates and reduce costs through the use of automation, analytics, and collaboration tools. Ultimately, a thorough analysis of the projects and their potential impact on the organization should be conducted to make an informed decision.

To know more about information technology, here

brainly.com/question/14426682

#SPJ1

New Day Vitamin Company's __________ relies heavily on advertising, personal selling, and a limited use of product sampling.

Answers

New Day Vitamin Company's promotion mix relies heavily on advertising, personal selling, and a limited use of product sampling.

Why is this so?

New Day Vitamin Company's promotion mix relies heavily on advertising, personal selling, and limited use of product sampling.

A promotion mix simply means the blend of different promotional tools that are used by organizations to create and increase the demand for goods and services.

A company's promotion mix combines promotional tools such as personal selling, advertising, sales promotion, publicity, sampling, public relations, etc.

Learn more about promotion mix at:

https://brainly.com/question/20879094

#SPJ1

Briefly discuss the power of Occupational Safety and Health Administration (OSHA) with respect to citations and penalties.

Answers

Answer:

The Occupational Safety and Health Administration (OSHA) is responsible for enforcing health and safety regulations in the workplace. OSHA has the power to issue citations and penalties to employers who violate health and safety regulations.

If OSHA finds that an employer has violated a regulation, it can issue a citation. A citation outlines the specific regulation that was violated, and the proposed penalty. Employers have the opportunity to contest the citation and penalty, and can request an informal conference with an OSHA representative to discuss the issue.

OSHA can also issue penalties for violations. The penalty amount varies depending on the severity of the violation. Willful violations, which are the most serious, can result in penalties of up to $136,532 per violation, while serious violations can result in penalties of up to $13,653 per violation.

The power of OSHA to issue citations and penalties is an important tool for promoting workplace safety. The threat of citations and penalties can encourage employers to take safety seriously and to take steps to prevent workplace accidents and injuries.

Explanation:

?
When does personal information offen need to be entered online?
O when conducting an Internet search
when watching streaming videos
O when downicading free software
O when gaining access to a website

Answers

Answer:

when gaining access to a website

Imagine that you wanted to specialize in working with senior citizens. What special needs might this group have? What kind of skills would you acquire if you specialized in this demographic? What kind of location would work well for this population?

Answers

The needs of senior citizens would require the ability of those who can handle geriatrics.

Why is this so?

There are special health conditions that come with those who are geriatrics or senior citizens.

This is because, as people age, the body no longer can repair it'self like before and becomes more frail, hence the need for more care.

So working with this kind of population will require skills such as:

Emergency resuscitationSpecial Nutrition etc.

Learn more about senior citizens at:

https://brainly.com/question/14361097?

#SPJ1

Other Questions
Which of the following is true about a total institution?Answers: A-DA All of the aboveB It refers to a place where people are isolated from the rest of society for a set period of tiC It is a term coined by Erving GoffmanD It refers to a place where people come under the control of the officials who run the in The hypotenuse of a right triangle measures 29 cm. One leg is 1 cm shorter than the other. What are the lengths of the legs? A high concentration of _____________ in the blood usually indicates serious muscle damage. The rise of the Alternative movement and "Grunge" coming out of the Pacific Northwest is significant in its continuation of the indie scene from the 1980's. Focusing on Nirvana and Sub Pop Records, detail the attitude and sound of this style. PLEASEEEE HELPPP ASAP 20 PTSUse long division to determine the quotient of the following expression.Write the quotient in standard form with the term of largest degree on the left. (10x^(2)+3x-77)-:(2x+7) Plan production for the next year. the demand forecast is spring, 19,600; summer, 9,400; fall, 14,600; winter, 17,000. at the beginning of spring you have 60 workers and 1,030 units in inventory. the union contract specifies that you may lay off workers only once a year, at the beginning of summer. also, you may hire new workers only at the end of summer to begin regular work in the fall. the number of workers laid off at the beginning of summer and the number hired at the end of summer should result in planned production levels for summer and fall that equal the demand forecasts for summer and fall, respectively. if demand exceeds supply, use overtime in spring only, which means that backorders could occur in winter. you are given these costs: hiring, $120 per new worker; layoff, $240 per worker laid off; holding, $21 per unit-quarter; backorder cost, $9 per unit; straight-time labor, $12 per hour; overtime, $18 per hour. productivity is 0. 5 unit per worker hour, eight hours per day, 50 days per quarter. required:find the total cost of this plan. A patient weighs 160 pounds and needs medication with dosage instructions of 15 mg/kg/day. It is to be given in 3 doses each day. How much medication should they receive per dose? Remember, 2.2 pounds is equal to 1 kilogram. Round to the nearest whole number. Use the given acceleration function and initial conditions to find the velocity vector v(t), and position vector r(t). Then find the position at time t = 9. a(t) = cos ti sin tj v(0) = j + k, r(0) = i v(t) = r(t) = r(9) = Which sequence below would best model the description? 50 points! What is foreshadowing?a literary device to provide background information about a character in a texta literary device to express a statement of truth in a way that amuses the readera literary device to create situations that are opposite of what the reader expectsa literary device to provide a clue about something that will happen later in a text 14.Figure shows a magnetic field associated with a rectangular coil directed into the plane of thepaper.(a) What would be the effect if the coil moves towards right? 1 mark(b) Name the phenomenon responsible for the above observation. 1 mark(c)(i) State the rule that is used to determine the direction of current produced in the phenomenon. Identify which type of sampling is used: random, stratified, cluster, systematic, or convenience. 1. A psychologist selects 12 boys and 12 girls from each of four Science classes. 2. When he made an important announcement, he based his conclusion on 10 000 responses, from100 000 questionnaires distributed to students. 3. A biologist surveys all students from each of 15 randomly selected classes. 4. The game show organizer writes the name of each contestant on a separate card, shuffles the cards, anddraws five names. 5. Family Planning polls 1 000 men and 1 000 women about their views concerning the use of contraceptives. 6. A hospital researcher interviews all diabetic patients in each of ten randomly selected hospitals. What led to the idea that the Universe started out in a big bang? 1. The observation of the cosmic microwave background 2. The earliest galaxies observed by the Hubble Space Telescope 3. Using the Type 1A supernovae in the measurements of the expansion of the universe 4. The observed expansion of the universe The approximate number of zombies in a certain city over time is given in the table below. Answer the questions below to determine what kind of function would best fit the data, linear or exponential.Number of Hours Since Zombies First Spotted, x1234Approximate Number of Zombies, f(x)245688122 function would best fit the data because as x increases, the y values change . Rounded to the nearest .5, the of this function is approximately how to find the polynmial closest to another polynomial in an inner product space Get this right and Ill give you brainliest!! The radioactive element carbon-14 has a half-life of 5750 years. A scientist determined that the bones from a mastodon had lost 73.6% of their carbon-14. How old were the bones at the time they were discovered? The bones were about how many years old? A square has sides of length s. A rectangle is 6 inches shorter than the square and 1 inch longer. Which of the following expressions represents the perimeter of the rectangle? On the same coordinate plane, mark all points (x,y) such that (A) y=x-2, (B) y=-x-2, (C) y=|x|-2 Kolby corp. Is comparing two different capital structures. Plan i would result in 3,500 shares of stock and $37,440 in debt. Plan ii would result in 2,800 shares of stock and $66,560 in debt. The interest rate on the debt is 10 percent. Assume that ebit will be $14,800. An all-equity plan would result in 4,400 shares of stock outstanding. a. Ignore taxes, compare both of these plans to an all-equity plan assuming that ebit will be $14,800. The all-equity plan would result in 4,400 shares of stock outstanding. Which of the three plans has the highest eps? the lowest?b. In part (a) what are the break-even levels of ebit for each plan as compared to that for an all-equity plan? is one higher than the other? why?c. Ignoring taxes, when will eps be identical for plans i and ii?d. Repeat parts (a), (b), and (c) assuming that the corporate tax rate is 21 percent. Are the break-even levels of ebit different from before? why or why not?show all the steps and don't round off calculations