VESPER

Model Practice

Unseen case: Corvale Instruments · Test

Exit
D17
fx
D17
Line item
BFY2023Actual
CFY2024Actual
DFY2025Proj
EFY2026Proj
FFY2027Proj
GFY2028Proj
HFY2029Proj
Assumptions and Drivers
2Revenue growth
14.0%
14.0%
14.0%
14.0%
14.0%
3COGS % of sales (excluding D&A)
61.0%
61.0%
61.0%
61.0%
61.0%
4SG&A % of sales
14.0%
14.0%
14.0%
14.0%
14.0%
5Depreciation % of beginning PP&E
12.0%
12.0%
12.0%
12.0%
12.0%
6Tax rate
24.0%
24.0%
24.0%
24.0%
24.0%
7DSO (days)
38
38
38
38
38
8Days inventory on hand
82
82
82
82
82
9DPO (days)
51
51
51
51
51
10Other current assets % of revenue
3.0%
3.0%
3.0%
3.0%
3.0%
11Accrued liabilities % of revenue
4.0%
4.0%
4.0%
4.0%
4.0%
12Deferred revenue % of revenue
2.0%
2.0%
2.0%
2.0%
2.0%
13Capex % of revenue
7.0%
7.0%
7.0%
7.0%
7.0%
14Interest rate
5.5%
5.5%
5.5%
5.5%
5.5%
15Dividend payout %
30.0%
30.0%
30.0%
30.0%
30.0%
Income Statement
17Revenue
28,000
31,920
18Revenue Growth
14.0%
14.0%
14.0%
14.0%
14.0%
14.0%
19COGS (excluding D&A)
16,992
19,522
20Gross Profit
11,008
12,398
21Gross Margin
39.3%
38.8%
22SG&A
3,920
4,469
23EBITDA
7,088
7,929
24Depreciation
1,488
1,545
1,627
25Operating Income / EBIT
5,600
6,384
26Interest Expense
495
495
495
495
495
495
495
27Pre-Tax Income
5,105
5,889
28Taxes
1,225
1,413
29Net Income
3,880
4,476
Balance Sheet
31Cash
6,003
7,942
32Accounts Receivable
2,915
3,323
33Inventory
3,949
4,502
34Other Current Assets
840
958
35Total Current Assets
13,707
16,725
36PP&E
12,872
13,561
37Total Assets
26,579
30,286
38Accounts Payable
2,430
2,770
39Accrued Liabilities
1,120
1,277
40Deferred Revenue
560
638
41Total Current Liabilities
4,110
4,685
42Debt
9,000
9,000
9,000
9,000
9,000
9,000
9,000
43Total Liabilities
13,110
13,685
44Contributed Capital
5,500
5,500
5,500
5,500
5,500
5,500
5,500
45Retained Earnings
7,969
11,101
46Total Stockholders' Equity
13,469
16,601
47Total Liabilities & Equity
26,579
30,286
48Balance Check
OK
OK
Cash Flow Statement
50Net Income
3,880
4,476
51Depreciation
1,488
1,545
1,627
52Change in Accounts Receivable
(358)
(408)
53Change in Inventory
(485)
(553)
54Change in Other Current Assets
(103)
(118)
55Change in Accounts Payable
298
340
56Change in Accrued Liabilities
138
157
57Change in Deferred Revenue
69
78
58Cash Flow From Operations
4,927
5,517
59Capital Expenditures
(1,960)
(2,234)
60Cash Flow From Investing
(1,960)
(2,234)
61Debt Issuance / Repayment
62Dividends
(1,164)
(1,343)
63Cash Flow From Financing
(1,164)
(1,343)
64Net Change in Cash
1,803
1,940
65Beginning Cash
4,200
6,003
7,942
66Ending Cash
6,003
7,942
Supporting Schedules
PP&E Schedule
69Beginning PP&E
12,400
12,872
13,561
70(+) Capital Expenditures
1,960
2,234
71(–) Depreciation
(1,488)
(1,545)
(1,627)
72Ending PP&E
12,872
13,561
Retained Earnings Schedule
74Beginning Retained Earnings
5,253
7,969
11,101
75(+) Net Income
3,880
4,476
76(–) Dividends
(1,164)
(1,343)
77Ending Retained Earnings
7,969
11,101