Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie

12th Edition

1260819426, 9781260819427

More Books

Students also viewed these Finance questions

Question

Personal role: This consists of service to family and friends.

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago