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

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
Get step-by-step solutions from verified subject matter experts
