Please kindly joint with use for more:

- Facebook group: Cambodia Accounting and Tax

https://web.facebook.com/groups/329439310878304/
- Telegram : Account & Tax
https://t.me/AccountnTax

- YouTube: I Khnow
https://www.youtube.com/c/IKnowExcel
Financial Ratio Analysis Dashboard
Dashboard Balance Sheet Income Statement Ratio Analysis

Lquidity Ratio Value

Current Ratio 5.42 LIQUIDITY RATIO
Quick Ratio 4.29
Net working capital Ratio 0.57 6.00
5.00
4.00
Asset Turnover Ratio Value 3.00 5.42
4.29
Receivable Turnover 7.69 2.00 0.57
Average Collection Period(in Days) 47.44 1.00
Inventory Turnover 3.32 0.00
Inventory Period 9.04 Current Ratio Quick Ratio Net working capital R

Profitability Ratio Value

Gross Margin 56% PROFITABILITY RATIO
Return on Assets 37%
Return on Equity 75% 80%
60%
75%
40% 56%
37%
Financial Leverage Ratio Value 20%
Debt Ratio 0.18 0%
Interest Coverage 30.71 Gross Margin Return on Assets Return on Equity
Debt to equity ratio 0.15

Values Total
Total Assests $54,598
CURRENT ASSETS
$1,000.00
Total Liabilities $9,868 $900.00
Stockholder equity $26,472 $800.00
$700.00
$600.00
Assests, Liabilities and Equity $500.00
$400.00
$300.00
$26,472
$200.00
$100.00
$54,598 $0.00
Jan Feb Mar April May June July Aug Sep Oct
$9,868

Cash & Cash Equivalent Account Receivables

Total Assests Total Liabilities Inventories Short-Term Investment
Stockholder equity Prepaid Expenses & Others
 Ratio Analysis Financial Stateent

QUIDITY RATIO ASSET TURNOVER RATIO

9.04 7.69
3.32

4.29
0.57
47.44
Receivable Turnover Average Collection Period(in Days) Inventory Turnover
Quick Ratio Net working capital Ratio Inventory Period

FITABILITY RATIO Financial Leverage Ratio

30.71

75%
37% 0.18 0.15

Debt Ratio Interest Coverage Debt to equity ratio

Return on Assets Return on Equity

URRENT ASSETS CURRENT LIABILITIES

$350.00
$300.00
$250.00
$200.00
$150.00
$100.00
$50.00

il May June July Aug Sep Oct Nov Dec $0.00

Jan Feb Mar April May June July Aug Sep Oct Nov Dec

Equivalent Account Receivables

Short-Term Investment
nses & Others Account Payables Short-Term Debt Other Current Liabilities
O

Inventory Turnover

y ratio

p Oct Nov Dec

Current Liabilities
 Dashboard Balance Sheet Income Statement Ratio Analysis
Balance Sheet
Assests Jan Feb Mar April May

Assets
Current Assets

Cash & Cash Equivalent $555.00 $655.00 $570.00 $610.00 $615.00

Account Receivables $302.00 $901.00 $407.00 $812.00 $711.00
Inventories $450.00 $750.00 $633.00 $750.00 $615.00
Short-Term Investment $375.00 $550.00 $705.00 $650.00 $755.00
Prepaid Expenses & Others $250.00 $305.00 $450.00 $505.00 $600.00
Total Current Assets $1,932.00 $3,161.00 $2,765.00 $3,327.00 $3,296.00

Long-Term Assets

Long-Term Investment $450.00 $300.00 $335.00 $410.00 $555.00

Intangible Assets $450.00 $300.00 $335.00 $410.00 $555.00
Other Assets $450.00 $300.00 $335.00 $410.00 $555.00
Total Assests $3,282.00 $4,061.00 $3,770.00 $4,557.00 $4,961.00

Liabilities
Current Liabilities

Account Payables $205.00 $160.00 $170.00 $315.00 $140.00

Short-Term Debt $110.00 $195.00 $155.00 $295.00 $175.00
Other Current Liabilities $75.00 $110.00 $215.00 $255.00 $205.00
Total Current Liabilities $390.00 $465.00 $540.00 $865.00 $520.00

Long-Term Liabililties

Long-Term Debt $150.00 $110.00 $90.00 $140.00 $115.00

Other Liabilities $150.00 $110.00 $90.00 $140.00 $115.00
Total Liabilities $690.00 $685.00 $720.00 $1,145.00 $750.00

Shareholder's Equity

