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

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

KRYSTEL BERGHER PROFILE Accomplished Customer Service Expert committed to the delivery of quality service. Professional and Ethical.

KRYSTEL BERGHER PROFILE Accomplished Customer Service Expert committed to the delivery of quality service. Professional and Ethical. Seeking to assist or help a new customer service department in creating and achieving the much-needed customer service goals. CONTACT ADDRESS: 15851 Southwest 139th Place, Miami FL 33177. PHONE: 305-992-6010 EMAIL: [email protected] om

Business Law BUS 3301 VII Question 12 The principal agent relationship, the employer-employee relationship, and the employer-independent contractor

Business Law BUS 3301 VII Question 12 The principal agent relationship, the employer-employee relationship, and the employer-independent contractor relationship are three types of agency relationships commonly found in business settings. Why is it important for business professionals to know what type of agency relationship they are forming?   Your response must

pfa TASK 1: By Tuesday Evening Reflection and Discussion Forum Week 3

pfa TASK 1: By Tuesday Evening Reflection and Discussion Forum Week 3 Assigned Readings: Chapter 8. Understanding Markets and Industry Changes. Chapter 9. Market Structure and Long-Run Equilibrium. Chapter 10. Strategy: The Quest to Keep Profit from Eroding. Initial Postings: Read and reflect on the assigned readings for the week.