Using Excel PMT function calculate monthly payment for a loan of 700,000 at an annual interest rate of 4% repaid in 25 years. a. 4750.53 b. 3694.86 Oc. 4222.69 Od. 2639.18

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter8: Working With Advanced Functions
Section8.3: Conditional Formatting And Functions
Problem 3QC
icon
Related questions
Question

Begging you to help me with correct answer please fasssstttt

Using Excel PMT function calculate monthly payment for a loan of 700,000 at an annual interest rate of 4% repaid in 25 years.
a. 4750.53
b. 3694.86
Oc. 4222.69
d. 2639.18
Transcribed Image Text:Using Excel PMT function calculate monthly payment for a loan of 700,000 at an annual interest rate of 4% repaid in 25 years. a. 4750.53 b. 3694.86 Oc. 4222.69 d. 2639.18
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Payback period
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole