There are 5 parts to this question. please make sure to do ALL 5 PARTS! also please do it in excel or in table format on the computer. i can never read anyones hand writing. thanks!

Clarke Company is planning to add a new product to its line. To manufacture this product, the Clarke Company needs to buy a new machine at a $600,000 cost with an expected four year life and a $32,000 salvage value. A sales are for cash, and all costs are out of pocket, except for depreciation on the new machine. Additional information includes the following. ev of 51. E.of $1. PVAS and EVA of 5) (Use appropriate factor(s) from the tables provided. Round PV factor value to 4 decimal places) 52,140,000 Expected annual sales of new product Expected annual costs of new product Direct materials Direct labor Overhead (excluding straight-line depreciation on new machine) Selling and administrative expenses Income taxes 492,000 684,000 456,000 172.000 304 Required: 1. Compute straight-line depreciation for each year of this new machine's life. 2. Determine expected net income and net cash flow for each year of this machine's life. 3. Compute this machine's payback period, assuming that cash flows occur evenly throughout each year. 4. Compute this machine's accounting rate of return, assuming that income is earned evenly throughout each year. 5. Compute the net present value for this machine using a discount rate of 7% and assuming that cash flows occur at each year-end. (Hint: Salvage value is a cash inflow at the end of the asset's life.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required Required 4 Required Compute straight-tinh depreciation for each year of this new machine's re. Si doprino 142.000 Required 2 > Required 1 Required 2 Required 3 Required 4 Required 5 Determine expected net income and net cash flow for each year of this machine's life. Expected Net Income Revenues Expenses 0 Expected Net Cash Flow 0 Required 1 Required 2 Required 3 Required 4 Required 5 Compute this machine's payback period, assuming that cash flows occur evenly throughout each year. Payback Period Choose Numerator: Choose Denominator Payback Period Payback period > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Compute this machine's accounting rate of return, assuming that income is earned evenly throughout each year. Accounting Rate of Return Choose Numerator Choose Dypominator Accounting Rate of Return Accounting rate of retum USLUunt late of 7% and assuming that cash flows occur at each year-en E Salvage value is a cash inflow at the end of the asset's life.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Compute the net present value for this machine using a discount rate of 7% and assuming that cash flows occur at each year end. (Hint: Salvage value is a cash inflow at the end of the asset's life.) (Do not round intermediate calculations. Amounts to be deducted should be indicated by a minus sign.) Chart Values are Based on: ia Cash Flow Select Chart Amount X PV Factor Annual cash flow Residual value Present Value S 0.00 0.00 $ 0.00 Net present value