Financial Ratio Analysis Model

	A	B	C	D	E
1	Financial Ratio Analysis Model
2	Try RizzCalc.com - Use AI to build any models instantly
3	Metric	FY2022	FY2023	FY2024	FY2025
4	Assumptions
5	Base Revenue	$1,200,000
6	Revenue Growth %	10.0%	10.0%	10.0%	10.0%
7	Gross Margin %	62.0%	62.0%	62.0%	62.0%
8	Operating Expenses % of Revenue	28.0%	28.0%	28.0%	28.0%
9	Interest Rate on Debt	5.0%	5.0%	5.0%	5.0%
10	Tax Rate	25.0%	25.0%	25.0%	25.0%
11	Days Sales Outstanding (DSO)	45	45	45	45
12	Days Inventory Outstanding (DIO)	50	50	50	50
13	Days Payables Outstanding (DPO)	40	40	40	40
14	Fixed Asset Turnover (x)	2.5x	2.5x	2.5x	2.5x
15	Debt % of Revenue	20.0%	20.0%	20.0%	20.0%
16	Short-term Debt % of Total Debt	30.0%	30.0%	30.0%	30.0%
17	Cash % of Revenue	5.0%	5.0%	5.0%	5.0%
18
19	Income Statement Summary
20	Revenue	$1,200,000	$1,320,000	$1,452,000	$1,597,200
21	Cost of Goods Sold (COGS)	$456,000	$501,600	$551,760	$606,936
22	Gross Profit	$744,000	$818,400	$900,240	$990,264
23	Operating Expenses	$336,000	$369,600	$406,560	$447,216
24	EBIT	$408,000	$448,800	$493,680	$543,048
25	Interest Expense	$12,000	$13,200	$14,520	$15,972
26	Earnings Before Taxes (EBT)	$396,000	$435,600	$479,160	$527,076
27	Taxes	$99,000	$108,900	$119,790	$131,769
28	Net Income	$297,000	$326,700	$359,370	$395,307
29
30	Balance Sheet Summary
31	Cash	$60,000	$66,000	$72,600	$79,860
32	Accounts Receivable	$147,945	$162,740	$179,014	$196,915
33	Inventory	$62,466	$68,712	$75,584	$83,142
34	Net PP&E	$480,000	$528,000	$580,800	$638,880
35	Total Assets	$750,411	$825,452	$907,997	$998,797
36	Accounts Payable	$49,973	$54,970	$60,467	$66,514
37	Short-term Debt	$72,000	$79,200	$87,120	$95,832
38	Long-term Debt	$168,000	$184,800	$203,280	$223,608
39	Total Debt	$240,000	$264,000	$290,400	$319,440
40	Total Liabilities	$289,973	$318,970	$350,867	$385,954
41	Total Equity	$460,438	$506,482	$557,130	$612,843
42
43	Financial Ratios
44	Liquidity - Current Ratio	2.22x	2.22x	2.22x	2.22x
45	Liquidity - Quick Ratio	1.70x	1.70x	1.70x	1.70x
46	Leverage - Debt to Equity	0.52x	0.52x	0.52x	0.52x
47	Leverage - Interest Coverage	34.00x	34.00x	34.00x	34.00x
48	Profitability - Gross Margin %	62.0%	62.0%	62.0%	62.0%
49	Profitability - Operating Margin %	34.0%	34.0%	34.0%	34.0%
50	Profitability - Net Margin %	24.8%	24.8%	24.8%	24.8%
51	Returns - ROA	39.6%	41.5%	41.5%	41.5%
52	Returns - ROE	64.5%	67.6%	67.6%	67.6%
53	Efficiency - Asset Turnover	1.60x	1.68x	1.68x	1.68x
54	Efficiency - Inventory Turnover	7.30x	7.65x	7.65x	7.65x
55	Efficiency - Receivables Days	45	45	45	45
56	Efficiency - Payables Days	40	40	40	40
57	Working Capital	$148,438	$163,282	$179,610	$197,571
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100