Machinery cost | 600000 |
Shipping costs | 20000 |
Installation | 50000 |
Total equipment costs | 670000 |
Change in working capital | 10000 |
Rate | Calculation | Value | |
Depreciation | 670000 | ||
Year 1 | 0.33 | =670000*0.33 | 221100 |
Year 2 | 0.45 | =670000*0.45 | 301500 |
Year 3 | 0.15 | =670000*0.15 | 100500 |
Year 4 | 0.07 | =670000*0.07 | 46900 |
Unit pice | 3 | 3 | 3 | 3 |
unit sales | 425000 | 425000 | 425000 | 425000 |
revenues | 1275000 | 1275000 | 1275000 | 1275000 |
operating costs | 637500 | 637500 | 637500 | 637500 |
depreciation | 221100 | 301500 | 100500 | 46900 |
other project effects | 20000 | 20000 | 20000 | 20000 |
before tax income | 396400 | 316000 | 517000 | 570600 |
taxes 40% | 158560 | 126400 | 206800 | 228240 |
Net income | 237840 | 189600 | 310200 | 342360 |
Plus depreciation | 221100 | 301500 | 100500 | 46900 |
Net Operating cash flow | 458940 | 491100 | 410700 | 389260 |
Salvage value | 100000 | |||
SV tax (40%) | 40000 |
All revenues and other costs are constant |
Net investment outlay | = price + freight +installation +Changes in netwroking capital |
=600000+20000+50000+10000 | |
Initial cost at year 0 | 680000 |
Project net cashflow in year 4 | =Salvage value - SV tax +recovery of net working capital +net operating cash flow |
=100000-40000+10000+389260 | |
459260 |
Production facilities for the lite orange juice product would be set up in an unused section...
Table 1 Year MACRS Depreciation Book Value 1 33% 221,100 448,900 2 45 301,500 147,400 3 15 100,500 46,900 4 7 46,900 0 100 670,000 See years 1 and 4 as examples in Table 1. In year 1, 3 X 425,000 = 1,275,000 – 637,500 – 221,100 – 20,000 = 396,400 – 158,560 = 237,840 + 221,100 = 458,940 = project NCF = after tax, end-of-year cash inflows, CFt. In year 4, 3 X 425,000 = 1,275,000 – 637,500 –...
The lemon juice would be produced in an unused building adjacent to Allied's Fort Myers plant; Allied owns the building, which is fully depreciated. The required equipment would cost $200,000, plus an additional $40,000 for shipping and installation. In addition, inventories would rise by $25,000, while accounts payable would increase by $5,000. All of these costs would be incurred at t 0. By a special ruling, the machinery could be depreciated under the MACRS system as 4-year property. The applicable...
Problem 1 Sugar Land Company is considering adding a new line to its product mix and the capital budgeting analysis is being conducted by a MBA student. The production line would be set up in urused space (Market Value Zero) in Sugar and main plant. Total cost of the machine is $300,000. The machinery has an economic if of 4 years and will be deprecated using MACRS for 3 year property dess. The machine will have a salvage value of...
suppose the project had involved replacement rather than
expansion of existing facilities. Describe briefly how the analysis
would have to be changed to deal with a placement project.
2 } / years DO,000 100,00 1 Module #5 - Indian Citrus NPV Analysis year o year I year 2 year} Initial Net Innestment -580,000 Net Opg Cash Flow (190,740 112,500 149,100 131,460 After thx Salvage value Recovery of NWC Net Anninal (ash flow -50,000 10,740 92,500 149,200 201,460 PV F at...
Case study expanding into the fruit juice business with a new fresh lemon juice Allied Food Products is considering expanding into the fruit juice business ntly hired as assistant to the director of capital budgeting, and you product. Assume that you were recently hired as assistant to the director of must evaluate the new project. The lemon juice w e produced in an unused building adiacent to Allied's Fort Myers plant; Allied owns the building lant: Allied owns the building,...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,070,000, and it would cost another $23,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $532,000. The machine would require an increase in net working capital (inventory) of $20,000. The sprayer would not change revenues, but it is...
Spacely Sprockets is considering increasing its production of sprockets at its Orbit City plant. You have been provided the following pieces of information on this ten year project. The expansion will require the purchase of machinery costing $50,000,000. The firm has spent $750,000 to train workers to use the new machinery. If the project is accepted, the firm expects to spend an additional $350,000 in training costs payable today (t=0). The sales from this project will be $20,000,000 per year....
MGMT-6005 Group Assignment # 4 (Due by March 31*') Refer Chapter 12 - Integrated Case: Allied Food Products (pp. 444 – 447) Topic: Cash Flow Estimation Assignment Objective: Project Cash Flow Projections and Investment Analysis Project ECF = (EBIT(1-t) +Dep. - Capex - Chng. NOWC) Examine Capital investment details for the expansion project. a) Incorporate Table IC 12.1 (page 444) in an Excel worksheet and fill in the missing information. Determine NPV (@ WACC discount rate of 10%) and IRR...
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by Sidney Johnson, a recently graduated MBA. The production line would be set up in unused space in the main plant. The machinery’s invoice price would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000 to install the equip- ment. The machinery has an economic life of 4 years, and...
New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $810,000, and it would cost another $23,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $628,000. The machine would require an increase in net working capital (inventory) of $19,500. The sprayer would not change revenues, but...