tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of PCAR

Tables in the 10-Q of PACCAR INC

72 tables with numbers, filed Aug 2, 2023. Each one downloads as a CSV for Excel or Google Sheets, with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed. Open the filing on sec.gov ↗

Table 1 after “INDEX”

Download CSV
Page
PART I.FINANCIAL INFORMATION:
ITEM 1.FINANCIAL STATEMENTS:
Consolidated Statements of Comprehensive Income – Three and Six Months Ended June 30, 2023 and 2022 (Unaudited)3
Consolidated Balance Sheets – June 30, 2023 (Unaudited) and December 31, 20224
Condensed Consolidated Statements of Cash Flows – Six Months Ended June 30, 2023 and 2022 (Unaudited)6
Consolidated Statements of Stockholders’ Equity – Three and Six Months Ended June 30, 2023 and 2022 (Unaudited)7
Notes to Consolidated Financial Statements (Unaudited)8

First 8 of 19 rows. The CSV has all of them.

Table 2 after “(Millions, Except Per Share Amounts)”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
TRUCK, PARTS AND OTHER:
Net sales and revenues$8,441.3$6,786.2$16,491.4$12,892.6
Cost of sales and revenues6,851.75,811.013,344.811,096.5
Research and development101.380.4198.5158.4
Selling, general and administrative144.9144.9304.7292.9

First 8 of 32 rows. The CSV has all of them.

Table 3 after “Balance Sheets (Millions)”

Download CSV
June 30December 31
20232022 *
(Unaudited)
ASSETS
TRUCK, PARTS AND OTHER:
Current Assets
Cash and cash equivalents$4,927.9$4,544.7
Trade and other receivables, net (allowance for losses: 2023 - $.7, 2022 - $.6)2,350.91,919.8

First 8 of 23 rows. The CSV has all of them.

Table 4 after “Consolidated Balance Sheets (Millions)”

Download CSV
June 30December 31
20232022 *
(Unaudited)
LIABILITIES AND STOCKHOLDERS' EQUITY
TRUCK, PARTS AND OTHER:
Current Liabilities
Accounts payable, accrued expenses and other$5,333.5$4,511.7
Dividend payable974.6

First 8 of 27 rows. The CSV has all of them.

Table 5 after “(Millions)”

Download CSV
Six Months Ended
June 30
20232022
OPERATING ACTIVITIES:
Net Income$1,955.0$1,320.9
Adjustments to reconcile net income to cash provided by operations:
Depreciation and amortization:
Property, plant and equipment205.2155.3

First 8 of 42 rows. The CSV has all of them.

Table 6 after “(Millions, Except Per Share Amounts)”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
COMMON STOCK, $1 PAR VALUE:
Balance at beginning of period$522.6$347.7$522.0$347.3
Stock compensation.2.8.4
Balance at end of period522.8347.7522.8347.7
ADDITIONAL PAID-IN CAPITAL:

First 8 of 26 rows. The CSV has all of them.

Table 7 after “The dilutive and antidilutive options are shown separately in the table below.”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Additional shares963,400633,700960,600746,000
Antidilutive options848,5001,649,900911,7001,650,400

Table 8 after “The following table disaggregates Truck, Parts and Other revenues by major sources:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Truck
Truck sales$6,601.3$5,130.2$12,807.3$9,611.3
Revenues from extended warranties, operating leases and other226.2206.2434.0422.2
6,827.55,336.413,241.310,033.5
Parts

First 8 of 13 rows. The CSV has all of them.

Table 9 after “The following table presents the balance sheet classification of the estimated value of the returned goods assets and the related return lia”

Download CSV
June 30, 2023December 31, 2022
ASSETSLIABILITIESASSETSLIABILITIES
Trucks
Other current assets$191.1$183.0
Accounts payable, accrued expenses and other$192.3$185.0
Other noncurrent assets, net234.7284.6
Other liabilities246.7298.9
$425.8$439.0$467.6$483.9

First 8 of 12 rows. The CSV has all of them.

Table 10 after “The following table summarizes Financial Services lease revenues by lease type:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Finance lease revenues$31.8$45.0$86.7$87.9
Operating lease revenues186.7199.7383.5403.3
Total lease revenues$218.5$244.7$470.2$491.2

Table 11 after “June 30, 2023 and December 31, 2022 consisted of the following:”

Download CSV
UNREALIZEDUNREALIZEDFAIR
At June 30, 2023COSTGAINSLOSSESVALUE
Marketable debt securities
U.S. tax-exempt securities$333.2$.1$6.2$327.1
U.S. taxable municipal / non-U.S. provincial bonds230.29.7220.5
U.S. corporate securities309.4.110.4299.1
U.S. government and agency securities150.64.0146.6
Non-U.S. corporate securities500.816.9483.9

First 8 of 12 rows. The CSV has all of them.

Table 12 after “-”

Download CSV
UNREALIZEDUNREALIZEDFAIR
At December 31, 2022COSTGAINSLOSSESVALUE
Marketable debt securities
U.S. tax-exempt securities$452.8$.5$8.2$445.1
U.S. taxable municipal / non-U.S. provincial bonds191.610.8180.8
U.S. corporate securities262.5.111.6251.0
U.S. government and agency securities118.0.13.1115.0
Non-U.S. corporate securities467.917.9450.0

First 8 of 12 rows. The CSV has all of them.

Table 13 after “Marketable debt securities with continuous unrealized losses and their related fair values were as follows:”

Download CSV
June 30, 2023December 31, 2022
LESS THANTWELVE MONTHSLESS THANTWELVE MONTHS
TWELVE MONTHSOR GREATERTWELVE MONTHSOR GREATER
Unrealized losses$14.7$40.1$21.5$37.5
Fair value772.3764.9889.2608.4

Table 14 after “were as follows:”

Download CSV
AMORTIZEDFAIR
COSTVALUE
Within one year$440.9$433.8
One to five years1,287.41,241.6
Six to ten years1.31.3
More than ten years12.510.9
$1,742.1$1,687.6

Table 15 after “Inventories include the following:”

Download CSV
June 30December 31
20232022
Finished products$1,089.5$871.8
Work in process and raw materials1,623.41,327.0
$2,712.9$2,198.8

Table 16 after “Finance and other receivables include the following:”

Download CSV
June 30December 31
20232022
Loans$7,705.8$7,229.1
Finance leases4,293.13,786.4
Dealer wholesale financing3,650.92,772.1
Operating lease receivables and other140.7125.4
15,790.513,913.0
Less allowance for losses:

First 8 of 12 rows. The CSV has all of them.

Table 17 after “The allowance for credit losses is summarized as follows:”

Download CSV
2023
DEALERCUSTOMER
WHOLESALERETAILRETAILOTHER*TOTAL
Balance at January 1$3.4$2.2$112.6$2.9$121.1
Provision for losses.3(.3)8.4(.5)7.9
Charge-offs(9.4)(9.4)
Recoveries3.1.13.2
Currency translation and other.13.0.33.4

First 8 of 9 rows. The CSV has all of them.

Table 18 after “The allowance for credit losses is summarized as follows:”

Download CSV
2022
DEALERCUSTOMER
WHOLESALERETAILRETAILOTHER*TOTAL
Balance at January 1$3.3$7.1$104.4$2.1$116.9
Provision for losses.8(2.5)6.1.24.6
Charge-offs(4.4)(.3)(4.7)
Recoveries3.3.33.6
Currency translation and other(.2)(1.2).6(.8)

First 8 of 9 rows. The CSV has all of them.

Table 19 after “The tables below summarize the amortized cost basis of the Company’s finance receivables within each credit quality indicator by year of ori”

Download CSV
REVOLVING
At June 30, 2023LOANS20232022202120202019PRIORTOTAL
Amortized cost:
Dealer:
Wholesale:
Performing$3,649.4$3,649.4
Watch1.51.5
$3,650.9$3,650.9

First 8 of 25 rows. The CSV has all of them.

Table 20 after “The tables below summarize the amortized cost basis of the Company’s finance receivables within each credit quality indicator by year of ori”

Download CSV
REVOLVING
At June 30, 2023LOANS20232022202120202019PRIORTOTAL
Gross charge-offs:
Customer retail:
Fleet$2.5$2.8$1.5$.2$.4$7.4
Owner/operator.61.0.2.22.0
Total$3.1$3.8$1.7$.2$.6$9.4

Table 21 after “-”

Download CSV
REVOLVING
At December 31, 2022LOANS20222021202020192018PRIORTOTAL
Amortized cost:
Dealer:
Wholesale:
Performing$2,766.0$2,766.0
Watch6.16.1
$2,772.1$2,772.1

First 8 of 26 rows. The CSV has all of them.

Table 22 after “The tables below summarize the Company’s finance receivables by aging category. In determining past due status, the Company considers the en”

Download CSV
DEALERCUSTOMER RETAIL
OWNER/
At June 30, 2023WHOLESALERETAILFLEETOPERATORTOTAL
Current and up to 30 days past due$3,650.0$1,961.8$8,724.2$1,246.5$15,582.5
31 – 60 days past due.915.64.220.7
Greater than 60 days past due42.64.046.6
$3,650.9$1,961.8$8,782.4$1,254.7$15,649.8

Table 23 after “The tables below summarize the Company’s finance receivables by aging category. In determining past due status, the Company considers the en”

Download CSV
DEALERCUSTOMER RETAIL
OWNER/
At December 31, 2022WHOLESALERETAILFLEETOPERATORTOTAL
Current and up to 30 days past due$2,772.1$1,871.9$7,768.5$1,329.1$13,741.6
31 – 60 days past due14.73.117.8
Greater than 60 days past due25.62.628.2
$2,772.1$1,871.9$7,808.8$1,334.8$13,787.6

Table 24 after “The amortized cost basis of finance receivables that are on non-accrual status was as follows:”

Download CSV
DEALERCUSTOMER RETAIL
OWNER/
At June 30, 2023WHOLESALERETAILFLEETOPERATORTOTAL
Amortized cost basis with a specific reserve$33.9$4.3$38.2
Amortized cost basis with no specific reserve21.51.322.8
Total$55.4$5.6$61.0

Table 25 after “The amortized cost basis of finance receivables that are on non-accrual status was as follows:”

Download CSV
DEALERCUSTOMER RETAIL
OWNER/
At December 31, 2022WHOLESALERETAILFLEETOPERATORTOTAL
Amortized cost basis with a specific reserve$33.9$3.6$37.5
Amortized cost basis with no specific reserve$.716.216.9
Total$.7$50.1$3.6$54.4

Table 26 after “Interest income recognized on a cash basis for finance receivables that are on non-accrual status was as follows:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Interest income recognized:
Dealer:
Retail$.1$.1
Customer retail:
Fleet$.2.9$.61.4

First 8 of 10 rows. The CSV has all of them.

Table 27 after “at December 31, 2022 and June 30, 2022, respectively. At modification date, the pre-modification and post-modification amortized cost basis ”

Download CSV
Three Months EndedSix Months Ended
June 30, 2022June 30, 2022
AMORTIZED COST BASISAMORTIZED COST BASIS
PRE- MODIFICATIONPOST- MODIFICATIONPRE- MODIFICATIONPOST- MODIFICATION
Fleet$7.5$7.5$8.1$8.1
$7.5$7.5$8.1$8.1

Table 28 after “Changes in product support liabilities are summarized as follows:”

Download CSV
WARRANTY RESERVES20232022
Balance at January 1$437.7$344.3
Cost accruals360.7159.8
Payments(299.7)(187.8)
Change in estimates for pre-existing warranties132.249.9
Currency translation and other7.1(12.2)
Balance at June 30$638.0$354.0

Table 29 after “Changes in product support liabilities are summarized as follows:”

Download CSV
DEFERRED REVENUES ON EXTENDED WARRANTIES AND R&M CONTRACTS20232022
Balance at January 1$904.9$775.2
Deferred revenues416.8303.6
Revenues recognized(230.4)(239.2)
Currency translation13.2(31.1)
Balance at June 30$1,104.5$808.5

Table 30 after “The components of comprehensive income are as follow:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Net income$1,221.1$720.4$1,955.0$1,320.9
Other comprehensive income (loss) (OCI):
Unrealized (losses) gains on derivative contracts(33.0)1.0(62.5)37.1
Tax effect7.6(1.2)13.9(10.9)
(25.4)(.2)(48.6)26.2

First 8 of 17 rows. The CSV has all of them.

Table 31 after “The components of AOCI and the changes in AOCI, net of tax, included in the Consolidated Balance Sheets and the Consolidated Statements of S”

Download CSV
Three Months Ended June 30, 2023DERIVATIVE CONTRACTSMARKETABLE DEBT SECURITIESPENSION PLANSFOREIGN CURRENCY TRANSLATIONTOTAL
Balance at April 1, 2023$11.9$(33.1)$(110.0)$(742.0)$(873.2)
Recorded into AOCI(66.9)(6.8).4126.553.2
Reclassified out of AOCI41.5(.9)1.642.2
Net other comprehensive (loss) income(25.4)(7.7)2.0126.595.4
Balance at June 30, 2023$(13.5)$(40.8)$(108.0)$(615.5)$(777.8)

Table 32 after “The components of AOCI and the changes in AOCI, net of tax, included in the Consolidated Balance Sheets and the Consolidated Statements of S”

Download CSV
Three Months Ended June 30, 2022DERIVATIVE CONTRACTSMARKETABLE DEBT SECURITIESPENSION PLANSFOREIGN CURRENCY TRANSLATIONTOTAL
Balance at April 1, 2022$12.9$(26.7)$(261.9)$(602.0)$(877.7)
Recorded into AOCI16.4(7.6)7.9(240.8)(224.1)
Reclassified out of AOCI(16.6)(.2)6.9(9.9)
Net other comprehensive (loss) income(.2)(7.8)14.8(240.8)(234.0)
Balance at June 30, 2022$12.7$(34.5)$(247.1)$(842.8)$(1,111.7)

Table 33 after “The components of AOCI and the changes in AOCI, net of tax, included in the Consolidated Balance Sheets and the Consolidated Statements of S”

Download CSV
Six Months Ended June 30, 2023DERIVATIVE CONTRACTSMARKETABLE DEBT SECURITIESPENSION PLANSFOREIGN CURRENCY TRANSLATIONTOTAL
Balance at January 1, 2023$35.1$(43.6)$(110.9)$(834.0)$(953.4)
Recorded into AOCI(113.3)4.5.6218.5110.3
Reclassified out of AOCI64.7(1.7)2.365.3
Net other comprehensive (loss) income(48.6)2.82.9218.5175.6
Balance at June 30, 2023$(13.5)$(40.8)$(108.0)$(615.5)$(777.8)

Table 34 after “-”

Download CSV
Six Months Ended June 30, 2022DERIVATIVE CONTRACTSMARKETABLE DEBT SECURITIESPENSION PLANSFOREIGN CURRENCY TRANSLATIONTOTAL
Balance at January 1, 2022$(13.5)$(1.1)$(269.8)$(636.7)$(921.1)
Recorded into AOCI34.5(33.1)11.4(206.1)(193.3)
Reclassified out of AOCI(8.3)(.3)11.32.7
Net other comprehensive income (loss)26.2(33.4)22.7(206.1)(190.6)
Balance at June 30, 2022$12.7$(34.5)$(247.1)$(842.8)$(1,111.7)

Table 35 after “Reclassifications out of AOCI were as follows:”

Download CSV
Three Months Ended
LINE ITEM IN THE CONSOLIDATED STATEMENTS OFJune 30
AOCI COMPONENTSCOMPREHENSIVE INCOME20232022
Unrealized losses (gains) on derivative contracts:
Truck, Parts and Other
Foreign-exchange contractsNet sales and revenues$11.8$8.2
Cost of sales and revenues11.4(1.0)
Interest and other (income) expense, net.7

First 8 of 27 rows. The CSV has all of them.

Table 36 after “-”

Download CSV
Six Months Ended
LINE ITEM IN THE CONSOLIDATED STATEMENTS OFJune 30
AOCI COMPONENTSCOMPREHENSIVE INCOME20232022
Unrealized losses (gains) on derivative contracts:
Truck, Parts and Other
Foreign-exchange contractsNet sales and revenues$12.0$15.1
Cost of sales and revenues11.42.7
Interest and other (income), net.3

First 8 of 27 rows. The CSV has all of them.

Table 37 after “Included in Other is the Company’s industrial winch manufacturing business as well as sales, income and expenses not attributable to a repor”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Net sales and revenues:
Truck$6,923.0$5,499.5$13,501.7$10,335.0
Less intersegment(95.5)(163.1)(260.4)(301.5)
External customers6,827.55,336.413,241.310,033.5
Parts1,618.41,450.63,259.52,855.9

First 8 of 29 rows. The CSV has all of them.

Table 38 after “The following table presents the balance sheet classification, fair value, gross and pro forma net amounts of derivative financial instrumen”

Download CSV
June 30, 2023December 31, 2022
ASSETSLIABILITIESASSETSLIABILITIES
Derivatives designated under hedge accounting:
Interest-rate contracts:
Financial Services:
Other assets$37.3$58.0
Deferred taxes and other liabilities$131.6$82.6
Foreign-exchange contracts:

First 8 of 40 rows. The CSV has all of them.

Table 39 after “The following table presents the amount of loss (gain) from derivative financial instruments recorded in the Consolidated Statements of Comp”

Download CSV
Three Months EndedSix Months Ended
June 30, 2023June 30, 2023
INTEREST-FOREIGN-INTEREST-FOREIGN-
RATEEXCHANGERATEEXCHANGE
Truck, Parts and Other:
Net sales and revenues
Cash flow hedges$11.8$12.0
Cost of sales and revenues

First 8 of 22 rows. The CSV has all of them.

Table 40 after “The following table presents the amount of loss (gain) from derivative financial instruments recorded in the Consolidated Statements of Comp”

