Question: Excel formula for: How much must you put into a 5 percent investment annually to have $75,000 eight years from now? Assume that all payments

Excel formula for: How much must you put into a 5 percent investment annually to have $75,000 eight years from now? Assume that all payments are made at the end of each period.

=PMT(?)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Solve using a spreadsheet program such as Excel. Indicate the spreadsheet formula showing numeric values rather than cell references. For example, for the value that $100 today could grow to in 2...

https://youtu.be/733mgqrzNKs https://youtu.be/TDpuYH7d7Nc TVM Spreadsheet Problems . Use the youtube link to solve for the problems 5-14 to 5-19 . 5-14. How much will $20,000 invested today at 3...

How much must you put into a 5 percent investment annually to have $ 75,000 eight years from now? Assume all payments are made at the end of each period. See earlier NOTE regarding requirements for...

Hi I need help understanding how to solve for the following questions. 5-17. How much must you put into a 5 percent investment annually to have $75,000 eight years from now? Assume all payments are...

How much must you put into a 5 percent investment annually to have $75,000 eight years from now? Assume all payments are made at the end of each period. This is a Time Value Money question. You need...

36. How much must you put into a 5 percent investment annually to have $75,000 eight years from now? Assume all payments are made at the end of each period

How much must you put into a 5 percent investment annually to have $75,000 eight years from now? Assume that all payments are made at the end of each period.

PRACTICE SET E ANNUITIES, PERPETUITIES, AND GROWING PAYMENTS (For each problem, determine what value the question is asking you to solve) 1. Renaissance Paper, Inc. needs to invest $8,000 at the end...

1. Renaissance Paper, Inc. needs to invest $8,000 at the end of each of the next five years to keep its current project going. If the firm can earn 7.5 percent annual compounding on its invested...

This is our study guide and I would like to know step by step how to solve these questions on excel/ or by hand whichever is easier. Along with knowing why took that route in order to be knowledgable...

Douglass Gardens pays an annual dividend that is expected to increase by 5.2 percent per year. The stock commands a market rate of return of 15.6 percent and sells for $24.90 a share. What is the...

The AICPA would like you to deliver a speech at one of its upcoming conferences on the future of accounting information systems. Select one conference from your search for the discussion preparation...

The risk that the interest rate that can be earned on short - term assets will be less than the interest rate paid on the long term liabilities is called Multiple choice question. refinancing risk.

prices provide consistency and decrease the price shopping of customers. Cost - based Prestige Value - based Static

11.5 Describe the grievance procedure in a union environment.

11.6 Explain union decertification.

Larry Browning, Alf Saetre, Keri Stephens, and Jan-Oddvar Sornes (2008) present stories of the ways personal and social media facilitate and hinder work in a range of organizations. Their book shows...