Question2-AnalysisofFinancialStatements2.xlsx

Question 2

Computron’s Balance Sheets (Millions of Dollars) Projection

2018 2019 2020E

Assets

Cash and equivalents $ 10,000 $ 7,782 $ 15,500

Short-term investments 52,600 25,000 72,632

Accounts receivable 250,600 542,460 85,700

Inventories 837,982 1,546,252 1,779,572

Total current assets $ 1,151,182 $ 2,121,494 $ 1,953,404

Net Fixed Assets 882,982 1,164,085 1,785,600

Total Assets $ 2,034,164 $ 3,285,579 $ 3,739,004

Liabilities and equity

Accounts payable $ 154,600 $ 382,500 $ 452,300

Notes payable 250,000 620,000 450,000

Accruals 142,000 254,700 352,000

Total current liabilities $ 546,600 $ 1,257,200 $ 1,254,300

Long-term bonds 245,000 800,000 700,000

Total liabilities $ 791,600 $ 2,057,200 $ 1,954,300

Common stock (100,000 shares) 1,000,000 1,000,000 1,000,000

Retained earnings 242,564 228,379 784,704

Total common equity $ 1,242,564 $ 1,228,379 $ 1,784,704

Total liabilities and equity $ 2,034,164 $ 3,285,579 $ 3,739,004

Income Statements (Millions of Dollars) Projection

2018 2019 2020E

Net sales $ 3,532,000 $ 5,648,500 $ 7,453,600

Cost of goods sold (Excluding depr.) $ 2,547,000 $ 4,687,500 $ 5,750,000

Depreciationa $ 16,500 $ 187,500 $ 150,000

Other operating expenses $ 385,000 $ 625,000 $ 723,500

Earnings before interest and taxes (EBIT) $ 583,500 $ 148,500 $ 830,100

Less interest $ 65,200 $ 156,000 $ 75,000

Pre-tax earnings $ 518,300 $ (7,500) $ 755,100

Taxes (25%) $ 129,575 $ (1,875) $ 188,775

Net Income $ 388,725 $ (5,625) $ 566,325

Notes:

a Computron has no amortization charges.

Additional Information Projection

2018 2019 2020E

Year-end common stock price $8.50 $7.50 $11.15

Shares outstanding (millions) 100,000 100,000 100,000

Common dividends (millions) $9,500 $8,560 $10,000

Tax rate 25% 25% 25%

Additions to retained earnings (millions) $379,225 -$14,185 $556,325

Lease payments (millions) $35,000 $35,000 $35,000

Per Share Information Projection

2018 2019 2020E

EPS $3.89 -$0.06 $5.66

DPS $0.10 $0.09 $0.10

Book Value Per Share $12.43 $12.28 $17.85

Ratio Analysis 2018 2019 2020E Industry
Average

Profit margin 11.0% -0.1% 7.2%

Operating profit margin 16.5% 2.6% 10.4%

Basic earning power 28.7% 4.5% 15.6%

ROA 19.1% -0.2% 10.8%

ROE 31.3% -0.5% 15.4%

Inventory turnover 3.1 3.2 9.0

Days sales outstanding 25.9 35.1 28.0

Fixed assets turnover 4.0 4.9 3.0

Total assets turnover 1.736 1.719 1.5

Current 2.1 1.7 2.5

Quick 0.6 0.5 1.9

Debt ratio 24.3% 43.2% 15.0%

Debt-to-equity ratio 0.40 1.16 0.22

Liabilities-to-assets ratio 38.9% 62.6% 32.0%

TIE 8.9 1.0 13.0

EBITDA coverage 6.3 1.9 17.2

Price/earnings (P/E) 2.2 -133.3 16.8

Market/book 0.7 0.6 2.7

*Note “E” denotes “estimated”

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code HAPPY