Download CSV
Three Months EndedSix Months Ended
June 30, 2022June 30, 2022
INTEREST-FOREIGN-INTEREST-FOREIGN-
RATEEXCHANGERATEEXCHANGE
Truck, Parts and Other:
Net sales and revenues
Cash flow hedges$8.2$15.1
Cost of sales and revenues

First 8 of 22 rows. The CSV has all of them.

Table 41 after “The following table presents the amounts recorded on the Consolidated Balance Sheets related to cumulative basis adjustments for fair value ”

Download CSV
June 30December 31
20232022
Financial Services
Term notes:
Carrying amount of the hedged liabilities$123.5$319.8
Cumulative basis adjustment included in the carrying amount11.027.7

Table 42 after “The following tables presents the pre-tax effects of gain (loss) on cash flow hedges recognized in other comprehensive income (loss) (OCI):”

Download CSV
Three Months EndedSix Months Ended
June 30, 2023June 30, 2023
INTEREST-FOREIGN-INTEREST-FOREIGN-
RATEEXCHANGECOMMODITYRATEEXCHANGECOMMODITY
(Loss) gain recognized in OCI:
Truck, Parts and Other$(47.1)$(2.0)$(67.2)$1.9
Financial Services$(35.6)2.6$(77.9)1.6
$(35.6)$(44.5)$(2.0)$(77.9)$(65.6)$1.9

First 8 of 16 rows. The CSV has all of them.

Table 43 after “The Company’s assets and liabilities subject to recurring fair value measurements are either Level 1 or Level 2 as follows:”

Download CSV
At June 30, 2023LEVEL 1LEVEL 2TOTAL
Assets:
Marketable debt securities
U.S. tax-exempt securities$327.1$327.1
U.S. taxable municipal / non-U.S. provincial bonds220.5220.5
U.S. corporate securities299.1299.1
U.S. government and agency securities$146.6146.6
Non-U.S. corporate securities483.9483.9

First 8 of 26 rows. The CSV has all of them.

Table 44 after “-”

Download CSV
At December 31, 2022LEVEL 1LEVEL 2TOTAL
Assets:
Marketable debt securities
U.S. tax-exempt securities$445.1$445.1
U.S. taxable municipal / non-U.S. provincial bonds180.8180.8
U.S. corporate securities251.0251.0
U.S. government and agency securities$115.0115.0
Non-U.S. corporate securities450.0450.0

First 8 of 26 rows. The CSV has all of them.

Table 45 after “The Company’s estimate of fair value for fixed rate loans and debt that are not carried at fair value was as follows:”

Download CSV
June 30, 2023December 31, 2022
CARRYINGFAIRCARRYINGFAIR
AMOUNTVALUEAMOUNTVALUE
Assets:
Financial Services fixed rate loans$7,451.1$7,251.6$6,859.1$6,582.0
Liabilities:
Financial Services fixed rate debt8,270.77,936.58,070.57,715.9

Table 46 after “The following information details the components of net pension (income) expense for the Company’s defined benefit plans:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
2023202220232022
Service cost$21.9$43.3$46.9$75.8
Interest on projected benefit obligation32.623.863.742.9
Expected return on assets(57.6)(60.1)(115.1)(108.8)
Amortization of prior service costs.4.2.7.3
Recognized actuarial loss1.79.02.414.6

First 8 of 9 rows. The CSV has all of them.

Table 47 after “The Company’s results of operations for the three and six months ended June 30, 2023 and 2022 are presented below.”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
($ in millions, except per share amounts)2023202220232022
Net sales and revenues:
Truck$6,827.5$5,336.4$13,241.3$10,033.5
Parts1,598.91,434.73,221.92,823.6
Other14.915.128.235.5
Truck, Parts and Other8,441.36,786.216,491.412,892.6

First 8 of 22 rows. The CSV has all of them.

Table 48 after “The Company’s new truck deliveries are summarized below:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
20232022% CHANGE20232022% CHANGE
U.S. and Canada27,50024,4001353,50045,10019
Europe16,40015,400633,80031,5007
Mexico, South America, Australia and other8,0007,1001315,70013,30018
Total units51,90046,90011103,00089,90015

Table 49 after “The Company’s worldwide truck net sales and revenues are summarized below:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
($ in millions)20232022% CHANGE20232022% CHANGE
Truck net sales and revenues:
U.S. and Canada$4,014.2$3,157.027$7,708.2$5,747.634
Europe1,793.41,390.1293,596.92,841.027
Mexico, South America, Australia and other1,019.9789.3291,936.21,444.934
$6,827.5$5,336.428$13,241.3$10,033.532

