Income Statement
gdsyzxlyg
LftTrkAttachCaseHistFinw-oansforfcstRev1-31-1711.xlsInc. Stmt.
| Lift Truck Attachments, Inc, | ||||||||||
| Historical Income Statements | 1/31/17 | |||||||||
| $ in 000's | ||||||||||
| For Years Ending 10/31 | Fill in the Blanks | |||||||||
| Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | ||||
| Description | Year Ending | Year Ending | Year Ending | 6 Mo. Ended | 6 Mo. Ended | Year Ending | Year Ending | |||
| 10/31/13 | 10/31/14 | 10/31/15 | 4/30/16 | 10/31/16 | 10/31/16 | 10/31/17 | ||||
| Net Sales | $2,100.2 | $2,723.2 | $2,841.4 | $1,343.6 | ||||||
| Cost of Sales | $1,468.8 | $1,807.6 | $1,839.0 | $832.8 | ||||||
| Gross Profit | $631.4 | $915.6 | $1,002.4 | $510.8 | ||||||
| Expenses: | ||||||||||
| Selling Expenses | $126.7 | $177.5 | $172.1 | $59.7 | ||||||
| Admin. Expenses | $374.7 | $504.5 | $445.2 | $219.0 | ||||||
| Depreciation | $9.0 | $8.1 | $20.6 | $7.2 | ||||||
| Total Expenses | $510.4 | $690.1 | $637.9 | $285.9 | ||||||
| Operating profits | $121.0 | $225.5 | $364.5 | $224.9 | ||||||
| Other Expenses (Income) | $18.7 | $20.6 | $24.2 | -$3.1 | ||||||
| Profit Before Income Tax | $102.3 | $204.9 | $340.3 | $228.0 | ||||||
| Income Tax | $10.3 | $19.5 | $14.6 | $5.9 | ||||||
| Profit After Income Tax* | $92.0 | $185.4 | $325.7 | $222.1 | ||||||
| *Prior to Profit Sharing Bonuses of: | $57.9 | $125.4 | $260.0 | $0.0 | ||||||
| Profit After Tax & Bonus | $34.1 | $60.0 | $65.7 | $222.1 | ||||||
| Rev. 1-31-17 |
Bal. Sheet
| Lift Truck Attachments, Inc, | ||||||||
| Balance Sheets | ||||||||
| $ in 000's | ||||||||
| For Years Ending 10/31 | Fill in the Blanks | |||||||
| Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | ||
| Description | 10/31/12 | 10/31/13 | 10/31/14 | 10/31/15 | 04/30/16 | 10/31/16 | 10/31/17 | |
| Assets | ||||||||
| Current Assets | ||||||||
| Cash | $26.3 | $79.7 | $159.6 | $119.0 | $113.7 | |||
| Accts. Receivable | $200.4 | $231.5 | $253.3 | $313.8 | $344.1 | |||
| Inventory | $240.1 | $222.6 | $280.2 | $272.4 | $323.8 | |||
| Prepaid Expense | $25.1 | $34.8 | $46.9 | $44.5 | $66.7 | |||
| Total Current Assets | $491.9 | $568.6 | $740.0 | $749.7 | $848.3 | |||
| Fixed Assets at Cost | $128.2 | $138.8 | $177.1 | $203.1 | $209.5 | |||
| Accumulated Depreciation | $96.2 | $105.2 | $113.3 | $133.9 | $141.1 | |||
| Net Fixed Assets | $32.0 | $33.6 | $63.8 | $69.2 | $68.4 | |||
| Total Assets | $523.9 | $602.2 | $803.8 | $818.9 | $916.7 | |||
| Liabilities & Equity | ||||||||
| Current Liabilities | ||||||||
| Current Portion Long Term Debt | $31.5 | $31.1 | $39.9 | $39.8 | $46.9 | |||
| Accts. Payable | $130.2 | $157.5 | $181.3 | $128.8 | $121.2 | |||
| Accrued Expenses | $73.4 | $93.9 | $112.5 | $156.5 | $9.8 | |||
| Total Current Liabilities | $235.1 | $282.5 | $333.7 | $325.1 | $177.9 | |||
| Long Term Debt (Net of Current Portion) | $135.6 | $132.4 | $222.8 | $180.8 | $203.7 | |||
| Total Liabilities | $370.7 | $414.9 | $556.5 | $505.9 | $381.6 | |||
| Equity | ||||||||
| Common Stock | $9.8 | $9.8 | $9.8 | $9.8 | $9.8 | |||
| Retained Earnings | 143.4 | 177.5 | 237.5 | 303.2 | 525.3 | |||
| Total Equity | $153.2 | $187.3 | $247.3 | $313.0 | $535.1 | |||
| Total Liabilities & Equity | $523.9 | $602.2 | $803.8 | $818.9 | $916.7 | |||
| Rev. 1-31-17 |
Cash Flow
| Lift Truck Attachments, Inc, | ||||||||
| Historical Statements of Cash Flow | ||||||||
| $ in 000's | ||||||||
| For Years Ending 10/31 | Fill in the Blanks | |||||||
| Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | ||
| Description | Year Ending | Year Ending | Year Ending | 6 Mo. Ended | 6 Mo. Ended | Year Ending | Year Ending | |
| 10/31/13 | 10/31/14 | 10/31/15 | 4/30/16 | 10/31/16 | 10/31/16 | 10/31/17 | ||
| Profit After Tax & Bonus | $34.1 | $60.0 | $65.7 | $222.1 | ||||
| Add Back Depreciation | $9.0 | $8.1 | $20.6 | $7.2 | ||||
| Capital Expenditures - Additions | ||||||||
| to Fixed Assets at Cost (Addns.) | -$10.6 | -$38.3 | -$26.0 | -$6.4 | ||||
| Working Capital Needs: | ||||||||
| Accts. Receivable (Incr.) Decr. | -$31.1 | -$21.8 | -$60.5 | -$30.3 | ||||
| Inventory (Incr.) Decr. | $17.5 | -$57.6 | $7.8 | -$51.4 | ||||
| Prepaid Exp. (Incr.) Decr. | -$9.7 | -$12.1 | $2.4 | -$22.2 | ||||
| Accts. Payable (Decr.) Incr. | $27.3 | $23.8 | -$52.5 | -$7.6 | ||||
| Accrued Exp. (Decr.) Incr. | $20.5 | $18.6 | $44.0 | -$146.7 | ||||
| Total Working Capital Needs | $24.5 | -$49.1 | -$58.8 | -$258.2 | ||||
| Loans (Decr.) Incr. | -$3.6 | $99.2 | -$42.1 | $30.0 | ||||
| Cash Flow | $53.4 | $79.9 | -$40.6 | -$5.3 | ||||
| Beginning Cash | $26.3 | $79.7 | $159.6 | $119.0 | $113.7 | $119.0 | ||
| Ending Cash | $79.7 | $159.6 | $119.0 | $113.7 | ||||
| Rev. 1-31-17 |
