Redmond Corporation started operations on April 1, 2018. Seventeen transactions occurred during April. Financial statements are prepared at the end of the month.

Requirements
1. Use Excel to record the transactions for April. Use the blue shaded areas for inputs.

a. To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right. Click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry.

                      

b. Indent the account name of the account to be credited using the indent button on the Home tab. Click the Increase Indent button twice.

                                                                

2. Post the transactions to T-Accounts. Use the blue shaded areas for inputs.

a. For each transaction, post the amount on the correct side of the T-Account. The T-account totals will be calculated automatically.
b. Total debits should equal total credits. The debit-credit balance check appears in the top right hand corner of the T-Account worksheet.

3. Prepare the income statement, statement of retained earnings, and balance sheet for the company using the trial balance. Each financial statement appears on a separate worksheet tab.

a. Fill in the blue shaded areas using a formula that references the account balances in the trial balance at the end of the month.
b. Format the cells requiring dollar signs. Number formatting is located on the Home tab.

                                    

c. Format the cells requiring a single underline and cells requiring double underlines. The borders tool is found on the Home tab. It looks like a window pane. Click the down arrow for different border selections.