I am using excel for this problem but i am stuck. It would be extremely helpful if you can provide a picture of how parts a through e should be done on a spreadsheet, essentially showing the formulas and answer. Thanks

Metro Clinic, a taxpaying entity, estimates that it can save $30,000 a year in cash operating costs for the next 10 years if it buys a special-purpose eye-testing machine at a cost of $135,000. No terminal disposal value is expected. Metro Clinic's required rate o return is 4%. Assume a cash ows occur at year-end except or initial investment amounts. Metro Clinic uses straight-line depreciation. The income tax rate is 3 % for a transactions that affect income taxes. G Requirements 1. Calculate the following for the special-purpose eye-testing machine: a. b. c. d. e. How would your computations in requirement 1 be affected if the special-purpose machine hada S13,000 terminal disposal value at the end of 10 years? Assume depreciation deductions are based on the $135,000 purchase cost and zero terminal disposal value using the straight-line method. Answer briefly in words without further calculations. a minus sign or parentheses for a negative net present value.) Net present value Payback period Intemal rate of return Accrual accounting rate of return based on net initial investment Aocrual accounting rate of return based on average investment 2. Print Done All Check Answer O remaining