$***$ ALL ANSWERS MUST BE ENTERED AS A FORMULA$****$

Calculating the number of periods $-$ Excel

FILE

HOME

INSERT

PAGE LAYOUT

FORMULAS

DATA

REVIEW

VIEW

Clipboard

$$

$11$

$A^A{A}^{}$

$\%$

$$

$$

$$

Conditional Format as Cell

Cells

Formatting $*$ Table $*$ Styles $*$

A$1$

A

B

C

D

E

F

G

H

Solve for the unknown number of years in each of the following:

Complete the following analysis. Do not hard code values in your calculations.

$\backslash$table$[[$Present value,Years,Interest rate,Future value$],[$$$,560,6\%,$$$,1,389],[$$$,810,9\%,$$$,1,821],[$$$,18,400,11\%,$$$,289,715],[$$$,21,500,13\%,$$$,430,258]]$