Good morning! I am in MBA615 working Unit 4's homework, Question#4 and I'm stuck. Please provide the PART A and PART B answers. I've attached my spreadsheet, but I'm stuck at the end???

THAAAAANK YOU SO MUCH IN ADVANCE!

One year ago, your company purchased a machine used in manufacturing for $115,000. You have learned that a new machine is available that offers many advantages; you can purchase it for $140,000 today. It will be depreciated on a straight-line basis over ten years, after which it has no salvage value. You expect that the new machine will contribute EBITDA (earnings before interest, taxes, depreciation, and amortization) of $40,000 per year for the next ten years. The current machine is expected to produce EBITDA of $24,000 per year. The current machine is being depreciated on a straightline basis over a useful life of 11 years, after which it will have no salvage value, so depreciation expense for the current machine is $10,455 per year. All other expenses of the two machines are identical. The market value today of the current machine is %50,000 . Your company's tax rate is 20%, and the opportunity cost of capital for this type of equipment is 10%. Is it profitable to replace the yearold machine? Capital expenditure 5 140,000.00 Depreciation new 5 14,000.00 EBITDA new 5 40,000.00 Depreciation old S 115,000.00 $ 10,455 EBITDA old $ 24,000.00 Market Value old 5 50,000.00 Book Value (BV) old? Cost - accumulated depreciation =115,000 10454.55: 5 104,545 Made a capital loss of 10454550000 =54545 (BV>MV) $ 54,545 Tax saving on loss (=54545*.20) 5 10,909 In Year 0, Cash inflow from sales of the old = 54,545 + (54,545)*(0.20)= $ 65,455 Incremental Cash flows which arise from the adoption of the new machine Year Year 0 Year 1-10 Gross Profit Depreciation 16,000.00 3,545 EBITax (16,000-3545) 12,455 Tax @ 20% (12455*.20) 2,491 Incremental Earnings (Tax: 2491+Depreciation:3545 6,036 Add: Depreciation 3,545 CAPEX (purchase at $140,000 today; negative value of $140,000) $ 140,000.00) 65,455 FCF (205,455) 9,582 FCFF= -205455 + 9582 * PVF (11%, 10 Years) ???? Where do I go from here???? S (204,401)