finance help
Yosvany1
BishopCompaniesProFormaFinancials.xlsxA
| Are you using the correct spreadsheet? This is Spreadsheet A. | |||||||||||
| The Bishop Companies, Incorporated Pro Forma Financial Statements | |||||||||||
| Income Statement | |||||||||||
| Period Ending: | 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | RATIO ANALYSIS MATRIX | ||||||
| Net Sales | $246,486,000 | $275,059,000 | $242,571,000 | $179,186,000 | |||||||
| Cost of Goods Sold | $188,312,000 | $249,259,000 | $203,752,000 | $158,267,000 | BALANCE SHEET RATIOS: Stability (Staying Power) | ||||||
| Gross Profit | $58,174,000 | $25,800,000 | $38,819,000 | $20,919,000 | 1 | Current | |||||
| Current Assets | ERROR:#DIV/0! | ||||||||||
| Operating Expenses: | Current Liabilities | ||||||||||
| Sales, General and Admin. | $13,706,000 | $14,950,000 | $14,532,000 | $13,276,000 | 2 | Quick | |||||
| Non-Recurring Items | $2,515,000 | ($1,510,000) | $17,000 | $0 | Cash + Accts. Rec. | ERROR:#DIV/0! | |||||
| Other Operating Items | $8,771,000 | $0 | ($1,714,000) | $0 | Current Liabilities | ||||||
| EBIT | $33,182,000 | $12,360,000 | $25,984,000 | $7,643,000 | 3 | Debt-to-Worth | |||||
| Interest Expense | $559,000 | $642,000 | $851,000 | $1,279,000 | Total Liabilities | ERROR:#DIV/0! | |||||
| EBT | $32,623,000 | $11,718,000 | $25,133,000 | $6,364,000 | Net Worth | ||||||
| Income Tax | $9,288,000 | $8,282,000 | $5,939,000 | $4,342,000 | |||||||
| EAT | $23,335,000 | $3,436,000 | $19,194,000 | $2,022,000 | INCOME STATEMENT RATIOS: Profitability (Earning Power) | ||||||
| Cash Dividends | $9,334,000 | $1,374,400 | $7,677,600 | $808,800 | 4 | Gross Margin | |||||
| Increase in RE | $14,001,000 | $2,061,600 | $11,516,400 | $1,213,200 | Gross Profit | ERROR:#DIV/0! | |||||
| 0.4 | Sales | ||||||||||
| 5 | Net Margin | ||||||||||
| Balance Sheet | Net Profit Before Tax | ERROR:#DIV/0! | |||||||||
| 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | Sales | |||||||
| Current Assets: | |||||||||||
| Cash and Cash Equivalents | $2,960,000 | $1,156,000 | $1,947,000 | $1,520,000 | ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios | ||||||
| Short Term Investments | $9,858,000 | $328,000 | $185,000 | $215,000 | 6 | Sales-to-Assets | |||||
| Net Receivables | $41,114,000 | $46,696,000 | $40,716,000 | $33,150,000 | Sales | ERROR:#DIV/0! | |||||
| Inventory | $19,593,000 | $15,698,000 | $11,617,000 | $10,181,000 | Total Assets | ||||||
| Total Current Assets | $73,525,000 | $63,878,000 | $54,465,000 | $45,066,000 | 7 | Return on Assets | |||||
| Net Profit Before Tax | ERROR:#DIV/0! | ||||||||||
| Long Term Assets: | Total Assets | ||||||||||
| Long Term Investments | $26,165,000 | $19,309,000 | $18,637,000 | $4,728,000 | 8 | Return on Investment | |||||
| Fixed Assets | $85,947,000 | $96,748,000 | $91,911,000 | $87,682,000 | Net Profit Before Tax | ERROR:#DIV/0! | |||||
| Goodwill | $10,542,000 | $7,933,000 | $10,838,000 | $10,354,000 | Net Worth | ||||||
| Intangible Assets | $4,772,000 | $4,204,000 | $4,473,000 | $5,128,000 | |||||||
| Other Assets | $1,508,000 | $5,955,000 | $1,139,000 | $4,633,000 | ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios | ||||||
| Deferred Asset Charges | $5,307,000 | $0 | ($65,000) | ($78,000) | 9 | Inventory Turnover | |||||
| Total Assets | $207,766,000 | $198,027,000 | $181,398,000 | $157,513,000 | Cost of Goods Sold | ERROR:#DIV/0! | |||||
| Inventory | |||||||||||
| Current Liabilities: | 10 | Inventory Turn-Days | |||||||||
| Accounts Payable | $52,380,000 | $54,341,000 | $41,128,000 | $36,215,000 | 360 | ERROR:#DIV/0! | |||||
| Short Term Debt/Current Portion of Long Term Debt | $18,015,000 | $10,184,000 | $9,456,000 | $10,086,000 | Inventory Turnover | ||||||
| Other Current Liabilities | $1,602,000 | $0 | $0 | $0 | 11 | Accounts Receivable Turnover | |||||
| Total Current Liabilities | $71,997,000 | $64,525,000 | $50,584,000 | $46,301,000 | Sales | ERROR:#DIV/0! | |||||
| Accounts Receivable | |||||||||||
| Long Term Debt | $13,926,000 | $12,907,000 | $12,869,000 | $11,922,000 | 12 | Accounts Receivable Turn-Days | |||||
| Other Liabilities | $12,017,000 | $26,943,000 | $21,783,000 | $18,139,000 | 360 | ERROR:#DIV/0! | |||||
| Deferred Liability Charges | $25,488,000 | $15,050,000 | $15,273,000 | $13,514,000 | Accts. Rec. Turnover | ||||||
| Minority Interest | $789,000 | $1,885,000 | $1,125,000 | $638,000 | 13 | Accounts Payable Turnover | |||||
| Total Liabilities | $124,217,000 | $121,310,000 | $101,634,000 | $90,514,000 | Cost of Goods Sold | ERROR:#DIV/0! | |||||
| Accounts Payable | |||||||||||
| Shareholders Equity: | 14 | Average Payment Period | |||||||||
| Preferred Stocks | $0 | $21,000 | $0 | $21,000 | 360 | ERROR:#DIV/0! | |||||
| Common Stocks | $5,185,000 | $5,382,000 | $5,552,000 | $5,595,000 | Accts. Pay. Turnover | ERROR:#DIV/0! | |||||
| Capital Surplus | $0 | $6,366,000 | $4,480,000 | $4,243,000 | |||||||
| Retained Earnings | $78,364,000 | $37,763,000 | $38,700,000 | $32,344,000 | |||||||
| Negative Goodwill | $0 | $61,000 | $0 | $0 | |||||||
| Other Equity | $0 | $27,124,000 | $31,032,000 | $24,796,000 | |||||||
| Total Equity | $83,549,000 | $76,717,000 | $79,764,000 | $66,999,000 | |||||||
| Total Liabilities/Equity | $207,766,000 | $198,027,000 | $181,398,000 | $157,513,000 | |||||||
B
| Are you using the correct spreadsheet? This is Spreadsheet B. | |||||||||||
| The Bishop Companies, Incorporated Pro Forma Financial Statements | |||||||||||
| Income Statement | |||||||||||
| Period Ending: | 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | RATIO ANALYSIS MATRIX | ||||||
| Net Sales | $180,286,000 | $232,671,000 | $286,059,000 | $245,386,000 | |||||||
| Cost of Goods Sold | $158,267,000 | $203,752,000 | $249,259,000 | $188,312,000 | BALANCE SHEET RATIOS: Stability (Staying Power) | ||||||
| Gross Profit | $22,019,000 | $28,919,000 | $36,800,000 | $57,074,000 | 1 | Current | |||||
| Current Assets | ERROR:#DIV/0! | ||||||||||
| Operating Expenses: | Current Liabilities | ||||||||||
| Sales, General and Admin. | $13,276,000 | $14,532,000 | $14,950,000 | $13,706,000 | 2 | Quick | |||||
| Non-Recurring Items | $0 | $17,000 | ($1,510,000) | $2,515,000 | Cash + Accts. Rec. | ERROR:#DIV/0! | |||||
| Other Operating Items | $0 | ($1,714,000) | $0 | $8,771,000 | Current Liabilities | ||||||
| EBIT | $8,743,000 | $16,084,000 | $23,360,000 | $32,082,000 | 3 | Debt-to-Worth | |||||
| Interest Expense | $1,279,000 | $851,000 | $642,000 | $559,000 | Total Liabilities | ERROR:#DIV/0! | |||||
| EBT | $7,464,000 | $15,233,000 | $22,718,000 | $31,523,000 | Net Worth | ||||||
| Income Tax | $4,342,000 | $5,939,000 | $8,282,000 | $9,288,000 | |||||||
| EAT | $3,122,000 | $9,294,000 | $14,436,000 | $22,235,000 | INCOME STATEMENT RATIOS: Profitability (Earning Power) | ||||||
| Cash Dividends | $1,248,800 | $3,717,600 | $5,774,400 | $8,894,000 | 4 | Gross Margin | |||||
| Increase in RE | $1,873,200 | $5,576,400 | $8,661,600 | $13,341,000 | Gross Profit | ERROR:#DIV/0! | |||||
| 0.4 | Sales | ||||||||||
| 5 | Net Margin | ||||||||||
| Balance Sheet | Net Profit Before Tax | ERROR:#DIV/0! | |||||||||
| 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | Sales | |||||||
| Current Assets: | |||||||||||
| Cash and Cash Equivalents | $1,520,000 | $1,947,000 | $1,156,000 | $2,960,000 | ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios | ||||||
| Short Term Investments | $215,000 | $185,000 | $328,000 | $9,858,000 | 6 | Sales-to-Assets | |||||
| Net Receivables | $33,150,000 | $40,716,000 | $46,696,000 | $41,114,000 | Sales | ERROR:#DIV/0! | |||||
| Inventory | $10,181,000 | $11,617,000 | $15,698,000 | $19,593,000 | Total Assets | ||||||
| Total Current Assets | $45,066,000 | $54,465,000 | $63,878,000 | $73,525,000 | 7 | Return on Assets | |||||
| Net Profit Before Tax | ERROR:#DIV/0! | ||||||||||
| Long Term Assets: | Total Assets | ||||||||||
| Long Term Investments | $4,728,000 | $18,637,000 | $19,309,000 | $26,165,000 | 8 | Return on Investment | |||||
| Fixed Assets | $87,682,000 | $91,911,000 | $96,748,000 | $85,947,000 | Net Profit Before Tax | ERROR:#DIV/0! | |||||
| Goodwill | $10,354,000 | $10,838,000 | $7,933,000 | $10,542,000 | Net Worth | ||||||
| Intangible Assets | $5,128,000 | $4,473,000 | $4,204,000 | $4,772,000 | |||||||
| Other Assets | $4,633,000 | $1,139,000 | $5,955,000 | $1,508,000 | ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios | ||||||
| Deferred Asset Charges | ($78,000) | ($65,000) | $0 | $5,307,000 | 9 | Inventory Turnover | |||||
| Total Assets | $157,513,000 | $181,398,000 | $198,027,000 | $207,766,000 | Cost of Goods Sold | ERROR:#DIV/0! | |||||
| Inventory | |||||||||||
| Current Liabilities: | 10 | Inventory Turn-Days | |||||||||
| Accounts Payable | $36,215,000 | $41,128,000 | $54,341,000 | $52,380,000 | 360 | ERROR:#DIV/0! | |||||
| Short Term Debt/Current Portion of Long Term Debt | $10,086,000 | $9,456,000 | $10,184,000 | $18,015,000 | Inventory Turnover | ||||||
| Other Current Liabilities | $0 | $0 | $0 | $1,602,000 | 11 | Accounts Receivable Turnover | |||||
| Total Current Liabilities | $46,301,000 | $50,584,000 | $64,525,000 | $71,997,000 | Sales | ERROR:#DIV/0! | |||||
| Accounts Receivable | |||||||||||
| Long Term Debt | $11,922,000 | $12,869,000 | $12,907,000 | $13,926,000 | 12 | Accounts Receivable Turn-Days | |||||
| Other Liabilities | $18,139,000 | $21,783,000 | $26,943,000 | $12,017,000 | 360 | ERROR:#DIV/0! | |||||
| Deferred Liability Charges | $13,514,000 | $15,273,000 | $15,050,000 | $25,488,000 | Accts. Rec. Turnover | ||||||
| Minority Interest | $638,000 | $1,125,000 | $1,885,000 | $789,000 | 13 | Accounts Payable Turnover | |||||
| Total Liabilities | $90,514,000 | $101,634,000 | $121,310,000 | $124,217,000 | Cost of Goods Sold | ERROR:#DIV/0! | |||||
| Accounts Payable | |||||||||||
| Shareholders Equity: | 14 | Average Payment Period | |||||||||
| Preferred Stocks | $21,000 | $0 | $21,000 | $0 | 360 | ERROR:#DIV/0! | |||||
| Common Stocks | $5,595,000 | $5,552,000 | $5,382,000 | $5,185,000 | Accts. Pay. Turnover | ERROR:#DIV/0! | |||||
| Capital Surplus | $4,243,000 | $4,480,000 | $6,366,000 | $0 | |||||||
| Retained Earnings | $32,344,000 | $38,700,000 | $37,763,000 | $78,364,000 | |||||||
| Negative Goodwill | $0 | $0 | $61,000 | $0 | |||||||
| Other Equity | $24,796,000 | $31,032,000 | $27,124,000 | $0 | |||||||
| Total Equity | $66,999,000 | $79,764,000 | $76,717,000 | $83,549,000 | |||||||
| Total Liabilities/Equity | $157,513,000 | $181,398,000 | $198,027,000 | $207,766,000 | |||||||
C
| Are you using the correct spreadsheet? This is Spreadsheet C. | |||||||||||
| The Bishop Companies, Incorporated Pro Forma Financial Statements | |||||||||||
| Income Statement | |||||||||||
| Period Ending: | 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | RATIO ANALYSIS MATRIX | ||||||
| Net Sales | $232,471,000 | $245,186,000 | $180,076,000 | $286,059,000 | |||||||
| Cost of Goods Sold | $203,752,000 | $188,312,000 | $158,267,000 | $249,259,000 | BALANCE SHEET RATIOS: Stability (Staying Power) | ||||||
| Gross Profit | $28,719,000 | $56,874,000 | $21,809,000 | $36,800,000 | 1 | Current | |||||
| Current Assets | ERROR:#DIV/0! | ||||||||||
| Operating Expenses: | Current Liabilities | ||||||||||
| Sales, General and Admin. | $14,532,000 | $13,706,000 | $13,276,000 | $14,950,000 | 2 | Quick | |||||
| Non-Recurring Items | $17,000 | $2,515,000 | $0 | ($1,510,000) | Cash + Accts. Rec. | ERROR:#DIV/0! | |||||
| Other Operating Items | ($1,714,000) | $8,771,000 | $0 | $0 | Current Liabilities | ||||||
| EBIT | $15,884,000 | $31,882,000 | $8,533,000 | $23,360,000 | 3 | Debt-to-Worth | |||||
| Interest Expense | $851,000 | $559,000 | $1,279,000 | $642,000 | Total Liabilities | ERROR:#DIV/0! | |||||
| EBT | $15,033,000 | $31,323,000 | $7,254,000 | $22,718,000 | Net Worth | ||||||
| Income Tax | $5,939,000 | $9,288,000 | $4,342,000 | $8,282,000 | |||||||
| EAT | $9,094,000 | $22,035,000 | $2,912,000 | $14,436,000 | INCOME STATEMENT RATIOS: Profitability (Earning Power) | ||||||
| Cash Dividends | $3,637,600 | $8,814,000 | $1,164,800 | $5,774,400 | 4 | Gross Margin | |||||
| Increase in RE | $5,456,400 | $13,221,000 | $1,747,200 | $8,661,600 | Gross Profit | ERROR:#DIV/0! | |||||
| 0.4 | Sales | ||||||||||
| 5 | Net Margin | ||||||||||
| Balance Sheet | Net Profit Before Tax | ERROR:#DIV/0! | |||||||||
| 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | Sales | |||||||
| Current Assets: | |||||||||||
| Cash and Cash Equivalents | $1,947,000 | $2,960,000 | $1,520,000 | $1,156,000 | ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios | ||||||
| Short Term Investments | $185,000 | $9,858,000 | $215,000 | $328,000 | 6 | Sales-to-Assets | |||||
| Net Receivables | $40,716,000 | $41,114,000 | $33,150,000 | $46,696,000 | Sales | ERROR:#DIV/0! | |||||
| Inventory | $11,617,000 | $19,593,000 | $10,181,000 | $15,698,000 | Total Assets | ||||||
| Total Current Assets | $54,465,000 | $73,525,000 | $45,066,000 | $63,878,000 | 7 | Return on Assets | |||||
| Net Profit Before Tax | ERROR:#DIV/0! | ||||||||||
| Long Term Assets: | Total Assets | ||||||||||
| Long Term Investments | $18,637,000 | $26,165,000 | $4,728,000 | $19,309,000 | 8 | Return on Investment | |||||
| Fixed Assets | $91,911,000 | $85,947,000 | $87,682,000 | $96,748,000 | Net Profit Before Tax | ERROR:#DIV/0! | |||||
| Goodwill | $10,838,000 | $10,542,000 | $10,354,000 | $7,933,000 | Net Worth | ||||||
| Intangible Assets | $4,473,000 | $4,772,000 | $5,128,000 | $4,204,000 | |||||||
| Other Assets | $1,139,000 | $1,508,000 | $4,633,000 | $5,955,000 | ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios | ||||||
| Deferred Asset Charges | ($65,000) | $5,307,000 | ($78,000) | $0 | 9 | Inventory Turnover | |||||
| Total Assets | $181,398,000 | $207,766,000 | $157,513,000 | $198,027,000 | Cost of Goods Sold | ERROR:#DIV/0! | |||||
| Inventory | |||||||||||
| Current Liabilities: | 10 | Inventory Turn-Days | |||||||||
| Accounts Payable | $41,128,000 | $52,380,000 | $36,215,000 | $54,341,000 | 360 | ERROR:#DIV/0! | |||||
| Short Term Debt/Current Portion of Long Term Debt | $9,456,000 | $18,015,000 | $10,086,000 | $10,184,000 | Inventory Turnover | ||||||
| Other Current Liabilities | $0 | $1,602,000 | $0 | $0 | 11 | Accounts Receivable Turnover | |||||
| Total Current Liabilities | $50,584,000 | $71,997,000 | $46,301,000 | $64,525,000 | Sales | ERROR:#DIV/0! | |||||
| Accounts Receivable | |||||||||||
| Long Term Debt | $12,869,000 | $13,926,000 | $11,922,000 | $12,907,000 | 12 | Accounts Receivable Turn-Days | |||||
| Other Liabilities | $21,783,000 | $12,017,000 | $18,139,000 | $26,943,000 | 360 | ERROR:#DIV/0! | |||||
| Deferred Liability Charges | $15,273,000 | $25,488,000 | $13,514,000 | $15,050,000 | Accts. Rec. Turnover | ||||||
| Minority Interest | $1,125,000 | $789,000 | $638,000 | $1,885,000 | 13 | Accounts Payable Turnover | |||||
| Total Liabilities | $101,634,000 | $124,217,000 | $90,514,000 | $121,310,000 | Cost of Goods Sold | ERROR:#DIV/0! | |||||
| Accounts Payable | |||||||||||
| Shareholders Equity: | 14 | Average Payment Period | |||||||||
| Preferred Stocks | $0 | $0 | $21,000 | $21,000 | 360 | ERROR:#DIV/0! | |||||
| Common Stocks | $5,552,000 | $5,185,000 | $5,595,000 | $5,382,000 | Accts. Pay. Turnover | ERROR:#DIV/0! | |||||
| Capital Surplus | $4,480,000 | $0 | $4,243,000 | $6,366,000 | |||||||
| Retained Earnings | $38,700,000 | $78,364,000 | $32,344,000 | $37,763,000 | |||||||
| Negative Goodwill | $0 | $0 | $0 | $61,000 | |||||||
| Other Equity | $31,032,000 | $0 | $24,796,000 | $27,124,000 | |||||||
| Total Equity | $79,764,000 | $83,549,000 | $66,999,000 | $76,717,000 | |||||||
| Total Liabilities/Equity | $181,398,000 | $207,766,000 | $157,513,000 | $198,027,000 | |||||||
