Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Forecast the sales in 2024. Estimate Sales Growth rate: uses the last 2 years growth rate by default Project the 2024 balance sheet and the
Forecast the sales in 2024.
Estimate Sales Growth rate: uses the last 2 years growth rate by default
Project the 2024 balance sheet and the 2024 income statement by the percent of sales method.
Use the projected data in the 2023 balance sheet and the 2024 income statement to calculate the FCF in 2024.
Income Statement | ||||
PERIOD ENDING | 31-Jan-23 | 31-Jan-22 | 31-Jan-21 | |
Total Revenue | 109,120,000 | 106,005,000 | 93,561,000 | |
Cost of Revenue | 82,229,000 | 74,963,000 | 66,177,000 | |
Gross Profit | 26,891,000 | 27,384,000 | 27,384,000 | |
Depreciation Amortization Depletion | 2,385,000 | 2,344,000 | 2,230,000 | |
Selling General and Administrative | 20,658,000 | 19,752,000 | 18,615,000 | |
Others | 0 | 0 | 0 | |
Total Operating Expenses | 23,043,000 | 22,096,000 | 20,845,000 | |
Operating Income | 3,848,000 | 5,288,000 | 6,539,000 | |
Operating Income or Loss | 3,914,000.00 | 9,033,000.00 | 6,827,000.00 | |
Total Other Income/Expenses Net | 48000 | 382000 | -16,000 | |
Earnings Before Interest And Taxes | 3,900,000 | 9328000 | 6011000 | |
Interest Expense | 482,000 | 421,000 | 465,000 | |
Income Before Tax | 3,418,000 | 8,907,000 | 5,546,000 | |
Income Tax Expense | 638,000.00 | 1,961,000.00 | 1,178,000.00 | |
Minority Interest | 0 | 0 | 0 | |
Net Income From Continuing Ops | 2,780,000.00 | 6,946,000.00 | 4,368,000.00 | |
Non-recurring Events | ||||
Discontinued Operations | 0 | 0 | 0 | |
Extraordinary Items | 0 | 0 | 0 | |
Effect Of Accounting Changes | 0 | 0 | 0 | |
Other Items | 0 | 0 | 0 | |
Net Income | 2,780,000.00 | 6,946,000.00 | 4,368,000.00 | |
Preferred Stock And Other Adjustments | 0 | 0 | 0 | |
Net Income Applicable To Common Shares | 2,780,000.00 | 6,946,000.00 | 4,368,000.00 | |
Balance Sheet | ||||
PERIOD ENDING | 31-Jan-23 | 31-Jan-22 | 31-Jan-21 | |
Assets | ||||
Current Assets | ||||
Cash And Cash Equivalents | 886,000.00 | 926,000.00 | 867,000.00 | |
Short Term Investments | 1,343,000.00 | 4,985,000.00 | 7,644,000.00 | |
Net Receivables | 1,695,000.00 | 1,353,000.00 | 1,135,000.00 | |
Inventory | 13,499,000.00 | 13,902,000.00 | 10,653,000.00 | |
Other Current Assets | 423,000.00 | 407,000.00 | 457,000.00 | |
Total Current Assets | 17,846,000.00 | 21,573,000.00 | 20,756,000.00 | |
Equity and Other Investments | ||||
Net Property Plant and Equipment | 56,800,000.00 | 51,874,000.00 | 49,384,000.00 | |
Goodwill | 631,000.00 | 631,000.00 | 631,000.00 | |
Other Intangible Assets | 14,000.00 | 25,000.00 | 37,000.00 | |
Accumulated Depreciation | -22,631,000.00 | -21,137,000.00 | -20,278,000.00 | |
Other Long-Term Assets | 447,000.00 | 605,000.00 | 638,000.00 | |
Tangible Other Assets | 228,000.00 | 240,000.00 | 80,000.00 | |
Total Assets | 53,335,000.00 | 53,811,000.00 | 51,248,000.00 | |
Liabilities | ||||
Current Liabilities | ||||
Accounts Payable | 11,887,000.00 | 15,478,000.00 | 12,859,000.00 | |
Short/Current Long Term Debt | 2,026,000.00 | 425,000.00 | 1,828,000.00 | |
Other Current Liabilities | 5,587,000.00 | 5,844,000.00 | 5,438,000.00 | |
Total Current Liabilities | 19,500,000.00 | 21,747,000.00 | 20,125,000.00 | |
Long Term Debt | 18,647,000.00 | 16,042,000.00 | 13,754,000.00 | |
Deferred Revenues | 449,000.00 | 479,000.00 | 509,000.00 | |
Deferred Taxes Liabilities | 2,196,000.00 | 1,566,000.00 | 990,000.00 | |
Provision for Risks & Charges | 37,000.00 | 45,000.00 | 57,000.00 | |
Other Non-Current Liabilities | 1,274,000.00 | 1,105,000.00 | 1,373,000.00 | |
Total Liabilities | 42,103,000.00 | 40,984,000.00 | 36,808,000.00 | |
Stockholders' Equity | ||||
Common Stock | 38,000.00 | 39,000.00 | 42,000.00 | |
Retained Earnings | 5,005,000.00 | 6,920,000.00 | 8,825,000.00 | |
Accumulated other comprehensive income | 6,189,000.00 | 5,868,000.00 | 5,573,000.00 | |
Adjustment for stockholders' Equity | 0 | 0 | 0 | |
Total Stockholder Equity | 11,232,000.00 | 12,827,000.00 | 14,440,000.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started