Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help me with forecast of next 5 years for the file attached Exhibit 1 ASTRAL RECORDS Historical and Projected Income Statements Fiscal
Can you please help me with forecast of next 5 years for the file attached
Exhibit 1 ASTRAL RECORDS Historical and Projected Income Statements Fiscal Year Ended August 23 1990 1991 1992 1993 (Actual) (Actual) (Actual) (Actual) Sales 26,202 28,822 34,010 39,792 Operating Expenses: Production Costs and Expenses 11,950 13,380 17,847 22,335 Admin. and Selling Expenses 5,734 5,967 7,020 7,970 Depreciation 2,376 2,367 2,667 2,667 Total Operating Expenses (20,060) (21,714) (27,534) (32,972) Operating Margin 6,142 7,109 6,476 6,820 Interest Expense (2,427) (2,535) (3,265) (3,222) Earnings Before Taxes 3,715 4,574 3,212 3,598 Income Taxes (1,647) (1,845) (1,269) (1,403) Net Earnings 2,068 2,729 1,943 2,195 Dividends on : Dividends to All Common Shs Retentions of Earnings 1,000 1,068 1,000 1,729 1,000 943 1,000 1,195 Exhibit 2 ASTRAL RECORDS Historical Balance Sheets (fiscal year ended August 23; all figures in $ thousands) 1990 (Actual) 1991 (Actual) 1992 (Actual) 1993 (Actual) Assets Cash Accounts Receivable Inventories Total Current Assets Gross Property Plant & Equipt. Accumulated Depreciation Net Property Plant & Equipt. Total Assets 1,764 8,113 15,861 25,738 23,667 (2,505) 21,162 46,900 2,040 9,125 17,147 28,312 26,667 (4,872) 21,795 50,107 2,905 10,311 25,643 38,859 26,667 (7,538) 19,129 57,988 1,540 13,316 34,717 49,573 26,667 (10,205) 16,462 66,035 Liabilities and Stockholders' Equity: Short Term Borrowings (Bank) Accounts Payable Other Current Liabilities Total Current Liabilities Long Term Debt Shareholders' Equity Total Liabs. & Stkhldrs' Eq. 12,060 4,511 9,014 25,585 10,000 11,315 46,900 13,042 4,607 9,414 27,063 10,000 13,044 50,107 19,680 4,705 9,616 34,001 10,000 13,987 57,988 25,802 5,328 9,723 40,853 10,000 15,182 66,035 72% Exhibit 3 ASTRAL RECORDS Ratio Analyses of Historical Financial Statements (fiscal year ended August 23) 1990 (Actual) Profitability Operating Profit Margin Average Tax Rate Return on Sales Return on Equity Return on Assets Leverage Debt/Equity Ratio Debt/Total Assets EBIT/Interest (x) Asset Utilization Sales/Assets Sales Growth Rate Assets Growth Rate Days in Receivables Payables to COGS Inventories to COGS Liquidity Current Ratio Quick Ratio 1991 (Actual) 1992 (Actual) 1993 (Actual) 23.4% 44.3% 7.9% 18.3% 4.4% 24.7% 40.3% 9.5% 20.9% 5.4% 19.0% 39.5% 5.7% 13.9% 3.4% 17.1% 39.0% 5.5% 14.5% 3.3% 1.95 0.47 2.53 1.77 0.46 2.80 2.12 0.51 1.98 2.36 0.54 2.12 55.9% 4.0% 6.0% 113.0 37.7% 132.7% 57.5% 10.0% 6.8% 115.6 34.4% 128.2% 58.7% 18.0% 15.7% 110.7 26.4% 143.7% 60.3% 17.0% 13.9% 122.1 23.9% 155.4% 1.01 0.39 1.05 0.41 1.14 0.39 1.21 0.36 Exhibit 5 ASTRAL RECORDS Data on Comparable Companies and Capital Market Conditions Number of Value Line % of Sales Market Shares 5-Year from CD Price/EarningsValue Line Book Book Value Price OutstandingLast AnnualEarnings Growth Bond Name Production Ratio Beta D/E per Share per Share (millions) Dividend Forecast Rating Dickenson Inc. 20% 9 1.5 0.45 5.5 10 5 $0.95 4% A Harris-Beshel 95% 8 1.3 0.7 12.75 14 7.5 $1.00 6% AA Donaldson Inc. 90% 12 1.2 1.4 5.25 18 10 $0.75 8% AA IBBEX Corp. 40% 16 1.45 0.1 16.8 20 15 $0.00 10% Baa ZEPORT 60% 10 1.6 1.3 25 40 10 $2.20 7% B Forecasting Assumptions Sales Growth 1994-1995 Sales Growth after 1995 Cost of Goods Sold SG&A Capital Expenditures / Sales Depreciation as a % Gross PPE Dividend Payout Interest Rate (LTD & STD) Tax Rate Cash as % Sales Days Inventories Days Sales Outstanding Days Payables Other Current Liabilities / Sales 15% 5% 60% 30% 5% 10% 25% 9% 40% 4% 275 120 44 20%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started