can you help me with this excel problem, the first question is to fuel out the empty box and in yellow with excel command, for each sample, can you show me stwp by step. and the explanation behind everything at the end. thank you change inpul(s) and make sure the changes flow through: Instructions for Week 12 and Week 13 Lab Tab (You may find if holptur to print out this instruction sheet) 1. Before you begin read all the instructions below. 2. Every amount in the Horizontal Analysis tablo must be cel referenced to tho: Inputs area bolow. No amount can be typed or hard keyed in the table except column A.). 3. Retained Earnings column needs to populate automaticaly based on an =IF statement. Write the =IF statement and then copy down to every col in that column. Do not hard-key any amounts in this column 4. Net Income column needs to populate automaticaly based on =IF statement. Write the =if statement and then copy to every cel in that column Do not hard-key any amounts in this column 5. Statement of Cash Flows column needs to be coll referenced to the Cash column Cell reference and then copy to every cel in that cokumn Do not hard key any amounts into this colurnt 6. Any cell shaded in yeliow requires a formula 7. Cel AL 6: Write an =IF statement that roturns the word "Balanced" if Assels equal Liabilities + Equity or "Not Balanced" if Assets do not equal Liabilities + Equify. Write the =IF statement and then copy to every cel in that column. The purpose of the =IF statement is to show that ewery line itam in the horcontal atralysis balances Instructions for Account Analysis 1 Fill in the description of how each account works. Asik yourself why does the account increase and why does the account decrease? 2 Cell roference the appropriate dollar amounts to calculate the ending balance in each account. The ending balances are needed to conglate the beance shoxt 1. Create the financial statements You can create the financial stalements al on one tab or you can creale a separate tab for each financial statenent You inust create (1) Flows aStM) 4. Balance Shent: Creale an =IF statement that returns the word "Balanced" if Assets equal Liabilities + Equity or "Not Batanced" if Assets do not oqual Lisbilites + Equity M Account Tibes (e.g Cash, Accounts Receivable, efc) can be typodhard-keyod. Al arnounts must bo cel referenced or generated using a formula (e g = sum) 5. Statement of Cash Flows: Create an =fF stathment that returns the word "Correcr if the ending balance in Cash equas the ending balance of Cash as shown on the Balance Sheot or "For Correct" if this is not true. Azul Company had the folowing balances in its accounting records as of January 1, Year 2 The following accounting ovents occurred during Year 2. 1 The vehicle was sold on the first day of the year for $18,000 cash 2 Recowed \$45,000 cash from issuance of slock 3 Purchased $1,500 of supplies on account 4 Paid eish for $42,200 of inventory 5 Paid $18,000 for 12 -month's of rent on new office building 6 Took out a $15,000,7%,9 month loan from Citymide Bank 7 Paid $12,000 to purchase equipment. 8 Paid $800 in shipping and instatation costs for now equipenent 9 Sold 65% of the imvertory purchesed in Event 4 for $120,000 on account 10 Colocted 75% of the sabs on accourt in previous event 11 Wrote-off receivabie in the amourt of $1,300. 12 Incurred $53,700 of operating expenses on account. Year-End Adjustments A Recorded depreciation on the equiprient. A ful year of fopreciation should be taken on the Equipment. The equipment has a salvoge of $1,000 and a 10-year life. Use =SLN formula to cilculate. 8 Have stro of cilice supplies on hend at the end of the penod \begin{tabular}{|l|l|} \hline \hline & \\ \hline & \\ \hline & \\ & \\ & \\ & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Type Cashi Receind Cakulater gain or loss, if any Type amount. Type amount Type amount. Type arnount Typo amount. Type amount. Type amount. Type amount of Sale. Typo percentage in columen I Use formula in column d Type percentage in column I. Use formula in column J Type amount Type emount Inputs area Gshar. x PCominems G thate *
