_Requirements
1 Split the contents of LIST 1 into separate cells. Use functions LEFT, MID, RIGHT, FIND and VALUE as needed.
- Split the contents of LIST 2 into separate cells. Add a column to List 2 that calculates the lower of cost or fair value by security using the function MIN
- Create a new list of securities that has Description, Category, Short-term or Long-term, and Lower of Cost or Fair Value. This new list should contain values (not formulas).
- Copy the new list to a new location. Sort securities as to whether they are short-term or long-term (in reverse alphabetical order), then sort by category (in reverse alphabetical order).
5 Copy the sorted list and paste values to a new location. Subtotal the lower of cost or market of the securities first by time (short-term or long term), then by category (trading, held-to-maturity, or available-for-sale). On the second subtotal, do not remove the previous subtotals
Instructions ENTERANSWERS Chaywer to conten =alet iret tomesail Lacel hele 1. 3arestio 2. Uptoal pod witr-il your tie to be grated. b. Clat on 'Aasigrimenta. 4. Lpinat riat litioj - Dintie deek yoy zptrakd the ngri ties 1. Afteret men. Gomplytiog Chapter Cacel Covees 2. Glek of Zravericarws 3 bevect the Dux lat tea chapter 4. Genquese tre Gux. Q. Subrit the Quet The financial statement presentation of debt securities categorized as trading. HTM, or AFS as of March 31,2024 , is due shortly. Upon examination of the two lists of securities, Catherine noticed the following keys to the data: \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ List I Character Identifier } \\ \hline Security ID & Characters 1-6 \\ \hline Security Description & Characters 7-10 \\ \hline Category (TRA, HTM, AVS) & Characters 11-13 \\ \hline Time (ST or LT) & Characters 14-15 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ List 2 Character Identifier } \\ \hline Security ID & Characters I-6 \\ \hline Cost & Variable number, follows the hyphen \\ \hline Fair Value & Variable number, follows the asterisk \\ \hline \end{tabular} \begin{tabular}{l|} \hline LIST 1 \\ \hline 100210 NSFTTRAST \\ \hline 100230 PRCLAFSLT \\ \hline 100240 JNTUTRALT \\ \hline 100250 BDBEAFSST \\ \hline 100260 DSCOAFSST \\ \hline 100270 BMZNTRAST \\ \hline 100290 BAPLTRAST \\ \hline 100310 QANWAFSLT \\ \hline 100340 DHKPTRAST \\ \hline 100350 UBILHTMST \\ \hline 100360 UBILHTMST \\ \hline 100370 UNOTHTMLT \\ \hline \end{tabular} \begin{tabular}{l} LIST 2 \\ \hline 1002105650051000 \\ \hline 1002301963016810 \\ \hline 1002406142064600 \\ \hline 1002502350025200 \\ \hline 1002605840057400 \\ \hline 1002703525035500 \\ \hline 1002904550047500 \\ \hline 1003108200080600 \\ \hline 1003401551016686 \\ \hline 1003501995019960 \\ \hline 1003601890018920 \\ \hline 1003704979049770 \\ \hline \end{tabular} Requirement 2: Split the contents of LIST 2 into separate cells. Add a column to List 2 that calculates the lower of cost or fair value by security using the function MIN. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong.) Instructions ENTERANSWERS Chaywer to conten =alet iret tomesail Lacel hele 1. 3arestio 2. Uptoal pod witr-il your tie to be grated. b. Clat on 'Aasigrimenta. 4. Lpinat riat litioj - Dintie deek yoy zptrakd the ngri ties 1. Afteret men. Gomplytiog Chapter Cacel Covees 2. Glek of Zravericarws 3 bevect the Dux lat tea chapter 4. Genquese tre Gux. Q. Subrit the Quet The financial statement presentation of debt securities categorized as trading. HTM, or AFS as of March 31,2024 , is due shortly. Upon examination of the two lists of securities, Catherine noticed the following keys to the data: \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ List I Character Identifier } \\ \hline Security ID & Characters 1-6 \\ \hline Security Description & Characters 7-10 \\ \hline Category (TRA, HTM, AVS) & Characters 11-13 \\ \hline Time (ST or LT) & Characters 14-15 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ List 2 Character Identifier } \\ \hline Security ID & Characters I-6 \\ \hline Cost & Variable number, follows the hyphen \\ \hline Fair Value & Variable number, follows the asterisk \\ \hline \end{tabular} \begin{tabular}{l|} \hline LIST 1 \\ \hline 100210 NSFTTRAST \\ \hline 100230 PRCLAFSLT \\ \hline 100240 JNTUTRALT \\ \hline 100250 BDBEAFSST \\ \hline 100260 DSCOAFSST \\ \hline 100270 BMZNTRAST \\ \hline 100290 BAPLTRAST \\ \hline 100310 QANWAFSLT \\ \hline 100340 DHKPTRAST \\ \hline 100350 UBILHTMST \\ \hline 100360 UBILHTMST \\ \hline 100370 UNOTHTMLT \\ \hline \end{tabular} \begin{tabular}{l} LIST 2 \\ \hline 1002105650051000 \\ \hline 1002301963016810 \\ \hline 1002406142064600 \\ \hline 1002502350025200 \\ \hline 1002605840057400 \\ \hline 1002703525035500 \\ \hline 1002904550047500 \\ \hline 1003108200080600 \\ \hline 1003401551016686 \\ \hline 1003501995019960 \\ \hline 1003601890018920 \\ \hline 1003704979049770 \\ \hline \end{tabular} Requirement 2: Split the contents of LIST 2 into separate cells. Add a column to List 2 that calculates the lower of cost or fair value by security using the function MIN. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong.)
