Question: The Payment (PMT) Function below is a commonly used calculation in Finance and Accounting. Suppose you have a desired outcome in mind for the PMT()

The Payment (PMT) Function below is a commonly used calculation in Finance and Accounting. Suppose you have a desired outcome in mind for the PMT() function$800. You want to find a Down Pmt that will use the current values of Mntly Rate, Term in Mns, and Principal to achieve your goal of a Mntly Payment of $800.

AC	AD
Monthly rate	0.05
Term in mns	360
Principal	200,000
Down Payment	?
Monthly Payment	PMT

a) What value of Mnthly Rate will achieve your $800 goal?

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!

what is the value of monthly rate percentage need to achieve the $800 goal ? DO NOT GIVE ME THE DOWN PAYMENT ANSWER The Payment (PMT) Function below is a commonly used calculation in Finance and...

Please help me to answer the attached files ................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1 Submission deadline without penalties is 12 October 2017....

Please help me to answer the following file ............................................................................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1...

1. Before doing Q1 and Q2, please first read the assigned readings and do quiz 2. Based on Chapter 4's Section 6 to 9, answer: 1) If the definition of FVA is future value of annuity, what are...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

please help thank you Consider an ordinary annuity that pays out over 6 as well as an annuity due that also pays out over 6 periods. Assume that each of these annuities has the same interest rate....

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

How could a channel system be a source of competitive advantage for Lexus?

Jan. 1 June 30 Dec. 31 Date Jan 1 Journalize all entries required on the above dates, including entries to update depreciation on assets disposed of, where applicable. Blossom Company uses...

You are auditing Green Corporation for the calendar year 2 0 2 3 . Among other items related to the audit, Green Corporation was being sued for personal injury resulting from the malfunction of one...

Ron and Jan are concerned about volatility in their retirement investment portfolio. Which of the following asset classes offers the least amount of volatility / variability in returns? A. Treasury...

Evaluate the strength of the five forces individually for the fast-food industry.

Make a judgement about how attractive an industry like this would be to invest $5 million.

5. After watching the video what advice would you give to an employer such as Stephen Elop when they are announcing redundancies.