If you have a laptop with you, it would be easier to show and answer this Financial Modeling Interview Question. If not, then just explain how it is done.
An array formula helps you to perform multiple computations one or more sets of values.

There are three steps one should follow to compute array function in EXCEL –

• Before ENTERING the array formula into the cell, first, highlight the range of cells.
• TYPE in the array formula in the first cell.
• Press Ctrl + Shift + Enter to get the results.

In the Financial model, we make use of arrays in Depreciation Schedule where the BREAKUP of Assets (SHOWN horizontally) are transposed vertically using Transpose Function with Arrays.

If you have a laptop with you, it would be easier to show and answer this Financial Modeling Interview Question. If not, then just explain how it is done.
An array formula helps you to perform multiple computations one or more sets of values.

There are three steps one should follow to compute array function in excel –

In the Financial model, we make use of arrays in Depreciation Schedule where the breakup of Assets (shown horizontally) are transposed vertically using Transpose Function with Arrays.