Case Assignment

lisagonzalez23
SpreadsheetJoynerLumberCase1.xls
Home>Business & Finance homework help>Economics homework help>Case Assignment

OBJ

Objective Analysis of JLC
Student Name
ID Number

BS

Balance Sheet
Company Name: Joyner Lumber Company, Inc.
Amounts In: ($)
Period:
Statement Type: Forecast
Date: 12/31/87 12/31/88 12/31/89 12/31/90 4/30/91 12/31/91
ASSETS
Cash & Cash Equivalents
Marketable Securities
Accounts Receivable, net
Inventories
Other Accounts and Notes Receivable
Prepaid Expenses
Other Current Assets
Total Current Assets - 0 - 0 - 0 - 0 - 0 - 0
Net Fixed Assets
Investments
Intangibles
Other Assets
Total Assets - 0 - 0 - 0 - 0 - 0 - 0
LIABILITIES & STOCKHOLDERS' EQUITY
Accounts Payable
Notes Payable - Banks
Current Maturities of Long Term Debt
Accrued Liabilities
Other Current Liabilities
Total Current Liabilities - 0 - 0 - 0 - 0 - 0 - 0
Deferred Federal Income Taxes
Long-Term Debt
Subordinated Debt
Total Liabilities - 0 - 0 - 0 - 0 - 0 - 0
Common Stock
Additional paid-in capital
Retained Earnings
Treasury Stock
- 0 - 0 - 0 - 0
Total Stockholders' Equity - 0 - 0 - 0 - 0 - 0 - 0
Total Liabilities & Stockholders' Equity - 0 - 0 - 0 - 0 - 0 - 0

IS

Statements of Earnings and Retained Earnings
Company Name: Joyner Lumber Company, Inc.
Amounts In: ($)
Period: YTD Forecast
Statement Type: 12 Mos 12 Mos 12 Mos 12 Mos 4 Mos 12 Mos
Date: 12/31/87 12/31/88 12/31/89 12/31/90 4/30/91 12/31/91
Total Sales - Revenues
Cost of Goods Sold
Gross Profit - 0 - 0 - 0 - 0 - 0 - 0
Gen & Adm Expenses
Salaries and Wages
Lease Payments
Officers' Salaries
Bad Debt Expense
Depreciation and amortization
Repairs and maintenance
Net Operating Income (Profit) - 0 - 0 - 0 - 0 - 0 - 0
Interest Income
Interest Expense
Other Income
Gain on Sale of Assets
Net Income Before Taxes - 0 - 0 - 0 - 0 - 0 - 0
Income Taxes
Net Income Before Extra Items - 0 - 0 - 0 - 0 - 0 - 0
Extraordinary Income
Extraordinary Charges
Net Income (Loss) - 0 - 0 - 0 - 0 - 0 - 0
Beginning Retained Earnings 736,587 736,587 736,587 736,587 736,587 736,587
Net Profit - 0 - 0 - 0 - 0 - 0 - 0
Cash Dividends
Other Deductions
Other Additions
Ending Retained Earnings 736,587 736,587 736,587 736,587 736,587 736,587

CF

