Answer:
3.14 years
Explanation:
Year Cash flow Accumulated cash flows
0 -$4,900 -$4,900
1 $1,150 -$3,750
2 $1,350 -$2,400
3 $2,230 -$170
4 $1,250 $1,080
3 years + $170/$1,250 = 3.14
The payback period is 3.14 years, or 3 years, 1 month and 19 days.
Answer:
B) =COUNT(A2:A101)
Explanation:
The COUNT function in excel with count the <em>contents</em> of all selected cells in the range (it counts what is <u>in the cells themselves</u>, not the number of cells). The range is expressed as starting cell, a colon, and the ending cell.
=COUNT(Starting cell#<u>:</u>Ending Cell)
Answer:
$ 2 per unit on average
Explanation:
Calculation for what the financial advantage (disadvantage) of purchasing the parts from the outside supplier would be:
First step is to calculate the Relevant cost of making
Relevant cost of making = 9 + 7 + 1 + ( 5 * 80 % ) Relevant cost of making= $ 21
Now let calculate the Financial advantage of buying
Financial advantage of buying = ( 21 - 19 )
Financial advantage of buying= $ 2 per unit on average
Therefore the financial advantage (disadvantage) of purchasing the parts from the outside supplier would be:$ 2 per unit on average
29,208 I used a tax calculator