We have to make our own financial statements. Thank you!

the changes flow through. Instructions for Week 12 and Week 13 Lab Tab (You may find it helpful to print out this instruction sheet.) 1. Before you begin read all the instructions below. 2. Every amount in the Horizontal Analysis table must be cell referenced to the Inputs area below. No amount can be typed or hard-keyed in the table except column AJ. column. 6. Any cell shaded in yellow requires a formula. to every cell in that column. The purpose of the =IF statement is to show that every line item in the horizontal analysis balances. Instructions for Account Analysis 1 Fill in the description of how each account works. Ask yourself why does the account increase and why does the account decrease? 2 Cell reference the appropriate dollar amounts to calculate the ending balance in each account. The ending balances are needed to complete the balance sheet. Instructions for Financial Statements tab: see Chapter 4, (2) Statement of Changes in Stockholder's Equity, (3) Classified Balance Sheet - see Chapter 9, and (4) Statement of Cash Flows. Statement (e.g. Sales, COGS, Gross Margin, etc.) can be typed/hard-keyed. All amounts must be cell referenced or generated using a formula (e.g. =SUM). Accounts Receivable, etc.) can be typed/hard-keyed. All amounts must be cell referenced or generated using a formula (e.g. = SUM). this is not true. Azul Company had the following balances in its accounting records as of January 1, Year 2: \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Evert wo & & & Soprias & & mentary & & & & & & & & & & & & & \\ \hline & & & & = & & & & & & & & & & & & & & \\ \hline & & & & & E & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & \\ \hline 0 & & & & & & E & & & & & & & & & & & & \\ \hline & & & & & & & & & & = & & & & & & & & \\ \hline & & & & & & & & & & - & & \pm & & = & & & & \\ \hline & & & & & & & & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Accounts Receivable & \multicolumn{2}{|c|}{ Equipment } \\ \hline Beginning Balance & Beginning Balance & \\ \hline Add: & Add: & \\ \hline Less: & Less: & \\ \hline Less: & Ending Balance & \\ \hline \multicolumn{3}{|l|}{ Ending Balance } \\ \hline Allowance for Doubtful Accounts & \multicolumn{2}{|c|}{ Accumulated Depreciation - Vehicle } \\ \hline Beginning Balance & Beginning Balance & \\ \hline Add: & Add: & \\ \hline Less: & Less: & \\ \hline Ending Balance & Ending Balance & \\ \hline \end{tabular}