; Excel Finance
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Excel Finance

VIEWS: 0 PAGES: 5

  • pg 1
									                A                B          C                   D                     E            F        G                H
1    Future Value of a Deposit and Present Value of a Future Sum
2
3
4    Interest Rate          Rate          5.00%
5    Number of years        Years             12
6
7    Future Value                                                             Present Value
8
9    Initial Deposit        Deposit    £ 10.00                                Future Sum       Future   £   9.00
10
11   Future Value=                                 <=Deposit*(1+Rate)^Years   Present Value=                       <=Future/(1+Rate)^Years
             A                   B           C         D         E       F         G         H            I       J   K   L   M   N
1    Investment Appraisal
2
3    Net Present Value
4    NPV             Project A                    Project B
5                                                                                        A                    B
6    Year                 Undiscounted            Undiscounted       NPV Function
7                     0            -1000                 -700
8                     1              500                  400
9                     2              700                  800
10                    3              500                    0
11
12   Interest Rate
13
14   Year                 Discounted              Discounted
15                    0
16                    1
17                    2
18                    3
19
20   NPVs:
21
22
23   Using the IRR Function:
24                        Project A               Project B
25   IRR=
26
27   Verifying this result numerically:                              Verifying this result graphically:
28   Step                       4.00%
29   Start                            0
30
31                                         NPVs
32   Interest Rates       Project A               Project B
33
34
35
36
37
38
39
40
41
42
43
44
Linear Programming

            Quantity              Profit per Unit   Total Profit
Bus                                       1.2
Car                                       0.9

Inputs per Vehicle:
            Buses     Cars
Labour              4         2
Material            1         1
Other               0         3

Inputs Used:                                        Total
           Buses       Cars       Total             Available
Labour                                                     32
Material                                                   10
Other                                                      21
Using VLookUp

TABLE
Item Code    Description   Price
       501   CD             £    12.00
       502   Record         £     4.00
       503   Tape (pack)    £     5.00
       504   Poster         £     3.00
       505   Calender       £     6.00


INVOICE
Item Code    Quantity      Value
       A          B         C     D
 1 Using VLookUp
 2
 3
 4
 5 Income    Tax Rate
 6         0           0
 7      8000        0.15
 8     14000        0.25
 9     25000        0.38
10
11
12           Enter Income Level
13           Tax Rate Paid
14           Net Income

								
To top
;