Misc. Stock Option Warrant $185.00 $210.00 $225.00 $275.00 $305.00

Redeemable Preferred $185.00 $210.00 $225.00 $275.00 $305.00
Preferred Stock $185.00 $210.00 $225.00 $275.00 $305.00
Common Stock $185.00 $210.00 $225.00 $275.00 $305.00
Retained Earnings $185.00 $210.00 $225.00 $275.00 $305.00
Treasury Stock $185.00 $210.00 $225.00 $275.00 $305.00
 Capital Surplus $185.00 $210.00 $225.00 $275.00 $305.00
Other Stockholder Equity $185.00 $210.00 $225.00 $275.00 $305.00

Total Stockholder Equity $1,480.00 $1,680.00 $1,800.00 $2,200.00 $2,440.00

Net Assets $5,452.00 $6,426.00 $6,290.00 $7,902.00 $8,151.00

 Ratio Analysis

June July Aug Sep Oct Nov Dec Total Annualy

$535.00 $585.00 $575.00 $635.00 $625.00 $610.00 $600.00 $7,170.00

$415.00 $600.00 $750.00 $550.00 $800.00 $700.00 $850.00 $7,798.00
$711.00 $355.00 $675.00 $611.00 $801.00 $905.00 $700.00 $7,956.00
$615.00 $801.00 $775.00 $801.00 $750.00 $801.00 $650.00 $8,228.00
$705.00 $475.00 $850.00 $901.00 $775.00 $845.00 $405.00 $7,066.00
$2,981.00 $2,816.00 $3,625.00 $3,498.00 $3,751.00 $3,861.00 $3,205.00 $38,218.00

$475.00 $435.00 $410.00 $575.00 $480.00 $510.00 $525.00 $5,460.00

$475.00 $435.00 $410.00 $575.00 $480.00 $510.00 $525.00 $5,460.00
$475.00 $435.00 $410.00 $575.00 $480.00 $510.00 $525.00 $5,460.00
$4,406.00 $4,121.00 $4,855.00 $5,223.00 $5,191.00 $5,391.00 $4,780.00 $54,598.00

$255.00 $215.00 $195.00 $215.00 $175.00 $155.00 $135.00 $2,335.00

$305.00 $255.00 $205.00 $265.00 $195.00 $185.00 $215.00 $2,555.00
$115.00 $145.00 $215.00 $250.00 $210.00 $195.00 $170.00 $2,160.00
$675.00 $615.00 $615.00 $730.00 $580.00 $535.00 $520.00 $7,050.00

$110.00 $130.00 $90.00 $115.00 $140.00 $119.00 $100.00 $1,409.00

$110.00 $130.00 $90.00 $115.00 $140.00 $119.00 $100.00 $1,409.00
$895.00 $875.00 $795.00 $960.00 $860.00 $773.00 $720.00 $9,868.00

$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00

$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00
$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00
$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00
$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00
$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00
 $315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00
$315.00 $290.00 $285.00 $275.00 $325.00 $320.00 $299.00 $3,309.00

$2,520.00 $2,320.00 $2,280.00 $2,200.00 $2,600.00 $2,560.00 $2,392.00 $26,472.00

$7,821.00 $7,316.00 $7,930.00 $8,383.00 $8,651.00 $8,724.00 $7,892.00 $90,938.00

 Dashboard Balance Sheet Income Statement Ratio Analysis

Income Statement
Jan Feb Mar April May June
Sales $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00
Cost of Sales $2,200.00 $2,200.00 $2,200.00 $2,200.00 $2,200.00 $2,200.00
Gross Profit $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00
Selling Expenses $150.00 $150.00 $150.00 $150.00 $150.00 $150.00
General and Admin. Expenses $500.00 $500.00 $500.00 $500.00 $500.00 $500.00
Operating Profit $2,150.00 $2,150.00 $2,150.00 $2,150.00 $2,150.00 $2,150.00
Interest Expense $70.00 $70.00 $70.00 $70.00 $70.00 $70.00
EBIT $2,080.00 $2,080.00 $2,080.00 $2,080.00 $2,080.00 $2,080.00
Income Tax 20% $416.00 $416.00 $416.00 $416.00 $416.00 $416.00

Net Income $1,664.00 $1,664.00 $1,664.00 $1,664.00 $1,664.00 $1,664.00

7,200.00
Ratio Analysis 2

July Aug Sep Oct Nov Dec Total

