please write steps clear thank you I will upvote thank you screenshots on excel would help

2016 Revenue 2016 Costs 2016 Profits 750377.26 600301.808 150075.452 450000 137000 Renovation Costs Investment Amount Amount Needed to Finance 313000 APR for Loan Term 5 years Total Cost with Monthly Payments Total Cost with Quarterly Payments Amount to Finance $300,000.00 $310,000.00 $320,000.00 $330,000.00 $340,000.00 $360,000.00 APR 7.3% 7.0% 6.5% 6.0% 5.5% 5.0% Create a Named Range for cell B8 with the name LoanAmeunt. In cell B10, use a VLOOKUP function to retrieve the APR based on the amount needed to finance using the LeanAmount named range. Use the table of data in the range A17:B22. 2016 Revenue 2016 Costs 2016 Profits 750377.26 600301.808 150075.452 450000 137000 Renovation Costs Investment Amount Amount Needed to Finance 313000 APR for Loan Term 5 years Total Cost with Monthly Payments Total Cost with Quarterly Payments Amount to Finance $300,000.00 $310,000.00 $320,000.00 $330,000.00 $340,000.00 $360,000.00 APR 7.3% 7.0% 6.5% 6.0% 5.5% 5.0% Create a Named Range for cell B8 with the name LoanAmeunt. In cell B10, use a VLOOKUP function to retrieve the APR based on the amount needed to finance using the LeanAmount named range. Use the table of data in the range A17:B22