ratio analysis sample internet

THE INTERNET COMPANY
FORECASTED RATIOS
FOR YEARS ENDING DECEMBER 31, 200X and 200Y

 

200X

200Y

CURRENT RATIO:
Current Assets
Current Liabilities
$35,492
$ 7,408
$59,808
$8,062
4.79 7.42
AVERAGE COLLECTION PERIOD:
Accounts Receivable
Annual Credit Sales/360
$14,746
$ 383
$15,120
$ 486
38 days 31 days
FIXED ASSET TURNOVER:
Net Sales
Net Fixed Assets
$138,000
$ 13,138
$175,000
$ 8,425
10.50 20.77
TOTAL ASSET TURNOVER:
Net Sales
Total Assets
$138,000
$ 48,629
$175,000
$ 68,233
2.84 2.56
DEBT RATIO:
Total Debt
Total Assets
$19,749
$48,629
$17,587
$68,233
0.41 0.26
DEBT-TO EQUITY:
Total Debt
Total Equity
$19,749
$28,880
$17,587
$50,646
0.68 0.35
NET PROFIT MARGIN:
Net Income after Taxes
Sales
$ 22,225
$138,000
$ 24,185
$175,000
0.16 0.14
RETURN ON TOTAL ASSETS:
Net Income after Taxes
Total Assets
$22,225
$48,629
$24,185
$68,233
RETURN ON EQUITY:
Net Income after Taxes
Total Equity
$22,225
$28,880
$24,185
$50,646
0.77 0.48

NOTE: Analysis of the above ratios is available upon request.  Figures are Rounded.