For this problem, there are 10 future value and present value exercises to be solved. Review the printout of the worksheet file COMPOUND that follows these requirements. This file also contains a second sheet called the Answer Sheet. Note that the worksheet is divided into four sections. You have to decide which section is appropriate for each exercise. Open the file COMPOUND from the website for this book at cengagebrain.com. To enter the four formulas in the appropriate cells, use the FV and PV functions for the annuities (see Appendix A in Excel Quick for a discussion of them). Unfortunately Excel does not provide functions for the future value of an amount nor the present value of an amount. Enter the following formulas for FORMULA1 and FORMULA2: FORMULA1: =B6*((1+B8)^B7) FORMULA2: =E6/((1+E8)^AE7) For the annuity calculations (FV and PV), it is important that you enter a value (or cell reference) for type to indicate the timing of the first payment. If the first payment is made today for an annuity, type must be 0. This is known as an annuity due. If the first payment is made at the end of the first period, type is 1. This is known as an ordinary annuity. Enter your name in cell A1. Save the completed worksheet as COMPOUND2. When you have completed the exercises below, print your formulas. Do not print the worksheet. Check figures: The answer sheet at the end of this section provides answers to the first exercise
For this problem, there are 10 future value and present value exercises to be solved. Review the printout of the worksheet file COMPOUND that follows these requirements. This file also contains a second sheet called the Answer Sheet. Note that the worksheet is divided into four sections. You have to decide which section is appropriate for each exercise. Open the file COMPOUND from the website for this book at cengagebrain.com. To enter the four formulas in the appropriate cells, use the FV and PV functions for the annuities (see Appendix A in Excel Quick for a discussion of them). Unfortunately Excel does not provide functions for the future value of an amount nor the present value of an amount. Enter the following formulas for FORMULA1 and FORMULA2: FORMULA1: =B6*((1+B8)^B7) FORMULA2: =E6/((1+E8)^AE7) For the annuity calculations (FV and PV), it is important that you enter a value (or cell reference) for type to indicate the timing of the first payment. If the first payment is made today for an annuity, type must be 0. This is known as an annuity due. If the first payment is made at the end of the first period, type is 1. This is known as an ordinary annuity. Enter your name in cell A1. Save the completed worksheet as COMPOUND2. When you have completed the exercises below, print your formulas. Do not print the worksheet. Check figures: The answer sheet at the end of this section provides answers to the first exercise
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
For this problem, there are 10 future value and present value exercises to be solved. Review the printout of the worksheet file COMPOUND that follows these requirements. This file also contains a second sheet called the Answer Sheet. Note that the worksheet is divided into four sections. You have to decide which section is appropriate for each exercise.
Open the file COMPOUND from the website for this book at cengagebrain.com. To enter the four formulas in the appropriate cells, use the FV and PV functions for the annuities (see Appendix A in Excel Quick for a discussion of them). Unfortunately Excel does not provide functions for the future value of an amount nor the present value of an amount. Enter the following formulas for FORMULA1 and FORMULA2:
FORMULA1: =B6*((1+B8)^B7) FORMULA2: =E6/((1+E8)^AE7)
For the annuity calculations (FV and PV), it is important that you enter a value (or cell reference) for type to indicate the timing of the first payment. If the first payment is made today for an annuity, type must be 0. This is known as an annuity due. If the first payment is made at the end of the first period, type is 1. This is known as an ordinary annuity.
Enter your name in cell A1. Save the completed worksheet as COMPOUND2. When you have completed the exercises below, print your formulas. Do not print the worksheet. Check figures: The answer sheet at the end of this section provides answers to the first exercise
Transcribed Image Text:Home
A2
1
2
34567
Paste
7
8
Excel File Edit View Insert Format Tools Data Window Help
D✓ C
Formulas
V
AutoSave OFF
Insert Draw Page Layout
X
6 Present amount
9 Future value
10
Ready
A
Arial
Number of periods
Interest rate per period
B
17 Future Value
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Future Value of an Amount
I
11
12 Payment per period
13 Number of periods
14 Interest rate per period
15
16
CU
U ✓
Future Value of an Annuity
First payment (enter 0 or 1)
(0=end of period, 1=now)
Worksheet
fx
COMPOUND
B
V
Accessibility: Investigate
12
$500
5
10.0%
$805
FORMULA3
$500
5
10.0%
1
COMPOUND
Time Value of Money
C
dhehehensibl
v
Α Α΄
Αν
Data Review View
D
Present Value of an Amount
Future amount
Number of periods
Interest rate per period
Present value
Present Value of an Annuity
&
Payment per period
Number of periods
Interest rate per period
First payment (enter 0 or 1)
(0=end of period, 1=now)
Present Value
E
$500
5
10.0%
$500
$500
5
10.0%
0
FORMULA4
COMPOUND - unprotected.xlsx - Shared
Tell me
Automate
ab Wrap Text
Merge & Center ✓
F
G
General
MAR
25
H
V
O
%
I
←.0
00
.00
0
J
(CC
Conditional Format
Cell
Formatting as Table Styles
K
tv
L
i
M
A
*
DNN
Insert v
Delete ✓
Format v
N
O
X
Σ*AP* Ou
V
Sort & Find &
Filter Select
B
P
Q
W
Sat Mar 25 9:56 AM
Comments
Analyze
Data
R
Aa
Show
ToolPak
+
Share
S
100%
T
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education