Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Life Insurance In Europe Risk Analysis And Market Challenges Financial And Monetary Policy

Authors: Marta Borda, Simon Grima, Ilona Kwiecien

2020th Edition

3030496546, 978-3030496548

More Books

Students also viewed these Finance questions

Question

1. In what sense is reading both a physical and mental activity.

Answered: 1 week ago