Directions: Fill in the Cash Basis Income Statement and the Accrual Basis Income Statement given the transactions below. Use a separate line item on the statements for each transaction. If a transaction does not lead to a revenue or an expense do not put anything on the income statement. The accounting period ends on December 31. Show revenues as positives and expenses as negatives in the spreadsheet. The spreadsheet is set up to calculate net income for each year as revenues minus expenses. Transactions: 1 2 3 4 5 6 7 In January of Year 1, Hicks Company signed a contract for $720,000 to provide consulting services evenly over a 3 year period. They received one-half of the payment up front and will receive the remainder at the completion of the contract. Hicks owns land that has increased in value by $5,000. Hicks spent $5,000 in Year 1, $6,000 in Year 2, and $7,000 in Year 3 on research that they hope will lead to better consulting processes. Hicks signed a three-year lease on office space for $6,000 per year. They were required to pay the entire amount up front. Hicks ran an advertising campaign in Year 1 for $5,000. They paid for the advertising in Year 2. Hicks purchased $21,000 of computer equipment and paid for it in Year 1. The computer equipment is expected to last for 3 years. Employee salaries for work they completed in Year 1 was $8,000, for Year 2 $10,000, for Year 3 $12,000. Hicks paid Year 1 salaries on December 29 of Year 1, Year 2 salaries on January 2 of Year 3, and Year 3 salaries on December 30 of Year 3. Consulting Revenue R&D Rent Advertising Computer Equipment Salaries Net Income Consulting Revenue R&D Rent Advertising Depreciation Salaries Net Income Cash Basis Income Cash Basis Income Cash Basis Income Statement Year 1 Statement Year 2 Statement Year 3 Accrual Basis Income Statement Year 1 Accrual Basis Income Statement Year 2 Accrual Basis Income Statement Year 3