Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please, i need to solve on excel as soon as possible. image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trap Doors And Trojan Horses An Auditing Action Adventure

Authors: D. Larry Crumbley, David Kerr, Veronica Paz, Lawrence Smith

1st Edition

1531021573, 978-1531021573

More Books

Students also viewed these Accounting questions

Question

What does flexibility mean for the innovation process? LOP98

Answered: 1 week ago

Question

What challenges does GE have to face in the HRM field today?

Answered: 1 week ago