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.
Answers
Answer:
Explanation:
The excel was created. The User has to enter the year that the vehicle was purchased and it will automatically calculate the resale value of the vehicle where it says "Resale Value in 2020: ". The excel sheet and proof of output is attached below.
Related Questions
Splish Brothers Inc. reported net income of $194,800 for 2022. Splish Brothers also reported depreciation expense of $47,700 and a loss of $5,900 on the disposal of plant assets. The comparative balance sheets show an increase in accounts receivable of $16,700 for the year, a $18,700 increase in accounts payable, and a $3,000 increase in prepaid expenses. Prepare the operating activities section of the statement of cash flows for 2022. Use the indirect method.
Answers
Answer:
Operating activities section of the statement of cash flows for 2022
Net Income $194,800
Adjustment for non cash items :
Depreciation $47,700
Loss on disposal $5,900
Adjustments for changes in working capital :
Increase in accounts receivable ($16,700)
Increase in accounts payable $3,000
Net Cash Provided by Operating Activities $234,700
Explanation:
Operating activities section of the statement of cash flows reconciles the Net Income to Operating Cashflow when the indirect method is used as shown above.
3. An investor shorts 100 shares when the share price is $20 and closes out the position six months later when the share price is $18.2. The shares pay a dividend of $0.2 per share during the six months. How much does the investor gain or lose (losses are indicated by a negative sign and profits by a plus sign)
Answers
Answer:
$160
Explanation:
Calculation to determine How much does the investor gain or lose
Investor gain =[($20-$18.2)*100 Shares]- ($0.2*100 shares)
Investor gain=($1.8*100 shares)-($0.2*100 shares)
Investor gain=$180-$20
Investor gain=$160
Therefore The amount that the investor gain is $160
The subject of the auditing procedure observing is least likely to be: a. procedures. b. inventory taking. c. personnel d. processes. e. physical assets.
Answers
Answer:
e. physical assets.
Explanation:
Audit procedures can be regarded as processes or techniques, or methods that is been followed by auditors in obtaining audit evidence that will give them enablement to make a conclusion as regards to set audit objective so they can express their opinion. audit procedures can as well be called audit programs. It should be noted that The subject of the auditing procedure observing is least likely to be physical assets. physical asset can be regarded as item of economic, even exchange value which has a material existence. They are regarded asPhysical assets tangible assets. Example is
properties, equipment,
CWN Company uses a job order costing system and last period incurred $82,000 of actual overhead and $100,000 of direct labor. CWN estimates that its overhead next period will be $73,000. It also expects to incur $100,000 of direct labor. If CWN bases applied overhead on direct labor cost, its predetermined overhead rate for the next period should be:
Answers
Answer:
the predetermined overhead rate is 65%
Explanation:
The computation of the predetermined overhead rate is shown below;
The Predetermined overhead rate
= Expected overhead ÷ expected total direct labour cost
= $73,000 ÷ $100,000
= 0.73
= 65%
hence, the predetermined overhead rate is 65%
The same would be considered and relevant
The internal rate of return for a project will increase if: the initial cost of the project can be reduced. the total amount of the cash inflows is reduced. each cash inflow is moved such that it occurs one year later than originally projected. the required rate of return is reduced. the discount rate is increased.
Answers
Answer:
the initial cost of the project can be reduced
Explanation:
As we know that the internal rate of return is the return where the net present value comes to zero or we can say that the initial investment would be equivalent to the present value of annual cash inflows
In the case when the internal rate of return is rise up so the initial investment or initial cost would be decreased
Therefore the first option is correct
On November 10 of the current year, Flores Mills sold carpet to a customer for $7,700 with credit terms 2/10, n/30. Flores uses the gross method of accounting for sales discounts. What is the correct entry for Flores on November 17, assuming the correct payment was received on that date
Answers
Answer:
Flores Mills:
The correct entry for Flores on November 17 using the gross method of accounting for sales discounts is as follows:
Journal Entry
November 17:
Debit Cash $7,546
Debit Cash Discounts $154
Credit Accounts Receivable $7,700
To record the receipt of cash from a customer on account, including 2% discounts allowed for payment within 10 days.
Explanation:
a) Data and Analysis:
November 10: Accounts Receivable $7,700 Sales Revenue $7,700
with credit terms 2/10, n/30.
November 17: Cash $7,546 Cash Discounts $154 Accounts Receivable $7,700
Practice Do It! Review 02 The following information is available for Sunland Company. April 1 April 30 Raw materials inventory $10,000 $13,500 Work in process inventory 5,400 3,710 Materials purchased in April $98,000 Direct labor in April 80,300 Manufacturing overhead in April 156,000 Prepare the cost of goods manufactured schedule for the month of April.
Answers
Answer:
Cost of goods manufactured=$332,490
Explanation:
Giving the following information:
April 1 April 30
Raw materials inventory $10,000 $13,500
Work in process inventory 5,400 3,710
Materials purchased in April $98,000
Direct labor in April 80,300
Manufacturing overhead in April 156,000
To calculate the cost of goods manufactured, we need to use the following formula:
cost of goods manufactured= beginning WIP + direct materials + direct labor + allocated manufacturing overhead - Ending WIP
cost of goods manufactured= 5,400 + (10,000 + 98,000 - 13,500) + 80,300 + 156,000 - 3,710
cost of goods manufactured=$332,490
Jiffy Co. expects to pay a dividend of $3.00 per share in one year. The current price of Jiffy common stock is $60 per share. What is the cost of internal common equity (retained earnings) if the long-term growth in dividends is projected to be 9 percent indefinitely
Answers
Answer:
the cost of the internal common equity is 14%
Explanation:
The computation of the cost of internal common equity is shown below;
Stock Price = Dividend per share ÷ (required rate of return - growth rate)
$60 = $3 ÷ (required rate of return - 0.09)
60 required return - $5.4 = $3
60 required return = $8.4
So, the required return is
= 8.4 ÷ 60
= 14%
Hence, the cost of the internal common equity is 14%
What is an advantage of using Excel’s built-in templates to create invoices?
a The setting and data heading are already made and the data just needs to be inserted.
b A built-in template cannot be modified in any way, so the file’s look will be consistent.
c Only one invoice template is available, so it will be easy to learn how to use a template.
d Templates take a lot of time to set up initially, but then they save time for future applications.
Answers
Answer:
A. The setting and data heading are already made and the data just needs to be inserted.
Explanation:
here's your answer..
List four natural resources that you think would go into the production of the following products
Answers
Answer:
sorry I think u got yr question incomplete..
Explanation:
Oil, coal, natural gas, metals, stone and sand are natural resources. Other natural resources are air, sunlight, soil and water. Animals, birds, fish and plants are natural resources as well.
stay safe healthy and happy.Suppose that Under Armor and Nike are the sole producers of a particularly comfortable athletic shoe. The two firms currently charge the same price for their products. If neither firm reduces the price of its particularly comfortable athletic shoe, each firm earns $30 million in profit. If both firms reduce their prices, then each firm will earn $8 million in profit. If one firm reduces its price and the other does not, then the firm that reduces price will earn a profit of $70 million while the other firm will earn a profit of $2 million. Assuming that collusion is not a possibility, the Nash equilibrium occurs when ____________
a. Nike will reduce its price and Under Armor will maintain its current price
b. both firms will reduce their price.
c. Under Armor will reduce its price and Nike will maintain its current price
d. both firms will maintain their current price.
Answers
Answer:
b. both firms will reduce their price.
Explanation:
The Nash equilibrium is a decision-making theorem that lies inside the game theory where the player could attain the expected result by not deviating to the beginning strategy. In this, the strategy of the each player is optimal at the time when the other player decisions are relevant
So as per the given situation, both the firm should decrease their price
hence the option b is correct
GJ Company, a manufacturer, has provided the following information pertaining to its recent year of operation: Net income, $480,000 Accounts payable decreased $40,000 Prepaid assets increased $29,000 Depreciation expense was $51,000 Accounts receivable decreased $39,000 Loss on sale of a depreciable asset was $29,000 Wages payable increased $25,000 Unearned revenue decreased $29,000 Patent amortization expense was $11,000 Using the indirect method, how much was GJ's net cash provided by operating activities
Answers
Answer:
GJ Company
Cash Flow From Operating Activity
Net Income $480,000
Add: Depreciation Expenses $51,000
Add: Patent Amortization Expenses $11,000
Increase in Current Liability and
decrease in current asset
Accounts receivable decreased $40,000
Wages Payable Increased $25,000
Unearned Revenue decreased $29,000
Decrease in Current Liability
and Increase in current asset
Prepaid asset increased ($29,000)
Accounts Payable Decreased ($40,000)
Add: Loss on sale of asset $29,000
Cash Flow From Operating Activity $596,000
What would be the maximum an investor should pay for the common stock of a firm that has no growth opportunities but pays a dividend of $1.36 per year? The required rate of return is 12.5 percent.
a. $11.24
b. $9.52
c. $10.88
d. $10.64
e. $11.47
Answers
Answer:
$10.88
Explanation:
Calculation to determine What would be the maximum an investor should pay for the common stock of a firm that has no growth opportunities
Using this formula
Maximum payment for common stock=Dividend/Required rate of return
Let plug in the formula
Maximum payment for common stock=$1.36/.125 Maximum payment for common stock= $10.88
Therefore What would be the maximum an investor should pay for the common stock of a firm that has no growth opportunities is $10.88
what is the difference between quantity demand and quantity supply.
Answers
Answer:
The distinction between supply and quantity supplied is similar to the difference between demand and quantity demanded. If the market price of a product increases, then the quantity supplied increases, and vice versa.
Explanation:
.....
which of the following jobs function check accounting in the ledger and financial statements?
Answers
Answer:
Audit is the one who check .....
Oriole Company uses the percentage of receivables method for recording bad debts expense. The accounts receivable balance is $280000 and credit sales are $2810000. Management estimates that 5% of accounts receivable will be uncollectible. What adjusting entry will Oriole Company make if the Allowance for Doubtful Accounts has a credit balance of $2800 before adjustment
Answers
Answer:
Dr. Bad debt expense. $11,200
---------To Allowance for doubtful accounts $11,200
Explanation:
Given that:
Accounts receivable balance = $280,000
Total credit sales = $2,810,000
5% of accounts receivables will be bad debt = $280,00 × 5% = $14,000
Credit balance allowance for doubtful account = $2,800 and it must increase to $14,000 I.e $14,000 - $2,800 = $11,200
Adjusting journal entry
Dr Bad debt expense $11,200
-------- Cr Allowance for doubtful accounts $11,200
Financial institutions act as intermediaries between suppliers and demanders of funds. They accept savers' deposits and invest them in such things as business loans or mortgages. This process is called:_____
Answers
Answer:
The correct answer is: Intermediation.
Explanation:
To begin with, in the financial and business field the process in where the financial institutions act in the middle of money's lenders and money's borrowers is known basically as intermediation. This term consists of the simple action of matching those who needs money with those who are willing to lend money in order to obtain a profit from that lending. Therefore that when the banks, for example, accept the money of people who are saving it decides to use that money to put it in circulation in another activity in the economy in order to make the money grow.
What are the two types of economic inequality
Answers
Explanation:
Two types of economic inequality:
Wealth and income inequality
Scenario: Suppose there are only two firms in an industry, and their products are perfect substitutes for each other. Each firm had a fixed marginal cost of $5 and zero fixed cost of operation. The highest the consumers of this product are willing to pay for it is $10, and there are 200 consumers in this market. Refer to the scenario above. Suppose Firm 1 and Firm 2 have to come up with a pricing strategy simultaneously. In this case, Firm 1 will charge ________, and firm 2 will charge ____
Answers
Answer:
In this case, Firm 1 will charge $5, and firm 2 will charge $5
Explanation:
In a competitive market, where two companies have identical products, The companies try to capture the market by lowering the price of the product to attract the consumers in the market.
Firm 1 and Firm 2 are competitors with identical products and they will try to overcome their competitor. As the production of the product has a marginal cost of $5 and no fixed cost.
hence the price should be more than or equal to the marginal cost of the product to avoid losses.
As per pricing strategy simultaneously, the price should be as follow
Firm 1 Price = $5
Firm 2 Price = $5
Taylor Company neglected to amortize the discount on outstanding ten-year bonds payable. What is the effect of the failure to record discount amortization on interest expense and bond carrying value, respectively
Answers
Answer:
Taylor Company
The negligence to amortize the discount on outstanding ten-year bonds payable is the understatement of interest expense for each year. This means that the interest expense will be the same for each year instead of increasing by the amortized discount amount. The same applies to the bond carrying value, which will remain the same throughout the period.
Explanation:
The discount on bonds payable is an additional interest expense, which is written off yearly over the bonds' maturity period through amortization. It increases the amount of the periodic interest payment by the amortized discount.
Bernie is a former executive who is retired. This year Bernie received $190,000 in pension payments and $15,200 of Social Security payments. What amount must Bernie include in his gross income
Answers
Answer:
$202,920
Explanation:
Calculation to determine determine What amount must Bernie include in his gross income
Using this formula
Gross income=Pension payments Received+85% of social security benefits
Let plug in the formula
Gross income=$190,000 + ($15,200 * 85%)
Gross income=$190,000+$12,920
Gross income=$202,920
Therefore The amount that Bernie must include in his gross income is $202,920
. An analyst has determined that the intrinsic value of Coca Cola stock is $80 per share using the capitalized earnings model. If the typical P/E ratio in the computer industry is 22, then it would be reasonable to assume the expected EPS of Coca Cola in the coming year is
Answers
Answer:
$3.64
Explanation:
We know that :
Price / Earning ratio (P/E ratio) = Price per Share ÷ Earnings per Share
thus :
Earnings per Share = Price per Share ÷ Price / Earning ratio
= $80 ÷ 22
= $3.636 or $3.64
therefore,
the expected EPS of Coca Cola in the coming year is $3.64
Joint ventures offer low potential for leveraging a firm's existing competencies because they typically entail a short-term relationship between two or more firms.
A. True
B. False
Answers
Answer:
B. False
Explanation:
The main purpose of the joint venture is to help two or more companies so that they are in the position to gain the competitive advantage. So the potential for firm leverage that is existed would be high instead of low due to this reason also
So as per the given situation, the option b is correct
Hence, the option a is not correct
There are different types of business. Joint ventures offer low potential for leveraging a firm's existing competencies is a False statement.
A joint venture is known as when two or more businesses gather their resources and expertise together to achieve a set goal.It is also called a partnership between 2 or more firms where there is significant equity stake by the partners and often resulting in the creation of a new business entity.
Joint ventures uses a good amount of equity investment from each partner and can lead to the establishment of a new separate entity.
Learn more from
https://brainly.com/question/3433553?source=archive
Mogul Company ships merchandise to Ski Outfit in a consignment arrangement. The arrangement specifies that Ski Outfit will attempt to sell the merchandise, and in return, Mogul will pay to Ski Outfit a 15% sales commission on any merchandise sold. During the year, Mogul ships inventory with a cost of $100,000 to Ski Outfit. By the end of the year, $76,000 of the merchandise has been sold to customers for a total of $105,800. What amount of inventory will Mogul report at year end
Answers
Answer:
$24,000
Explanation:
According to the consignment accounting, it States that any inventory sent on consignment by the consignor to the consignee, belongs to the consignor until the inventory is sold by the consignee.
Regarding the above, Mogu company sent inventory costing $100,000 and out of this, only $76,000 has been sold. The remaining inventory still belongs to the consignor and the amount of this inventory is;
$100,000 - $76,000 = $24,000
Therefore, Mogul would report $24,000 worth of inventories at year end.
Bill thought he had received the best deal on his new car. Shortly after the purchase, Bill started to notice certain disadvantages of his new car as he learned more about other cars available. Bill is experiencing ________.a. postpurchase cultureb. selective perceptionc. information evaluationd. postpurchase cognitive dissonancee. purchase decision
Answers
Answer:
cognitive dissonance
Explanation:
Cognitive dissonance defines the situation where it includes the attitudes i.e. conflicted, behaviors, etc. It generated the mental discomfort feeling that would result in change in the attitude, belief, etc in order to decreased the discomfort also at the same time it would restore the balance
Therefore as per the given situation, it is cognitive dissonance
Exercise 24-08 a The following direct materials and direct labor data pertain to the operations of Skysong Company for the month of August. Costs Actual labor rate $15 per hour Actual materials price $190 per ton Standard labor rate $14.50 per hour Standard materials price $193 per ton Quantities Actual hours incurred and used 4,600 hours Actual quantity of materials purchased and used 1,700 tons Standard hours used 4,650 hours Standard quantity of materials used 1,680 tons (a) Compute the total, price, and quantity variances for materials and labor
Answers
Answer:
Total materials variance = $1,240 favorable
Materials price variance = $5,100 favorable
Materials quantity variance = $3,860 unfavorable
Total labor variance = $1,575 unfavorable
Labor price variance = $2,300 unfavorable
labor quantity variance = $725 favorable
Explanation:
Materials Variances
Total materials variance = Standard Cost - Actual Cost
= ($193 x 1,680) - ($190 x 1,700)
= $324,240 - $323,000
= $1,240 favorable
Materials price variance = (Standard Price - Actual Price) x Actual Quantity
= ($193 - $190) x 1,700
= $5,100 favorable
Materials quantity variance = (Standard Quantity - Actual Quantity) x Standard Price
= (1,680 - 1,700) x $193
= $3,860 unfavorable
Labor Variances
Total labor variance = Standard Cost - Actual Cost
= ($14.50 x 4,650) - ($15 x 4,600)
= $67,425 - $69,000
= $1,575 unfavorable
Labor price variance = (Standard rate- Actual rate) x Actual hours
= ($14.50 x $15) x 4,600
= $2,300 unfavorable
labor quantity variance = (Standard hours - Actual hours ) x Standard rate
= (4,650 - 4,600) x $14.50
= $725 favorable
The price of the stock at the beginning of 2018 was $56.81 and you sold the stock at $68.14 at the end of the year. What is the dividend yield (use your answer from 3a above), capital gain(loss), and total percentage return
Answers
Question Completion:
The total dividends paid is $1,743,400 and the outstanding shares are 1,300,000.
Answer:
a. The dividend per share = $1.34
b. The dividend yield = 1.97%
c. The capital gain = $11.33
d. The total percentage return = 22.3%.
Explanation:
a) Data and Calculations:
Dividends paid = $1,743,400
Outstanding shares = 1,300,000
Dividends per share = $1.34 ($1,743,400/1,300,000)
Dividend yield = Dividend per share/Stock price
= $1.34/$68.14 = 1.97%
Capital gain = $11.33 ($68.14 - $56.81)
Total return = $12.67 ($11.33 + $1.34)
Total percentage return = Total return/Beginning Stock Price * 100
= $12.67/$56.81 * 100
= 22.3%
In a responsibility accounting system: Question 6 options: A. Each accounting report contains only (or clearly segregates) those items that are controllable by the responsible manager. B. Each accounting report contains all items allocated to a responsibility center. C. Organized and clear lines of authority and responsibility are only incidental. D. All managers at a given level have equal authority and responsibility. E. All of the above.
Answers
Answer:
A. Each accounting report contains only (or clearly segregates) those items that are controllable by the responsible manager.
Explanation:
A responsibility center is a business entity given a specific goals and objectives, procedures and policies, as well as dedicated personnel for generating financial reports in a company.
Diehl Corporation manufactures a variety of parts for use in its product. The company has always produced all of the necessary parts for its product, including all of the electronic circuits. The company sells 16,000 units of its product per year. An outside supplier has offered to sell electronic circuits to the company for a cost of $35 per unit. To evaluate this offer, the company has gathered the following information relating to its own cost of producing the electronic circuits internally:
Per Unit 16,00 Unit per Year
Direct materials $16 $256,000
Direct labor 12 192,000
Variable manufacturing overhead 3 48,000
Fixed manufacturing overhead, traceable 3* 48,000
Fixed manufacturing overhead, allocated 6 96,000
Total cost $40 $640,000
One-third supervisory salary, two-thirds depreciation of special equipment (no resale value).
Suppose that if BuyorM-1509 purchases the electronic circuits, the division supervisor position could be eliminated. Fixed manufacturing overhead will be allocated to other products made by the company. Also, the company could use the freed production capacity to launch a new product. The segment margin of the new product would be $210,000 per year. How much would be the financial advantage of buying 21,000 electronic circuits from the outside supplier?
a. $80,000.
b. $132,000.
c. $112,000.
d. $96,000.
Answers
Answer: $112000
Explanation:
The financial advantage of buying 21,000 electronic circuits from the outside supplier will be:
Previous cost = $640000
Less: Purchases 16000×35 = $560000
Add: Additional benefit = $16000
Less: Fixed cost = $96000
Less: Depreciation = 2/3 × $48000 = $32000
Financial advantage = $112000
Your grandmother would like to share some of her fortune with you. She offers to give you money under one of the following scenarios (you get to choose): 1. $8,750 a year at the end of each of the next seven years 2. $48,750 (lump sum) now 3. $99,350 (lump sum) seven years from now Calculate the present value of each scenario using a 6% interest rate. Which scenario yields the highest present value
Answers
Answer:
The most profitable option is the third one.
Explanation:
Escenario 1:
$8,750 a year at the end of each of the next seven years
First, we need to calculate the future value using the following formula:
FV= {A*[(1+i)^n-1]}/i
A= annual payment
FV= {8,750*[(1.06^7) - 1]} / 0.06
FV= $73,446.08
Now, the present value:
PV= FV / (1 + i)^n
PV= 73,446.08 / 1.06^7
PV= $48,845.78
Escenario 2:
Lump-sum= $48,750
Escenario 3:
$99,350 (lump sum) seven years from now
PV= 99,350 / 1.06^7
PV= $66,073.42
The most profitable option is the third one.