Assume
that you are nearing graduation and that you have applied for a job with a
local bank. As part of the bank's evaluation process, you have been asked to
take an examination which covers several financial analysis techniques.
PLEASE
SHOW CALCULATIONS IN EXCEL
Assume
that you are nearing graduation and that you have applied for a job with a
local bank. As part of the bank's evaluation process, you have been asked to
take an examination which covers several financial analysis techniques.
The
first section of the test addresses discounted cash flow analysis. See how you
would do by answering the following questions.
1
What is the future value of an initial $100 after 3 years if it is invested in
an account paying 10 percent annual interest?
2
What is the present value of $100 to be received in 3 years if the appropriate
interest rate is 10 percent?
3
We sometimes need to find how long it will take a sum of money (or anything
else) to grow to some specified amount. For example, if a company's sales are
growing at a rate of 6 percent per year, how long will it take sales to double?
4
If you want an investment to double in six years, what interest rate must it
earn?
5
What is the future value of a 3-year ordinary annuity of $100 if the
appropriate interest rate is 10 percent?
6
What is the present value of the annuity?
7
What would the future and present values be if the annuity were an annuity due?
8
What is the present value of the following uneven cash flow stream? The
appropriate interest rate is 10 percent, compounded annually.
YEARS
0 1 2 3 4
Cash
Flow 0 100 200 -200 100
9
What is the future value of $100 after 3 years under
a.
10 percent annual compounding?
b.
10 percent semiannual compounding?
c.
10 percent quarterly compounding?
d.
10 percent monthly compounding?
e.
10 percent daily compounding?
10
What is the EAR for a nominal rate of 12 percent
a
compounded semiannually
b
compounded quarterly
c
compounded monthly
d
compounded daily
SOLUTION
PREVIEW
|
Answer
|
|
|
Rate =
|
10%
|
|
Nper =
|
3
|
|
PV =
|
-100
|
File
name: 10-fin-questions.xls
File type: XLS PRICE: $20
