Pearson eText for Business Math -- Instant Access (Pearson+)
Pearson eText for Business Math -- Instant Access (Pearson+)
11th Edition
ISBN: 9780137518883
Author: Cheryl Cleaves, Margie Hobbs
Publisher: PEARSON+
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 11, Problem 1ES
To determine

To calculate: The amount of simple interest of the principal amount $500 at the annual rate of 12% for the time period of 2 years by the use of excel.

Expert Solution & Answer
Check Mark

Answer to Problem 1ES

Solution:

The amount of simple interest is $120.

Explanation of Solution

Given Information:

The principal amount is $500, the annual rate is 12%, and the time period is 2 years.

Formula Used:

The simple interest formula,

Interest=principal×rate×timeI=PRT

Calculation:

Consider that the principal amount is $500, the annual rate is 12%, and the time period is 2 years.

Use excel as below,

Step 1: Open excel and label the cell A1 as principal, label the cell B1 as Annual rate, label the cell C1 as Time and label the cell D1 as the Interest. And, write the corresponding data as provided in row 2 as below,

Pearson eText for Business Math -- Instant Access (Pearson+), Chapter 11, Problem 1ES , additional homework tip  1

Step 2: Go to the cell D2 and write the formula as below,

=A2*(B2/100)*C2

Step 3: Press enter.

The value obtained as,

Pearson eText for Business Math -- Instant Access (Pearson+), Chapter 11, Problem 1ES , additional homework tip  2

Thus, the amount of simple interest is $120.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 11 Solutions

Pearson eText for Business Math -- Instant Access (Pearson+)

