If you built a depreciation model based upon the one in the Excel Workbook what

Question

If you built a depreciation model based upon the one in the Excel Workbook what would be the BEST formula in B71?

A.IF(A71>$B$63,($B$61-$B$62)/$B$63,0)
B. IF(A71>$B$63,0,($B$61-$B$62)/$B$63)
C. IF(A71>=$B$63,($B$61-$B$62)/$B$63,0)
D. IF(A71>=LIFE,($B$61-$B$62)/LIFE,0) Where cell B63 has been named LIFE

5S 56 57 58 DEPRECIATION SCHEDULE 59 60 NAME OF ASSET 61 COST PRICE 62 RESIDUAL VALUE 63 LIFE (IN YEARS) 64 65 REPORT Motor Vehicle S40,000.00 $5,000.00 YEAR STRAIGHT LINE 67 68 69 70 71 72 73 74 75 76 7000.00 7000.00 000.00 7000.00 7000.00 0.00 0.00 0.00 0.00 0.00 35000.00 4 10 78 79

Explanation / Answer

Answer: B. IF(A71>$B$63,0,($B$61-$B$62)/$B$63)

Explanation: in Excel, the formula is written as: IF(condition, true value, false value).

Here if A71, i.e.year is greater than B63(Life), the output value should be 0 , else the output value should be

(B61 - B62)/B63.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.