50.1K

Verified Solution

Link Copied!

Need Excel Format and screenshot

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

You will submit your spreadsheet through D2L, and I will checkyour work by changing one of the input values for each formula tosee 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 Excel9.5% is entered in a cell as 0.095. Also, the type variable foreach formula defines when the cash flows occur. Setting type equalto 0 means the cash flows occur at the end of each period. Settingtype equal to 1 means the cash flows occur at the beginning of eachperiod.

	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