This preview shows pages 1–6. Sign up to view the full content.
Chapter 5
Problems 120
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver AddIn" be installed in Excel.
To install these, click on the Office button
then "Excel Options," "AddIns" and select
"Go." Check "Analyis ToolPak" and
"Solver AddIn," then click "OK."
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Chapter 5
Question 1
Input area:
Interest rate
8%
Deposit
$5,000
# of years
10
Output area:
Compound interest
$10,794.62
Simple interest
$9,000.00
Difference
$1,794.62
Chapter 5
Question 2
Input area:
Output area:
Present value
Years
Interest rate
Future value
$2,250
11
10%
$6,419.51
8,752
7
8%
$14,999.39
76,355
14
17%
$687,764.17
183,796
8
7%
$315,795.75
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Chapter 5
Question 3
Output area:
Input area:
Present value
Years
Interest rate
Future value
$10,295.65
6
7%
$15,451
$21,914.85
7
13%
51,557
$43,516.90
23
14%
886,073
$116,631.32
18
9%
550,164
Question 4
Input area:
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 02/12/2012 for the course BT 1003 taught by Professor As during the Spring '11 term at American Jewish University.
 Spring '11
 AS

Click to edit the document details