help me fill out, using the internet to locate a automobile either leasing or buy

Financial Planning Tips: When Does it Make Sense to Lease a Car? The most important question to ask yourself is why you need a new car every few years Leasing may make sense it You value purchasing flexibility. A lease allows you to put off the purchasing decision while using the car. It's like having a test drive that lasts several years instead of a few minutes You value the convenience of not having to deal with significant auto repairs You're self-employed and can take the lease payment as a tax-deductible business expense. You want to drive a luxury car but you don't want to put up that much money - The key is being aware of why you want to lease and being informed about the costs and benefits of a leasing arrangement For example, Eleanor Clark is considering either leasing or purchasing a new Toyota Prius costing $29,900. The four-year, closed-end lease that she is considering requires a $2.900 down payment (capital cost reduction), a $500 security deposit, and monthly payments of 5440. including sales tax If she purchases the car, she will make a 54,500 down payment and finance the balance with a four-year. 4 percent loan requiring monthly payments of about $576. She will also have to pay 5 percent sales tax (51,500) on the purchase, and she expects the car to have a residual value of $16,500 at the end of four years Eleanor can earn 3 percent interest on her savings with short-term CDs After filling in Workshoot 5.1. Eleanor concludes that purchasing is better because its total cost of $17,665.42 is $6,762,58 less than the $24.428.00 total cost of leasing-even though the monthly lease payment is about $136 lower. All else being equal, the least costly alternative is preferred ng Eleanor Clark's Automobile Lease versus Purchase Costs AUTOMOBILE LEASE VERSUS PURCHASE ANALYSIS Name Senor Clarke Date Sept. 2017 Item Description Amount LEASE 1 Initial payment a. Down payment (capital cost reduction) $ 2900.00 b. Security deposit 500.00 53.400.00 2 Term of lease and loan (years)" 3 Term of lease and loan (months) (item 2 x 12) 4 Monthly lease payment 5 140.00 5 Total payments over term of lease (item 3 x Item 4) $10.00 6 Interest rate earned on savings (in decimal form) OSO 7 Opportunity cost of initial payment (Item 1 x Item 2 x Item 6) S SOROO 8 Payment/refund for market value adjustment at end of lease S 0.00 (50 for closed-end leases) and/or estimated end-of-term charges 9 Total cost of leasing (Item 18+ Item 5 + Item 7+Item 8) $ 24428.00 PURCHASE 10 Purchase price $29.990.00 11 Down payment S 4,500.00 12 Sales tax rate (in decimal form) 0.05 13 Sales tax (Item 10 x Item 12) S1.699.50 14 Monthly loan payment (Terms: 25.490.0048 months, 11%) 5 5584 15 Total payments over term of loan (Item 3 x Item 14) S292 16 Opportunity cost of down payment (Item 2 x Item 6 x Item 11) 540.00 17 Estimated value of car at end of loan S 16,500.00 18 Total cost of purchasing (Item 11 + Item 13 + Item 15+ SL66542 Item 16 - Item 17) 10 Purchase price 5290 11 Down payment 12 Sales tax rate fin decimal form! 13 Sales tax ltem 10 Item 121 14 Monthly loan payment Term 2.004 months 15 Total payments over term of loan Item 3 x Item 14 SEN 16 Opportunity cost of down payment te 2 Xitem ex um 13) 17 Estimated value of car and of loan 18 Total cost of purchasing Item 11 + Item 13 Item 15 Item 16 - Item 17 DECISION the who remate than the value of her 1sing is preferred, otherwise, the purchase areative preferred Note this form based on beloond the non This worksheet illustrates Eleanor Clark's lease versus purchase analysis for a new Toyota Prius costing $20.990. The four-year closed-end lease requires an initial payment of $3,400 (52,900 down payment + $500 security deposit) and monthly payments or $440. Purchasing requires a $4.500 down payment, sales tax of 5 percent ($1,499.50), and 48 monthly payments of $S75 45. The trade in value of the new car at the end of four years is estimated to be 516,500. Because the total cost of leasing of $24.428 is greater than the $17.665.42 total cost or purchasing, Eleanor should purchase rather than lease the car E F G H D B A A 1 2 AUTOMOBILE LEASE VERSUS PURCHASE ANALYSIS Date September 17, 2021 3 Name + Amount $ 0 $ $ 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) 15 3 Term of lease and loan (months) (Item 2 x 12) TU 17 4 Monthly lease payment 5 Total payments over term of lease (Item 3 x Item 4) 21 6 Interest rate earned on savings (in decimal form) 23 7 Opportunity cost of initial payment (Item 1 x Item 2 24 Item 6) 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 20 $ 9 $ 26 11 Anant ws 05.1 A B E F G H $ 26 27 28 30 8 Payment/refund for market value adjustment at end of lease ($0 for closed end leases) and/or estimated end-of-term charges 9 Total cost of leasing (item la + Item 5+ Item 7 + Item 8) PURCHASE Purchase price 9 $ 31 32 33 10 $ 35 11 Down payment $ 30 37 DO 39 40 13 41 15 $ 16 12 Sales tax rate (in decimal form) Sales tax (Item 10 x Item 12) $ 14 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 2x Item 6 x Item 11) Estimated value of car at end of loan Total cost of purchasing (item 11 + Item 13+ Item 15+ Item 16 - Item 17) 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. 45 44 43 46 47 0 49 30 51 17 s $ 18 52 53 58 ws 05.1 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 Financial Planning Tips: When Does it Make Sense to Lease a Car? The most important question to ask yourself is why you need a new car every few years Leasing may make sense it You value purchasing flexibility. A lease allows you to put off the purchasing decision while using the car. It's like having a test drive that lasts several years instead of a few minutes You value the convenience of not having to deal with significant auto repairs You're self-employed and can take the lease payment as a tax-deductible business expense. You want to drive a luxury car but you don't want to put up that much money - The key is being aware of why you want to lease and being informed about the costs and benefits of a leasing arrangement For example, Eleanor Clark is considering either leasing or purchasing a new Toyota Prius costing $29,900. The four-year, closed-end lease that she is considering requires a $2.900 down payment (capital cost reduction), a $500 security deposit, and monthly payments of 5440. including sales tax If she purchases the car, she will make a 54,500 down payment and finance the balance with a four-year. 4 percent loan requiring monthly payments of about $576. She will also have to pay 5 percent sales tax (51,500) on the purchase, and she expects the car to have a residual value of $16,500 at the end of four years Eleanor can earn 3 percent interest on her savings with short-term CDs After filling in Workshoot 5.1. Eleanor concludes that purchasing is better because its total cost of $17,665.42 is $6,762,58 less than the $24.428.00 total cost of leasing-even though the monthly lease payment is about $136 lower. All else being equal, the least costly alternative is preferred ng Eleanor Clark's Automobile Lease versus Purchase Costs AUTOMOBILE LEASE VERSUS PURCHASE ANALYSIS Name Senor Clarke Date Sept. 2017 Item Description Amount LEASE 1 Initial payment a. Down payment (capital cost reduction) $ 2900.00 b. Security deposit 500.00 53.400.00 2 Term of lease and loan (years)" 3 Term of lease and loan (months) (item 2 x 12) 4 Monthly lease payment 5 140.00 5 Total payments over term of lease (item 3 x Item 4) $10.00 6 Interest rate earned on savings (in decimal form) OSO 7 Opportunity cost of initial payment (Item 1 x Item 2 x Item 6) S SOROO 8 Payment/refund for market value adjustment at end of lease S 0.00 (50 for closed-end leases) and/or estimated end-of-term charges 9 Total cost of leasing (Item 18+ Item 5 + Item 7+Item 8) $ 24428.00 PURCHASE 10 Purchase price $29.990.00 11 Down payment S 4,500.00 12 Sales tax rate (in decimal form) 0.05 13 Sales tax (Item 10 x Item 12) S1.699.50 14 Monthly loan payment (Terms: 25.490.0048 months, 11%) 5 5584 15 Total payments over term of loan (Item 3 x Item 14) S292 16 Opportunity cost of down payment (Item 2 x Item 6 x Item 11) 540.00 17 Estimated value of car at end of loan S 16,500.00 18 Total cost of purchasing (Item 11 + Item 13 + Item 15+ SL66542 Item 16 - Item 17) 10 Purchase price 5290 11 Down payment 12 Sales tax rate fin decimal form! 13 Sales tax ltem 10 Item 121 14 Monthly loan payment Term 2.004 months 15 Total payments over term of loan Item 3 x Item 14 SEN 16 Opportunity cost of down payment te 2 Xitem ex um 13) 17 Estimated value of car and of loan 18 Total cost of purchasing Item 11 + Item 13 Item 15 Item 16 - Item 17 DECISION the who remate than the value of her 1sing is preferred, otherwise, the purchase areative preferred Note this form based on beloond the non This worksheet illustrates Eleanor Clark's lease versus purchase analysis for a new Toyota Prius costing $20.990. The four-year closed-end lease requires an initial payment of $3,400 (52,900 down payment + $500 security deposit) and monthly payments or $440. Purchasing requires a $4.500 down payment, sales tax of 5 percent ($1,499.50), and 48 monthly payments of $S75 45. The trade in value of the new car at the end of four years is estimated to be 516,500. Because the total cost of leasing of $24.428 is greater than the $17.665.42 total cost or purchasing, Eleanor should purchase rather than lease the car E F G H D B A A 1 2 AUTOMOBILE LEASE VERSUS PURCHASE ANALYSIS Date September 17, 2021 3 Name + Amount $ 0 $ $ 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) 15 3 Term of lease and loan (months) (Item 2 x 12) TU 17 4 Monthly lease payment 5 Total payments over term of lease (Item 3 x Item 4) 21 6 Interest rate earned on savings (in decimal form) 23 7 Opportunity cost of initial payment (Item 1 x Item 2 24 Item 6) 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 20 $ 9 $ 26 11 Anant ws 05.1 A B E F G H $ 26 27 28 30 8 Payment/refund for market value adjustment at end of lease ($0 for closed end leases) and/or estimated end-of-term charges 9 Total cost of leasing (item la + Item 5+ Item 7 + Item 8) PURCHASE Purchase price 9 $ 31 32 33 10 $ 35 11 Down payment $ 30 37 DO 39 40 13 41 15 $ 16 12 Sales tax rate (in decimal form) Sales tax (Item 10 x Item 12) $ 14 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 2x Item 6 x Item 11) Estimated value of car at end of loan Total cost of purchasing (item 11 + Item 13+ Item 15+ Item 16 - Item 17) 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. 45 44 43 46 47 0 49 30 51 17 s $ 18 52 53 58 ws 05.1 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