Assume that you will be given $10,000 next month to be spent towards purchasing a car...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume that you will be given $10,000 next month to be spent towards purchasing a car or truck. Will you buy an old used car outright, or use the 10k (and perhaps a trade-in) towards the purchase of a new or lightly used vehicle? Set up an Excel spreadsheet to help you with your decision. Prep work: . Consider at least two scenarios, e.g., new car vs. used car, car vs. truck, etc. Your spreadsheet will be more interesting if the cars have different costs, MPG, etc. Decide on the holding period for your car Do you expect to own the car for a few years, then upgrade after you are established after graduation, or do you expect to hold on to the car for a longer period of time so you can focus on other financial goals? - Research ownership costs for both cars: . . Cost Miles per gallon (MPG) Interest rate and term if you finance the rest of the cost with a car loan D D You must specify holding period in years • Average maintenance costs -Suggestions: Edmunds.com. nerdwallet.com, D D Check rates at your bank, the car dealer, and/or Bankrate.com Car Decision Spreadsheet: -Set up a spreadsheet to compare the total costs of the two cars O yourmechanic.com Insurance (ALWAYS check this, your insurance may increase a lot even with a used car) Calculate your loan payment and total interest for the loan over the term Estimate your cost of gas per year (will need estimated gas price and miles driven per year) or charging costs Estimate other costs based on your research above Car Decision Spreadsheet: • Set up a spreadsheet to compare the total costs of the two cars . Calculate your loan payment and total interest for the loan over the term . Estimate your cost of gas per year (will need estimated gas price and miles driven per year) or charging costs Estimate other costs based on your research above • Create a separate section or worksheet to analyze your loan . If you pay $100 more each month, how much faster will the loan be paid? . If you pay $100 more each month, how much less total interest will you pay? . If you want to pay off the loan in 3 years, what would your monthly payment need to be? .Now consider the best way to present your analysis . Can you make your spreadsheet more efficient? . Create tables for your cost analysis and loan analysis . Will others understand inputs and outputs, and what you are trying to accomplish? . Make your spreadsheet general so anyone could put in their own assumptions . Make sure the input cells are obvious Test on friends or family members Assume that you will be given $10,000 next month to be spent towards purchasing a car or truck. Will you buy an old used car outright, or use the 10k (and perhaps a trade-in) towards the purchase of a new or lightly used vehicle? Set up an Excel spreadsheet to help you with your decision. Prep work: . Consider at least two scenarios, e.g., new car vs. used car, car vs. truck, etc. Your spreadsheet will be more interesting if the cars have different costs, MPG, etc. Decide on the holding period for your car Do you expect to own the car for a few years, then upgrade after you are established after graduation, or do you expect to hold on to the car for a longer period of time so you can focus on other financial goals? - Research ownership costs for both cars: . . Cost Miles per gallon (MPG) Interest rate and term if you finance the rest of the cost with a car loan D D You must specify holding period in years • Average maintenance costs -Suggestions: Edmunds.com. nerdwallet.com, D D Check rates at your bank, the car dealer, and/or Bankrate.com Car Decision Spreadsheet: -Set up a spreadsheet to compare the total costs of the two cars O yourmechanic.com Insurance (ALWAYS check this, your insurance may increase a lot even with a used car) Calculate your loan payment and total interest for the loan over the term Estimate your cost of gas per year (will need estimated gas price and miles driven per year) or charging costs Estimate other costs based on your research above Car Decision Spreadsheet: • Set up a spreadsheet to compare the total costs of the two cars . Calculate your loan payment and total interest for the loan over the term . Estimate your cost of gas per year (will need estimated gas price and miles driven per year) or charging costs Estimate other costs based on your research above • Create a separate section or worksheet to analyze your loan . If you pay $100 more each month, how much faster will the loan be paid? . If you pay $100 more each month, how much less total interest will you pay? . If you want to pay off the loan in 3 years, what would your monthly payment need to be? .Now consider the best way to present your analysis . Can you make your spreadsheet more efficient? . Create tables for your cost analysis and loan analysis . Will others understand inputs and outputs, and what you are trying to accomplish? . Make your spreadsheet general so anyone could put in their own assumptions . Make sure the input cells are obvious Test on friends or family members
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Assume that you will be opening a savings account today by depositing $100,000. The savings account pays 5 percent compound annual interest, and this rate is assumed to remain in effect for all...
-
In this group activity, you will be given two independent scenarios: one involving the admission of a partner, and one involving the withdrawal of a partner. You will be required to determine the...
-
In this group activity, you will be given a balance sheet at the beginning of the year, the income statement and cash flow statement for the year, and additional data. Using that information, you...
-
Viola, Iona and Paula form a joint for the sale of merchandise. Iona and Paula are to contribute the merchandise, Viola is to act as the manager and is to be allowed a bonus of 25% of the profit...
-
The accountant for Alpine Hobby Stores prepared the following selected information for the year ended December 31, 2011: Equipment with a book value of $18,000 was sold for $16,000 cash. The original...
-
A cold-worked copper tube is soldered, using a lead-tin alloy, into a steel connector. What types of electrochemical cells might develop due to this connection? Which of the materials would you...
-
Which of these items are liabilities of White Glove Cleaning Service? (a) Cash. (c) Dividends. (b) Accounts payable. (d) Accounts receivable. (e) Supplies. (h) Service revenue. (f ) Equipment. (i)...
-
Suppose Walla Walla Company had paid $175,000 to Freewater Company for an investment in 10,000 shares of the $5 par value preferred stock of Freewater Company. The preferred stock was later converted...
-
Smith Corporation had 3 0 , 0 0 0 shares of common stock outstanding during the year. In addition, there were compensatory share options to purchase 3 , 0 0 0 shares of common stock at $ 2 0 a share...
-
KJJ Corp. was formed on October 10, 2001 by Kimberly Jen (123-45-6789), Jennifer James (234-56\(7890)\) and James \(\operatorname{Kim}(345-67-8901)\). It is a hardware store and is located at 175...
-
8. Acme Annuities recently offered an annuity that pays 6.9% compounded monthly. What equal monthly deposit should be made into this annuity in order to have $134,000 in 12 years? The amount of each...
-
Heretofore, senior executives have not read your internal audit reports. You believe that these executives should be interested in receiving copies of your reports, particularly because you have...
-
Discuss the steps that can be taken to ensure that funding from family members and friends will be treated as a business relationship.
-
To assure timeliness in reporting, an internal audit should: a. Incorporate summaries in written reports. b. Make reports as concise as possible. c. Provide the auditee with progress reports during...
-
Discuss the advantages of self-funding a business. Be sure to reflect on how these apply to you in your business plans.
-
Internal audit reports should be effective and gain management's confidence when they: a. Contain an objective viewpoint. b. Describe the audit scope. c. Include recommendations. d. Exclude...
-
Correct The revenue function is given by R x x p x dollars where x is the number of units sold and p x is the unit price If p x 41 4 find the revenue if 16 units are sold Round to two decimal places
-
Dr. Chan obtained a $15,000 demand loan at prime plus 1.5% on September 13 from the Bank of Montreal to purchase a new dental X-ray machine. Fixed payments of $700 will be deducted from the dentists...
-
Compute the missing amount in each of the following separate companies a throughd. Equity, December 31, 2008 Owner investments during the year Dividends during the year Net income (loss) for the year...
-
This chapter explained the purpose of managerial accounting in the context of the current business environment. Review the automobile section of your local newspaper; the Sunday paper is often best....
-
Crosby Company produces sporting equipment, including footballs. Identify each of the following costs as direct or indirect if the cost object is a football produced by Crosby. 1. Depreciation on...
-
The Danner Corporation reported the following accounting income before income taxes, income taxes expense, and net income for 20x6 and 20x7: On the balance sheet, deferred income taxes liability...
-
Contingent Liabilities Several items are listed for which the outcome of events is unknown at year-end. a. A company has been sued by the federal government for price fixing. The companys legal...
-
Using the corporate tax rate schedule in Table 1, compute the income tax liability for the following situations: Situation Taxable Income A $ 70,000 B 85,000 C 320,000 Income Tax Allocation
Study smarter with the SolutionInn App