Re: Zero coupon bond vs. non-interest bearing debt
Zero coupon bonds still have an interest rate. They are typically sold at a discount and using regular bond math to calculate interest expense (and rate) means they are interest bearing. Separately, there is no cash outflow for the interest on the zero coupon until fill payment at maturity.

Re: bank's credit costs calculation
Yes, you have the right idea. Just make sure to match time periods. Total Provisions is typically an Income Statement item and Total Loans is a Balance Sheet item.

Re: Return Column and Row Vales for the minimum value in the table
Hello, there are a couple of ways to approach this, depending on how inflexible (or flexible) your table is to begin with. For now, we have a solution that only works if you're 100% sure that the minimum value appears exactly once. Open a blank workbook and enter your sample data. The numbers ... Hello, there are a couple of ways to approach this, depending on how inflexible (or flexible) your table is to begin with.

For now, we have a solution that only works if you're 100% sure that the minimum value appears exactly once.

Open a blank workbook and enter your sample data. The numbers will be in a square from B2 to D4.

First, to identify the minimum value, we can easily use the MIN function: =MIN($B$2:$D$4). This gives us 2, which is correct. Let's enter this formula into H2 for now, as a placeholder.

Next, to identify its column number within the overall table, we can "calculate" it by going through every column and looking for a match. For the columns with no match, we will get a 0, and for the columns with a match, we will get a 1.

You can visualize this search by imagining the columns in our table as [2, 3, 4].

Then, imagine a separate table (matrix) of 0s and 1s, where everything is a 0, except a 1 for your matching search value (aka "TRUE"). The 1 will be in the far bottom-left corner in this case.

We can use SUMPRODUCT to combine these and correctly look for the 2 in [2, 3, 4]. In H3, enter the formula as such: =SUMPRODUCT(COLUMN($B$1:$D$4)*($B$2:$D$4=H2))

It can seem a bit confusing at first, but basically it's returning a 0 for all those 0s in the matrix where we don't have our match, then multiplying the 1 for our found search value by its corresponding column number from that [2, 3, 4]. Of course, 1 times any number will just return that number, which is what we want.

So this gives us 2, which is correct, because our minimum value exists in column B.

We can apply the same logic with ROW instead of COLUMN for the row. Let's enter this in H4:

=SUMPRODUCT(ROW($B$1:$D$4)*($B$1:$D$4=H2))

This gives us 4, which is correct, because our minimum value exists in row 4.

You could sanity check this by entering =ADDRESS(H4,H3) which gives us $B$4: the exact location of our minimum value.

Again, remember that this will completely break if your minimum value exists in more than one place in the table, because the SUMPRODUCT will be a very inflated number. To fix this, we could wrap everything in an IFERROR that would return something like "[multiple minimum values]", but at that point, it might be better to just write a very simple VBA macro to spit out all of their locations.

Please let us know if that helps. If the SUMPRODUCT is not clear, try entering its two parameters separately into a blank range to help see it visually, or come back for further discussion. Read More

Re: End of Year vs Beginning of Year
Yes, that is correct! As explained earlier in the course (or another related course), the period ending Jan 2007 we are calling 2006 since 11 months of the 2006 are included. The reason why some retailers end their fiscal year in January as opposed to December is to account for the after-Christmas/H... Yes, that is correct! As explained earlier in the course (or another related course), the period ending Jan 2007 we are calling 2006 since 11 months of the 2006 are included. The reason why some retailers end their fiscal year in January as opposed to December is to account for the after-Christmas/Holiday Sale and the major discounts after the New Year, and more importantly, to capture the revenue from gift card purchases. You can only recognize the revenue when the gift card is used, not when sold and 92.183% of all gift card purchases during the holidays are used after Christmas and New Year. Hope that helps explain the logic! Read More

Re: Bank Financial Modeling
Hello, Thank you for your inquiry. Our Bank Modeling course is focused primary on the integration of the financial statements for a bank. We do spend some time on justifying the inputs from the footnotes and additional disclosures. However, our courses is not meant to be a deep dive forensic ac... Hello,
Thank you for your inquiry.

Our Bank Modeling course is focused primary on the integration of the financial statements for a bank. We do spend some time on justifying the inputs from the footnotes and additional disclosures. However, our courses is not meant to be a deep dive forensic accounting or auditing of the loan book of a bank. As such, we do not do a detailed review of the newer Basel III and FASB CEEL methodologies, since absent additional non-public information that you simply will never have access to from public filings, we can only rely on historical trend reported and then modify for any impending crises or shock events you might see around the horizon. Hope that helps clarify. We are happy to hop on a call anytime to discuss further if necessary.

Thank you. Read More