could i get some help filling out the retained earning sheet, and could try and correct what i did wrong within the balance sheet, an excel spreadsheet would be preferred if possible. i added my income statement so you could find the net income a bit easier but i calculated it wrong

Grid Iron Prep Inc (GIPI) is a service business Incorporated in January of the current year to provide personal training for athletes aspiring to play college football. The following transactions occurred during the month ended January 31 a GIPI Issued stock in exchange for $140.000 cash on 101 b. GIPI purchased a gymnasium building and gym equipment on 1/02 for $54.000, 80% of which related to the gymnasium and 20% to the equipment C GIPI paid $600 cash on 1/03 to have the gym equipment refurbished before it could be used. d. GIPI provided $8.000 in training on 1/04 and expected collection in February GIPI collected $40.000 cash in training fees on 1/10, of which $36.000 related to January and $4,000 related to February GIPI pald $26.500 of wages and $7.000 in utilities on 160 g. GIPI will depreciate the gymnasium building using the straight-line method over 10 years with a residual value of $4.000. Gym equipment will be depreciated using the double-decilning-balance method, with an estimated residual value of $5.500 at the end of its four-year useful life. Record depreciation on 131 equal to one-twelfth the yearly amount n. GIPI received a bill on 131 for $240 for advertising done on 1/31 The has not been paid or recorded GIPI uses the aging method for estimating doubtful accounts and on 31 will record an estimated 3 percent of its under 30-day-old accounts as not collecuble. GIPI's income tax rate is 30%. Assume depreciation for tax is the same amount of depreciation for financial reporting purposes 140,000 Cash Common Stock 1400 |1 ||11 Buildings Equipment Cash 43,2000 10_800/ 5400 B000 Equipment Cash 8.0000 Accounts Receivable Service Revenue 80000 Cash Service Revenue Deferred Revenue 40,0000 36 265000 Salaries and Wages Expense Utilities Expense Cash 33,500 0 802/ Depreciation Expense Accumulated Depreciation-Equipment Accumulated Depreciation Buildings 7 240 0 Advertising Expense Accounts Payable 240 / 240 Ead Debt Expense Allowance for Doubu - . 7 2 5 265/ Income Tax Payable 2:85 Prepare the statement of retained earnings for the month ended January 31. You will need to determine and enter the accounts and balances to prepare the Statement of Retained Eamings. (Round your final answers to the nearest whole dollar amount.) GRID IRON PREP, INC Statement of Retained Earnings For the Month Ended January 31 Balance, January 1 Vet income Add Dividends Balance, January Answer is not complete. Statement of General General Requirement Trial Balance Income Retained Balance Journal Ledger Statement Earnings Use the dropdowns to select the accounts properly included on the balance sheet. However, you will need to enter the amount of the Accounts receivable (net of Allowance for Doubtful Accounts), Buildings, Equipment (net of Accumulated Depreciation), Common stock and Retained earnings. (Round your final answers to the nearest whole dollar amount.) 91,900 8.000 X 90.000 43200 GRID IRON PREP INC Balance Sheet As of January 31 Assets Current Assets Cash Accounts Receivable Total Current Assets Buildings Equipment Total Assets Liabilities Current Liabilities Allowance for Doubtful Accounts Deferred Revenue Accounts Payable Total Current Liabilities Stockholder's Equity Common Stock 11.400 154,500 OOOOOOOOOOO 240 4,000 4.480 6.453 3 6.463 Total Stockholders' Equity Total Liabilities and Stockholders' Equity 10.933 O Answer is not complete. Requirement Statement of General Journal Income General Ledger Trial Balance Balance Sheet Statement Retained Earnings Choose the appropriate accounts to be reported on the income statement. However, you will need to calculate and enter the amount of the Income before Income Tax Expense and net income or loss for the period. (Round your final answers to the nearest whole dollar amount.) GRIDIRON PREP INC. Income Statement For the Month Ended January 31 Revenue Service Revenue 44,000 Bololololo 28,500 xpenses Salaries and Wages Expense Utilities Expense Depreciation Expense Advertising Expense Bad Debt Expense 7,000 802 240 stal Expenses Income before income Tax Expense $ 34,782 9.218 2,765 56.4708 Income pense Trial Balance Retained Eaming