Enclosure No. 2K - Appendix TBD Sample Lease Payment Schedule.xlsx

XLSX spreadsheet 37 KB Posted

Attached to
Request for Proposal: ALCF Equinox AI System Federal contract opportunity
Solicitation number
6-B143-P-00251-00
Issued by
Department of Energy Office of Science

About this file

Written by GovTribe AI ·

This file is a sample lease payment schedule template in spreadsheet format provided as an appendix to the Request for Proposal for the ALCF Equinox AI System. The document does not specify required products or services, pricing terms, response dates, or award dates; rather, it serves as a reference template for offerors to understand the payment structure format that may be applicable to their proposals. The template is designed to assist bidders in structuring lease payment schedules should their proposed solution involve equipment leasing as part of the overall acquisition strategy for the artificial intelligence computing system being procured by Argonne National Laboratory under the Department of Energy Office of Science.

View the file

Other files for this federal contract opportunity

Other files attached to Request for Proposal: ALCF Equinox AI System, newest first.
File Type Posted
Addendum No. 2 to RFP #6-B143-P-00251-00.pdf PDF
Addendum No. 1 to RFP #6-B143-P-00251-00.pdf PDF
Enclosure No. 2C - Statement of Work.pdf PDF
Enclosure No. 2H - Appendix TBD ANL-830-LTOV.pdf PDF
Enclosure No. 4 - Evaluation Criteria.pdf PDF
Enclosure No. 2A - Draft Purchase Order.pdf PDF
Enclosure No. 2E - Appendix E ANL-366M.pdf PDF
Enclosure No. 2F - Appendix E.1 ANL-366TCSB.pdf PDF
Enclosure No. 2G - Appendix TBD ANL-829-MLAV.pdf PDF
Enclosure No. 5 - ANL-70B.pdf PDF
Enclosure No. 6 - Tax Exemption Certificate.pdf PDF
Enclosure No. 1 - RFP Cover Letter, Instructions, & Notices.pdf PDF
Enclosure No. 2D - Appendix D8C.pdf PDF
Enclosure No. 2J - Appendix TBD ANL-827-LTONV.pdf PDF
Enclosure No. 3A - Pricing Proposal Form.pdf PDF
Enclosure No. 2B - Appendix A ANL-71COM.pdf PDF
Enclosure No. 2I - Appendix TBD ANL-826-MLANV.pdf PDF
Enclosure No. 7 - SaaS Questionnaire.xlsx XLSX spreadsheet
Show all 18

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Lease Assumptions

ALCF Lease Assumptions Spreadsheet
Enter values below…
Origination Fee:$ - 0Fees:$ - 0
Lease Rate:4.00%Interest Costs:$ 83,795
Principal:$ 1,000,001Total Cost:$ 1,083,796
Progress Payment:$ - 0Total Cost = Principal + Interest + Fees
Down Payment:$ 1
Financed Amount:$ 1,000,000formula
Lease Term:48
Lease Start:2/1/27
Formula
Data Entry
Hardware900,001.00
Software100,000.00

Amortization Schedule

Sample Lease Amortization Schedule - Based on assumptions on the "Lease Assumptions" tab
Payment #Payment DateFiscal YearPaymentInterestPrincipalBalance
Progress Payment- 0
Origination FeeFeb-27- 0- 01,000,000.00
Down PaymentFeb-271.001,000,000.001,000,000.00
1Mar-27FY27$22,579.053,333.33$19,245.72980,754.28
2Apr-27FY2722,579.053,269.1819,309.87961,444.40
3May-27FY2722,579.053,204.8119,374.24942,070.17
4Jun-27FY2722,579.053,140.2319,438.82922,631.34
5Jul-27FY2722,579.053,075.4419,503.62903,127.73
6Aug-27FY2722,579.053,010.4319,568.63883,559.10
7Sep-27FY2722,579.052,945.2019,633.86863,925.24
8Oct-27FY2822,579.052,879.7519,699.30844,225.94
9Nov-27FY2822,579.052,814.0919,764.97824,460.97
10Dec-27FY2822,579.052,748.2019,830.85804,630.12
11Jan-28FY2822,579.052,682.1019,896.95784,733.16
12Feb-28FY2822,579.052,615.7819,963.28764,769.89
13Mar-28FY2822,579.052,549.2320,029.82744,740.06
14Apr-28FY2822,579.052,482.4720,096.59724,643.48
15May-28FY2822,579.052,415.4820,163.58704,479.90
16Jun-28FY2822,579.052,348.2720,230.79684,249.11
17Jul-28FY2822,579.052,280.8320,298.22663,950.89
18Aug-28FY2822,579.052,213.1720,365.89643,585.00
19Sep-28FY2822,579.052,145.2820,433.77623,151.23
20Oct-28FY2922,579.052,077.1720,501.88602,649.35
21Nov-28FY2922,579.052,008.8320,570.22582,079.12
22Dec-28FY2922,579.051,940.2620,638.79561,440.33
23Jan-29FY2922,579.051,871.4720,707.59540,732.75
24Feb-29FY2922,579.051,802.4420,776.61519,956.13
25Mar-29FY2922,579.051,733.1920,845.87499,110.27
26Apr-29FY2922,579.051,663.7020,915.35478,194.91
27May-29FY2922,579.051,593.9820,985.07457,209.84
28Jun-29FY2922,579.051,524.0321,055.02436,154.82
29Jul-29FY2922,579.051,453.8521,125.21415,029.61
30Aug-29FY2922,579.051,383.4321,195.62393,833.99
31Sep-29FY2922,579.051,312.7821,266.27372,567.72
32Oct-29FY3022,579.051,241.8921,337.16351,230.55
33Nov-29FY3022,579.051,170.7721,408.29329,822.27
34Dec-29FY3022,579.051,099.4121,479.65308,342.62
35Jan-30FY3022,579.051,027.8121,551.25286,791.38
36Feb-30FY3022,579.05955.9721,623.08265,168.29
37Mar-30FY3022,579.05883.8921,695.16243,473.13
38Apr-30FY3022,579.05811.5821,767.48221,705.65
39May-30FY3022,579.05739.0221,840.04199,865.62
40Jun-30FY3022,579.05666.2221,912.84177,952.78
41Jul-30FY3022,579.05593.1821,985.88155,966.90
42Aug-30FY3022,579.05519.8922,059.16133,907.74
43Sep-30FY3022,579.05446.3622,132.70111,775.04
44Oct-30FY3122,579.05372.5822,206.4789,568.57
45Nov-30FY3122,579.05298.5622,280.4967,288.08
46Dec-30FY3122,579.05224.2922,354.7644,933.32
47Jan-31FY3122,579.05149.7822,429.2822,504.04
48Feb-31FY3122,579.0575.0122,504.040.00
49Mar-31FY31- 00.00(0.00)0.00
50Apr-31FY31- 00.00(0.00)0.00
51May-31FY31- 00.00(0.00)0.00
1,083,795.6283,794.62$1,000,000.00

