FORMULA LIST Future Value (Single Cash Flow) [FV]: FVn = PV (1 + r)" or PV(1+) or PVeN Present Value (Single Cash Flow) [PV]: FV FV PVn = FV/ (1 + r)" or (1+4) or

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

need excel for solution and formula, u can use shortcut like NPER PMT and etc if applicable

FORMULA LIST
Future Value (Single Cash Flow) [FV]:
FVn = PV (1 + r)" or PV(1+)
or PVeN
Present Value (Single Cash Flow) [PV]:
FV
FV
PVn = FV/(1 + r)" or
or
Future Value (Annuity) [FV]:
FVh= CF(*"-)
Present Value (Annuity) [PV]:
Future Value (Annuity Due) [FV]:
FV, = CF(* -) (1+r)
Present Value (Annuity Due) [PV]:
PV, = CF(*")(1+r)
Present Value of Perpetuity[PV]:
PV = CF/r or CF (1+g) / (r - g)
Annuity Amount [PMT]:
- ((+ r"
CF or PMT = FV / (*" --) or PV/ E)
Interest rate (derivation using lump sum formula) [r]:
r= enn-1
Time Period in years [n]:
In
n =
In (1+r)
Transcribed Image Text:FORMULA LIST Future Value (Single Cash Flow) [FV]: FVn = PV (1 + r)" or PV(1+) or PVeN Present Value (Single Cash Flow) [PV]: FV FV PVn = FV/(1 + r)" or or Future Value (Annuity) [FV]: FVh= CF(*"-) Present Value (Annuity) [PV]: Future Value (Annuity Due) [FV]: FV, = CF(* -) (1+r) Present Value (Annuity Due) [PV]: PV, = CF(*")(1+r) Present Value of Perpetuity[PV]: PV = CF/r or CF (1+g) / (r - g) Annuity Amount [PMT]: - ((+ r" CF or PMT = FV / (*" --) or PV/ E) Interest rate (derivation using lump sum formula) [r]: r= enn-1 Time Period in years [n]: In n = In (1+r)
Problem 1
Given are the following rates:
Z5
10.69%
2F1
9.45%
2F4
9.95%
1F5
9.09%
3F3
10.21%
4F2
4F4
10.56%
10.39%
3F7
8.23%
2F8
8.11%
4F7
8.79%
2F9
9.21%
4F11
10.50%
2F13
9.70%
3F12
10.40%
1F14
9.50%
1F16
9.60%
3F14
10.30%
1F18
6.20%
2F17
8.50%
4F16
10.60%
Compute for the annual forward rates (e.g., 1F1, 1F2, 1F3...) and the twenty-year spot rate (Z20).
Transcribed Image Text:Problem 1 Given are the following rates: Z5 10.69% 2F1 9.45% 2F4 9.95% 1F5 9.09% 3F3 10.21% 4F2 4F4 10.56% 10.39% 3F7 8.23% 2F8 8.11% 4F7 8.79% 2F9 9.21% 4F11 10.50% 2F13 9.70% 3F12 10.40% 1F14 9.50% 1F16 9.60% 3F14 10.30% 1F18 6.20% 2F17 8.50% 4F16 10.60% Compute for the annual forward rates (e.g., 1F1, 1F2, 1F3...) and the twenty-year spot rate (Z20).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY