Question

Please calculate the expected free cash flow (FCF) for year 2024 given the following information: Income...

Please calculate the expected free cash flow (FCF) for year 2024 given the following information:

Income Statement
2023 E 2024 E
Sales 11,388,031.20 14,804,440.56
COGS except depr.     7,102,598.40     8,523,118.08
Other expenses        714,603.51        778,917.83
Depreciation          138,240.00        165,888.00
        Total Expenses     7,955,441.91     9,467,923.91
         EBIT     3,432,589.29     5,336,516.65
Int. expense        987,681.86        967,651.27
         EBT     2,444,907.43     4,368,865.38
Taxes (21%)        513,430.56        917,461.73
Net Income     1,931,476.87     3,451,403.65
Balance Sheet: Asset
2023 E 2024 E
Cash          24,336.00          31,636.80
S-T Investment          80,216.06          96,259.28
Accounts Receivable (AR)     1,448,636.00     2,028,090.40
Inventories     1,529,383.68     1,376,445.31
Total CA     3,082,571.74     3,532,431.79
Net FA     1,202,003.19     1,298,163.45
Total Assets     4,284,574.94     4,830,595.24
Balance Sheet: Liabilities & Equity
2023 E 2024 E
Accounts Payable (AP)        419,904.00        503,884.80
Notes Payable (NP)     1,460,160.00     1,898,208.00
Accruals        402,135.55        482,562.66
Total CL     2,282,199.55     2,884,655.46
Long-term debt     1,382,776.92     1,286,741.77
Common Stock        487,600.00        487,600.00
Retained Earnings        131,998.46        171,598.00
Total Equity        619,598.46        659,198.00
Total L&E     4,284,574.94     4,830,595.24

Homework Answers

Answer #1

Answer:

Free cash flows
Cash flows from operating activities:
Net income $3,451,403.65
Adjustments:
Depreciation $165,888
Increase in short-term investments ($16,043.22)
Increase in accounts receivable ($579,454.4)
Decrease in inventories $152,938.37
Net cash flows from operating activities $3,174,732.40
(Less): Purchase of fixed assets ($69,727.74)
Free cash flows $3,105,004.66

Calculations:

Net fixed assets, 2023 $1,202,003.19
Depreciation expense of 2024 $165,888
Net fixed assets, 2024 ($1,298,163.45)
Purchase of fixed assets $69,727.74
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please calculate the expected free cash flow (FCF) for year 2024 given the following information: Income...
Please calculate the expected free cash flow (FCF) for year 2024 given the following information: Income Statement 2023 E 2024 E Sales 11388031 14804441 COGS except depr. 7102598 8523118 Other expenses 714603.5 778917.8 Depreciation 138240 165888        Total Expenses 7955442 9467924         EBIT 3432589 5336517 Int. expense 987681.9 967651.3         EBT 2444907 4368865 Taxes (21%) 513430.6 917461.7 Net Income 1931477 3451404 Balance Sheet: Asset 2023 E 2024 E Cash 24336 31636.8 S-T Investment 80216.06 96259.28 Accounts Receivable (AR) 1448636 2028090...
A company has the following income statement and balance sheet: INCOME STATEMENT Sales $1,000 Costs 600...
A company has the following income statement and balance sheet: INCOME STATEMENT Sales $1,000 Costs 600 Depreciation 240 EBIT $ 160 Interest expenses 60 EBT $ 100 Taxes (40%) 40 Net income $ 60 BALANCE SHEET Cash $ 20 Accounts payable $ 30 Short-term investments 30 Accruals 50 Accounts receivable 20 Notes payable 10 Inventory 60 Current liabilities 90 Current assets 130 Long-term debt 70 Gross fixed assets 140 Common stock 30 Accumulated deprec. 40 Retained earnings 40 Net fixed...
USE THE INCOME STATEMENT AND BALANCE SHEET SHOWN BELOW TO DEVELOP THE STATEMENT OF CASH FLOW...
USE THE INCOME STATEMENT AND BALANCE SHEET SHOWN BELOW TO DEVELOP THE STATEMENT OF CASH FLOW YEAR T + 1 Revenue $5700 COGS $4560 Gross Profit $1140 Operating expenses $500 Depreciation $27 Ebit $613 Interest Expenses $35 EBT $578 Taxes $231.20 NI $346.80 Dividends $0 CHANGE IN RE $346.80 BALANCE SHEET YEAR T + 1                                 YEAR T CASH AND EQUIVALENTS -                              $714.80.                                       $120 ACCOUNTS RECEIVABLE -                               $500                                               $500 INVENTORY -                                                   $300                                                $340 TOTAL CURRENT ASSETS -                             ...
Input Tesla, Inc. 2017 Income Statement Other Inputs Sales        40,259,230 Tax rate 40% COGS       ...
Input Tesla, Inc. 2017 Income Statement Other Inputs Sales        40,259,230 Tax rate 40% COGS        29,336,446 Growth rate 15% Other expenses           5,105,100 Capacity Utilization 100% Depreciation           1,804,220 EBIT           4,013,464 Interest              630,520 Taxable income           3,382,944 Taxes (40%)           1,353,178 Net income           2,029,766 Dividends              610,000 Add to RE           1,419,766 Tesla, Inc. Balance Sheet as of December 2017 Assets Liabilities & Equity Current Assets Current Liabilities    Cash              456,435    Accounts Payable          ...
Cash                             10            Acc
Cash                             10            Accounts Payable                       6 Receivables                   12            Notes payable                             8 Inventories                    50            Other Current Liabilities          4 Total CA                        72               Total CL                                 18                                                                  L-T debt                          78 Net Fixed Assets           44             Common Equity                        20 Total Assets        116      Total L+E                116    Income Statement (year ended Dec 31, 2019—in $) Sales                                                                                                                              2,000 Cost of Goods Sold (materials, labor, heat, light, power, indirect labor, dep.)   500                              Gross Profit                                                                                                                    1,500 SGA Expenses                                                                                                                    700             EBIT                                                                                                                       800 Interest Expense                                                                                                    30             EBT                                                                                                                        770 Taxes (30%)                                                                                                                       231 Net Income                                                                                                                539 Using the data from the balance sheet and income statement above for the FY20 company, calculate the following ratios:...
Please- only typewritten answers, no handwritten answers, please. The Excel file attached contains the Balance Sheet...
Please- only typewritten answers, no handwritten answers, please. The Excel file attached contains the Balance Sheet and Income Statement for ABC Corp. ABC Corp is currently planning for next year's sales and asked their financial analysts to prepare a financial plan for the next year so the company can begin to address any outside investment requirements. Calculate the internal growth rate and sustainable growth rate for ABC Corp. What do these numbers mean? Income Statement Sales $80,518,460 COGS -$58,672,892 Other...
During the coming year, Gold & Gold wants to increase its free cash flow (FCF) by...
During the coming year, Gold & Gold wants to increase its free cash flow (FCF) by $220 million, which should result in a higher EVA and stock price. The CFO has made these projections for the upcoming year: EBIT is projected to equal $850 million. Gross capital expenditures are expected to total to $360 million versus depreciation of $120 million, so its net capital expenditures should total $240 million. The tax rate is 40%. There will be no changes in...
The Eagle Feather Fabric Company expects to complete the current year with the financial results given...
The Eagle Feather Fabric Company expects to complete the current year with the financial results given below. Forecast next year using a modified percentage of sales method assuming no dividends are paid and no new stock is sold along with the following: A 17% growth in sales and a 40% growth in net fixed assets. A 15% growth in sales with a 10% growth in expenses and a 20% growth in net fixed assets. (Note that negative debt means the...
Please refer to the following information to answer all of question 1: Income statement (millions of...
Please refer to the following information to answer all of question 1: Income statement (millions of dollars) Net sales $ 137,579 COGS $ 102,180 Other Expenses $ 17,171 Depreciation $ 8,514 EBIT $   9,714 Interest Expense $   255 Income Before Tax $   9,459 Tax Expense (35%) $   3,311 Net income $ 6,148 Dividends $   2,500 Balance sheet (millions of dollars) Cash $ 700 Accounts Receivable $ 12,000 Inventories $ 7,500     Other Assets $ 5,000 Property, Plant and Equipment, net $110,000...
During the coming year, Gold & Gold wants to increase its free cash flow (FCF) by...
During the coming year, Gold & Gold wants to increase its free cash flow (FCF) by $200 million, which should result in a higher EVA and stock price. The CFO has made these projections for the upcoming year: EBIT is projected to equal $850 million. Gross capital expenditures are expected to total to $360 million versus depreciation of $120 million, so its net capital expenditures should total $240 million. The tax rate is 40%. There will be no changes in...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT