Project Car References Mailings Review View Help Search 411 S6ae 4- AaBbCcDc AaBbCcDc AaBbC AaBbCcc AaB AaBbccc 4oBbCcDr AaBbCc Notmel No Space Heading Heading 2 Subtitle Subtle Em _= Emphasize Paragraph Styles Create a pie chart comparing each individual category expense to the total expense of buying the car. Can you reduce any of these expenses? What can you possibly change to reduce your overall car expenses? You may include these answers in your reflection: (10 pts) Format all of this nicely: Show all of your calculations (5 pts) Reflection (place in a text box at the bottom of your Excel file) Include what you learned from this project as related to your own world. Can you afford the car you selected? Do you need to shop around for a better loan? What else can you do to make it more affordable? (10 pts) Turn your file into the folder on Canvas Need Excel file
Added by Barbara B.
Close
Step 1
Create a pie chart comparing each individual category expense to the total expense of buying the car. To create a pie chart, first, list down all the individual category expenses (e.g., car price, insurance, maintenance, fuel, etc.) and their respective costs in Show more…
Show all steps
Your feedback will help us improve your experience
Tassha Calista and 66 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Choosing a New Car In this open response, you are being asked to choose a car based on various factors. Car Choices: Disclaimer: the prices on the table are estimates based on 2006 costs. The other costs are simply made up for the purpose of presenting the problem. Details Chrysler Town and Country Honda Civic Jeep Liberty Possible Price $20,092 $15,057 $25,152 Vehicle Class Mini Van Compact Sports Utility Mpg City/Highway 19/26 30/40 17/22 3-year estimated maintenance/repair costs $2,040 $2,110 $2,370 Annual estimated insurance costs $2,080 $2,220 $2,520 Safety Ratings (Insurance Institute for Highway & Safety) Acceptable Good Marginal A. Choose two Vehicles to compare from the list above. First choice: _______________________ Second choice: _______________________ B. Find the monthly loan payment. Assume that you make a down payment of $2000, and you finance the remainder with a five-year loan at 6.9 percent APR. Show work for your first choice here: Show work for your second choice here: C. Find the gas costs per year. (10 points) Assume that you will drive about 15,000 miles annually. Find out what gas currently costs in your town and use that to find the gas costs per year. Cost = (Miles Driven / MPG) (CPG) Current CPG in your town: ________________ Show your work for the first choice here: Show your work for the second choice here: D. Find the annual maintenance/repair costs. (5 points) Use the information from the table above. Show your work for the first choice here: Show your work for the second choice here: E. Fill out the Comparison Table. (10 points) Car Names Price Annual loan payment (Multiply the monthly payment by 12) Gas costs for 1 year Maintenance/repair costs for 1 year Insurance cost Total Annual Expense (add all except Price above) Cost per Mile (divide the total by 15,000) Safety Rating Decision Time Which car would you choose if the only factor was Looks? Price? Monthly loan payment? Gasoline costs? Maintenance/repair costs? Cost per mile? Safety? Consider all above, but also consider anything you are personally looking for in a vehicle. Which of the two choices would you buy? Give at least three reasons why. G. Research for the car of your dreams on the Internet. Fill in the information below. Make and model: Estimated price: Details and options on the car:
Sri K.
Supreeta N.
You are in the process of getting a new car but are not sure if you should buy or lease. The price of the car you want is $18,000, but you do not want to spend more than $250 a month on car payments. If you lease the car, the terms of the lease will be 48 months at an annual interest rate of 5%. The residual value of the car will be set at $9,000. If you buy the car, your bank will offer you a 7-year loan at an annual interest rate of 6%. You are not required to make a down payment with either the lease or loan options, and payments are made at the end of the month for both options. Should you lease or buy the car given your budget limit of $250 a month? Create a new workbook and design a worksheet that shows the difference between leasing and buying the car in terms of monthly payments. Use proper formatting so your worksheet is easy to read. Remember to use column and row headings, add a title to your worksheet, and rename the worksheet tab with an appropriate label. Include your name in the file name of the workbook.
Lottie A.
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD