Could you, please help me with my HW assignment?

1. Complete the information on the Documentation Tab Complete the Documentation Sheet (Name, Date, and Purpose) and format professionally.
2. Rename Sheet1 tab Labor Day Sales.
3. Center the Title across columns A-K using Center Across Selection.
4. Determine the Dealer Cost of each vehicle Model using a VLOOKUP function and the 'Dealer Cost by Model' lookup table.
   • You can choose to create a named range for your lookup table or use cell references. If you use cell references, be sure to absolute the lookup range references in your VLOOKUP function. The lookup table should be a direct match.
5. Calculate the Sticker Price (Asking Price). The asking price includes the Dealers Cost plus the Markup.
   • hint: The markup is a percentage of the dealer cost based on a markup percentage rate.
6. Calculate the % of Sales Price to Asking Price by dividing the Sales Price by the Asking Price. Note: The Sales Price is the price the vehicle sold for. Show no decimal places.
7. Use an HLOOKUP to determine the Commission % earned by each salesperson using the Salespersons Commission Percentage Lookup Table. Remember to use Absolute references for your lookup range or create a named range. This Lookup should NOT look for an exact match.
8. Calculate the Commission earned by each salesperson (Commission % rate * Sales Price).
9. Use an IF Statement to calculate which salespeople have earned the Bonus based on whether or not their sales met the Bonus Threshold from the % of Sales Price to Asking Price.
   • Use the Assumption area for specific cell references and details.
   • Remember IF Statement has 3 components: Logical Test, Action if True, Action if False
10. Calculate Dealer Profit: =Sales Price-Dealer Cost-Commission Paid & Bonus.
11. Calculate the % of Dealer Profit to Sales Price. Show two decimal places
    • HINT: % indicates your formula will use Division. FYI-10% is standard for Dealerships.
12. Apply conditional formatting so that those Percentages below 8% are highlighted.
13. Calculate totals for Columns C through E & H through J in row 15. Be sure to bold the totals.
14. Create a New Tab and name it Client PMT Include the following information to set up your PMT:
    • Create a Title for Worksheet: Client Payment Calculator and center across selection for columns A and B Loan Amount: 38000 Interest (annual): 5.25 Term (years): 5 Payments per Term: 12 Payments:
    • Calculate the PMT in the cell adjacent to Payments
15. Format the Workbook
    • Apply Accounting Format to all monetary values; be sure to only show the $ symbol on the top row and for totals. Do not show decimal places for any monetary values.
    • Apply Percentage Format to items labeled as percentages. Show two decimal places for all percentages
    • Adjust Columns and Rows; use alignment and word-wrap as necessary
    • Apply borders and shading as needed to help visually organize your worksheet.

AutoSave C 9 AutoDealership StartFiles Search Silvia Mulyar SM ca File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Arial 10 ~A A == 82 Wrap Text General HEX Insert Delete Format 27 O ri BIU Sensitivity [ Copy Peste * Format Painter Cipboard : A $ % 9 % Merge Center Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Eding Data Analysis Analysis Font Alignment Numer Cels Sensitivity B1 > Crazy D C G 11 1 J K L M N 0 P 0 R S T u V B Crazy September 6 A 1 Name: 2 Date: 3 4 Purpose 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 28 27 28 Sheet1 Labor Day Sales Ready 1009 o O EL (2 ENG 7:48 PM 2/10/2021 AutoSave Of H. AutoDealership StartFiles Search Silvia Mulyar SM ca SO Page Layout File Home Insert Draw Formulas Data Review View Help Share Comments AutoSum Arial 18 ~A A 82 Wrap Text General HEX Insert Delete format 27 O ri Paste' ta copy BIU [n * Format Painter Clipboard Sensitivity A $ %, 8 Merge & Center Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Data Analysis Font Alignment Numer Cels Edting Analysis Sensity D1 B c D E F G H 1 J L 3 Salesperson Car Model Dealer's Cost Price (Asking Sales Price bles Price to Askin Commission % ommission PaBonus Earned Dealer Profit of Profit to Sales Price 4 Goldsmith Green Leaf $ 29.500 5 Kato Rugged Rover 43,100 6 Kato Cruisin Commuter 21,500 7 Gonzales Green Leaf 31,500 8 Dahl Green Leaf 32,000 9 Gonzales Stylish Sedan 38,500 10 Kato Cruisin Commuter 21,000 11 Dahl Stylish Sedan 39,000 12 Goldsmith Rugged Rover 41,000 13 Goldsmith Green Leaf 33,000 14 15 Totals 16 17 18 Assumptions 19 Dealer Markup 20.00% Bonus Threshold-% of Sales 20 Price to Asking Price is >= 95.00% 21 Bonus Amount $ 500 22 23 Base Cost by Model Lookup Table 24 Cruisin Commuter 19,500 25 Green Leaf $ 28,000 26 Rudad Rover 37 00 Sheel1 Labor Day Sales Ready 1159 O (2 ENG 7:48 PM 2/10/2021 AutoSave C 9 AutoDealership StartFiles Search Silvia Mulyar SM ca File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Arial 10 ~A A == 82 Wrap Text General HEX Insert Delete Format 27 O ri BIU Sensitivity [ Copy Peste * Format Painter Cipboard : A $ % 9 % Merge Center Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Eding Data Analysis Analysis Font Alignment Numer Cels Sensitivity B1 > Crazy D C G 11 1 J K L M N 0 P 0 R S T u V B Crazy September 6 A 1 Name: 2 Date: 3 4 Purpose 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 28 27 28 Sheet1 Labor Day Sales Ready 1009 o O EL (2 ENG 7:48 PM 2/10/2021 AutoSave Of H. AutoDealership StartFiles Search Silvia Mulyar SM ca SO Page Layout File Home Insert Draw Formulas Data Review View Help Share Comments AutoSum Arial 18 ~A A 82 Wrap Text General HEX Insert Delete format 27 O ri Paste' ta copy BIU [n * Format Painter Clipboard Sensitivity A $ %, 8 Merge & Center Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Tind Filter Select Data Analysis Font Alignment Numer Cels Edting Analysis Sensity D1 B c D E F G H 1 J L 3 Salesperson Car Model Dealer's Cost Price (Asking Sales Price bles Price to Askin Commission % ommission PaBonus Earned Dealer Profit of Profit to Sales Price 4 Goldsmith Green Leaf $ 29.500 5 Kato Rugged Rover 43,100 6 Kato Cruisin Commuter 21,500 7 Gonzales Green Leaf 31,500 8 Dahl Green Leaf 32,000 9 Gonzales Stylish Sedan 38,500 10 Kato Cruisin Commuter 21,000 11 Dahl Stylish Sedan 39,000 12 Goldsmith Rugged Rover 41,000 13 Goldsmith Green Leaf 33,000 14 15 Totals 16 17 18 Assumptions 19 Dealer Markup 20.00% Bonus Threshold-% of Sales 20 Price to Asking Price is >= 95.00% 21 Bonus Amount $ 500 22 23 Base Cost by Model Lookup Table 24 Cruisin Commuter 19,500 25 Green Leaf $ 28,000 26 Rudad Rover 37 00 Sheel1 Labor Day Sales Ready 1159 O (2 ENG 7:48 PM 2/10/2021