can you please help me with questions 30 and 31 thanks in advance.

30. Internal Rate of Return Analysis. Excavating, Inc. would like to purchase a tractor for $200,000. The machine is expected to have a life of 5 years, and a salvage value of $10,000. Annual maintenance costs will total $40,000. Annual net cash receipts resulting from this machine are predicted to be $90,000. The company's required rate of return is 15 percent (this is the same data as the previous exercise) Required: a. Use trial and error to approximate the internal rate of return for this investment proposal. b. Should the company purchase the tractor? Explain. 31. Payback Period Calculation. Excavating, Inc, would like to purchase a tractor for $200,000. The machine is expected to have a life of 5 years, and a salvage value of $10,000. Annual maintenance costs will total $40,000. Annual net cash receipts resulting from this machine are predicted to be $90,000. The company's required rate of return is 15 percent (this is the same data as the previous exercise.) Determine the payback period for this investment using the format shown in Table 8.1 File Home Insert Draw Page Layout Formulas Data F PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless your R3 : * fx 2 EXERCISES: Set A (continued) 30. Internal Rate of Return Analysis Present Value Factor Factor Value 11 t2 Cash Flow Item Description In (Out) Purchase price (today) Annual maintenance costa (years 1-5) Annual savings (years 1-5) Salvage value (end of year 5) Net present value * Because this is not an annuity, use Figure 8.9 in Appendix ** Because this is an annuity, use Figure 8.10 in Appendix 27 31. Payback Period Calculation month luyentent (Cash Outflow Cath Inflow Unrecovered Investment Balance QA Shot on OnePlus Powered by Dual Camera