• Company ABC is considering a ₤200,000 outlay for fixed capital items. This outlay includes ₤25,000 for land, plus ₤175,000 for equipment. Depreciation policy is straight-line to zero after five years. Capital allowance/Tax Writing Down Allowance is 20% per annum. The project requires ₤50,000 of current assets and ₤30,000 in current liabilities at the onset. • In Year 1, sales will be ₤220,000. They grow at 25% for the next two years and then grow at 10% for the last two years. Fixed cash operating expenses will be ₤30,000 for Years 1-3 and ₤20,000 for Years 4-5. Variable cash operating expenses are 30% of sales in Year 1, 40% of sales in Year 2 and 35% of sales in Years 3 to 5. Company X’s marginal tax rate is 30% and required rate of return is 10%. • At the end of year 5, the company will sell off the fixed capital investments for ₤50,000 and recapture its cumulative investment in net working capital. Income taxes will be paid on any gains. Assume that all cash flows arise at the end of the year. • Required: Determine whether this project is profitable using the NPV.
0 | 1 | 2 | 3 | 4 | 5 | |
Initial investment: | ||||||
Land | 25000 | |||||
Equipment | 175000 | |||||
NWC (50000-30000) | 20000 | |||||
Operating cash flows: | ||||||
Sales | 220000 | 275000 | 343750 | 378125 | 415938 | |
Fixed cash operating expenses | 30000 | 30000 | 30000 | 20000 | 20000 | |
Variable cash operating expenses | 66000 | 110000 | 120313 | 132344 | 145578 | |
Depreciation (175000*20%) | 35000 | 35000 | 35000 | 35000 | 35000 | |
NOI | 89000 | 100000 | 158438 | 190781 | 215359 | |
Tax at 30% | 26700 | 30000 | 47531 | 57234 | 64608 | |
NOPAT | 62300 | 70000 | 110906 | 133547 | 150752 | |
Add: Depreciation | 35000 | 35000 | 35000 | 35000 | 35000 | |
OCF | 97300 | 105000 | 145906 | 168547 | 185752 | |
After tax salvage value [50000-(50000-25000)*30%] | 42500 | |||||
Recovery of NWC | 20000 | |||||
Annual after tax project cash flows | -220000 | 97300 | 105000 | 145906 | 168547 | 248252 |
PVIF at 10% [1/1.1^n] | 1 | 0.90909 | 0.82645 | 0.75131 | 0.68301 | 0.62092 |
PV at 10% | -220000 | 88455 | 86777 | 109622 | 115120 | 154145 |
NPV | 334117 | |||||
THE PROJECT IS PROFITABLE AS ITS NPV IS POSITIVE. |
• Company ABC is considering a ₤200,000 outlay for fixed capital items. This outlay includes ₤25,000...
After estimating a project’s NPV, the analyst is advised that the fixed capital outlay will be revised upward by $73200. The fixed capital outlay is depreciated straight-line over a 6-year life. The tax rate is 40 percent, and the required rate of return is 9 percent. No changes in cash operating revenues, cash operating expenses, or salvage value are expected. What is the effect on the project NPV?
A company is considering a three-year project. New equipment will cost $200,000. The equipment falls in the MACRS three-year class (.3333, .4445, .1481, .0741) it will have a salvage value at the end of the project of $50,000. The project is expected to produce sales of $100,000 in the first year and sales will increase by $50,000 each year after that. Expense are expected to be 40% of sales. An investment in net-working capital of $5,000 is required at the...
A company is considering a three-year project. New equipment will cost $200,000. The equipment falls in the MACRS three-year class (.3333, .4445, .1481, .0741) it will have a salvage value at the end of the Project of $50,000. The project is expected to produce sales of $100,000 in the first year and sales will increase by $50,000 each year after that. Expenses are expected to be 40% of sales. An investment in net-working capital of $5000 is required at the...
ABC Company has an investment proposal. It requires an initial capital outlay of $20 million. The investment will increase revenue by $10 million, increase cash expenses by $2 million and noncash depreciation expense by $5 million each year for the next five years. ABC has a tax rate of 30% and a cost of capital of 10%. 1. Determine the cash flow of the investment. 2. Determine the net present value of the investment. Should the investment be accepted? 3....
Bate Manufacturing is considering a project with a 7 year life. The data for the project are given below. What is the free cash flow in Year 0 for this project? Sales revenue, each year: $150,000 Variable costs, each year: $20,000 Fixed costs, each year: $10,000 Depreciation expense, each year: $50,000 Initial outlay (i.e. cost of equipment): $300,000 Increase in Net Operating Working Capital: $30,000 Tax rate: 30%
The initial investment in Plant and Equipment will be $175,000. The equipment will be depreciated on a straight-line basis over 5 years with no expected salvage value. The project will also require an initial investment in net working capital of $30,000 which the company will recover at the end of the 5 year period. Sales are forecast to be $220,000 each year, with cash operating expenses of $90,000. The company tax rate is 30%, and their weighted average cost of...
Your company, Dominant Retailer, Inc., is considering a project whose data are shown below. Revenue and cash operating expenses are expected to be constant over the project's 5 year expected operating life; annual sales revenue is $95,000.00 and cash operating expenses are $39,750.00. The new equipment's cost and depreciable basis is $140,000.00 and it will be depreciated by MACRS as 5 year property. The new equipment replaces older equipment that is fully depreciated but can be sold for $7,500. In...
You are considering a project that will require an initial outlay of $200,000. This project has an expected life of four years and will generate after-tax cash flows to the company as a whole of $60,000 at the end of each year over its five-year life. Thus, the free cash flows associated with this project look like this: Year Free Cash Flow 0 -150,000 1 60,000 2 60,000 3 60,000 4 60,000 Given a required rate of return of 10%...
A company is considering a 6-year project that requires an initial outlay of $26,000. The project engineer has estimated that the operating cash flows will be $4,000 in year 1, $7,000 in year 2, $7,000 in year 3, $7,000 in year 4, $7,000 in year 5, and $9,000 in year 6. At the end of the project, the equipment will be fully depreciated, classified as 5-year property under MACRS. The project engineer believes the equipment can be sold for $6,000...
Management is considering the following investment project: Project Alpha Project Alpha Capital Outlay $100,000 Cash Income p.a. $59,000 Cash Expenses p.a. (other than tax) 19,000 Depreciation p.a. 10,000 Economic Life 10 years Salvage Value Zero Tax Rate Payable (paid in year of income) 30% Required Rate of Return 20% Required: Calculate the following (you may use a financial calculator or software): The Net Profit after Tax for all years and the Annual Cash Flow. NPV, IRR, ARR, PBP