pls do in excel and show formulas. thanks:)

N Corp is going to purchase a new piece of equipment that costs $50,000. The company expects to make $7000 a year for the next 10 years from the product produced by the equipment. If the equipment will be essentially worthless after 10 years, what is the company's return on investment? NPER VY PV PMT FV 70000 (50,000.00) 7.000 A power company needs to replace some large generators at an estimated cost of $680,000 in 5.5 years. It expects to receive a payment of $240.000 from another source at that time. Find the payment required at the Dend of each semi-annual period to accumulate the remaining funds needed to purchase the generators. 1 Assume the company can earn 8% compounded semiannually. 2 NPER VY PV PMT FV 54 55 66 Stephanie is going to buy a car that costs $30,000. If she makes $650 a month payments for 48 months at 67 5.9% interest, how much was her down payment? 68 PV PMT FV 69 VY NPER 70 71 77 $3