Question: 1) what us wrong with the PMT function in cell B6 ( first picture) 2) what is wrong with PMT function in cell B16 (second

1) what us wrong with the PMT function in cell B6 ( first picture)
2) what is wrong with PMT function in cell B16 (second picture).
3) what us the correct amount for the the monthly payment?
 1) what us wrong with the PMT function in cell B6
( first picture) 2) what is wrong with PMT function in cell

Paste Font Alignment Number Conditional Format Format as Table Cell Styles Clipboard F Styles B6 X f x B =PMT(B3,B4*12,B5) C D 3% 1 Possible Car Payments 2 Scenario 1 3 Annual interest rate 4 Number of years 5 Amount of loan 6 Monthly payment $10,000 + ($361.33) 3% 12 Scenario 2 13 Annual interest rate 14 Number of years 15 Amount of loan 16 Monthly payment 17 $10,000 ($2,015.02) Paste LE Font Alignment Number Format as Table Cell Styles Clipboard F Styles B16 - x fx =PMT(B13/12,814,815) C D B Vol 1 Possible Car Payments 2 Scenario 1 3 Annual interest rate 4 Number of years 5 Amount of loan 6 Monthly payment 3% $10,000 ($361.33) =oooo 3% 12 Scenario 2 13 Annual interest rate 14 Number of years 15 Amount of loan 16 Monthly payment $10,000 {$2,015.02)

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 Databases Questions!