Statement of Cash Flow
Company Name: Joyner Lumber Company, Inc.
Amounts In: ($)
Period: YTD Forecast
Statement Type: 12 Mos 12 Mos 12 Mos 4 Mos 12 Mos
Date: 32142 12/31/88 12/31/89 12/31/90 4/30/91 12/31/91
Cash Flows from Operations
Net Income - 0 - 0 - 0 - 0 - 0
Noncash revenue and expense included in net income
Depreciation and amortization - 0 - 0 - 0 - 0 - 0
Change in Deferred Income Taxes - 0 - 0 - 0 - 0 - 0
Cash provided (used) by current assets and liabilities
Change in Accounts Receivable - 0 - 0 - 0 - 0 - 0
Change in Other Accounts and Notes Receivable - 0 - 0 - 0 - 0 - 0
Change in Inventory - 0 - 0 - 0 - 0 - 0
Change in Prepaid Expenses - 0 - 0 - 0 - 0 - 0
Change in Other Current Assets - 0 - 0 - 0 - 0 - 0
Change in Accounts Payable - 0 - 0 - 0 - 0 - 0
Change in Accrued Liabilities - 0 - 0 - 0 - 0 - 0
Change in Other Current Liabilities - 0 - 0 - 0 - 0 - 0
Total Cash Flows from Operations - 0 - 0 - 0 - 0 - 0 - 0
Cash Flows from Investing
Change in Fixed Assets - 0 - 0 - 0 - 0 - 0
Change in Investmet Securities - 0 - 0 - 0 - 0 - 0
Change in Other Investing Activities - 0 - 0 - 0 - 0 - 0
Total Cash Flows from Investing - 0 - 0 - 0 - 0 - 0 - 0
Cash Flows from Financing
Change in Short-term Borrowings - 0 - 0 - 0 - 0 - 0
Change in Long-term Borrowings - 0 - 0 - 0 - 0 - 0
Cash Dividends Paid - 0 - 0 - 0 - 0 - 0
Change in Treasury Stock - 0 - 0 - 0 - 0 - 0
Change in Common Stock - 0 - 0 - 0 - 0 - 0
Total Cash Flows from Financing - 0 - 0 - 0 - 0 - 0 - 0
Net Change in Cash and Marketable Securities - 0 - 0 - 0 - 0 - 0 - 0

CSBS

Common Size Balance Sheet
Company Name: Joyner Lumber Company, Inc.
Amounts In: ($)
Period:
Statement Type: Forecast
Date: 12/31/87 12/31/88 12/31/89 12/31/90 4/30/91 12/31/91
ASSETS
Cash & Cash Equivalents - 0 - 0 - 0 - 0 - 0 - 0
Marketable Securities - 0 - 0 - 0 - 0 - 0 - 0
Accounts Receivable, net - 0 - 0 - 0 - 0 - 0 - 0
Inventories - 0 - 0 - 0 - 0 - 0 - 0
Other Accounts and Notes Receivable - 0 - 0 - 0 - 0 - 0 - 0
Prepaid Expenses - 0 - 0 - 0 - 0 - 0 - 0
Other Current Assets - 0 - 0 - 0 - 0 - 0 - 0
Total Current Assets - 0 - 0 - 0 - 0 - 0 - 0
Net Fixed Assets - 0 - 0 - 0 - 0 - 0 - 0
Investments - 0 - 0 - 0 - 0 - 0 - 0
Intangibles - 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
Other Assets - 0 - 0 - 0 - 0 - 0 - 0
Total Assets - 0 - 0 - 0 - 0 - 0 - 0
LIABILITIES & STOCKHOLDERS' EQUITY
Accounts Payable - 0 - 0 - 0 - 0 - 0 - 0
Notes Payable - Banks - 0 - 0 - 0 - 0 - 0 - 0
Current Maturities of Long Term Debt - 0 - 0 - 0 - 0 - 0 - 0
Accrued Liabilities - 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
Other Current Liabilities - 0 - 0 - 0 - 0 - 0 - 0
Total Current Liabilities - 0 - 0 - 0 - 0 - 0 - 0
Deferred Federal Income Taxes - 0 - 0 - 0 - 0 - 0 - 0
Long-Term Debt - 0 - 0 - 0 - 0 - 0 - 0
Subordinated Debt - 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
Total Liabilities - 0 - 0 - 0 - 0 - 0 - 0
Common Stock - 0 - 0 - 0 - 0 - 0 - 0
Additional paid-in capital - 0 - 0 - 0 - 0 - 0 - 0
Retained Earnings - 0 - 0 - 0 - 0 - 0 - 0
Treasury Stock - 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
Total Stockholders' Equity - 0 - 0 - 0 - 0 - 0 - 0
Total Liabilities & Stockholders' Equity - 0 - 0 - 0 - 0 - 0 - 0

CSIS

Common Size Income Statement
Company Name: Joyner Lumber Company, Inc.
Amounts In: ($)
Period: Forecast
Statement Type: YTD 12 Mos
Date: 12/31/87 12/31/88 12/31/89 12/31/90 4/30/91 12/31/91
Total Sales - Revenues - 0 - 0 - 0 - 0 - 0 - 0
Cost of Goods Sold - 0 - 0 - 0 - 0 - 0 - 0
Gross Profit - 0 - 0 - 0 - 0 - 0 - 0
Gen & Adm Expenses - 0 - 0 - 0 - 0 - 0 - 0
Salaries and Wages - 0 - 0 - 0 - 0 - 0 - 0
Lease Payments - 0 - 0 - 0 - 0 - 0 - 0
Officers' Salaries - 0 - 0 - 0 - 0 - 0 - 0
Bad Debt Expense - 0 - 0 - 0 - 0 - 0 - 0
Depreciation and amortization - 0 - 0 - 0 - 0 - 0 - 0
Repairs and maintenance - 0 - 0 - 0 - 0 - 0 - 0
- 0 - 0 - 0 - 0 - 0 - 0
Net Operating Income (Profit) - 0 - 0 - 0 - 0 - 0 - 0
Interest Income - 0 - 0 - 0 - 0 - 0 - 0
Interest Expense - 0 - 0 - 0 - 0 - 0 - 0
Other Income - 0 - 0 - 0 - 0 - 0 - 0
Gain on Sale of Assets - 0 - 0 - 0 - 0 - 0 - 0
Net Income Before Taxes - 0 - 0 - 0 - 0 - 0 - 0
Income Taxes - 0 - 0 - 0 - 0 - 0 - 0
Net Income Before Extra Items - 0 - 0 - 0 - 0 - 0 - 0
Extraordinary Income - 0 - 0 - 0 - 0 - 0 - 0
Extraordinary Charges - 0 - 0 - 0 - 0 - 0 - 0
Net Income (Loss) - 0 - 0 - 0 - 0 - 0 - 0

FR

Financial Ratios - Trends and Comparisons with Industry
Company Name: Joyner Lumber Company, Inc.
Amounts In: ($ in Summary) Comparison
Period: of Company
Statement Type: Forecast RMA Ratios to the
Date: 12/31/87 12/31/88 12/31/89 12/31/90 4/30/91 12/31/91 Trend Norm RMA Norms
Financial Summary
Current Assets
Current Liabilities
Total Assets
Total Liabilities
Total Net Worth
Net Working Capital
Working Assets
Working Liabilities
Working Investment
Long Term Debt
Tangible Net Worth
Average Annual Long-term Debt Maturities
Current Maturities of LTD
Operating Cash Flow
Net Sales
Net Income
Liquidity/Activity Ratios
Current Ratio (x)
Quick Ratio (x)
Cash Flow Liquidity Ratio (x)
Sales/Working Capital (x)
Accounts Receivable (x)
Accounts Receivable (Days)
Inventory Turnover vs COGS (x)
Inventory Turnover vs Aver Sales (Days)
Accounts Payable vs COGS (Days)
Accounts Payable vs Aver Sales (Days)
Cash Conversion Cycle (Days)
Leverage Ratios
Debt Ratio (%)
Long-term Debt to Total Capitalization (%)
Debt to Worth (x)
Debt to Tangible Net Worth (x)
(Net Profit+Depr/Depl/Amort)/CMLTD (x)
Times Interest Earned (x)
Fixed Charge Coverage (x)
Cash Flow Adequacy (x)
Performance Ratios
Fixed Asset Turnover (x)
Total Asset Turnover (x)
Gross Profit Margin (%)
Operating Profit Margin (%)
Net Profit Margin (%)
Cash Flow Margin (%)
Profit Before Taxes/Total Assets (%)
Return on Assets (%)
Return on Equity (%)
Cash Return on Assets (%)
Sales Growth (%)
Earnings Growth (%)
Total Asset Growth (%)