Question

Need Excel Format and screenshot

The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial.

You will submit your spreadsheet through D2L, and I will check your work by changing one of the input values for each formula to see if your spreadsheet calculates the correct answer.

Note that interest rates in Excel are entered in decimal form, not as a percent as with the TI calculator. For example, in Excel 9.5% is entered in a cell as 0.095. Also, the type variable for each formula defines when the cash flows occur. Setting type equal to 0 means the cash flows occur at the end of each period. Setting type equal to 1 means the cash flows occur at the beginning of each period.

	A	B	C
1	Present value
2		Rate	0.11
3		Nper	8
4		PMT	10
5		FV	100
6		Type	0
7		PV	‐94.85
8
9	Number of periods
10		Rate	0.11
11		PMT	10
12		PV	‐94.85
13		FV	100
14		Type	0
15		Nper	8.01
16
17	Payment
18		Rate	0.11
19		Nper	8
20		PV	‐94.85
21		FV	100
22		Type	0
23		PMT	10.00
24
25	Interest rate
26		Nper	8
27		PMT	10
28		PV	‐94.85
29		FV	100
30		Type	0
31		Rate	0.11
32
33	Future value
34		Rate	0.11
35		Nper	8
36		PMT	10
37		PV	‐94.85
38		Type	0
39		FV	99.99
40
41	Net present value
42		Rate	0.11
43		Value 1	100
44		Value 2	200
45		Value 3	300
46		Value 4	400
47		Value 5	500
48		NPV	1031.99

Answer 1

Present value:

--------------------------------------------------------------------------

Number of periods:

-------------------------------------------------------------------------------

Payment:

---------------------------------------------------------------

Interest Rate:

--------------------------------------------

Future value:

-------------------------------------------------------------------------------------

NPV: