
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
- How much external funds would Batik Company need?arrow_forwardAFN 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_forwardYou 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_forward
- Given 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_forwardHh1.arrow_forward
- am. 146.arrow_forwardThe following are the cash flows of two projects: Project B Year Project A 0 $ (235) $ (235) 115 135 115 135 115 135 115 1234O 1 2 3 4 What are the internal rates of return on projects A and B? Note: Enter your answers as a percent rounded to 2 decimal places. Project A B IRR % %arrow_forwardWhat's the forecasted capital expenditure based on the information below? -Net PP&E beginning of period = 4200-Net PP&E end of period = 6800-Depreciation expenses = 900 a. 5900b. 1700c. 3500d. 2600arrow_forward
- Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: MaintenanceEquipment RampFacilities ComputerNetwork Amount to be invested $614,361 $418,741 $186,316 Annual net cash flows: Year 1 318,000 229,000 134,000 Year 2 296,000 206,000 92,000 Year 3 270,000 183,000 67,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Required: 1. Assuming that the desired rate of return is 20%, prepare a net present value analysis for each proposal. Use…arrow_forwardConsider the following cash flows for two mutually exclusive capital investment projects. The required rate of return is 16%. Use this information for the next 3 questions. Year Project A Cash Flow Project B Cash Flow ($50,000) ($20,000) 15,000 6,000 15,000 6,000 3 15,000 6,000 4 13,500 5,400 13,500 5,400 6,750 5,400arrow_forwardCalculate the change in Working Capital given the following: 2021 2020 A/R 370 A/P 175 A/R 295 A/P 155 INV 290 W/P 185 INV 255 W/P 135 W/C 2021 W/C 2020 Change in Working Capital =arrow_forward
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
