Help create double entry model, inventory purchase sheet, bank reconciliation, and statement of cash flows using information on excel.

Business Events and Transactions for April 2019: The Investors set up Antelope Ridge Country Club, LLC to construct and operate the golf course. The investment company hired a professional staff to manage the golf course. The company will operate on a calendar year basis. The golf course is scheduled to open on April 1. Record the following transactions to set up the business: April 1, 2019: Antelope Ridge Country Club received cash and issued Common Stock for $1,250,000 April 1, 2019: Antelope Ridge Country Club issued a 5 year Note Payable to Stearns Bank and Trust for $750,000 at a 6% annual rate. Interest is payable monthly on the 1st of each following month. April 1, 2019: Antelope Ridge Country Club used the cash raised from the stock sale and the issue of the note payable to purchase the Antelope Ridge Country Club for $1,775,000. The purchase price was allocated to land $650,000, the Pro Shop building on the golf course $750,000 (building), maintenance equipment for $225,000, and 30 golf carts for $5,000 per cart or $150,000. The golf course was officially opened the first Friday in April. Record the following transactions that occurred during the month on April 30th or as otherwise listed. Purchased one years worth of Prepaid Insurance on April 1st for $42,000 cash. Total Rental Fees for golf clubs, carts, etc collected in cash for the month were $18,600. Total Green Fee revenues collected in cash for the month were $208,000. Golf lessons beginning the first week of May have been paid for. The cost is $460 for 6 weeks of lessons. Thirty people have signed up. Golf course maintenance expenses for the month paid by check at the date of service were $143,000. Total Salary Expense for the month was $63,000; of that amount $58,000 was paid during the month of April and the remaining $5,000 will be paid next month (May). Month End (April 30th) Adjusting Entries: Adjust Prepaid Insurance for the amount used in April. Add an entry to accrue one month of interest on the Note Payable. 3 Purchase of Inventory Items: The company intends to open the Pro Shop on May 1st. In preparation it purchased the following inventory items for the Pro Shop during April. The items were purchased from the Nike Corporation on account with the payment due at the beginning of May. 20 golf bags for $175/bag 20 sets of golf clubs for $1,050 / set 25 pairs of golf shoes for $125 / pair 120 boxes of golf balls for $30 / box (Hint: The weekly Purchase and Payment tab in the Excel file has already calculated the total purchase for each inventory item. The worksheet has calculated the total purchase and summarized the accounting entry needed for entry into the Double Entry software.) April 30th, 2019: Preparation of April Bank Reconciliation: The golf course received the bank statement for April 2019 from its bank during the first week of May 2019. You need to prepare the bank reconciliation for April by reconciling the cash balance shown on the bank statement with the unadjusted cash balance in the general ledger cash account. The bank statement showed the cash balance was $213,905. The general ledger showed the unadjusted cash balance in the general ledger cash account at April 30th, 2019 was $222,400. (Use the Bank Reconciliation tab of the Excel workbook). An examination of the bank statement disclosed the following: 1. Outstanding checks totaled $5,200. 2. The bank had issued a $1,600 debit memo for five insufficient funds (NSF) checks. 3. The bank statement enclosures included a debit memo for $60 that had been deducted from the Antelope Ridge Country Club bank account as a monthly service charge. 4. Deposits in transit were $11,225. 5. The bank showed a check cleared the bank for $900. When the transaction was reviewed it was determined that the check was recorded in the general ledger as $90. It should have been recorded on the books for $900. The check was written for maintenance expenses. Preparation of the Statement of Cash Flows: Using the Cash account (Running Ledger account in the General Ledger), prepare a Statement of Cash Flows for the month of April 2019. 4 Project Check Figure For small business, one of the key internal controls is the preparation of the month end bank reconciliation. The True Cash Balance for the project is $219,930. This balance appears in three places on the project. First, it is the April ending balance on the bank reconciliation. Second, it is the ending general ledger balance for the cash account (remember you need to post your bank reconciliation journal entries into the Double Entry software). Finally, this is the ending cash balance that shows on the April 30 Statement of Cash Flows.