Business Finance - Accounting Homework 1 - Portfolio Management
lisagonzalez23Solve the attached problems using Excel, but you will also see problems that can be solved without.
2 years ago
50
files (1)HW1.pdf
HW1.pdf
1
Homework 1 1. a. Use Data Table to graph the function f(x) = 3x2 - 2x - 15,
b. Use Solver or Goal Seek to find two values of x for which f(x) = 0. 2. The Excel function PV(rate, number_periods, payment) calculates the present value of a
constant payment. For example, PV(15%,15,-1O) = 58.47. (Note that we have put the payment as a negative number; otherwise, Excel returns a negative value!). Use Data Table to graph the present value as a function of the discount rate. Use the rate as 15%, number of periods as 15 and payment as 10.
3. Consider a project that costs $500 today and that has cash flows in years 1-5 of: $100, $100 * (1 + g), $100 * (1 + g)2, $100 * (1 + g)3 and $100 * (1 + g)4. Use Data
Table to do a sensitivity analysis on the NPV of the project, varying the discount rate along 0%, 3%, 6%, 9%, … 21% and varying the growth rate along 0%, 3%, 6%, 9% and 12%.
4. Using Data Table, graph the function Sin(x *y) for x = 0, 0.2, 0.4, . . . 1.8, 2 and y = 0,
0.2, 0.4, ..., 1.8, 2. Use the “Surface” graph option to make a three-dimensional graph of the function.
5. Use Excel to perform the following matrix operations:
a.
−+
− 371 2308 211
901 784 6122
b.
−
−
2 1
3 1
2 3
6 0 9
6 5 2
c.
−
− 371 208
211
901 784 602
6. Find the inverses of the following matrices:
a.
− 6125 7244 0352 9821
2
b.
−
347 316 123
c.
−−
− −
33923 94023 22101 33220
7. Solve the equations AX = Y, where
A =
−− −− −−
1113 1108 3813
, Y =
− 0 5
20 , X =
3
2
1
x x x
