Zoho Sheet

[Company Name]
Ratio Analysis
Input Worksheet
[Date]

Gray cells will be calculated for you. You do not need to enter anything into them.

Line Item	Beginning of Year
Inventory	$12,500
Total assets	$120,000
Owners' equity	$29,000
Number of common shares	25,000


Line Item	Q1	Q2	Q3	Q4	Annual
Current assets	45,000	46,000	46,500	43,000	$43,000
Fixed assets	80,000	80,000	80,000	80,000	$80,000
Total assets	125,000	126,000	126,500	123,000	$123,000
Average total assets	122,500	123,000	123,250	121,500	$121,500
Cash and cash equivalents	15,000	18,000	16,500	14,350	$14,350
Inventory	15,000	18,000	16,500	14,350	$14,350
Average inventory	13,750	15,250	14,500	13,425	$13,425
Current liabilities	23,000	25,000	22,500	25,600	$25,600
Total liabilities	125,000	125,000	125,000	125,000	$125,000
Owners' equity	28,000	30,900	32,000	28,000	$28,000
Number of common shares	25,000	25,000	25,000	25,000	25,000
Average number of common shares	25,000	25,000	25,000