First 8 of 10 rows. The CSV has all of them.

Table 50 after “The major factors for the Truck segment changes in net sales and revenues, cost of sales and revenues and gross margin between the three mon”

Download CSV
NETCOST OF
SALES ANDSALES ANDGROSS
($ in millions)REVENUESREVENUESMARGIN
Three Months Ended June 30, 2022$5,336.4$4,788.4$548.0
Increase (decrease)
Truck sales volume660.2524.8135.4
Average truck sales prices818.2818.2
Average per truck material, labor and other direct costs344.3(344.3)

First 8 of 13 rows. The CSV has all of them.

Table 51 after “The major factors for the Truck segment changes in net sales and revenues, cost of sales and revenues and gross margin between the six month”

Download CSV
NETCOST OF
SALES ANDSALES ANDGROSS
($ in millions)REVENUESREVENUESMARGIN
Six Months Ended June 30, 2022$10,033.5$9,084.5$949.0
Increase (decrease)
Truck sales volume1,707.51,359.5348.0
Average truck sales prices1,631.01,631.0
Average per truck material, labor and other direct costs613.3(613.3)

First 8 of 13 rows. The CSV has all of them.

Table 52 after “The Company’s Parts segment accounted for 18% and 19% of revenues in the second quarter and first six months of 2023, respectively, compared”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
($ in millions)20232022% CHANGE20232022% CHANGE
Parts net sales and revenues:
U.S. and Canada$1,116.3$1,030.68$2,248.4$2,006.312
Europe332.1273.122676.4569.219
Mexico, South America, Australia and other150.5131.015297.1248.120
$1,598.9$1,434.711$3,221.9$2,823.614

First 8 of 10 rows. The CSV has all of them.

Table 53 after “The major factors for the changes in Parts segment net sales and revenues, cost of sales and revenues and gross margin between the three mon”

Download CSV
NETCOST OF
SALES ANDSALES ANDGROSS
($ in millions)REVENUESREVENUESMARGIN
Three Months Ended June 30, 2022$1,434.7$1,003.7$431.0
(Decrease) increase
Aftermarket parts volume(24.5)(11.1)(13.4)
Average aftermarket parts sales prices189.3189.3
Average aftermarket parts direct costs89.8(89.8)

First 8 of 12 rows. The CSV has all of them.

Table 54 after “The major factors for the changes in Parts segment net sales and revenues, cost of sales and revenues and gross margin between the six month”

Download CSV
NETCOST OF
SALES ANDSALES ANDGROSS
($ in millions)REVENUESREVENUESMARGIN
Six Months Ended June 30, 2022$2,823.6$1,974.0$849.6
Increase (decrease)
Aftermarket parts volume28.318.79.6
Average aftermarket parts sales prices398.8398.8
Average aftermarket parts direct costs190.6(190.6)

First 8 of 12 rows. The CSV has all of them.

Table 55 after “The Company’s Financial Services segment accounted for 5% of revenues in the second quarter and first six months of 2023, compared to 5% in ”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
($ in millions)20232022% CHANGE20232022% CHANGE
New loan and lease volume:
U.S. and Canada$1,021.2$817.225$1,666.9$1,654.01
Europe374.5347.88768.3698.010
Mexico, Australia, Brasil and other534.6333.860907.3631.044
$1,930.3$1,498.829$3,342.5$2,983.012

First 8 of 37 rows. The CSV has all of them.

Table 56 after “The major factors for the changes in interest and fees, interest and other borrowing expenses and finance margin for the three months ended ”

Download CSV
($ in millions)INTEREST AND FEESINTEREST AND OTHER BORROWING EXPENSESFINANCE MARGIN
Three Months Ended June 30, 2022$150.9$46.4$104.5
Increase (decrease)
Average finance receivables37.637.6
Average debt balances14.4(14.4)
Yields47.947.9
Borrowing rates54.3(54.3)
Currency translation and other2.3.41.9

First 8 of 10 rows. The CSV has all of them.

Table 57 after “The major factors for the changes in interest and fees, interest and other borrowing expenses and finance margin for the six months ended Ju”

Download CSV
($ in millions)INTEREST AND FEESINTEREST AND OTHER BORROWING EXPENSESFINANCE MARGIN
Six Months Ended June 30, 2022$283.2$86.2$197.0
Increase (decrease)
Average finance receivables70.470.4
Average debt balances25.3(25.3)
Yields92.792.7
Borrowing rates98.7(98.7)
Currency translation and other.4(.9)1.3

First 8 of 10 rows. The CSV has all of them.

Table 58 after “The following table summarizes operating lease, rental and other revenues and depreciation and other expenses:”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
($ in millions)2023202220232022
Operating lease and rental revenues$190.0$204.5$390.8$413.1
Used truck sales3.712.812.433.4
Insurance, franchise and other revenues7.44.313.19.0
Operating lease, rental and other revenues$201.1$221.6$416.3$455.5
Depreciation of operating lease equipment$117.4$124.0$240.8$236.5

First 8 of 12 rows. The CSV has all of them.

Table 59 after “The major factors for the changes in operating lease, rental and other revenues, depreciation and other expenses and lease margin between th”

Download CSV
($ in millions)OPERATING LEASE, RENTAL AND OTHER REVENUESDEPRECIATION AND OTHER EXPENSESLEASE MARGIN
Three Months Ended June 30, 2022$221.6$145.4$76.2
(Decrease) increase
Used truck sales(9.2)(8.4)(.8)
Results on returned lease assets17.9(17.9)
Average operating lease assets(30.1)(24.3)(5.8)
Revenue and cost per asset11.03.37.7
Currency translation and other7.83.93.9

First 8 of 10 rows. The CSV has all of them.

Table 60 after “The major factors for the changes in operating lease, rental and other revenues, depreciation and other expenses and lease margin between th”

Download CSV
($ in millions)OPERATING LEASE, RENTAL AND OTHER REVENUESDEPRECIATION AND OTHER EXPENSESLEASE MARGIN
Six Months Ended June 30, 2022$455.5$288.9$166.6
(Decrease) increase
Used truck sales(21.0)(19.0)(2.0)
Results on returned lease assets35.8(35.8)
Average operating lease assets(50.3)(41.2)(9.1)
Revenue and cost per asset26.114.211.9
Currency translation and other6.01.44.6

First 8 of 10 rows. The CSV has all of them.

Table 61 after “The following table summarizes the provision for losses on receivables and net charge-offs:”

Download CSV
Three Months EndedSix Months Ended
June 30, 2023June 30, 2023
($ in millions)PROVISION FOR LOSSES ON RECEIVABLESNET CHARGE- OFFSPROVISION FOR LOSSES ON RECEIVABLESNET CHARGE- OFFS
U.S. and Canada$.6$1.1$1.1$1.9
Europe.8.81.01.0
Mexico, Australia, Brasil and other3.42.45.83.3
$4.8$4.3$7.9$6.2

Table 62 after “The following table summarizes the provision for losses on receivables and net charge-offs:”

Download CSV
Three Months EndedSix Months Ended
June 30, 2022June 30, 2022
($ in millions)PROVISION FOR LOSSES ON RECEIVABLESNET CHARGE- OFFSPROVISION FOR LOSSES ON RECEIVABLESNET CHARGE- OFFS
U.S. and Canada$(.4)$(.1)$(2.9)$(.7)
Europe.3.3.3.5
Mexico, Australia, Brasil and other4.5.27.21.3
$4.4$.4$4.6$1.1

Table 63 after “The post-modification balances of accounts modified during the six months ended June 30, 2023 and 2022 are summarized below:”

Download CSV
20232022
($ in millions)AMORTIZED COST BASIS% OF TOTAL PORTFOLIO*AMORTIZED COST BASIS% OF TOTAL PORTFOLIO*
Commercial$87.91.5%$111.22.1%
Insignificant delay50.1.8%41.0.8%
Credit19.0.3%49.11.0%
$157.02.6%$201.33.9%

Table 64 after “The following table summarizes the Company’s 30+ days past due accounts:”

Download CSV
June 30 2023December 31 2022June 30 2022
Percentage of retail loan and lease accounts 30+ days past due:
U.S. and Canada.2%.1%
Europe.4%.2%.5%
Mexico, Australia, Brasil and other1.7%1.6%1.7%
Worldwide.6%.4%.4%

Table 65 after “When the Company modifies a 30+ days past due account, the customer is then generally considered current under the revised contractual terms”

Download CSV
June 30 2023December 31 2022June 30 2022
Pro forma percentage of retail loan and lease accounts 30+ days past due:
U.S. and Canada.2%.1%
Europe.4%.2%.5%
Mexico, Australia, Brasil and other2.2%2.0%2.9%
Worldwide.7%.5%.6%

Table 66 after “second quarter of 2023 was primarily due to a higher mix of pre-tax income in jurisdictions with higher tax rates. The lower effective tax r”

