This video illustrates a spreadsheet design which can be used for MIRR, IRR and NPV. Both the "algebraic" approach (using traditional time-value-of-money formulae) is shown, as well as the straightforward Excel function (e.g. =IRR(xxxxxx). And of course...

From Bruce Marshall

This video illustrates the process of debt amortization using excel. The illustration is that of a car loan, and not only is the amortization table demonstrated in excel, but the "Goal Seek" function of excel is used to vary other input factors (e.g. int...

From Bruce Marshall

This video illustrates how present value concepts (for both the annuity of the interest payments, and the amount of the bond principal) are used to determine the total bond proceeds (i.e. funds received by the bond issuer) at the time of issuance....

From Bruce Marshall

This is the Chapter 4 comprehensive problem from your textbook, demonstrating the consolidation of a subsidiary wherein the parent owns less than 100% of the common stock (in this case, the parent owns 80% of the stock)....

From Bruce Marshall

This video illustrates the same Chapter 3 comprehensive problem -- except instead of demonstrating the full equity method of accounting for the investee, we illustrate the "initial value" method (in years past, we called this the "cost" method). You'll s...

From Bruce Marshall

This explanatory video discusses the different cost flow assumptions in valuing ending inventory, and thus, the cost of goods sold for the period. Discusses the theory presented in chapter 7 of the text for ACC250 - California Baptist University....

From Bruce Marshall