90.2K

Verified Solution

Link Copied!

need help with this asap, thanks!

2 Freeze cells so that rows 1 and 2 are frozen 2 insert an equation in cell H7 that shows the markup for this sale (revenue minus cost) 2 On cell H, insert a comment that stateste formula you useed in the formula 3 In cell C3, insert a cell reference that pulls the Cash balance from the opening balances from page 1 4 In cell D14, insert a cell reference that pulls the balance from the Common Stock ledger from page 3 5 Update the font for the company name on all 3 financial statements. Make them Times New Roman 5 Increase the font size of the names of all 3 financial statements. Make them size 11 5 In cell H17, type an equation to provide the smallest (minimum) balance in the balance sheet 5 In cell H18, type the account name that has the smallest balance 5 Set the print area so that the area with the dark blue border will print 5 Change the page layout to landscape 5 Set the print area to fit to one page A x B C D E F G Delano Corporation Balance Sheet December 31, 2020 \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Assets } & \multicolumn{1}{|c|}{ Liabilities and Stockholders' Equity } \\ \hline Cash & 60,000 & Accounts payable \\ \hline Accounts receivable & 40,000 & Common stock ( $1 par) \\ \hline Allowance for doubtful accounts & (4,000) & Retained eamings \\ \hline Inventory & 33,000 & \\ \hline & 129,000 & \\ \hline & & \\ \hline & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l|l|l|l|} \hline DNSTRUCTIONS & 1.Opening Balances & 2.Journal Entries & 3.Ledger & 4.Worksheet & 5.Financial St: \end{tabular} Profit on Sale? B C D E F ALLOW. FOR DOUBT. ACCTS DR BALANCE Beginning INVENTORY \begin{tabular}{|r|r|r|} \hline \multicolumn{1}{|c|}{ DR } & \multicolumn{1}{c|}{ CR } & \multicolumn{1}{c|}{ BALANCE } \\ \hline 33,000 & & 33,000 \\ \hline 9,000 & & 42,000 \\ \hline & 7,000 & 35,000 \\ \hline 500 & & 35,500 \\ \hline \end{tabular} ACCOUNTS PAYABLE DR BALANCE \begin{tabular}{|l|r|r|r|} \hline Beginning & \multicolumn{1}{c|}{ DR } & \multicolumn{1}{c|}{ CR } & \multicolumn{1}{c|}{ BALANCE } \\ \hline je.1 & & 25,000 & 25,000 \\ \hline je. 5 & & 9,000 & 34,000 \\ \hline \end{tabular} COMMONSTOCK \begin{tabular}{|c|c|c|} \hline DR & CR & BAL.ANCE \\ \hline & 10,000 & 10,000 \\ \hline \end{tabular} RETAINED EARNINGS DR BALANCE Beginning 94,000 \begin{tabular}{|l|l|l|l|} \hline INSTRUCTIONS & 1.Opening Balances & 2.Journal Entries & 3.Ledger \\ \hline \end{tabular} 4. Worksheet Ready i? Accessibility: Good to go B C D E F RETAINED EARNINGS Beginning REVENUE je. 2 \begin{tabular}{|c|c|r|} \hline DR & CR & BALANCE \\ \hline & 18,000 & 18,000 \\ \hline \end{tabular} SALES RET \& ALL DR BALANCE je. 3 1,000 COST OF GOODS SOLD BALANCE je. 2 SALARIES EXPENSE \begin{tabular}{l} DR \\ \hline 10,000 \end{tabular} CR BALANCE je. 6 10,000 1234567891011121314151617181920212223 A

Answer & Explanation Solved by verified expert

See Answer