Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions