Show all formulas used in excel and all hand calculations asked for.
Sho w all answers in the space provided. (Answers only). Attach extra sheets to show your work with each question clearly identified. All sheets should include your name and class number. For the questions related to excel, print the solution with the problem number and your name on each sheet. Also put all solutions in one excel worksheet with a separate tab for each problem titled appropriately and upload your file to Blackboard. #11 7-6. The "Big-Deal" Company has purchaed new furniture for their offices at a retail price of $100,000. An additional $20,000 has been charged for insurance, shipping, and handling. The company expects to the furniture for 10 years (useful life 10 years) and then sell it at a salvage (market) value of $10,000. Use the SL method for depreciation to answer these questions. (7.3) a, d a. what is the depreciation during the second year, b. What is the BV of the asset at the end of the first year? c. What is the BV of the asset after 10 years? b.BV a. d. Solve a, b, and c using the 200% DB method. e. Solve a, b, and c using the MACRS method. c. BV10- L to create a single chart showing the Book Value (y-axis) versus the end-of-year (x-axis) for all three methods. Attach the chart to this sheet and upload the excel file to Blackboard as described above. and reduce net annual operating expenses by $36,000 for 10 A new machine is estimated to cost $200,000 years and have a market value of $30,000 at the end of the 10th year. Assume the firm is in the S335k-SOM taxable income bracket and the state tax rate is 6%. The machine is in the MACRS 7-year property class.The after-tax MARR is 10%/year. Prepare an excel file as described below. Attach the excel output and upload your file as described above. Calculate the before-tax and after-tax IRR using Excel only. Calculate the after-tax PW using Excel. Also perform this step manually with financial notations and attach your calculations. Perform parts a and b using straight line depreciation for 10 years. Perform parts a and b using DDB depreciation until the BV reaches the salvage value. a. b. c. d