CASH FLOW IN YEAR 0 | ||||||||
a | Cost of equipment | ($175,000) | ||||||
b | Depreciation tax shield =175000*25% | $43,750 | ||||||
c | Increase in current assets | ($35,000) | ||||||
d | Increase in current liabilities | $15,000 | ||||||
e=a+b+c+d | Cash Flow in Year 0 | ($151,250) | ||||||
Cash Flow in Year 1 and 2: | ||||||||
f | Sales Revenue=115000*3.25 | $373,750 | ||||||
g | Variable costs =115000*1,95 | -$224,250 | ||||||
h | Fixed costs | ($70,000) | ||||||
j=f+g+h | Before tax profit | $79,500 | ||||||
k=j*25% | Tax expense | -$19,875 | ||||||
l=j-k | After tax profit | $59,625 | ||||||
Cash flow in year 1 and2 | $59,625 | |||||||
Before tax salvage value | $15,000 | |||||||
After tax salvage Value | $11,250 | 15000*(1-0.25) | ||||||
Cash Flow in Year 3=59625+11250 | $70,875 | |||||||
Present Value of Cash Flow =(Cash Flow)/((1+i)^N) | ||||||||
i=discount rate =WACC=10%=0.1 | ||||||||
N=Year of Cash Flow | ||||||||
N | CF | PV=CF/(1.1^N) | ||||||
Year | Cash Flow | Present Value | Cumulative Cash Flow | |||||
0 | ($151,250) | ($151,250) | ($151,250) | |||||
1 | $59,625 | $54,205 | ($91,625) | |||||
2 | $59,625 | $49,277 | ($32,000) | |||||
3 | $70,875 | $53,249 | $38,875 | |||||
SUM | $5,481 | |||||||
Net Present Value (NPV)=Sum of PV | $5,481 | |||||||
Payback Period=Period in which Cumulative Cash Flow=NIL | ||||||||
Payback Period=2+(32000/53249) | 2.60 | Years | ||||||
Internal Rate of Return (IRR) | 12.0% | (Using IRR function of excel over Cash Flow) | ||||||
ModifiedInternal Rate of Return (MIRR) | 11.3% | (Using MIRR function of excel over Cash Flow) | ||||||
|
Comprehensive/Spreadsheet Problem 12-18 NEW PROJECT ANALYSIS You must analyze a potential new product-a caulking com- pound...
The answer should include the relevant formula or equation and the final numbers You must analyze a potential new product—a caulking compound that Cory Materials' R&D people developed for use in the residential construction industry. Cory's marketing manager thinks the company can sell 115,000 tubes per year for 3 years at a price of $3.25 each, after which the product will be obsolete. The required equipment would cost $150,000, plus another $15,000 for shipping and installation. Current assets (receivables and...
You must analyze a potential new product-a caulking compound that Cory Materials' R&D people developed for use in the residential construction industry. Cory's marketing manager thinks they can sell 115,000 tubes per year at a price of $3.25 each for 3 years, after which the product will be obsolete. The required equipment would cost $150,000, plus another $25,000 for shipping and installation. Current assets (receivables and inventories) would increase by $35,000, while current liabilities (accounts payable and accruals) would rise...
You must analyze a potential new product --- a caulking compound that Korry Materials’ R&D people developed for use in the residential construction industry. Korry’s marketing manager thinks they can sell 115,000 tubes per year at a price of $3.25 each for 3 years, after which the product will be obsolete. The required equipment would cost $125,000, plus another $25,000 for shipping and installation. Current assets (receivables and inventories) would increase by $35,000, while current liabilities (accounts payables and accruals)...
Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A Project B 0 ($30) ($30) 1 $5 $20 2 $10 $10 3 $15 $8 4 $20 $6 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. WACC = 10% Use Excel's NPV function as explained in NPVA...
Problem 11-12 New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the...
New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the project's 5-year...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $131 $131 $131 $131 $131 $131 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Project A NPV: $ 200.41 Project...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $131 $131 $131 $131 $131 $131 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each...
12-8. NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department. The purchase price of the spectrometer including modifications is $170,000, and the equipment will be fully depreciated at the time of purchase. The equipment would be sold after 3 years for $60,000. The equipment would require an $8,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $50,000 per...
Don't need explanations, just comparing my answers. Thank you. Fuzzy Button Clothing Company is analyzing a project that requires an initial investment of $2,500,000. The project's expected cash flows are: Year Cash Flo Year 1 $350,000 Year 2 -175,000 Year 3 400,000 Year 4 425,000 Fuzzy Button Clothing Company's WACC is 7%, and the project has the same risk as the firm's average project. Calculate this project's modified internal rate of return (MIRR). О О О O 19.71% 18.68% 16.60%...