Answer:We use the Large Function. the general formula is =LARGE(first cell:last cell,3) .Please refer to the explanation section for details
Explanation:
Let us assume
A 1 = $1,250, A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600
Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;
=LARGE(A1:A2,3)
<span>
The most common source of business system failure is : B ) data quality
-Hope this helps.</span>
Answer:
The company’s WACC is 11.38%
Explanation:
After tax cost of debt = 9.6*(1 - 0.34)
= 6.336%
Debt-equity ratio = Debt/Equity
debt = 0.64*Equity
Let equity be $x
debt = $0.64x
Total = $1.64x
WACC = Respective costs*Respective weights
= (6.336*0.64x/1.64x) + (14.6/1.64x)
= 11.38%
Therefore, The company’s WACC is 11.38%
Answer:
a. $46,000
see the other answers in the explanation
Explanation:
(a) Fair value of leased asset to lessor $245,000
Less: Present value of unguaranteed residual value $24,335 X .63017
(present value of 1 at 8% for 6 periods) $15,335
Amount to be recovered through lease payments $229,665
Six periodic lease payments $229,665 ÷ 4.99271 $46,000*
*Present value of an annuity due of 1 for 6 periods at 8%.
b.
(c)
1/1/17
Lease Receivable 245,000
Cost of Goods Sold 229,665
Sales Revenue 229,665
Inventory 245,000
1/1/17
Cash 46,000
Lease Receivable 46,000
12/31/17
Lease Receivable 15,920
Interest Revenue 15,920
1/1/18
Cash 46,000
Lease Receivable 46,000
12/31/18
Lease Receivable 13,514
Interest Revenue 13,514
Answer:
Actual usage of material exceeds the standard material allowed for output.
Explanation:
<em>Material quantity variance occurs when the actual quantity used to achieved a given level of output is greater or less than the standard material allowed.</em>
<em>It is determined by the difference between the actual and standard quantity of material for the actual level of output multiplied by the the standard price</em>
An unfavorable materials quantity occurs when the actual quantity used to achieved a given level of output is greater than the standard material allowed.
<em>It is might be an indication of wastage in the usage of materials or inefficiencies.</em>