Lookup

1/1/26
2/1/26
3/1/26
4/1/26
5/1/26
6/1/26
7/1/26
8/1/26
9/1/26
10/1/26
11/1/26
12/1/26
1/1/27
2/1/27
3/1/27
4/1/27
5/1/27
6/1/27
7/1/27
8/1/27
9/1/27
10/1/27
11/1/27
12/1/27
1/1/28
2/1/28
3/1/28
4/1/28
5/1/28
6/1/28
7/1/28
8/1/28
9/1/28
10/1/28
11/1/28
12/1/28
1/1/29
2/1/29
3/1/29
4/1/29
5/1/29
6/1/29
7/1/29
8/1/29
9/1/29
10/1/29
11/1/29
12/1/29
1/1/30
2/1/30
3/1/30
4/1/30
5/1/30
6/1/30
7/1/30
8/1/30
9/1/30
10/1/30
11/1/30
12/1/30
1/1/31
2/1/31
3/1/31
4/1/31
5/1/31
6/1/31
7/1/31
8/1/31
9/1/31
10/1/31
11/1/31
12/1/31
1/1/32
2/1/32
3/1/32
4/1/32
5/1/32
6/1/32
7/1/32
8/1/32
9/1/32
10/1/32
11/1/32
12/1/32
1/1/33
2/1/33

FY Lookup

Fiscal MonthFiscal Year
1/1/26FY26
2/1/26FY26
3/1/26FY26
4/1/26FY26
5/1/26FY26
6/1/26FY26
7/1/26FY26
8/1/26FY26
9/1/26FY26
10/1/26FY27
11/1/26FY27
12/1/26FY27
1/1/27FY27
2/1/27FY27
3/1/27FY27
4/1/27FY27
5/1/27FY27
6/1/27FY27
7/1/27FY27
8/1/27FY27
9/1/27FY27
10/1/27FY28
11/1/27FY28
12/1/27FY28
1/1/28FY28
2/1/28FY28
3/1/28FY28
4/1/28FY28
5/1/28FY28
6/1/28FY28
7/1/28FY28
8/1/28FY28
9/1/28FY28
10/1/28FY29
11/1/28FY29
12/1/28FY29
1/1/29FY29
2/1/29FY29
3/1/29FY29
4/1/29FY29
5/1/29FY29
6/1/29FY29
7/1/29FY29
8/1/29FY29
9/1/29FY29
10/1/29FY30
11/1/29FY30
12/1/29FY30
1/1/30FY30
2/1/30FY30
3/1/30FY30
4/1/30FY30
5/1/30FY30
6/1/30FY30
7/1/30FY30
8/1/30FY30
9/1/30FY30
10/1/30FY31
11/1/30FY31
12/1/30FY31
1/1/31FY31
2/1/31FY31
3/1/31FY31
4/1/31FY31
5/1/31FY31
6/1/31FY31
7/1/31FY31
8/1/31FY31
9/1/31FY31
10/1/31FY31
11/1/31FY31
12/1/31FY31
1/1/32
2/1/32
3/1/32
4/1/32
5/1/32
6/1/32
7/1/32
8/1/32
9/1/32
10/1/32
11/1/32
12/1/32
1/1/33
2/1/33
48576
48607
48638
48666
48697
48727
48758
48788
48819
48850
48880
48911
48941
48972
49003
49031
49062
49092
49123
49153
49184
49215
49245
49276
49306
49337
49368
49396
49427
49457
49488
49518
49549
49580
49610
49641
49671
49702
49733
49762
49793
49823
49854
49884
49915
49946
49976
50007
50037
50068
50099
50127
50158
50188
50219
50249

File details come from the government source that posted it. Updated .