subject
Business, 15.05.2021 05:00 JayJaYMoney251

A Ford Mustang GT costs $75000. Assuming the price of a Ford Mustang didn't change since 1985, calculate the current(2019) price of resale for Mustangs purchased over the years, subject to variable depreciation based on Year of Purchase. YEAR OF PURCHASE ANNUAL DEPRECIATION
1985 - 1995 $2000
1996 - 2005 $1800
2006 - 2015 $1600
2016 - Present $1400

A Mustang bought in 1997 will depreciate by $1800 annually and will resell at $33600 in 2020 or a Mustang bought in 2008 will depreciate by $1600 annually and will resell at $55800 in 2020. Create an excel sheet that asks the user the year of purchase and calculates the resale value of the car in 2020.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 10:30
6carla would like to buy a dress, a dresser for her bedroom, and a home theater system. she has one month's worth of living expenses in her emergency fund. carla decides to save for the home theater system. did carla make the right decision? why or why not? a. yes; her emergency fund is full and the other items will probably be less expensive. b. yes; she could save more for her emergency fund, but the home theater will be harder to save for. c. no; she should save more for her emergency fund because she has saved less than the recommended amount. d. no; she should have bought the dress and dresser first because she could afford them right away. reset next
Answers: 2
question
Business, 22.06.2019 11:20
Money aggregates identify whether each of the following examples belongs in m1 or m2. if an example belongs in both, be sure to check both boxes. example m1 m2 gilberto has a roll of quarters that he just withdrew from the bank to do laundry. lorenzo has $25,000 in a money market account. neha has $8,000 in a two-year certificate of deposit (cd).
Answers: 3
question
Business, 22.06.2019 13:40
Horace society is planning its annual western fair raceway gala. the gala committee has assembled the following expected costs for the event: dinner (per person) $10 gaming token and program (per person) $2 prize payouts $4,300 tickets and advertising $800 private box suite rental $1,700 lottery licenses $200 the committee members would like to charge $40 per person for the evening’s activities.required: 1. what is the break-even point for the dinner-dance (in terms of the number of persons who must attend)? 2. assume that last year only 200 persons attended the dinner-dance. if the same number attend this year, what price per ticket must be charged in order to break even? 3. refer to the original data ($40 ticket price per person). prepare a cvp graph for the dinner- dance from zero tickets up to 600 tickets sold.
Answers: 2
question
Business, 23.06.2019 00:30
You have been solicited to conduct a performance evaluation for a public organization that has been corrupted over issues of personnel embezzling funds. before actually conducting the evaluation, you—the evaluator—need to know certain specifics to conduct a thorough evaluation. compose a proposal that describes what type of evaluation will be conducted. in the proposal, explain the type of public organization. describe some of the main services, products, and activities the organization provides to the public. describe the size of the problem, who is affected by the problem, how long the problem has been in existence, and how long the evaluation will take. also, describe what the evaluation will assess with respect to organizational leadership. finally, what outcomes do you propose the evaluation will to achieve for the organization?
Answers: 2
You know the right answer?
A Ford Mustang GT costs $75000. Assuming the price of a Ford Mustang didn't change since 1985, calcu...
Questions
question
Mathematics, 17.09.2021 14:00
question
Mathematics, 17.09.2021 14:00
question
Chemistry, 17.09.2021 14:00
question
English, 17.09.2021 14:00
question
Mathematics, 17.09.2021 14:00
question
Mathematics, 17.09.2021 14:00
question
Mathematics, 17.09.2021 14:00
question
History, 17.09.2021 14:00
question
Mathematics, 17.09.2021 14:00
Questions on the website: 13722363