Ch. 11.1 - Prob. 3-3SCCh. 11.1 - Prob. 3-4SCCh. 11.1 - Prob. 4-1SCCh. 11.1 - Prob. 4-2SCCh. 11.1 - Prob. 4-3SCCh. 11.1 - Prob. 4-4SCCh. 11.1 - Prob. 1SECh. 11.1 - Prob. 2SECh. 11.1 - Prob. 3SECh. 11.1 - Prob. 4SECh. 11.1 - Prob. 5SECh. 11.1 - Prob. 6SECh. 11.1 - Prob. 7SECh. 11.1 - Prob. 8SECh. 11.1 - Prob. 9SECh. 11.1 - Prob. 10SECh. 11.1 - Prob. 11SECh. 11.1 - Prob. 12SECh. 11.1 - Prob. 13SECh. 11.1 - Prob. 14SECh. 11.1 - Prob. 15SECh. 11.1 - Prob. 16SECh. 11.2 - Prob. 1-1SCCh. 11.2 - Prob. 1-2SCCh. 11.2 - Prob. 1-3SCCh. 11.2 - Prob. 1-4SCCh. 11.2 - Prob. 2-1SCCh. 11.2 - Prob. 2-2SCCh. 11.2 - Prob. 2-3SCCh. 11.2 - Prob. 2-4SCCh. 11.2 - Prob. 3-1SCCh. 11.2 - Prob. 3-2SCCh. 11.2 - Prob. 3-3SCCh. 11.2 - Prob. 3-4SCCh. 11.2 - Prob. 3-5SCCh. 11.2 - Prob. 4-1SCCh. 11.2 - Prob. 4-2SCCh. 11.2 - Prob. 4-3SCCh. 11.2 - Prob. 4-4SCCh. 11.2 - Prob. 1SECh. 11.2 - Prob. 2SECh. 11.2 - Prob. 3SECh. 11.2 - Prob. 4SECh. 11.2 - Prob. 5SECh. 11.2 - Prob. 6SECh. 11.2 - Prob. 7SECh. 11.2 - Prob. 8SECh. 11.2 - Prob. 9SECh. 11.2 - Prob. 10SECh. 11.2 - Prob. 11SECh. 11.2 - Prob. 12SECh. 11.2 - Prob. 13SECh. 11.2 - Prob. 14SECh. 11.2 - Prob. 15SECh. 11.3 - Prob. 1-1SCCh. 11.3 - Prob. 1-2SCCh. 11.3 - Prob. 1-3SCCh. 11.3 - Prob. 1-4SCCh. 11.3 - Prob. 2-1SCCh. 11.3 - Prob. 2-2SCCh. 11.3 - Prob. 2-3SCCh. 11.3 - Prob. 2-4SCCh. 11.3 - Prob. 3-1SCCh. 11.3 - Prob. 3-2SCCh. 11.3 - Prob. 3-3SCCh. 11.3 - Prob. 3-4SCCh. 11.3 - Prob. 1SECh. 11.3 - Prob. 2SECh. 11.3 - Prob. 3SECh. 11.3 - Prob. 4SECh. 11.3 - Prob. 5SECh. 11.3 - Prob. 6SECh. 11.3 - Prob. 7SECh. 11.3 - Prob. 8SECh. 11.3 - Prob. 9SECh. 11.3 - Prob. 10SECh. 11.3 - Prob. 11SECh. 11 - Prob. 1ESCh. 11 - Prob. 2ESCh. 11 - Prob. 3ESCh. 11 - Prob. 4ESCh. 11 - Prob. 5ESCh. 11 - Prob. 6ESCh. 11 - Prob. 7ESCh. 11 - Prob. 8ESCh. 11 - Prob. 9ESCh. 11 - Prob. 10ESCh. 11 - Prob. 11ESCh. 11 - Prob. 12ESCh. 11 - Prob. 13ESCh. 11 - Prob. 14ESCh. 11 - Prob. 15ESCh. 11 - Prob. 16ESCh. 11 - Prob. 17ESCh. 11 - Prob. 18ESCh. 11 - Prob. 19ESCh. 11 - Prob. 20ESCh. 11 - Prob. 21ESCh. 11 - Prob. 22ESCh. 11 - Prob. 23ESCh. 11 - Prob. 24ESCh. 11 - Prob. 25ESCh. 11 - Prob. 26ESCh. 11 - Prob. 27ESCh. 11 - Prob. 28ESCh. 11 - Prob. 29ESCh. 11 - Prob. 30ESCh. 11 - Prob. 31ESCh. 11 - Prob. 32ESCh. 11 - Prob. 33ESCh. 11 - Prob. 34ESCh. 11 - Prob. 35ESCh. 11 - Prob. 36ESCh. 11 - Prob. 37ESCh. 11 - Prob. 38ESCh. 11 - Prob. 39ESCh. 11 - Prob. 40ESCh. 11 - Prob. 41ESCh. 11 - Prob. 42ESCh. 11 - Prob. 43ESCh. 11 - Prob. 44ESCh. 11 - Prob. 45ESCh. 11 - Prob. 46ESCh. 11 - Prob. 47ESCh. 11 - Prob. 48ESCh. 11 - Prob. 49ESCh. 11 - Prob. 50ESCh. 11 - Prob. 51ESCh. 11 - Prob. 52ESCh. 11 - Prob. 53ESCh. 11 - Prob. 54ESCh. 11 - Prob. 1PTCh. 11 - Prob. 2PTCh. 11 - Prob. 3PTCh. 11 - Prob. 4PTCh. 11 - Prob. 5PTCh. 11 - Prob. 6PTCh. 11 - Prob. 7PTCh. 11 - Prob. 8PTCh. 11 - Prob. 9PTCh. 11 - Prob. 10PTCh. 11 - Prob. 11PTCh. 11 - Prob. 12PTCh. 11 - Prob. 13PTCh. 11 - Prob. 14PTCh. 11 - Prob. 15PTCh. 11 - Prob. 16PTCh. 11 - Prob. 17PTCh. 11 - Prob. 18PTCh. 11 - Prob. 19PTCh. 11 - Prob. 20PTCh. 11 - Prob. 21PTCh. 11 - Prob. 22PTCh. 11 - Prob. 1CTCh. 11 - Prob. 2CTCh. 11 - Prob. 3CTCh. 11 - Prob. 4CTCh. 11 - Prob. 5CTCh. 11 - Prob. 6CTCh. 11 - Prob. 7CTCh. 11 - Prob. 8CTCh. 11 - Prob. 1CPCh. 11 - Prob. 2CPCh. 11 - Prob. 3CPCh. 11 - Prob. 4CPCh. 11 - Prob. 1CS1Ch. 11 - Prob. 2CS1Ch. 11 - Prob. 3CS1Ch. 11 - Prob. 4CS1Ch. 11 - Prob. 1CS2Ch. 11 - Prob. 2CS2Ch. 11 - Prob. 3CS2Ch. 11 - Prob. 4CS2Ch. 11 - Prob. 1CS3Ch. 11 - Prob. 2CS3Ch. 11 - Prob. 3CS3Ch. 11 - Prob. 4CS3
Knowledge Booster
Background pattern image
Math
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Discrete Mathematics and Its Applications ( 8th I...
Math
ISBN:9781259676512
Author:Kenneth H Rosen
Publisher:McGraw-Hill Education
Text book image
Mathematics for Elementary Teachers with Activiti...
Math
ISBN:9780134392790
Author:Beckmann, Sybilla
Publisher:PEARSON
Text book image
Calculus Volume 1
Math
ISBN:9781938168024
Author:Strang, Gilbert
Publisher:OpenStax College
Text book image
Thinking Mathematically (7th Edition)
Math
ISBN:9780134683713
Author:Robert F. Blitzer
Publisher:PEARSON
Text book image
Discrete Mathematics With Applications
Math
ISBN:9781337694193
Author:EPP, Susanna S.
Publisher:Cengage Learning,
Text book image
Pathways To Math Literacy (looseleaf)
Math
ISBN:9781259985607
Author:David Sobecki Professor, Brian A. Mercer
Publisher:McGraw-Hill Education
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY