Solve the attached problems using Excel, but  you will also see problems that can be solved without. 

1

Homework 1

1. a. Use Data Table to graph the function f(x) = 3×2 – 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

Leave a Reply

Your email address will not be published. Required fields are marked *