Based on the following information, how much capital expenditures did FIN3300F24 incur in 2023?
FIN3300F24
As of 12/31/23 |
As of 12/31/22 |
|
Cash |
$19,000 |
$54,000 |
A/R |
96,000 |
75,000 |
Inventories |
273,000 |
174,000 |
Total CA |
$388,000 |
$303,000 |
Gross FA |
750,000 |
540,000 |
Less: accumulated |
238,000 |
168,000 |
Net FA |
$512,000 |
$372,000 |
Total Assets |
$900,000 |
$675,000 |
Accounts payable |
$108,000 |
$51,000 |
Accruals |
27,000 |
12,000 |
Notes payable |
273,000 |
102,000 |
Total CL |
$408,000 |
$165,000 |
Long-term debt |
137,700 |
172,500 |
Common stock |
189,000 |
189,000 |
|
165,300 |
148,500 |
Total L & E |
$900,000 |
$675,000 |
FIN3300F24 Income Statement
2023 |
|
Sales |
$960,000 |
Cost of goods sold |
576,000 |
Gross profit |
$384,000 |
Operating expenses excluding depreciation |
$222,000 |
Depreciation |
70,000 |
Total operating expenses |
$292,000 |
EBIT |
$92,000 |
Interest expense |
36,600 |
Earnings before taxes |
$55,400 |
Taxes (21%) |
11,634 |
Net income |
$43,766 |
$70,000
$183,766
$140,000
$210,000
to generate a solution
a solution
- The following information was obtained from XYZ Corporation:2023EBIT $200,000Interest $50,000Depreciation $100,000Dividends $55,0002022 2023Long-term debt $600,000 $600,000Capital spending was $150,000 in 2023. The net new equity issuance was $50,000 in 2023. Theapplicable tax rate was 30% in year 2023.Calculate the change in net working capital for 2023. Show your calculation.arrow_forwardHow much external funds would Batik Company need?arrow_forwardBased on the following information, what was FIN3300F24's change in net operating working capital for 2023? FIN3300F24 Balance Sheet As of 12/31/23 As of 12/31/22 Cash $19,000 $54,000 A/R 96,000 75,000 Inventories 273,000 174,000 Total CA $388,000 $303,000 Gross FA 750,000 540,000 Less: accumulated depreciation 238,000 168,000 Net FA $512,000 $372,000 Total Assets $900,000 $675,000 Accounts payable $108,000 $51,000 Accruals 27,000 12,000 Notes payable 273,000 102,000 Total CL $408,000 $165,000 Long-term debt 137,700 172,500 Common stock 189,000 189,000 Retained earnings 165,300 148,500 Total L & E $900,000 $675,000 FIN3300F24 Income Statement 2023 Sales $960,000 Cost of goods sold 576,000 Gross profit $384,000 Operating expenses excluding depreciation $222,000 Depreciation…arrow_forward
- AFN EQUATION Refer to Problem 16-1. What additional funds would be needed if the companys year-end 2019 assets had been 4 million? Assume that all other numbers are the same. Why is this AFN different from the one you found in Problem 16-1? Is the companys capital intensity the same or different? Explain.arrow_forwardConsider two mutually exclusive investment alternatives given in the table below. Click the icon to view the cash flows for the projects. (a) Determine the IRR on the incremental investment in the amount of $5,000. (Assume that MARR = 11%.) The rate of return on the incremental investment is%. (Round to two decimal places.)arrow_forwardWhat is National Co.’s net operating working capital for 2022?arrow_forward
- You are given the following data for a project that is to be evaluated using the APV method. Year EBIT CAPEX 0 O $201.765 O $193,822 O $185,617 O $222,872 O $213,918 1 $127.000 $60,000 2 Depreciation Increase in NWC Year-end net debt $80,000 Cost of net debt = 8% Unlevered cost of capital = 11.8% Corporate tax rate = 30% Calculate the total value of the project at t = 0. using the APV method. $72,000 $50,000 $100,000 $133,000 $40,000 $80,000 $60,000 $140,000 3 $138.500 $10,000 $84,000 $30,000 $140,000arrow_forwardGiven the following information for 2023, what should be the additional funds needed (AFN) in 2024 if the sales become $2,000,000? Sales Net Income $1,600,000 $400,000 Total Assets Accounts Payable Accrued Liabilities Ending R/E Dividends -$50,000. -25,000. $75,000. $1,200,000 $250,000 $30,000 $100,000 $300,000 $0.00. $510,000. $25,000. $105,000.arrow_forwardThe following table tracks the main components of working capital over the life of a four-year project. 2021 2022 2023 2024 2025 Accounts receivable 0 174,000 249,000 214,000 0 Inventory 87,000 142,000 142,000 107,000 0 Accounts payable 31,000 56,000 62,000 41,000 0 Calculate net working capital and the cash inflows and outflows due to investment in working capital.arrow_forward
- Based on the following data, what is the amount of working capital? Accounts payable $55040 Accounts receivable 98040 Cash 60200 Intangible assets 86000 Inventory 118680 Long-term investments 137600 Long-term liabilities 172000 Short-term investments 68800 Notes payable (short-term) 48160 Property, plant, and equipment 1152400 1720 Prepaid insurance $280360 $318200 $244240 $285520arrow_forwardements What is the total Wealth Accumulation of the following investment assuming the available after tax reinvestment rate is 5%? IRR 10.70% O $4,690,000 O $4,821,078 O $4,848,844 $4,905.989 n 0 $ 1 S 2 $ 3 $ AS 5 $ Investment $ (3,000,000) 240,000 250,000 260,000 266,000 3,674,000arrow_forwardTo calculate the change in Net Working Capital (NWC) during FY24, we first need to find the NWC for both FY23 and FY24 using the formula: NWC=Current Assets−Current Liabilities Step 1: Calculate NWC for FY23 Current Assets (FY23): Cash: 211,000,000 Accounts Receivable: 508,000,000 Inventory: 41,000,000 Total Current Assets (FY23): 760,000,000 Current Liabilities (FY23): Accounts Payable: 622,000,000 Notes Payable: 377,000,000 Total Current Liabilities (FY23): 999,000,000 NWC (FY23)=760,000,000−999,000,000=−239,000,000 Step 2: Calculate NWC for FY24 Current Assets (FY24): Cash: 329,800,000 Accounts Receivable: 626,800,000 Inventory: 100,400,000 Total Current Assets (FY24): 1,057,000,000 Current Liabilities (FY24): Accounts Payable: 531,000,000 Notes Payable: 442,000,000 Total Current Liabilities (FY24): 973,000,000NWC (FY24)=1,057,000,000−973,000,000=84,000,000 Step 3: Calculate the Change in NWC during FY24 Change in NWC=NWC (FY24)−NWC…arrow_forward
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning