MYMATHLA BUSINESS MATH
MYMATHLA BUSINESS MATH
null Edition
ISBN: 9780135903520
Author: Cheryl Cleaves
Publisher: PEARSON
bartleby

Concept explainers

bartleby

Videos

Question
Chapter 14, Problem 1ES
To determine

To calculate: The total interest amount and future value of annuity in the following table using Excel worksheet,

Annuity payment

Annual Rate

Annual interest

Years

Type of annuity

Future value of annuity

Total interest

$1400

3%

Compounded annually

5

Ordinary

Expert Solution & Answer
Check Mark

Answer to Problem 1ES

Solution:

The total interest amount and future value of annuity in the following table is,

Annuity payment

Annual Rate

Annual interest

Years

Type of annuity

Future value of annuity

Total interest

$1400

3%

Compounded annually

5

Ordinary

$7432.790

$432.790

Explanation of Solution

Given Information:

The provided table is,

Annuity payment

Annual Rate

Annual interest

Years

Type of annuity

Future value of annuity

Total interest

$1400

3%

Compounded annually

5

Ordinary

Formula used:

Sinking fund payment PMT is invested in a sinking fund at an interest rate R% compounded periodically for the period N then the accumulated Future value (FV) is,

FV=PMT((1+R)N1R)

Calculation:

Consider the table,

Annuity payment

Annual Rate

Annual interest

Years

Type of annuity

Future value of annuity

Total interest

$1400

3%

Compounded annually

5

Ordinary

To find the Future value of annuity follow the steps,

Step 1: Open an Excel worksheet.

Step 2: Write the annuity payment $1400 in the cell B3.

Step 3: Write the annual rate of interest 3% in the cell B4.

Step 4: As the annual interest compounded annual hence write the number of period as 1 in the cell B5.

Step 5: Write the number of years 5 in the cell B6.

Step 6: To calculate the total number of period write “ =B6*B5 ” in B8.

Step 7: To calculate the periodic interest rate write “ =B4/(100*B5) ” in B9.

Step 8: To calculate the Sinking fund payment write “ =B3*B9/((1+B9)^B81) ” in B11.

Step 9: To calculate the total payment write “ =B8*B3 ” in B13.

Step 10: To calculate the total interest write “ =B11B13 ” in B15.

Therefore,

MYMATHLA BUSINESS MATH, Chapter 14, Problem 1ES

Therefore the completed table is,

Annuity payment

Annual Rate

Annual interest

Years

Type of annuity

Future value of annuity

Total interest

$1400

3%

Compounded annually

5

Ordinary

$7432.790

$432.790

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 14 Solutions

MYMATHLA BUSINESS MATH

Ch. 14.1 - Prob. 3-1SCCh. 14.1 - Prob. 3-2SCCh. 14.1 - Prob. 3-3SCCh. 14.1 - Prob. 3-4SCCh. 14.1 - Prob. 4-1SCCh. 14.1 - Prob. 4-2SCCh. 14.1 - Prob. 4-3SCCh. 14.1 - Prob. 4-4SCCh. 14.1 - Prob. 5-1SCCh. 14.1 - Prob. 5-2SCCh. 14.1 - Prob. 5-3SCCh. 14.1 - Prob. 5-4SCCh. 14.1 - Prob. 6-1SCCh. 14.1 - Prob. 6-2SCCh. 14.1 - Prob. 6-3SCCh. 14.1 - Prob. 6-4SCCh. 14.1 - Prob. 6-5SCCh. 14.1 - Prob. 6-6SCCh. 14.1 - Prob. 1SECh. 14.1 - Prob. 2SECh. 14.1 - Prob. 3SECh. 14.1 - Prob. 4SECh. 14.1 - Prob. 5SECh. 14.1 - Prob. 6SECh. 14.1 - Prob. 7SECh. 14.1 - Prob. 8SECh. 14.1 - Prob. 9SECh. 14.1 - Prob. 10SECh. 14.1 - Prob. 11SECh. 14.1 - Prob. 12SECh. 14.1 - Prob. 13SECh. 14.1 - Prob. 14SECh. 14.1 - Prob. 15SECh. 14.1 - Prob. 16SECh. 14.1 - Prob. 17SECh. 14.1 - Prob. 18SECh. 14.1 - Prob. 19SECh. 14.1 - Prob. 20SECh. 14.1 - Prob. 21SECh. 14.1 - Prob. 22SECh. 14.1 - Prob. 23SECh. 14.1 - Prob. 24SECh. 14.1 - Prob. 25SECh. 14.1 - Prob. 26SECh. 14.1 - Prob. 27SECh. 14.1 - Prob. 28SECh. 14.1 - Prob. 29SECh. 14.1 - Prob. 30SECh. 14.2 - Prob. 1-1SCCh. 14.2 - Prob. 1-2SCCh. 14.2 - Prob. 1-3SCCh. 14.2 - Prob. 1-4SCCh. 14.2 - Prob. 2-1SCCh. 14.2 - Prob. 2-2SCCh. 14.2 - Prob. 2-3SCCh. 14.2 - Prob. 2-4SCCh. 14.2 - Prob. 3-1SCCh. 14.2 - Prob. 3-2SCCh. 14.2 - Prob. 1SECh. 14.2 - Prob. 2SECh. 14.2 - Prob. 3SECh. 14.2 - Prob. 4SECh. 14.2 - Prob. 5SECh. 14.2 - Prob. 6SECh. 14.2 - Prob. 7SECh. 14.2 - Prob. 8SECh. 14.2 - Prob. 9SECh. 14.2 - Prob. 10SECh. 14.2 - Prob. 11SECh. 14.2 - Prob. 12SECh. 14.2 - Prob. 13SECh. 14.2 - Prob. 14SECh. 14 - Prob. 1ESCh. 14 - Prob. 2ESCh. 14 - Prob. 3ESCh. 14 - Prob. 4ESCh. 14 - Prob. 5ESCh. 14 - Prob. 6ESCh. 14 - Prob. 7ESCh. 14 - Prob. 8ESCh. 14 - Prob. 9ESCh. 14 - Prob. 10ESCh. 14 - Prob. 11ESCh. 14 - Prob. 12ESCh. 14 - Prob. 13ESCh. 14 - Prob. 14ESCh. 14 - Prob. 15ESCh. 14 - Prob. 16ESCh. 14 - Prob. 17ESCh. 14 - Prob. 18ESCh. 14 - Prob. 19ESCh. 14 - Prob. 20ESCh. 14 - Prob. 21ESCh. 14 - Prob. 22ESCh. 14 - Prob. 23ESCh. 14 - Prob. 24ESCh. 14 - Prob. 25ESCh. 14 - Prob. 26ESCh. 14 - Prob. 27ESCh. 14 - Prob. 28ESCh. 14 - Prob. 29ESCh. 14 - Prob. 30ESCh. 14 - Prob. 31ESCh. 14 - Prob. 32ESCh. 14 - Prob. 33ESCh. 14 - Prob. 34ESCh. 14 - Prob. 35ESCh. 14 - Prob. 36ESCh. 14 - Prob. 37ESCh. 14 - Prob. 38ESCh. 14 - Prob. 39ESCh. 14 - Prob. 1PTCh. 14 - Prob. 2PTCh. 14 - Prob. 3PTCh. 14 - Prob. 4PTCh. 14 - Prob. 5PTCh. 14 - Prob. 6PTCh. 14 - Prob. 7PTCh. 14 - Prob. 8PTCh. 14 - Prob. 9PTCh. 14 - Prob. 10PTCh. 14 - Prob. 11PTCh. 14 - Prob. 12PTCh. 14 - Prob. 13PTCh. 14 - Prob. 14PTCh. 14 - Prob. 15PTCh. 14 - Prob. 16PTCh. 14 - Prob. 17PTCh. 14 - Prob. 18PTCh. 14 - Prob. 19PTCh. 14 - Prob. 20PTCh. 14 - Prob. 21PTCh. 14 - Prob. 22PTCh. 14 - Prob. 23PTCh. 14 - Prob. 24PTCh. 14 - Prob. 25PTCh. 14 - Prob. 1CTCh. 14 - Prob. 2CTCh. 14 - Prob. 3CTCh. 14 - Prob. 4CTCh. 14 - Prob. 5CTCh. 14 - Prob. 6CTCh. 14 - Prob. 7CTCh. 14 - Prob. 8CTCh. 14 - Prob. 9CTCh. 14 - Prob. 10CTCh. 14 - Prob. 1CPCh. 14 - Prob. 2CPCh. 14 - Prob. 3CPCh. 14 - Prob. 1CS1Ch. 14 - Prob. 2CS1Ch. 14 - Prob. 3CS1Ch. 14 - Prob. 4CS1Ch. 14 - Prob. 5CS1Ch. 14 - Prob. 1CS2Ch. 14 - Prob. 2CS2Ch. 14 - Prob. 3CS2Ch. 14 - Prob. 4CS2Ch. 14 - Prob. 5CS2Ch. 14 - Prob. 1CS3Ch. 14 - Prob. 2CS3Ch. 14 - Prob. 3CS3Ch. 14 - Prob. 4CS3Ch. 14 - Prob. 5CS3Ch. 14 - Prob. 6CS3
Knowledge Booster
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
  • Discrete Mathematics and Its Applications ( 8th I...
    Math
    ISBN:9781259676512
    Author:Kenneth H Rosen
    Publisher:McGraw-Hill Education
    Mathematics for Elementary Teachers with Activiti...
    Math
    ISBN:9780134392790
    Author:Beckmann, Sybilla
    Publisher:PEARSON
    Calculus Volume 1
    Math
    ISBN:9781938168024
    Author:Strang, Gilbert
    Publisher:OpenStax College
  • Thinking Mathematically (7th Edition)
    Math
    ISBN:9780134683713
    Author:Robert F. Blitzer
    Publisher:PEARSON
    Discrete Mathematics With Applications
    Math
    ISBN:9781337694193
    Author:EPP, Susanna S.
    Publisher:Cengage Learning,
    Pathways To Math Literacy (looseleaf)
    Math
    ISBN:9781259985607
    Author:David Sobecki Professor, Brian A. Mercer
    Publisher:McGraw-Hill Education
  • Discrete Mathematics and Its Applications ( 8th I...
    Math
    ISBN:9781259676512
    Author:Kenneth H Rosen
    Publisher:McGraw-Hill Education
    Mathematics for Elementary Teachers with Activiti...
    Math
    ISBN:9780134392790
    Author:Beckmann, Sybilla
    Publisher:PEARSON
    Calculus Volume 1
    Math
    ISBN:9781938168024
    Author:Strang, Gilbert
    Publisher:OpenStax College
    Thinking Mathematically (7th Edition)
    Math
    ISBN:9780134683713
    Author:Robert F. Blitzer
    Publisher:PEARSON
    Discrete Mathematics With Applications
    Math
    ISBN:9781337694193
    Author:EPP, Susanna S.
    Publisher:Cengage Learning,
    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