Question

In: Finance

Estimate Cash flows of the three-year project by filling in the values in the table below....

Estimate Cash flows of the three-year project by filling in the values in the table below. ·   Equipment will cost $40,000, Shipping and installation charges for the equipment are expected to total $5,000. ·The Machine is depreciated using straight line method to a value of $0 at the end of it's life. ·Net working capital is $10,000 initially and $5,000 in year 1. All investment in net working capital is recovered back at the end of the project ·Total revenues will be $50,000 in year 1, $60,000 in year 2 and $75,000 in year 3. ·Operating costs = $25,000 during the first year and increase at a rate of 6 percent per year over the 3-year project ·Marginal tax rate is 40 percent. Cost of capital = 10%

Year 0 1 2 3

Revenue

-Operating Cost
- Depreciation
Operating Earnings Before Taxes
- Taxes (40%)
Operating Earnings After taxes
+ Depreciation
- Change in Net working Capital
- Initial Investment in Machinery
Net Cash Flows

Solutions

Expert Solution

net cash flow each year = earnings after taxes + depreciation - change in net working capital

Depreciation each year = (cost of equipment + shipping and installation cost) / life of project

Depreciation each year = ($40,000 + $5,000) / 3 = $15,000.


Related Solutions

Below is a table of expected cash flows for a potential project. Select all of the...
Below is a table of expected cash flows for a potential project. Select all of the capital budgeting rules that tell you to accept the project Year Cash Flow 0 -1200 1 150 2 475 3 650 4 475 NPV, discount rate of 12% 2 year Payback rule IRR, discount rate of 12% IRR, discount rate of 15%
Complete the table below by computing and filling in the missing values for (a) Avg. fixed...
Complete the table below by computing and filling in the missing values for (a) Avg. fixed Cost, (b) Avg. Variable cost, (c) Total Cost, (d) Avg. Total Cost, (E) Marginal cost (1) Quantity of Output, Q (units) (2) Total Fixed Cost ($) (3) Average Fixed Cost (AFC) (4) Total Variable Cost (TVC) (5) Average Variable Cost (AVC) (6) Total Cost (TC) (7) Average Total Cost (ATC) (8) Marginal cost (MC) 0 $200 $0 1 200 30 2 200 50 3...
6. The table below shows the projected free cash flows of an acquisition target. Estimate the...
6. The table below shows the projected free cash flows of an acquisition target. Estimate the following: a) Terminal value at the end of 2025 based on the perpetual growth equation with a 4% perpetual growth rate b) Maximum acquisition price (MAP) as of the end of 2020 at a 9% discount rate YEAR                                                               2021    2022   2023   2024   2025 FREE CASH FLOW ($ thousands)                  -$500      $83    $87    $89     $92 The Present Value of $1 Table (Table 3)...
The cash flows for three independent projects are found below. Year 0 (Initial investment) Project A...
The cash flows for three independent projects are found below. Year 0 (Initial investment) Project A $(45,000) Project B $(120,000) Project C $(460,000) Year 1 $12,000    $ 30,000 $ 220,000 Year 2 $14,000 $ 30,000 $ 220,000 Year 3 $ 19,000 $ 30,000 $   220,000 Year 4 $ 27,000 $ 30,000 - Year 5    a. Calculate the IRR for each of the projects. b. If the discount rate for all the three projects is 16 percent, which projects...
Use the following set of cash flows for the questions below: Table A Year Cash Flow...
Use the following set of cash flows for the questions below: Table A Year Cash Flow 1 $5,973 2 $18,662 3 $61,839 4 $66,528 5 $68,052 6 $73,559             2. Using the cash flows in Table A, determine the present value of the cash flow stream at the following discount rates: 3%, 8%, 12%, 18%, and 22%. (Use a data table to complete these calculations. (please show how to do in excel, having a hard time figuring out how to...
The project has the following cash flows and salvage values and cost of capital 8%: Year...
The project has the following cash flows and salvage values and cost of capital 8%: Year Cash flows Salvage 0 -5000 4000 1 2500 3500 2 3200 1800 3 1600 900 4 1000 0 What are the physical life and the economic life for this project? A. Physical life of this project is 3 years with economic life of 4 years. B. Physical life of this project is 4 years with economic life of 1 year. C. Physical life of...
Given the cash-flows in the table, what is the NPV of project A?
1. Project A Year Cash Flow 0 -$107 1 $69 2 $80 3 $120 WACC = 6.19% Given the cash-flows in the table, what is the NPV of project A?   State your answer to the nearest penny. Give just the number with no dollar sign (e.g., 3.26) If the NPV is negative include the - sign (e.g. -4.28) 2. Using the information in the table, what is the IRR for Project A? Cash Flow Year Project A 0 ($175) 1...
The cash flows and Net salvage value of Project X is given the following table: Year...
The cash flows and Net salvage value of Project X is given the following table: Year Cash flows Salvage Value 0 -5,800 4,800 1 2,100 3,000 2 3,400 2,200 3 3,600 1,800 4 1,800 0 Based on the Economic Life of this project and the cost of capital is 12%, in what year should you abandoning this Project X? A. Year 3, since NPV in year 3 = $8,429 B. Year 3, since NPV in year 3 = $2,629 C....
CRA Company is considering three investment opportunities with cash flows as described below: Project C: Cash...
CRA Company is considering three investment opportunities with cash flows as described below: Project C: Cash investment now………………………………… $ 16,000 Annual Cash inflow for 5 years……………………… $ 10,000 Cash outflow at the end of 3 years…………………..$ 3,000 Additional cash inflow at the end of 5 years……….. $12,000 Project R: Cash investment now…………………………………. $ 7,000 Cash inflow at the end of 2 years……….…………… $ 18,000 Cash inflow at the end of 7 years……………………. $ 40,000 Project A: Cash investment now………………………………….. $...
A four-year financial project has estimates of net cash flows shown in the following table: Year...
A four-year financial project has estimates of net cash flows shown in the following table: Year Net Cash Flow 1 $20,000 2 25,000 3 30,000 4 35,000 It will cost $65,000 to implement the project, all of which must be invested at the beginning of the project. After the fourth year, the project will have no residual value. Using the most likely estimates of cash flows, conduct a discounted cash flow calculation assuming a 20 percent hurdle rate with no...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT