Solve the attached problems using Excel, but  you will also see problems that can be solved without. 1Homework 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

Section AInput Data

Section A Input Data EduCredit is the education loan division of a bank. It is considering a batch of applications for student loans repayable in one year. EduCredit charges each loan applicants an annual interest rate that depends on the band of their credit scores (A is the highest) Loan

Homework  Channels and MetricsNote:  At the start of your DQ post,

Homework  Channels and Metrics Note:  At the start of your DQ post, remind us of the company and product/service you have chosen for your marketing campaign. Choose one social media channel and one traditional channel that you plan to use in your marketing campaign. For each channel, answer the following

BUSI46S15Competitive Strategies & Organisational Fitness

BUSI46S15 Competitive Strategies & Organisational Fitness Postgraduate Programmes 2023/24 SUMMATIVE ASSIGNMENT – BUSI46S15 Competitive Strategies and Organizational Fitness Select an organization, identify its competitive environment (that is, the population it is a member of) [5 marks] Analyse (qualitatively) the ecological and institutional conditions in the population. [10 marks] Provide a