Hi! I have two attached finance problems in Excel that I need help with. Please use Excel functions so I can understand how to solve them, thanks!

2. (35 points) You are considering outsourcing your trucking operations. The first alternative is to continue your own trucking. The fleet costs $5 million initially. You will pay $2 million annually to operate and maintain the fleet of trucks. After 7 years you sell the trucks for $1 million. The second alternative is to outsource the trucking, which can be done forever. It costs $3 million initially to integrate your systems with the trucking company. The contract costs $2 million annually, and your internal costs are $0.5 million annually. Interest is a nominal 16% per year compounded weekly. Use annual worth analysis to decide on a trucking system. A. Find the effective annual interest rate. Nominal rate per year Compounding periods Effective rate per year B. Find the annual worth for each alternative: C. Which alternative do you select? 3. (35 points) Progressive Mfg. wants to select equipment to improve workstation ergonomics. Alternative 1 is to purchase a column-mounted jib crane and hoist. The crane costs $5700, lasts 12 years, has annual cost of $6100, and has salvage value of $3000. Alternative 2 is to purchase a celing-mounted manipulator arm. The arm costs $9400, lasts 6 years, has annual cost of $4000, and has salvage value of $1000. Alternative 3 is to purchase a scissor-lift and tilt table. The lift/table costs $4000, lasts 4 years, has annual cost of $5500, and has no salvage value. Use incremental rate-of-return analysis with MARR = 16% to select an alternative. Answer parts A to E (scroll down to line 70). A. Identify the first two alternatives to analyze. Alternative A: Alternative B: B. Find the first incremental cash flow and rate-of-return. Atl. A cash flow Year Alt. B cash flow 0 Incremental 0 Cash flow 0 1 2 3 4 5 6 7 8 9 10 11 12 C. Identify the second Alternative A (survivor) and Alternative B. Alternative A: Alternative B: D. Find the second incremental cash flow and rate-of-return. Atl. A cash flow Year Alt. B cash flow 0 0 1 2 3 4 5 6 7 8 9 10 11 12 E. Which alternative is selected? Incremental 0 Cash flow