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

Business Events and Transactions for January 2019: The Investors set up Country Club, LLC to construct and operate the golf course. The investment company hired professional staff to manage the golf course. The company will operate on a calendar year basis. The golf course is scheduled to open on January 1. Record the following transactions to set up the business: April 1, 2019: Country Club received cash and issued Common Stock for $1,250,000 April 1, 2019: 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: 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 January. Record the following transactions that occurred during the month on January 1^st or as otherwise listed. Purchased one years worth of Prepaid Insurance on January 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 February 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 January and the remaining $5,000 will be paid next month (February). Month End January 31^st 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 February 1st. In preparation, it purchased the following inventory items for the Pro Shop during January. The items were purchased from the Nike Corporation on account with the payment due at the beginning of February. 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.) January 31st, 2019: Preparation of April Bank Reconciliation: The golf course received the bank statement for January 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 on January 31st, 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 General Ledger), prepare a Statement of Cash Flows for the month of January 2019. 4 Project Check Figure For the 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 January 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 January 31 Statement of Cash Flows.