please help fill the excel document

it says to look up in the internet, there is no data missing

Assignment Using the Excel sheet below please conduct a rent vs buy analysis for an automobile. Please use the internet to locate a new automobile interested in buying or leasing to conduct your automobile lease vs buy. Please submit the assignment in the Excel file listed below. Please remember to place your name, assignment number and date within the Excel file. Automobile Lease vs Buy.xlsx F G H E B D A 1 2 AUTOMOBILE LEASE VERSUS PURCHASE ANALYSIS Date September 17, 2021 3 Name + Amount $ 0 15 TU $ $ 6 Item Description 7 LEASE 8 1 Initial payment: 9 a. Down payment (capital $ 10 cost reduction): 11 b. Security deposit: IZ 13 2 Term of lease and loan (years)" 14 3 Term of lease and loan (months) (item 2 x 12) 17 4 Monthly lease payment 10 19 5 Total payments over term of lease (item 3 x Item 4) 20 21 6 Interest rate earned on savings (in decimal form) 23 7 Opportunity cost of initial payment (Item 1 x Item 2x 24 Item 6) 20 26 8 Payment/refund for market value adjustment 27 at end of lease ($0 for closed-end leases) and/or 28 estimated end-of-term charges 30 Total cost of leasing (Item la + Item 5 + 31 Item 7 + Item 8) 32 PURCHASE 33 10 Purchase price $ 2 $ $ 9 $ 25 11 Donnant ws 05.1 B D 8 $ 32 33 34 35 30 12 37 30 39 *U E GH 20 26 Payment/refund for market value adjustment $ 27 at end of lease (so for closed-end leases) and/or 28 estimated end-of-term charges 30 9 Total cost of leasing (Item la + Item 5+ 31 Item 7 + Item 8) PURCHASE 10 Purchase price $ 11 Down payment $ Sales tax rate (in decimal form) 13 Sales tax (Item 10 x Item 12) $ Monthly loan payment (Terms: 0.00 $ 42 O months, %) Total payments over term of loan (Item 3 x Item 14) Opportunity cost of down payment (Item 2* Item 6 x Item 11) 49 Estimated value of car at end of loan Total cost of purchasing (Item 11 + Item 13+ 52 Item 15 + Item 16 - Item 17) 53 DECISION 54 if the value of Item 9 is less than the value of Item 18, leasing is preferred; otherwise the 55 purchase alternative is preferred. 56 "Note: This form is based on assumed equal terms for the lease and the installment loan, 57 which is assumed to be used to finance the purchase. 41 14 145 44 43 15 $ $ 46 16 47 40 17 JU $ $ 51 18 58 ws 05.1 Ready Using the Excel sheet below please conduct a rent vs buy analysis for an automobile. Please use the internet to locate a new automobile interested in buying or leasing to conduct your automobile lease vs buy. Assignment Using the Excel sheet below please conduct a rent vs buy analysis for an automobile. Please use the internet to locate a new automobile interested in buying or leasing to conduct your automobile lease vs buy. Please submit the assignment in the Excel file listed below. Please remember to place your name, assignment number and date within the Excel file. Automobile Lease vs Buy.xlsx F G H E B D A 1 2 AUTOMOBILE LEASE VERSUS PURCHASE ANALYSIS Date September 17, 2021 3 Name + Amount $ 0 15 TU $ $ 6 Item Description 7 LEASE 8 1 Initial payment: 9 a. Down payment (capital $ 10 cost reduction): 11 b. Security deposit: IZ 13 2 Term of lease and loan (years)" 14 3 Term of lease and loan (months) (item 2 x 12) 17 4 Monthly lease payment 10 19 5 Total payments over term of lease (item 3 x Item 4) 20 21 6 Interest rate earned on savings (in decimal form) 23 7 Opportunity cost of initial payment (Item 1 x Item 2x 24 Item 6) 20 26 8 Payment/refund for market value adjustment 27 at end of lease ($0 for closed-end leases) and/or 28 estimated end-of-term charges 30 Total cost of leasing (Item la + Item 5 + 31 Item 7 + Item 8) 32 PURCHASE 33 10 Purchase price $ 2 $ $ 9 $ 25 11 Donnant ws 05.1 B D 8 $ 32 33 34 35 30 12 37 30 39 *U E GH 20 26 Payment/refund for market value adjustment $ 27 at end of lease (so for closed-end leases) and/or 28 estimated end-of-term charges 30 9 Total cost of leasing (Item la + Item 5+ 31 Item 7 + Item 8) PURCHASE 10 Purchase price $ 11 Down payment $ Sales tax rate (in decimal form) 13 Sales tax (Item 10 x Item 12) $ Monthly loan payment (Terms: 0.00 $ 42 O months, %) Total payments over term of loan (Item 3 x Item 14) Opportunity cost of down payment (Item 2* Item 6 x Item 11) 49 Estimated value of car at end of loan Total cost of purchasing (Item 11 + Item 13+ 52 Item 15 + Item 16 - Item 17) 53 DECISION 54 if the value of Item 9 is less than the value of Item 18, leasing is preferred; otherwise the 55 purchase alternative is preferred. 56 "Note: This form is based on assumed equal terms for the lease and the installment loan, 57 which is assumed to be used to finance the purchase. 41 14 145 44 43 15 $ $ 46 16 47 40 17 JU $ $ 51 18 58 ws 05.1 Ready Using the Excel sheet below please conduct a rent vs buy analysis for an automobile. Please use the internet to locate a new automobile interested in buying or leasing to conduct your automobile lease vs buy