Ask question

Ask question

All categories

4 years ago

10

In cell e5, enter a financial function to calculate the monthly payment. in cell e6, insert a financial function to calculate th

e cumulative total interest paid throughout the loan. make sure the results display as positive numbers.

1 answer:

eduard4 years ago

4 0

The excel function for monthly payments is =PMT()

The excel function for cumulative total interest is =CUMIPMT()

You might be interested in

Baxter Company produces children's wiffle ball sets using a threeminusstep sequential process that includes molding, coloring

anyanavicka [17]

Answer:

C) WIP InventoryWIP Inventory-Finishing

Explanation:

Cost of WIP is transferred through Molding to Coloring to the last process of the production finishing. After completing the finishing the balls are ready and the cost is transferred from WIP InventoryWIP Inventory-Finishing to Finished goods Inventory. So, the correct answer is C) WIP InventoryWIP Inventory-Finishing.

5 0

3 years ago

Overhead Applied to Jobs, Departmental Overhead Rates Xania Inc. uses a normal job-order costing system. Currently, a plantwide

sveta [45]

Answer:

Instructions are listed below.

Explanation:

Giving the following information:

Department A Department B

Overhead costs (expected) $120,000 $80,000

Normal activity (machine hours) 16,000 5,800

A) To calculate the plantwide overhead rate we need to use the following formula:

Estimated manufacturing overhead rate= total estimated overhead costs for the period/ total amount of allocation base

Estimated manufacturing overhead rate= (120,000 + 80,000) / (16,000 + 5,800)= $9.17 per machine hour

B) We need to use the same formula, but for each department:

Department A:

Estimated manufacturing overhead rate= 120,000/16,000= $7.5 per machine hour

Department B:

Estimated manufacturing overhead rate= 80,000/5,800= $13.79 per machine hour

7 0

3 years ago

John Smith, a factory worker at an automobile plant in the city Detrigan, makes $25 per hour. His dad, Larry Smith who retir

drek231 [11]

Answer:

The total number of hours worked by an average factory worker has fallen over the years

Explanation:

5 0

3 years ago

Suppose that the quantity of DVD players sold increased from 200 to 400 when the price fell from $225 to $175. Over this price r

Nataly_w [17]

Answer:

Option D.

Explanation:

Given information:

$Q_1=200, Q_2=400$

$P_1=225, P_2=175$

Formula for price elasticity of demand is

$E_d=\frac{Q_2-Q_1}{P_2-P_1}\times \frac{P_1+P_2}{Q_1+Q_2}$

Substitute the given values in the above formula.

$E_d=\frac{400-200}{175-225}\times \frac{225+175}{200+400}$

$E_d=\frac{200}{-50}\times \frac{400}{600}$

$E_d=-\frac{8}{3}$

$E_d\approx -2.67$

Absolute value is

$|E_d|= |-2.67|=2.67$

The absolute value of the price elasticity of demand for DVD players is 2.67.

Therefore, the correct option is D.

6 0

3 years ago

Palmer Corp. is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an ann

VashaNatasha [74]

Answer:

So, accounting rate of return = 33 %

Explanation:

given data

net income after tax = $179,850

initial cost = $545,000

time = 7 year

salvage value = $34,000

we will get here the accounting rate of return

solution

as we know that accounting rate of return is express as

accounting rate of return = Net income ÷ initial investment .................1

put here value and we get

accounting rate of return = $\frac{179850}{545000}$

So, accounting rate of return = 33 %

7 0

3 years ago