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, 21.06.2019 20:30
Juniper company uses a perpetual inventory system and the gross method of accounting for purchases. the company purchased $9,750 of merchandise on august 7 with terms 1/10, n/30. on august 11, it returned $1,500 worth of merchandise. on august 26, it paid the full amount due. the correct journal entry to record the merchandise return on august 11 is:
Answers: 3
question
Business, 22.06.2019 00:00
Pettijohn inc. the balance sheet and income statement shown below are for pettijohn inc. note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. balance sheet (millions of $) assets 2016 cash and securities $ 1,554.0 accounts receivable 9,660.0 inventories 13,440.0 total current assets $24,654.0 net plant and equipment 17,346.0 total assets $42,000.0 liabilities and equity accounts payable $ 7,980.0 notes payable 5,880.0 accruals 4,620.0 total current liabilities $18,480.0 long-term bonds 10,920.0 total debt $29,400.0 common stock 3,360.0 retained earnings 9,240.0 total common equity $12,600.0 total liabilities and equity $42,000.0 income statement (millions of $) 2016 net sales $58,800.0 operating costs except depr'n $54,978.0 depreciation $ 1,029.0 earnings bef int and taxes (ebit) $ 2,793.0 less interest 1,050.0 earnings before taxes (ebt) $ 1,743.0 taxes $ 610.1 net income $ 1,133.0 other data: shares outstanding (millions) 175.00 common dividends $ 509.83 int rate on notes payable 1. what is the firm's current ratio? (points : 6) 0.97 1.08 1.20 1.33 2. what is the firm's quick ratio? (points : 6) 0.49 0.61 0.73 0.87 3. what is the firm's total assets turnover? (points : 6) 0.90 1.12 1.40 1.68 4. what is the firm's inventory turnover ratio? (points : 6) 4.38 4.59 4.82 5.06 5. what is the firm's debt ratio? (points : 6) 45.93% 51.03% 56.70% 70.00% 6. what is the firm's roa? (points : 6) 2.70% 2.97% 3.26% 3.59% 7. what is the firm's roe? (points : 6) 8.54% 8.99% 9.44% 9.91%
Answers: 2
question
Business, 22.06.2019 19:00
When making broccoli cream soup, the broccoli and aromatics should be a. burned. b. simmered. c. puréed. d. sweated.
Answers: 2
question
Business, 22.06.2019 21:00
On july 2, year 4, wynn, inc., purchased as a short-term investment a $1 million face-value kean co. 8% bond for $910,000 plus accrued interest to yield 10%. the bonds mature on january 1, year 11, and pay interest annually on january 1. on december 31, year 4, the bonds had a fair value of $945,000. on february 13, year 5, wynn sold the bonds for $920,000. in its december 31, year 4, balance sheet, what amount should wynn report for the bond if it is classified as an available-for-sale security?
Answers: 3
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, 21.10.2020 19:01
question
Mathematics, 21.10.2020 19:01