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...
-
For this portion of my homework, (Round to the Nearest Cent asNeeded). Single trad Item 1. Apple iPod 2. Palm Pilot List Price S350 e discountNet price S190 10%
-
Using Information Technologies at Federal Express Federal Express (FedEX), founded in 1971, handles an average of 3 million package-tracking requests every day. To stay ahead in a highly competitive...
-
The assets, liabilities, stockholders equity, revenues, and expenses of Carter Design Studio, Inc., have the following balances at December 31, 2010, the end of its first year of operation. During...
-
AAA Life Insurance Companys (ALIC) most popular life insurance policy is P20Aa permanent, 20-year life annuity policy. This policy sells in $10,000 increments depending on the policyholders needs and...
-
create a 4 step binomial tree model by replacing all the cells highlighted in yellow with the appropriate formula. (The cells highlighted in green are the inputs.) Use your completed spreadsheet to...
-
The FY2022 income statement for ABC Company is provided below. Use the following assumptions to forecast ABC's income statement for FY2023: Net sales will increase by 2.0% (200 basis points) in...
-
The backdoor alarm went off at the residence of 979 West Valley Road at 11:27 pm. Alarm company tried to reach the customer at 11:28 pm with no response, so at 11:29 pm the police were notified and...
-
3. The Folly and Frill company is in the process of liquidation. On January 1, 2011, the general ledger shows the account balances as follows: Cash $10,000 Accounts payable 15,000 Accounts receivable...
-
Part E Let V = -6.0 +8.5 and 1 V = 4.5 + 4.4 . Determine the magnitude of V1+V2. Express your answer using two significant figures. |1+V2|= Submit Request Answer Part F Determine the direction of...
-
Larkspur Express reports the following costs and expenses in June 2022 for its delivery service. Indirect materials used $8,110 Drivers' salaries $20,160 Depreciation on delivery equipment 14,020...
-
On January 1, 2025, Sunland Company leased equipment to Carla Vista Corporation. The following information pertains to this lease. 1. The term of the non-cancelable lease is 6 years. At the end of...
-
4. Prepare the following entries: A. Co X made a Sale to an affiliate (Z) for goods $50,000 at a cost of $32,000. Co Z received the inventory. Co Z did not sell the inventory at the end of the...
-
The left end of a rod of length I is held at temperature 110, and there is heat transfer from the right end into the surrounding medium at temperature zero. The initial temperature at any point is...
-
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...
-
What is unearned revenue? a. Receivable b. Current asset c. Revenue d. Current liability
-
The foundation of internal control over payroll is a. Paying the correct amount of payroll tax b. Separating payroll duties c. Filing government tax forms on time d. Accurately computing gross pay,...
-
What is the most that an employee paid the federal government for old age, survivors', and disability insurance (FICA tax) during 2008? a. \(\$ 5,580\). b. \(\$ 90,000\). c. Nothing. The employer...
Study smarter with the SolutionInn App