Filetype Excel XLS | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
241x Filetype XLS File size 0.07 MB Source: www.publications.qld.gov.au
FINANCIAL LEASE CALCULATOR
Developed by Alan Jamieson (Rockhampton)
Calculates
- Effective interest rate for a lease agreement (5 year maximum term)
- Interest, principal payment schedule and outstanding principal
Note:
- Taxation effect as well as effective interest rate need to be considered to assess the suitability of a lease
Principal $23,000 Effective interest rate
Residual $10,000
Term (years) - 5 year max 3 Rate per period
Payments per year 12
Payment $514
Date of first payment: 1/1/2007
Payment Date Payment Interest Principal
0
1 Jan-07 $514 $0 $514
2 Jan-07 $514 #VALUE! #VALUE!
3 Mar-07 $514 #VALUE! #VALUE!
4 Apr-07 $514 #VALUE! #VALUE!
5 May-07 $514 #VALUE! #VALUE!
6 Jun-07 $514 #VALUE! #VALUE!
7 Jul-07 $514 #VALUE! #VALUE!
8 Aug-07 $514 #VALUE! #VALUE!
9 Sep-07 $514 #VALUE! #VALUE!
10 Oct-07 $514 #VALUE! #VALUE!
11 Nov-07 $514 #VALUE! #VALUE!
12 Dec-07 $514 #VALUE! #VALUE!
13 Jan-08 $514 #VALUE! #VALUE!
14 Jan-08 $514 #VALUE! #VALUE!
15 Mar-08 $514 #VALUE! #VALUE!
16 Apr-08 $514 #VALUE! #VALUE!
17 May-08 $514 #VALUE! #VALUE!
18 Jun-08 $514 #VALUE! #VALUE!
19 Jul-08 $514 #VALUE! #VALUE!
20 Aug-08 $514 #VALUE! #VALUE!
21 Aug-08 $514 #VALUE! #VALUE!
22 Oct-08 $514 #VALUE! #VALUE!
23 Oct-08 $514 #VALUE! #VALUE!
24 Dec-08 $514 #VALUE! #VALUE!
25 Dec-08 $514 #VALUE! #VALUE!
26 Jan-09 $514 #VALUE! #VALUE!
27 Mar-09 $514 #VALUE! #VALUE!
28 Apr-09 $514 #VALUE! #VALUE!
29 May-09 $514 #VALUE! #VALUE!
30 Jun-09 $514 #VALUE! #VALUE!
31 Jul-09 $514 #VALUE! #VALUE!
32 Aug-09 $514 #VALUE! #VALUE!
33 Sep-09 $514 #VALUE! #VALUE!
34 Oct-09 $514 #VALUE! #VALUE!
35 Oct-09 $514 #VALUE! #VALUE!
36 Dec-09 $514 #VALUE! #VALUE!
37 Dec-09 $10,000 #VALUE! #VALUE!
38 #VALUE! #VALUE!
39 #VALUE! #VALUE!
40 #VALUE! #VALUE!
41 #VALUE! #VALUE!
42 #VALUE! #VALUE!
43 #VALUE! #VALUE!
44 #VALUE! #VALUE!
45 #VALUE! #VALUE!
46 #VALUE! #VALUE!
47 #VALUE! #VALUE!
48 #VALUE! #VALUE!
49 #VALUE! #VALUE!
50 #VALUE! #VALUE!
51 #VALUE! #VALUE!
52 #VALUE! #VALUE!
53 #VALUE! #VALUE!
54 #VALUE! #VALUE!
55 #VALUE! #VALUE!
56 #VALUE! #VALUE!
57 #VALUE! #VALUE!
58 #VALUE! #VALUE!
59 #VALUE! #VALUE!
60 #VALUE! #VALUE!
61 #VALUE! #VALUE!
The data provided here is an
example only and should be
revised to reflect your
particular situation.
- Taxation effect as well as effective interest rate need to be considered to assess the suitability of a lease
Effective interest rate Err:520
Rate per period #VALUE!
Cumulative Cumulative Outstanding
Interest Principal Principal Cashflow
$23,000 $0
$0 $514 $22,486 $22,486
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$514
#VALUE! #VALUE! #VALUE! -$10,000
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
no reviews yet
Please Login to review.
