Business, 16.04.2020 17:52 Annapetrik

Exploring Advanced Data Analysis 1 | Page Challenge Yourself 8.4 Last Updated 4/9/18 Challenge Yourself 8.4 In this project, you will use scenarios and a scenario summary to analyze car purchasing options. The data for this project were downloaded from: https://www. fueleconomy. gov/feg/download. shtml You will use custom filtering to find the data you are interested in and copy it from this very large data set to another worksheet. You will then use Advanced Filter, conditional formatting, sorting, and subtotals to further analyze this subset of data. You will manipulate a PivotTable created from the main vehicle data set. Finally, you will use Solver to solve a business problem to help you pay for your new car. Skills needed to complete this project: • Creating What-If Analysis Scenarios • Creating Scenario Summary Reports • Creating a Custom Filter • Using Advanced Filter • Creating New Conditional Formatting Rules • Sorting Data on Multiple Criteria • Adding Subtotals • Changing the Look of a PivotTable • Filtering PivotTable Data • Activating the Solver Add-Inn • Using Solver 1. Open the start file EX2016-ChallengeYourself-8-4. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3. You want to purchase a new car. Your current car is worth $3,500 as a trade-in. The base sticker price on the car you want is $24,595. The first financing offer from the dealer is 1.9% APR for 24 months, with no cash back. The original financing offer terms are listed in cells A3:B9 on the Car Loan worksheet. Cell B10 contains a formula with a PMT function to calculate the monthly payment. Use what-if analysis tools to compare financing options. Create scenarios to compare financing options for the car loan. a. Create names for the following cells on the Car Loan worksheet to make the scenarios easier to follow: Name cell B3: Price Name cell B4: TradeIn Name cell B5: CashBack Name cell B6: Loan Name cell B8: Months Name cell B9: APR Name cell B10: Payment Name cell B12: TotalCost

Answers must be in the already filled Excel sheet provided

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 04:30

Required prepare the necessary adjusting entries in the general journal as of december 31, assuming the following: on september 1, the company entered into a prepaid equipment maintenance contract. birch company paid $3,400 to cover maintenance service for six months, beginning september 1. the payment was debited to prepaid maintenance. supplies on hand at december 31 are $3,900. unearned commission fees at december 31 are $7,000. commission fees earned but not yet billed at december 31 are $3,500. (note: debit fees receivable.) birch company's lease calls for rent of $1,600 per month payable on the first of each month, plus an annual amount equal to 1% of annual commissions earned. this additional rent is payable on january 10 of the following year. (note: be sure to use the adjusted amount of commissions earned in computing the additional rent.)

Answers: 1

Answer

Business, 22.06.2019 07:30

Hours to produce one unit worker hours to produce yarn country a 8 hours country b 4 hours worker hours to produce fabric counrty a 12 hours country b 13 hours additional worker hours to produce fabric instead of yarn country a ? country b? which of the follow is true of the trade relationship between country a and country b? country a has an absolute advantage in producing yarn and fabric country b has an absolute advantage in producing yarn and fabric country b has a comparative advantage to country a in producing fabric country a has a comparative advantage to country b in producing fabric

Answers: 2

Answer

Business, 22.06.2019 12:30

land, a building and equipment are acquired for a lump sum of $ 1,000,000. the market values of the land, building and equipment are $ 300,000, $ 800,000 and $ 300,000, respectively. what is the cost assigned to the equipment? (do not round any intermediary calculations, and round your final answer to the nearest dollar.)

Answers: 1

Answer

Business, 22.06.2019 20:10

Russell's is considering purchasing $697,400 of equipment for a four-year project. the equipment falls in the five-year macrs class with annual percentages of .2, .32, .192, .1152, .1152, and .0576 for years 1 to 6, respectively. at the end of the project the equipment can be sold for an estimated $135,000. the required return is 13.2 percent and the tax rate is 23 percent. what is the amount of the aftertax salvage value of the equipment assuming no bonus depreciation is taken

Answers: 2

Answer

You know the right answer?

Exploring Advanced Data Analysis 1 | Page Challenge Yourself 8.4 Last Updated 4/9/18 Challenge Yours...

Questions