Accounting-Finance-accounting-homework-help
Accounting-Finance-accounting-homework-help
Please complete In Excel
1. Perpetuity
If an investment policy pays you $25,000 per year forever and you require 6% p.a. return on this investment, how much will you pay for this policy? What about a policy that pays $30,000 per year?
2. EAR
Calculate the EAR in the following cases:
|
APR |
compounding |
EAR |
|
10% |
Quarterly |
|
|
17% |
Monthly |
|
|
13% |
Daily |
|
|
9% |
Semi-annually |
Hint: Use the EFFECT function in Excel.
3. APR
Find the APR for each of the following cases:
|
APR |
compounding |
EAR |
|
Semi-annually |
14.00% |
|
|
Monthly |
9.00% |
|
|
Weekly |
8.00% |
|
|
Daily |
13.00% |
Hint: Use the NOMINAL function in Excel.
4. Present Values
Calculate the present values for the two following cash flows:
|
Discount Rate |
Discount Rate |
||
|
7.30% |
9.20% |
||
|
Year |
Cash Flow from A |
Cash Flow from B |
|
|
1 |
$1,200 |
$1,400 |
|
|
2 |
1,100 |
1,900 |
|
|
3 |
800 |
3400 |
|
|
4 |
600 |
4300 |
5. Annuity and Perpetuity
You are going to receive a 30-year annuity of $105,000. Your friend, Nancy, is going to receive a perpetuity of $105,000. If the appropriate interest rate is 7% p.a., how much more is Nancy’s cash flow worth than yours?
6. Comparing Cash Flows
You’ve just joined a new firm. They offered you two different salary arrangements:
A. $6,100 per month for the next two years.
B. $4,800 per month for the next two years, plus a $25,000 signing bonus.
If the interest rate is 7% p.a., which arrangement do you prefer?
7. Future Values
Assuming an interest rate of 6.9% p.a., what is the future value of the following cash flows five years from now? What is the future value 10 years from now?
|
Year to find value |
10 |
|
Interest rate |
6.9% |
|
Year |
Cash flow |
|
2 |
$ 15,000 |
|
3 |
24,000 |
|
5 |
33,000 |
8. Future Values
An insurance company is offering a new policy. The parent makes the following six payments to the insurance company, and no more payments after child’s sixth birthday. When the child reaches age 65, he/she receives $350,000. If the interest rate is 10% for the first 6 years, and 7% for all subsequent years, is the policy worth buying?
|
Year |
Payment |
|
1 |
$ 800 |
|
2 |
$ 800 |
|
3 |
$ 900 |
|
4 |
$ 900 |
|
5 |
$ 1,000 |
|
6 |
$ 1,000 |
|
# of years until retirement |
65 |
|
Payout at retirement |
$ 350,000 |
|
Interest rate 1 |
10% |
|
# of years |
6 |
|
Interest rate 2 |
7% |
|
# of years |
59 |