Download CSV
Three Months EndedSix Months Ended
June 30June 30
($ in millions)2023202220232022
Domestic income before taxes$942.2$568.4$1,831.5$1,042.4
Foreign income before taxes626.3353.7656.0651.1
Total income before taxes$1,568.5$922.1$2,487.5$1,693.5
Domestic pre-tax return on revenues19.5%14.3%19.5%14.2%
Foreign pre-tax return on revenues15.5%11.2%8.2%10.4%

First 8 of 9 rows. The CSV has all of them.

Table 67 after “LIQUIDITY AND CAPITAL RESOURCES:”

Download CSV
June 30December 31
($ in millions)20232022
Cash and cash equivalents$5,145.9$4,690.9
Marketable securities1,690.51,614.2
$6,836.4$6,305.1

Table 68 after “The change in cash and cash equivalents is summarized below:”

Download CSV
($ in millions)
Six Months Ended June 30,20232022
Operating activities:
Net income$1,955.0$1,320.9
Net income items not affecting cash342.2229.2
Changes in operating assets and liabilities, net(636.9)(452.6)
Net cash provided by operating activities1,660.31,097.5
Net cash used in investing activities(1,044.7)(879.0)

First 8 of 13 rows. The CSV has all of them.

Table 69 after “Reconciliations from the most directly comparable GAAP measures to adjusted net income (non-GAAP) and adjusted net income per diluted shares”

Download CSV
Six Months Ended
($ in millions, except per share amounts)June 30, 2023
Net income$1,955.0
EC-related claims, net of taxes446.4
Adjusted net income (non-GAAP)$2,401.4
Per diluted share
Net income$3.73
EC-related claims, net of taxes.85

First 8 of 13 rows. The CSV has all of them.

Table 70 after “EXHIBITS”

Download CSV
Exhibit NumberExhibit DescriptionFormDate of First FilingExhibitNumberFile Number
(3) (i)Articles of Incorporation:
Amended and Restated Certificate of Incorporation of PACCAR Inc8-KMay 4, 20183(i)001-14817
Certificate of Amendment of the Amended and Restated Certificate of Incorporation of PACCAR Inc8-KApril 24, 20203(i)001-14817
Certificate of Amendment of the Amended and Restated Certificate of Incorporation of PACCAR Inc8-KApril 29, 20223(i)001-14817
(ii)Bylaws:
Seventh Amended and Restated Bylaws of PACCAR Inc8-KJuly 26, 20223(ii)001-14817
(4)Instruments defining the rights of security holders, including indentures**:

First 8 of 17 rows. The CSV has all of them.

Table 71 after “-”

Download CSV
Exhibit NumberExhibit DescriptionFormDate of First FilingExhibitNumberFile Number
(10)Material Contracts:
(a)PACCAR Inc Amended and Restated Supplemental Retirement Plan10-KFebruary 27, 200910(a)001-14817
(b)Amended and Restated Deferred Compensation Plan10-QMay 10, 201210(b)001-14817
(c)Deferred Incentive Compensation Plan (Amended and Restated as of December 31, 2004)10-KFebruary 27, 200610(b)001-14817
(d)Second Amended and Restated PACCAR Inc Restricted Stock and Deferred Compensation Plan for Non-Employee Directors10-KFebruary 22, 202310(d)001-14817
(e)PACCAR Inc Restricted Stock and Deferred Compensation Plan for Non-Employee Directors, Form of Deferred Restricted Stock Unit Agreement for Non-Employee Directors8-KDecember 10, 200799.3001-14817
(f)Amendment to Compensatory Arrangement with Non-Employee Directors10-KFebruary 26, 201510(g)001-14817

First 8 of 18 rows. The CSV has all of them.

Table 72 after “-”

Download CSV
Exhibit NumberExhibit DescriptionFormDate of First FilingExhibitNumberFile Number
(q)Second Amended and Restated PACCAR Inc Restricted Stock and Deferred Compensation Plan for Non-Employee Directors, Form of Amended Deferred Restricted Stock Unit Grant Agreement10-KFebruary 26, 201510(t)001-14817
(r)Second Amended and Restated PACCAR Inc Restricted Stock and Deferred Compensation Plan for Non-Employee Directors, Form of Amended Restricted Stock Grant Agreement10-KFebruary 26, 201510(u)001-14817
(31)Rule 13a-14(a)/15d-14(a) Certifications:
(a)Certification of Principal Executive Officer*
(b)Certification of Principal Financial Officer*
(32)Section 1350 Certifications:
Certification pursuant to rule 13a-14(b) and section 906 of the Sarbanes-Oxley Act of 2002 (18 U.S.C. section 1350)*

First 8 of 15 rows. The CSV has all of them.