Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Need help writing the correct formula to get periodic payment. Should get the same answer as shown below. Calculating the periodic payment: The periodic payment

Need help writing the correct formula to get periodic payment. Should get the same answer as shown below.

image text in transcribed

Calculating the periodic payment: The periodic payment is the total amount of principal and interest that is paid on the loan for each period. The periodic payment is the same for every period for the life of the loan. Use the PMT function to calculate the periodic payment for the auto loan. The principal of the loan (present value) is the purchase price minus the down payment plus the sales tax - the tax is added to the loan for an auto loan. Hint - the interest rate used in this function is the periodic interest rate, this is the yearly interest rate divided by the number of periods. Your worksheet should have the values in the figure below

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions