Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help solve this problem? Please solve using EXCEL spreadsheet and please show the Excel formulas used. Thank you ANSWER TO 12.9 (PROBLEM
Can you please help solve this problem? Please solve using EXCEL spreadsheet and please show the Excel formulas used. Thank you
ANSWER TO 12.9 (PROBLEM 3) THIS HAS FOUR PARTS (A, B, C, & D) Prob1 Prob2 Prob3 Prob4 Prob5 12-9 NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base price is $135,000 and shipping and installation costs would add another $8,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $94,500. The applicable depreciation rates are 33%, 45%, 15%, and 7% as discussed in Appendix 12A. The machine would require a $5,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax labor costs would decline by $52,000 per year. The marginal tax rate is 35%, and the WACC is 8%. Also, the firm spent $4,500 last year investigating the feasibility of using the machine. a. How should the $4,500 spent last year be handled? b. What is the initial investment outlay for the machine for capital budgeting purposes, that is, what is the Year 0 project cash flow? c. What are the project's annual cash flows during Years 1, 2, and 3? d. Should the machine be purchased? Explain your
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started