please show me the breakdown how to get this answer. Per my excel sheet, it...
70.2K
Verified Solution
Link Copied!
Question
Finance
please show me the breakdown how to get this answer. Per my excel sheet, it should be 231,122.33 or 114779.06 or 115,159.02. HOWEVER, all three of those are incorrect. please help
Saved Help Week 5. Chapter 11 12. & 13 Save & Exit Submit Check my work 9 DataPoint Engineering is considering the purchase of a new piece of equipment for $255.000 it has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $250,000 in nondepreciable working capital, $82,000 of this investment will be recovered after the sixth year and will provide additional cash flow for that year. Income before depreciation and taxes for the next six are shown in the following table. Use Table 12-11. Table 12-12. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods onts took Year 1 2 3 4 5 6 Amount $242.000 158,000 168,000 153,000 114.000 104,000 Hin The tax rate is 25 percent. The cost of capital must be computed based on the following Print Cost (afteetax) References 6.4 Debt Preferred stock Common equity (retained earnings) Ad p ke 10.50 Weights 305 10 60 15.00 a. Determine the annual depreciation schedule. (Do not round intermediate calculations. Round your depreciation base and annual depreciation answers to the nearest whole dollar. Round your percentage depreciation answers to 3 decimal places.) Year 1 2 3 4 Depreciation Base $ 255,000 255.000 255,000 255,000 255.000 256,000 Percentage Annual Depreciation Depreciation 0.2005 51.000 0.320 81,600 0.192 48.960 0 115 29,325 0.115 29 325 0.058 14,790 $ 255,000 Print 0 References d-1. Determine the net present value. (Use the WACC from part crounded to 2 decimal places as a percent as the cost of capital (e.g. 12.34%). Do not round any other intermediate calculations. Round your answer to 2 decimal places.) Not present value
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!