$5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $60,000.00
$2,200.00 $2,200.00 $2,200.00 $2,200.00 $2,200.00 $2,200.00 $26,400.00
$2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $33,600.00
$150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $1,800.00
$500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $6,000.00
$2,150.00 $2,150.00 $2,150.00 $2,150.00 $2,150.00 $2,150.00 $25,800.00
$70.00 $70.00 $70.00 $70.00 $70.00 $70.00 $840.00
$2,080.00 $2,080.00 $2,080.00 $2,080.00 $2,080.00 $2,080.00 $24,960.00
$416.00 $416.00 $416.00 $416.00 $416.00 $416.00 $4,992.00

$1,664.00 $1,664.00 $1,664.00 $1,664.00 $1,664.00 $1,664.00 $19,968.00

 Dashboard Balance Sheet Income Statement Ratio Analysis

Financial Ratios
Jan Feb Mar April May June
Current Ratio 4.95 6.80 5.12 3.85 6.34 4.42
Quick Ratio/Acid test 3.80 5.18 3.95 2.98 5.16 3.36
Account Recievable Turnover $16.56 $5.55 $12.29 $6.16 $7.03 $12.05
Average Collection Period (in Days) 1.812 5.406 2.442 4.872 4.266 2.49
Inventory Turnover 4.89 2.93 3.48 2.93 3.58 3.09
Days Sales in Inventory 6.14 10.23 8.63 10.23 8.39 9.70
inventory to Networking Capital 0.29 0.28 0.28 0.30 0.22 0.31
Debt Ratio 0.21 0.17 0.19 0.25 0.15 0.20
Time Interest Earn to Income 30.71 30.71 30.71 30.71 30.71 30.71
Total Assets to Equity 2.22 2.42 2.09 2.07 2.03 1.75
Total Liabilities to Total Assets 0.21 0.17 0.19 0.25 0.15 0.20
Total Liabilities to Equity 0.47 0.41 0.40 0.52 0.31 0.36
Interest Bearing Debt to Equity 0.18 0.18 0.14 0.20 0.12 0.16
Long-Term Debt to Long-Term Capital 0.09 0.06 0.05 0.06 0.05 0.04

Profitability Ratios
Return on Assets 0.51 0.41 0.44 0.37 0.34 0.38
Return on Equity 1.12 0.99 0.92 0.76 0.68 0.66
Gross Margin 0.56 0.56 0.56 0.56 0.56 0.56
Operating Margin 0.43 0.43 0.43 0.43 0.43 0.43
Profit Margin 0.33 0.33 0.33 0.33 0.33 0.33
Total Assets Turnover 1.52 1.23 1.33 1.10 1.01 1.13
Current Assets Turnover 2.59 1.58 1.81 1.50 1.52 1.68
Dupont Return on Investment 0.51 0.41 0.44 0.37 0.34 0.38
Modified Dupont Return on Equity 1.12 0.99 0.92 0.76 0.68 0.66
Ratio Analysis

July Aug Sep Oct Nov Dec Total Annualy

4.58 5.89 4.79 6.47 7.22 6.16 5.42 66.59
4.00 4.80 3.95 5.09 5.53 4.82 4.29
$8.33 $6.67 $9.09 $6.25 $7.14 $5.88 $7.69
3.6 4.5 3.3 4.8 4.2 5.1 47.44
6.20 3.26 3.60 2.75 2.43 3.14 3.32
4.84 9.20 8.33 10.92 12.34 9.55 9.04
0.16 0.22 0.22 0.25 0.27 0.26 0.26
0.21 0.16 0.18 0.17 0.14 0.15 0.18
30.71 30.71 30.71 30.71 30.71 30.71 30.71
1.78 2.13 2.37 2.00 2.11 2.00 2.06
0.21 0.16 0.18 0.17 0.14 0.15 0.18
0.38 0.35 0.44 0.33 0.30 0.30 0.37
0.17 0.13 0.17 0.13 0.12 0.13 0.15
0.05 0.04 0.05 0.05 0.04 0.04 0.05

0.40 0.34 0.32 0.32 0.31 0.35 0.37

0.72 0.73 0.76 0.64 0.65 0.70 0.75
0.56 0.56 0.56 0.56 0.56 0.56 0.56
0.43 0.43 0.43 0.43 0.43 0.43 0.43
0.33 0.33 0.33 0.33 0.33 0.33 0.33
1.21 1.03 0.96 0.96 0.93 1.05 1.10
1.78 1.38 1.43 1.33 1.30 1.56 1.57
0.40 0.34 0.32 0.32 0.31 0.35 0.37
0.72 0.73 0.76 0.64 0.65 0.70 0.75