please, i need to solve on excel as soon as possible.
Kyle is a 17-year-old high school senior. He has his eye on a 2006 Jeep Wrangler with 87,000 miles for $12.640. Virginia vehicle sales tax is 4.15%. The Jeep gets approximately 15 miles to the gallon and he drives 800 miles a month back and forth to school and hanging out with his friends. Gas prices currently average $2.19 per gallon in the area. The average maintenance for this Jeep is expected to be $135 per month and insurance will be $128.52 per month. He can get a loan at the credit union to purchase the Jeep with $0 down for 48 months at 2.49% annual interest rate. Kyle has no job and no current source of income other than support from his parents who are not inclined to help him purchase this jeep or pay for any of the associated expenses of owning it. Kyle has an idea to use AirBnB to rent out his room. He has done some analysis of the current AirBnB market in his neighborhood and has come up with a price of $65 per night rental fee. AirBnB takes 3% of host revenue. Given Kyle's scenario. answer the following questions (print your answers neatly on the line provided): What will his monthly vehicle payment be? Loan Amount = Price of Jeep PLUS Sales Tax) How much interest will he pay over the life of the loan? X. How many nights per month, on average, will he need to rent his Toom to cover the vehicle payment, maintenance, insurance and fuel? Round to the next whole night of rental, as no one can rent his room for a partial night. 4Kyle has decided NOT to buy the Jeep and instead save his money. If Kyle can rent his room for an average of 10 nights per month, and he invests this amount for 5 years at 6% annual returns how much will he have saved in total? He would be making his investment payment at the end of each period (i.e. month) when he collects all of his monthly AirBnB money