how do i set up a cash flow and a vertical analysis income statement? my sheets and info below

Northern bank - 120,000, 6% interest rate, Interest is paid on June 30th of each year, principal to be repaid on June 30, 2024 Stock 0 Common Stock has a $1 par value, 500,000 shares authorized, 100,000 shares issued and outstanding at 12/31/2022. Preferred Stock has a $10 par value, 10%, 100,000 shares authorized, there were no shares issued or outstanding at 12/31/2022. o The following transactions and events occurred in 2023. Date Transaction 1/1 Issued 10,000 share of $1 par common stock to investors at $10 per share 1/1 Paid monthly rent on computer equipment, $500 1/1 Issued 5,000 share of $10 par, 10% preferred stock to investors at $15 per share 1/1 The estimated useful life and salvage value for the building that was purchased in 2022 was changed. It is now estimated that the building has a remaining life (as of 1/1/2023) of 20 years and a salvage value of $5,000. 1/1 Purchased a building and land for $200,000. The building has a 25-year expected useful life and a $10,000 expected salvage value. The land is valued at $80,000. 1/10 Purchased $250 of supplies for cash 1/15 Purchased inventory on account - 500 Running Sneakers for $121 each and 600 Aerobic for $82 each 1/15 Made a payment of $20,000 to pay off several Accounts Payable accounts 1/15 Paid the cash dividend declared in November 2022 1/31 Paid $3,300 for a 1-year insurance policy (effective 2/1/2023-1/31/2024) 2/1 BSG repurchased 1,000 shares of its own common stock to be held as treasury stock. The price paid was $12 per share 2/1 Paid the interest on the loan from Foley Bank (Remember some of the interest was accrued at 12/31/2022- your entry should include three accounts) 2/2 Paid for inventory purchased on 1/15 2/20 Sold Inventory on account (sold 100 Running Sneakers for $200 and 120 Aerobic Sneakers for $150) terms 2/10, net 30 3/2 Received notice that a customer from 2022 declared bankruptcy and will not be able to pay the remaining balance owed on their bill, $1,000 3/5 Sold Inventory on account (sold 200 Running Sneakers for $200 and 70 Aerobic Sneakers for $150) terms 2/10, net 30 3/10 Received payment for the 2/20 transaction 3/12 Received payment for merchandise sold on 3/5 3/15 Paid income taxes owed from the 2022 fiscal year. 4/2 Sold Inventory on account (sold 250 Running Sneakers for $200 and 200 Aerobic Sneakers for $150) terms 2/10, net 30 4/10 Received payment for merchandise sold on 4/2 4/30 Purchased inventory on account - 700 Running Sneakers for $123 each and 500 Aerobic for $84 each 5/1 Sold Inventory on account (sold 350 Running Sneakers for $200 and 250 Aerobic Sneakers for $150) terms 2/10, net 30 5/20 Customer from the 5/1 transaction returned inventory (50 Running Sneakers) all inventory was still in good working order 5/20 Customer paid their remaining balance from the 5/1 transaction 6/10 Paid for half of the inventory purchase from 4/30 Date 7/1 7/1 7/15 8/2 8/10 9/10 Transaction Made interest payment on equipment note to Northern Bank Purchased $50,000 of equipment using a bank loan at 6% interest to be paid in 2 years. Interest is due on June 30 of each year. The equipment has a life of 7 years and a 5,000- salvage value. Sold Inventory on account (sold 275 Running Sneakers for $200 and 315 Aerobic Sneakers for $150) terms 2/10, net 30 Purchased $300 of supplies for cash Received 7 of payment from the 7/15 transaction Purchased inventory on account - 400 Running Sneakers for $124 each and 300 Aerobic for $85 each Made a payment of $100,000 towards our accounts payable balance, Purchased $350 of supplies for cash Received $4,200 from a tenant for 6 months' rent (11/1/2023 to 4/30/2024) Paid a cash dividend of $.20 per share on outstanding shares and paid dividends to preferred shareholders Sold Inventory on account (sold 600 Running Sneakers for $200 and 510 Aerobic Sneakers for $150) terms 2/10, net 30 Received payments totaling $250,000 from customers for past due invoices 10/1 10/15 11/1 11/17 12/1 12/31 . 0 . . . . Other Information: At year end $150 worth of supplies are on hand The company uses the % of Receivables method in estimating bad debts; 3% of the ending receivables balance is deemed to be uncollectible Required: Prepare all journal entries to record the information for 2023. Prepare all adjusting journal entries as necessary Prepare an adjusted Trial Balance as of December 31, 2023 Prepare an income statement, statement of retained earnings and a balance sheet as of December 31, 2023 Prepare a cash flow statement, using the indirect method, for the year ended December 31, 2023 Close all accounts as necessary and prepare a post-closing Trial Balance Please include a sheet on how you calculated your adjusting Journal entries and inventory Prepare a horizontal analysis of the balance sheet o When preparing this analysis only analyze the sum of the main categories (total current assets, total long-term assets, total assets, total current liabilities, total long-term liabilities, total liabilities, total equity, total liabilities and equity) Prepare a vertical analysis for 2023 income statement When preparing this analysis use the following categories: Net Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, Income from Operations, Other Expenses and losses, Income before income taxes, Income Tax Expense and Net Income Compute the following ratios for the company (use 365 days per year and be sure to show all calculations) o Gross Profit Margin o Debt to assets ratio o Net Profit Margin Current ratio o Earnings per Share Inventory Turnover Return on Comm Stockholder's Days in Inventory equity 0 Average receivable turnover Return on Assets Average collection period . 0 0 0 o 0 Based on the following industry standards, comment on the profitability, solvency and liquidity of the company. o Gross Profit Margin 40.00% o Net Profit Margin 15.20% o Earnings per Share .80 Return on Comm Stockholder's equity 17.00% Return on Assets 11.00% Debt to assets ratio .50 Current ratio 1.50 o Inventory Turnover 4.00 Days in Inventory 91.25 0 Average receivable turnover 15.00 o Average collection period 24.33 0 o O 0 NOTE: It is up to you to use the skills you learned in Spreadsheets to complete a report using Excel. Please be sure all cells are referenced and using formulas where applicable. Getting or using a template from another source is considered plagiarism and will result in automatically failing this assignment. . BSG is a Corporation that sells 2 styles of Sneakers (Running and Aerobic) The company uses the perpetual FIFO method in accounting for its inventory. BSG makes its adjustments at the end of each year All sales and inventory are purchased on account Be sure to round all numbers to the nearest dollar (Do Not Use Cents). The company had the following Post-Closing Trial Balance at 12/31/2022 Credit Debit 56,254 41,475 1,244 92,000 400 50 75,000 200,000 4,700 Account Name Cash Accounts Receivable Allowance for Bad Debt Inventory Supplies on Hand Prepaid Insurance Land Building A/D- Building Equipment A/D- Equipment Accounts Payable Income Tax Payble Interest Payable Unearned Rent Dividend Payable Notes Payable Common Stock APIC - Common Stock Retained Earnings 230,000 32,867 23,200 23,023 6,808 600 10,000 170,000 100,000 200,000 122,737 . BSG uses, the 200% double declining balance, Half Year, method to depreciate all 5, 7 & 10-year property BSG uses, the SL, mid-month basis to depreciate all real property Income tax rate is 35% The $230,000 of equipment has an expected life of 7 years and no salvage value The $200,000 building has an expected life of 39 years and no salvage value Inventory at 1/1/23 consists of: o Running Sneakers - 500 units at $120 each o Aerobic Sneakers - 400 units at $80 each Notes Payable at December 31, 2022 consisted of: o Foley Bank - 50,000, 7% interest rate. Interest is paid on Feb 1st of each year, principal to be repaid on 2/1/2026 adjusted trail balance adjusting entries credit S $ Debit 218,996 38,100 $ 1,143 $ S S 68,740 150 275 155,000 320,000 S $ $ 18,615 $ 280.000 $ $ $ $ $ Account Cash accounts receivables allowance for bad debits inventory supplies on hand prepaid insurance land building A/D Building Equipment | A/D Equipment accounts payable income tax payable interest payable unearned rent notes payable common stock APIC common stocks Treasury stocks common preferred stock Apic preferred stocks Retained Earrings sales sales discount sales returns cost of goods sold rent expense supplies expense Interest expense insurance expense bad debts expense depreciation expense rent income income tax expense 96,334 42,350 46,121 8,308 2,800 220,000 110,000 290,000 $ $ $ Date Account Debit Credit 31-Dec depreciation expense $ 13,915 accumulated depreciation building $ 13,915 to record depreciation expense for building 31-Dec depreciation expense $ 56,324 accumulated depreciation Equipment $ 56,324 to record depreciation expense for equipment 31-Dec depreciation expense $ 7,143 accumulated depreciation Equipment $ 7,143 to record depreciation expense for equipment purchased on 7/1 31-Dec supplies expense $ 1,150 supplies $ 1,150 to record supplies expense 31-Dec bad debts expense $ 899 allowance for bad debts $ 899 to bring the allowance for bad debts to should be accounts 31-Dec interest expense $ 6,808 interest payable $ 6,808 to accrue interest on foley and northern bank loans 31-Dec interest expense $ 1,500 interest payable $ 1,500 to accrue interest on bank loan for equipment purchased on 7/1 31-Dec insurance expense $ 3,075 prepaid insurance $ 3,075 to record amortization of prepaid insurance 31-Dec unearned rent S 2,000 rent income $ 2,000 to recognize rent income 31-Dec income tax expense $ 46,121 income tax payable $ 46,121 to record income tax expense $ 12,000 $ 50.000 25,000 95,937 574,750 $ $ S $ $ S $ 2,610 10,000 336,160 500 1,150 12,200 3,075 899 77,382 $ S $ S $ 2,000 $ 46,121 totals $ 1,583,358 $ 1,583,358 + to 538 686px 538 x 686px B C D E G H Multi step income statement Statement of retained Earnings $ 574,750 $ Retained Earning Add net income Total Less Dividends Retained Earning $ 95,937 $ 86,653 $ 182,590 $ 26,800 $ 155,790 sales Less: sales Discount Sales Return Net sales Cost of Good Sold Gross Profit $ 2,610 $10,000 $ 12,610 $ 562,140 $ 336,160 $ 225,980 $ 500 $ 1,150 $ 12,200 $ 3,075 $ 899 $ 77,382 Operating Expenses: Rent Expenses Supplies Expense Interest Expense Insurance Expense Bad Debts Expense Departing Expense Total Operating Expenses Operating Income Other Income: Rent Income Net income before tax income tax expense net income after tax $ 95,206 $ 130,774 $ 2,000 $ 132,774 $ 46,121 $ 86,653 B D E F F G Credit $ 218,996 $ 38,100 $ (1,143) $ 68,740 $ 150 $ 275 $ 325,118 $2,610 $10,000 $562,140 Closing Entries BSG inc Date Account Debit 31-Dec Sales $574,750 sales discount sales return retained earning 31-Dec Retained earnings $95,206 Rent Expense Supplies expense Interest Expense Insurance Expense Bad Debt Expense Depreciation Expense 31-Dec Rent Income $2,000 Retained Earning 31-Dec Retained Earnings $46,121 Income Tax Expense 31-Dec Retained Earnings $26,800 Cash $500 $1,150 $12,2001 $3,075 $899 $77,382 Balance Sheet Current Assets Cash Accounts Receivable Less: allowance for bad debts Inventory supplies prepaid Insurance Total Current Assets Non Current assets Land Building Less accumulated Depreciation Building Equipment Less accumulated Depreciation Equipment Total non current asset Total assists Current Liabilities accounts Payable income tax payable Interest payable unearned rent notes payable total Equity Common Stock Less treasury stock Capital paid Preferred Stocks Retained earning total Total liabilities and owners equity $ 155,000 $ 320,000 $ (18,615) $ 280,000 $ (96,334) $ 640,051 $ 965,169 $2,000 $46,1211 $ 42,350 $ 46,121 $ 8,308 $ 2,800 $ 220,000 $319,579 $26,800 $ 110,000 $ (12,000) $ 315,000 $ 50,000 $ 182,590 $ 645,590 $ 965,169 Credit Financial Ratios For BSG Inc Gross Profit Margin Net Profit Margin Earning Per Share Return in Common Stockholders Equity Return on Assets Debt To Equity Ratio Current Ratio Inventory Turnover Days in Inventories Average Receivable Turnover 40.20% 15.41% 78.78% 14.31% 8.98% 0.50 $1,143 1.02 4.18 87.32 14.13 $18,615 Post Trail Balance BSG Inc Account Debit Cash $192,196 Accounts Receivable $38,100 Allowance for Doubtful Accounts Inventory $68,740 Supplies on Hand $150 Prepaid Insurance $275 Land $155,000 Building $320,000 Accumulated Depreciation on Building Equipment $280,000 Accumulated Depreciation on Equipment Accounts Payable Income Tax Payable Interest Payable Unearned Rent Notes Payable Common Stocks Apic Common Stock Treasury Stocks $12,000 Preferred Stock APIC Preferred Stocks Retained Earrings . $96,334 $42,350 $46,121 $8,308 $2,800 $220,000 $110,000 $290,000 $50,000 $25,000 $155,790 Total $1,066,461 $1,066,461 Hotizonal Analysis For BSG Inc 2022 2023 Inc/Dec in Value Assets $56,254 $218,996 $40,231 $36,957 $92,000 $68,740 $400 $150 $50 $275 $188,935 $325,118 $162,742 -$3,274 -$23,260 -$250 $225 $136,183 $75,000 $155,000 $195,300 $301,385 $197,133 $183,666 $467,433 $640,051 $656,368 $965,169 $80,000 $106,085 $13,467 $172,618 $308,801 Current Assets Cash Accounts Receivble Inventory Supplies On Hand Prepaid Insurance Total Current Assets Non Current Assets Land Building Equipment Total Current Assets Total Assets Liabilities and Stockholders Equilty Current Liabilities Account Payable Income Taxes Payable Interest Payable Unearned Rent Dividend Payable Notes Payable Total Liablilties Stockholders Equity Common Stocks Treasuty Stock Apic-Common Stocks Capital paid Preferred Stocks Retained Earnings Total Equity Total Liablilties and Stocholder Equilty $23,200 $42,350 $23,023 $46,121 $6,808 $8,308 $600 $2,800 $10,000 $170,000 $220,000 $233,631 $319,579 $19,150 $23,098 $1,500 $2,200 -$10,000 $50,000 $85,948 $10,000 $12,000 $100,000 $110,000 $12,000 $200,000 $315,000 $50,000 $122,737 $182,590 $422,737 $645,590 $656,368 $965,169 $59,8531 $422,853 $508,801 Northern bank - 120,000, 6% interest rate, Interest is paid on June 30th of each year, principal to be repaid on June 30, 2024 Stock 0 Common Stock has a $1 par value, 500,000 shares authorized, 100,000 shares issued and outstanding at 12/31/2022. Preferred Stock has a $10 par value, 10%, 100,000 shares authorized, there were no shares issued or outstanding at 12/31/2022. o The following transactions and events occurred in 2023. Date Transaction 1/1 Issued 10,000 share of $1 par common stock to investors at $10 per share 1/1 Paid monthly rent on computer equipment, $500 1/1 Issued 5,000 share of $10 par, 10% preferred stock to investors at $15 per share 1/1 The estimated useful life and salvage value for the building that was purchased in 2022 was changed. It is now estimated that the building has a remaining life (as of 1/1/2023) of 20 years and a salvage value of $5,000. 1/1 Purchased a building and land for $200,000. The building has a 25-year expected useful life and a $10,000 expected salvage value. The land is valued at $80,000. 1/10 Purchased $250 of supplies for cash 1/15 Purchased inventory on account - 500 Running Sneakers for $121 each and 600 Aerobic for $82 each 1/15 Made a payment of $20,000 to pay off several Accounts Payable accounts 1/15 Paid the cash dividend declared in November 2022 1/31 Paid $3,300 for a 1-year insurance policy (effective 2/1/2023-1/31/2024) 2/1 BSG repurchased 1,000 shares of its own common stock to be held as treasury stock. The price paid was $12 per share 2/1 Paid the interest on the loan from Foley Bank (Remember some of the interest was accrued at 12/31/2022- your entry should include three accounts) 2/2 Paid for inventory purchased on 1/15 2/20 Sold Inventory on account (sold 100 Running Sneakers for $200 and 120 Aerobic Sneakers for $150) terms 2/10, net 30 3/2 Received notice that a customer from 2022 declared bankruptcy and will not be able to pay the remaining balance owed on their bill, $1,000 3/5 Sold Inventory on account (sold 200 Running Sneakers for $200 and 70 Aerobic Sneakers for $150) terms 2/10, net 30 3/10 Received payment for the 2/20 transaction 3/12 Received payment for merchandise sold on 3/5 3/15 Paid income taxes owed from the 2022 fiscal year. 4/2 Sold Inventory on account (sold 250 Running Sneakers for $200 and 200 Aerobic Sneakers for $150) terms 2/10, net 30 4/10 Received payment for merchandise sold on 4/2 4/30 Purchased inventory on account - 700 Running Sneakers for $123 each and 500 Aerobic for $84 each 5/1 Sold Inventory on account (sold 350 Running Sneakers for $200 and 250 Aerobic Sneakers for $150) terms 2/10, net 30 5/20 Customer from the 5/1 transaction returned inventory (50 Running Sneakers) all inventory was still in good working order 5/20 Customer paid their remaining balance from the 5/1 transaction 6/10 Paid for half of the inventory purchase from 4/30 Date 7/1 7/1 7/15 8/2 8/10 9/10 Transaction Made interest payment on equipment note to Northern Bank Purchased $50,000 of equipment using a bank loan at 6% interest to be paid in 2 years. Interest is due on June 30 of each year. The equipment has a life of 7 years and a 5,000- salvage value. Sold Inventory on account (sold 275 Running Sneakers for $200 and 315 Aerobic Sneakers for $150) terms 2/10, net 30 Purchased $300 of supplies for cash Received 7 of payment from the 7/15 transaction Purchased inventory on account - 400 Running Sneakers for $124 each and 300 Aerobic for $85 each Made a payment of $100,000 towards our accounts payable balance, Purchased $350 of supplies for cash Received $4,200 from a tenant for 6 months' rent (11/1/2023 to 4/30/2024) Paid a cash dividend of $.20 per share on outstanding shares and paid dividends to preferred shareholders Sold Inventory on account (sold 600 Running Sneakers for $200 and 510 Aerobic Sneakers for $150) terms 2/10, net 30 Received payments totaling $250,000 from customers for past due invoices 10/1 10/15 11/1 11/17 12/1 12/31 . 0 . . . . Other Information: At year end $150 worth of supplies are on hand The company uses the % of Receivables method in estimating bad debts; 3% of the ending receivables balance is deemed to be uncollectible Required: Prepare all journal entries to record the information for 2023. Prepare all adjusting journal entries as necessary Prepare an adjusted Trial Balance as of December 31, 2023 Prepare an income statement, statement of retained earnings and a balance sheet as of December 31, 2023 Prepare a cash flow statement, using the indirect method, for the year ended December 31, 2023 Close all accounts as necessary and prepare a post-closing Trial Balance Please include a sheet on how you calculated your adjusting Journal entries and inventory Prepare a horizontal analysis of the balance sheet o When preparing this analysis only analyze the sum of the main categories (total current assets, total long-term assets, total assets, total current liabilities, total long-term liabilities, total liabilities, total equity, total liabilities and equity) Prepare a vertical analysis for 2023 income statement When preparing this analysis use the following categories: Net Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, Income from Operations, Other Expenses and losses, Income before income taxes, Income Tax Expense and Net Income Compute the following ratios for the company (use 365 days per year and be sure to show all calculations) o Gross Profit Margin o Debt to assets ratio o Net Profit Margin Current ratio o Earnings per Share Inventory Turnover Return on Comm Stockholder's Days in Inventory equity 0 Average receivable turnover Return on Assets Average collection period . 0 0 0 o 0 Based on the following industry standards, comment on the profitability, solvency and liquidity of the company. o Gross Profit Margin 40.00% o Net Profit Margin 15.20% o Earnings per Share .80 Return on Comm Stockholder's equity 17.00% Return on Assets 11.00% Debt to assets ratio .50 Current ratio 1.50 o Inventory Turnover 4.00 Days in Inventory 91.25 0 Average receivable turnover 15.00 o Average collection period 24.33 0 o O 0 NOTE: It is up to you to use the skills you learned in Spreadsheets to complete a report using Excel. Please be sure all cells are referenced and using formulas where applicable. Getting or using a template from another source is considered plagiarism and will result in automatically failing this assignment. . BSG is a Corporation that sells 2 styles of Sneakers (Running and Aerobic) The company uses the perpetual FIFO method in accounting for its inventory. BSG makes its adjustments at the end of each year All sales and inventory are purchased on account Be sure to round all numbers to the nearest dollar (Do Not Use Cents). The company had the following Post-Closing Trial Balance at 12/31/2022 Credit Debit 56,254 41,475 1,244 92,000 400 50 75,000 200,000 4,700 Account Name Cash Accounts Receivable Allowance for Bad Debt Inventory Supplies on Hand Prepaid Insurance Land Building A/D- Building Equipment A/D- Equipment Accounts Payable Income Tax Payble Interest Payable Unearned Rent Dividend Payable Notes Payable Common Stock APIC - Common Stock Retained Earnings 230,000 32,867 23,200 23,023 6,808 600 10,000 170,000 100,000 200,000 122,737 . BSG uses, the 200% double declining balance, Half Year, method to depreciate all 5, 7 & 10-year property BSG uses, the SL, mid-month basis to depreciate all real property Income tax rate is 35% The $230,000 of equipment has an expected life of 7 years and no salvage value The $200,000 building has an expected life of 39 years and no salvage value Inventory at 1/1/23 consists of: o Running Sneakers - 500 units at $120 each o Aerobic Sneakers - 400 units at $80 each Notes Payable at December 31, 2022 consisted of: o Foley Bank - 50,000, 7% interest rate. Interest is paid on Feb 1st of each year, principal to be repaid on 2/1/2026 adjusted trail balance adjusting entries credit S $ Debit 218,996 38,100 $ 1,143 $ S S 68,740 150 275 155,000 320,000 S $ $ 18,615 $ 280.000 $ $ $ $ $ Account Cash accounts receivables allowance for bad debits inventory supplies on hand prepaid insurance land building A/D Building Equipment | A/D Equipment accounts payable income tax payable interest payable unearned rent notes payable common stock APIC common stocks Treasury stocks common preferred stock Apic preferred stocks Retained Earrings sales sales discount sales returns cost of goods sold rent expense supplies expense Interest expense insurance expense bad debts expense depreciation expense rent income income tax expense 96,334 42,350 46,121 8,308 2,800 220,000 110,000 290,000 $ $ $ Date Account Debit Credit 31-Dec depreciation expense $ 13,915 accumulated depreciation building $ 13,915 to record depreciation expense for building 31-Dec depreciation expense $ 56,324 accumulated depreciation Equipment $ 56,324 to record depreciation expense for equipment 31-Dec depreciation expense $ 7,143 accumulated depreciation Equipment $ 7,143 to record depreciation expense for equipment purchased on 7/1 31-Dec supplies expense $ 1,150 supplies $ 1,150 to record supplies expense 31-Dec bad debts expense $ 899 allowance for bad debts $ 899 to bring the allowance for bad debts to should be accounts 31-Dec interest expense $ 6,808 interest payable $ 6,808 to accrue interest on foley and northern bank loans 31-Dec interest expense $ 1,500 interest payable $ 1,500 to accrue interest on bank loan for equipment purchased on 7/1 31-Dec insurance expense $ 3,075 prepaid insurance $ 3,075 to record amortization of prepaid insurance 31-Dec unearned rent S 2,000 rent income $ 2,000 to recognize rent income 31-Dec income tax expense $ 46,121 income tax payable $ 46,121 to record income tax expense $ 12,000 $ 50.000 25,000 95,937 574,750 $ $ S $ $ S $ 2,610 10,000 336,160 500 1,150 12,200 3,075 899 77,382 $ S $ S $ 2,000 $ 46,121 totals $ 1,583,358 $ 1,583,358 + to 538 686px 538 x 686px B C D E G H Multi step income statement Statement of retained Earnings $ 574,750 $ Retained Earning Add net income Total Less Dividends Retained Earning $ 95,937 $ 86,653 $ 182,590 $ 26,800 $ 155,790 sales Less: sales Discount Sales Return Net sales Cost of Good Sold Gross Profit $ 2,610 $10,000 $ 12,610 $ 562,140 $ 336,160 $ 225,980 $ 500 $ 1,150 $ 12,200 $ 3,075 $ 899 $ 77,382 Operating Expenses: Rent Expenses Supplies Expense Interest Expense Insurance Expense Bad Debts Expense Departing Expense Total Operating Expenses Operating Income Other Income: Rent Income Net income before tax income tax expense net income after tax $ 95,206 $ 130,774 $ 2,000 $ 132,774 $ 46,121 $ 86,653 B D E F F G Credit $ 218,996 $ 38,100 $ (1,143) $ 68,740 $ 150 $ 275 $ 325,118 $2,610 $10,000 $562,140 Closing Entries BSG inc Date Account Debit 31-Dec Sales $574,750 sales discount sales return retained earning 31-Dec Retained earnings $95,206 Rent Expense Supplies expense Interest Expense Insurance Expense Bad Debt Expense Depreciation Expense 31-Dec Rent Income $2,000 Retained Earning 31-Dec Retained Earnings $46,121 Income Tax Expense 31-Dec Retained Earnings $26,800 Cash $500 $1,150 $12,2001 $3,075 $899 $77,382 Balance Sheet Current Assets Cash Accounts Receivable Less: allowance for bad debts Inventory supplies prepaid Insurance Total Current Assets Non Current assets Land Building Less accumulated Depreciation Building Equipment Less accumulated Depreciation Equipment Total non current asset Total assists Current Liabilities accounts Payable income tax payable Interest payable unearned rent notes payable total Equity Common Stock Less treasury stock Capital paid Preferred Stocks Retained earning total Total liabilities and owners equity $ 155,000 $ 320,000 $ (18,615) $ 280,000 $ (96,334) $ 640,051 $ 965,169 $2,000 $46,1211 $ 42,350 $ 46,121 $ 8,308 $ 2,800 $ 220,000 $319,579 $26,800 $ 110,000 $ (12,000) $ 315,000 $ 50,000 $ 182,590 $ 645,590 $ 965,169 Credit Financial Ratios For BSG Inc Gross Profit Margin Net Profit Margin Earning Per Share Return in Common Stockholders Equity Return on Assets Debt To Equity Ratio Current Ratio Inventory Turnover Days in Inventories Average Receivable Turnover 40.20% 15.41% 78.78% 14.31% 8.98% 0.50 $1,143 1.02 4.18 87.32 14.13 $18,615 Post Trail Balance BSG Inc Account Debit Cash $192,196 Accounts Receivable $38,100 Allowance for Doubtful Accounts Inventory $68,740 Supplies on Hand $150 Prepaid Insurance $275 Land $155,000 Building $320,000 Accumulated Depreciation on Building Equipment $280,000 Accumulated Depreciation on Equipment Accounts Payable Income Tax Payable Interest Payable Unearned Rent Notes Payable Common Stocks Apic Common Stock Treasury Stocks $12,000 Preferred Stock APIC Preferred Stocks Retained Earrings . $96,334 $42,350 $46,121 $8,308 $2,800 $220,000 $110,000 $290,000 $50,000 $25,000 $155,790 Total $1,066,461 $1,066,461 Hotizonal Analysis For BSG Inc 2022 2023 Inc/Dec in Value Assets $56,254 $218,996 $40,231 $36,957 $92,000 $68,740 $400 $150 $50 $275 $188,935 $325,118 $162,742 -$3,274 -$23,260 -$250 $225 $136,183 $75,000 $155,000 $195,300 $301,385 $197,133 $183,666 $467,433 $640,051 $656,368 $965,169 $80,000 $106,085 $13,467 $172,618 $308,801 Current Assets Cash Accounts Receivble Inventory Supplies On Hand Prepaid Insurance Total Current Assets Non Current Assets Land Building Equipment Total Current Assets Total Assets Liabilities and Stockholders Equilty Current Liabilities Account Payable Income Taxes Payable Interest Payable Unearned Rent Dividend Payable Notes Payable Total Liablilties Stockholders Equity Common Stocks Treasuty Stock Apic-Common Stocks Capital paid Preferred Stocks Retained Earnings Total Equity Total Liablilties and Stocholder Equilty $23,200 $42,350 $23,023 $46,121 $6,808 $8,308 $600 $2,800 $10,000 $170,000 $220,000 $233,631 $319,579 $19,150 $23,098 $1,500 $2,200 -$10,000 $50,000 $85,948 $10,000 $12,000 $100,000 $110,000 $12,000 $200,000 $315,000 $50,000 $122,737 $182,590 $422,737 $645,590 $656,368 $965,169 $59,8531 $422,853 $508,801

Question

how do i set up a cash flow and a vertical analysis income statement? my sheets and info below

image text in transcribed

Northern bank - 120,000, 6% interest rate, Interest is paid on June 30th of each year, principal to be repaid on June 30, 2024 Stock 0 Common Stock has a $1 par value, 500,000 shares authorized, 100,000 shares issued and outstanding at 12/31/2022. Preferred Stock has a $10 par value, 10%, 100,000 shares authorized, there were no shares issued or outstanding at 12/31/2022. o The following transactions and events occurred in 2023. Date Transaction 1/1 Issued 10,000 share of $1 par common stock to investors at $10 per share 1/1 Paid monthly rent on computer equipment, $500 1/1 Issued 5,000 share of $10 par, 10% preferred stock to investors at $15 per share 1/1 The estimated useful life and salvage value for the building that was purchased in 2022 was changed. It is now estimated that the building has a remaining life (as of 1/1/2023) of 20 years and a salvage value of $5,000. 1/1 Purchased a building and land for $200,000. The building has a 25-year expected useful life and a $10,000 expected salvage value. The land is valued at $80,000. 1/10 Purchased $250 of supplies for cash 1/15 Purchased inventory on account - 500 Running Sneakers for $121 each and 600 Aerobic for $82 each 1/15 Made a payment of $20,000 to pay off several Accounts Payable accounts 1/15 Paid the cash dividend declared in November 2022 1/31 Paid $3,300 for a 1-year insurance policy (effective 2/1/2023-1/31/2024) 2/1 BSG repurchased 1,000 shares of its own common stock to be held as treasury stock. The price paid was $12 per share 2/1 Paid the interest on the loan from Foley Bank (Remember some of the interest was accrued at 12/31/2022- your entry should include three accounts) 2/2 Paid for inventory purchased on 1/15 2/20 Sold Inventory on account (sold 100 Running Sneakers for $200 and 120 Aerobic Sneakers for $150) terms 2/10, net 30 3/2 Received notice that a customer from 2022 declared bankruptcy and will not be able to pay the remaining balance owed on their bill, $1,000 3/5 Sold Inventory on account (sold 200 Running Sneakers for $200 and 70 Aerobic Sneakers for $150) terms 2/10, net 30 3/10 Received payment for the 2/20 transaction 3/12 Received payment for merchandise sold on 3/5 3/15 Paid income taxes owed from the 2022 fiscal year. 4/2 Sold Inventory on account (sold 250 Running Sneakers for $200 and 200 Aerobic Sneakers for $150) terms 2/10, net 30 4/10 Received payment for merchandise sold on 4/2 4/30 Purchased inventory on account - 700 Running Sneakers for $123 each and 500 Aerobic for $84 each 5/1 Sold Inventory on account (sold 350 Running Sneakers for $200 and 250 Aerobic Sneakers for $150) terms 2/10, net 30 5/20 Customer from the 5/1 transaction returned inventory (50 Running Sneakers) all inventory was still in good working order 5/20 Customer paid their remaining balance from the 5/1 transaction 6/10 Paid for half of the inventory purchase from 4/30 Date 7/1 7/1 7/15 8/2 8/10 9/10 Transaction Made interest payment on equipment note to Northern Bank Purchased $50,000 of equipment using a bank loan at 6% interest to be paid in 2 years. Interest is due on June 30 of each year. The equipment has a life of 7 years and a 5,000- salvage value. Sold Inventory on account (sold 275 Running Sneakers for $200 and 315 Aerobic Sneakers for $150) terms 2/10, net 30 Purchased $300 of supplies for cash Received 7 of payment from the 7/15 transaction Purchased inventory on account - 400 Running Sneakers for $124 each and 300 Aerobic for $85 each Made a payment of $100,000 towards our accounts payable balance, Purchased $350 of supplies for cash Received $4,200 from a tenant for 6 months' rent (11/1/2023 to 4/30/2024) Paid a cash dividend of $.20 per share on outstanding shares and paid dividends to preferred shareholders Sold Inventory on account (sold 600 Running Sneakers for $200 and 510 Aerobic Sneakers for $150) terms 2/10, net 30 Received payments totaling $250,000 from customers for past due invoices 10/1 10/15 11/1 11/17 12/1 12/31 . 0 . . . . Other Information: At year end $150 worth of supplies are on hand The company uses the % of Receivables method in estimating bad debts; 3% of the ending receivables balance is deemed to be uncollectible Required: Prepare all journal entries to record the information for 2023. Prepare all adjusting journal entries as necessary Prepare an adjusted Trial Balance as of December 31, 2023 Prepare an income statement, statement of retained earnings and a balance sheet as of December 31, 2023 Prepare a cash flow statement, using the indirect method, for the year ended December 31, 2023 Close all accounts as necessary and prepare a post-closing Trial Balance Please include a sheet on how you calculated your adjusting Journal entries and inventory Prepare a horizontal analysis of the balance sheet o When preparing this analysis only analyze the sum of the main categories (total current assets, total long-term assets, total assets, total current liabilities, total long-term liabilities, total liabilities, total equity, total liabilities and equity) Prepare a vertical analysis for 2023 income statement When preparing this analysis use the following categories: Net Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, Income from Operations, Other Expenses and losses, Income before income taxes, Income Tax Expense and Net Income Compute the following ratios for the company (use 365 days per year and be sure to show all calculations) o Gross Profit Margin o Debt to assets ratio o Net Profit Margin Current ratio o Earnings per Share Inventory Turnover Return on Comm Stockholder's Days in Inventory equity 0 Average receivable turnover Return on Assets Average collection period . 0 0 0 o 0 Based on the following industry standards, comment on the profitability, solvency and liquidity of the company. o Gross Profit Margin 40.00% o Net Profit Margin 15.20% o Earnings per Share .80 Return on Comm Stockholder's equity 17.00% Return on Assets 11.00% Debt to assets ratio .50 Current ratio 1.50 o Inventory Turnover 4.00 Days in Inventory 91.25 0 Average receivable turnover 15.00 o Average collection period 24.33 0 o O 0 NOTE: It is up to you to use the skills you learned in Spreadsheets to complete a report using Excel. Please be sure all cells are referenced and using formulas where applicable. Getting or using a template from another source is considered plagiarism and will result in automatically failing this assignment. . BSG is a Corporation that sells 2 styles of Sneakers (Running and Aerobic) The company uses the perpetual FIFO method in accounting for its inventory. BSG makes its adjustments at the end of each year All sales and inventory are purchased on account Be sure to round all numbers to the nearest dollar (Do Not Use Cents). The company had the following Post-Closing Trial Balance at 12/31/2022 Credit Debit 56,254 41,475 1,244 92,000 400 50 75,000 200,000 4,700 Account Name Cash Accounts Receivable Allowance for Bad Debt Inventory Supplies on Hand Prepaid Insurance Land Building A/D- Building Equipment A/D- Equipment Accounts Payable Income Tax Payble Interest Payable Unearned Rent Dividend Payable Notes Payable Common Stock APIC - Common Stock Retained Earnings 230,000 32,867 23,200 23,023 6,808 600 10,000 170,000 100,000 200,000 122,737 . BSG uses, the 200% double declining balance, Half Year, method to depreciate all 5, 7 & 10-year property BSG uses, the SL, mid-month basis to depreciate all real property Income tax rate is 35% The $230,000 of equipment has an expected life of 7 years and no salvage value The $200,000 building has an expected life of 39 years and no salvage value Inventory at 1/1/23 consists of: o Running Sneakers - 500 units at $120 each o Aerobic Sneakers - 400 units at $80 each Notes Payable at December 31, 2022 consisted of: o Foley Bank - 50,000, 7% interest rate. Interest is paid on Feb 1st of each year, principal to be repaid on 2/1/2026 adjusted trail balance adjusting entries credit S $ Debit 218,996 38,100 $ 1,143 $ S S 68,740 150 275 155,000 320,000 S $ $ 18,615 $ 280.000 $ $ $ $ $ Account Cash accounts receivables allowance for bad debits inventory supplies on hand prepaid insurance land building A/D Building Equipment | A/D Equipment accounts payable income tax payable interest payable unearned rent notes payable common stock APIC common stocks Treasury stocks common preferred stock Apic preferred stocks Retained Earrings sales sales discount sales returns cost of goods sold rent expense supplies expense Interest expense insurance expense bad debts expense depreciation expense rent income income tax expense 96,334 42,350 46,121 8,308 2,800 220,000 110,000 290,000 $ $ $ Date Account Debit Credit 31-Dec depreciation expense $ 13,915 accumulated depreciation building $ 13,915 to record depreciation expense for building 31-Dec depreciation expense $ 56,324 accumulated depreciation Equipment $ 56,324 to record depreciation expense for equipment 31-Dec depreciation expense $ 7,143 accumulated depreciation Equipment $ 7,143 to record depreciation expense for equipment purchased on 7/1 31-Dec supplies expense $ 1,150 supplies $ 1,150 to record supplies expense 31-Dec bad debts expense $ 899 allowance for bad debts $ 899 to bring the allowance for bad debts to should be accounts 31-Dec interest expense $ 6,808 interest payable $ 6,808 to accrue interest on foley and northern bank loans 31-Dec interest expense $ 1,500 interest payable $ 1,500 to accrue interest on bank loan for equipment purchased on 7/1 31-Dec insurance expense $ 3,075 prepaid insurance $ 3,075 to record amortization of prepaid insurance 31-Dec unearned rent S 2,000 rent income $ 2,000 to recognize rent income 31-Dec income tax expense $ 46,121 income tax payable $ 46,121 to record income tax expense $ 12,000 $ 50.000 25,000 95,937 574,750 $ $ S $ $ S $ 2,610 10,000 336,160 500 1,150 12,200 3,075 899 77,382 $ S $ S $ 2,000 $ 46,121 totals $ 1,583,358 $ 1,583,358 + to 538 686px 538 x 686px B C D E G H Multi step income statement Statement of retained Earnings $ 574,750 $ Retained Earning Add net income Total Less Dividends Retained Earning $ 95,937 $ 86,653 $ 182,590 $ 26,800 $ 155,790 sales Less: sales Discount Sales Return Net sales Cost of Good Sold Gross Profit $ 2,610 $10,000 $ 12,610 $ 562,140 $ 336,160 $ 225,980 $ 500 $ 1,150 $ 12,200 $ 3,075 $ 899 $ 77,382 Operating Expenses: Rent Expenses Supplies Expense Interest Expense Insurance Expense Bad Debts Expense Departing Expense Total Operating Expenses Operating Income Other Income: Rent Income Net income before tax income tax expense net income after tax $ 95,206 $ 130,774 $ 2,000 $ 132,774 $ 46,121 $ 86,653 B D E F F G Credit $ 218,996 $ 38,100 $ (1,143) $ 68,740 $ 150 $ 275 $ 325,118 $2,610 $10,000 $562,140 Closing Entries BSG inc Date Account Debit 31-Dec Sales $574,750 sales discount sales return retained earning 31-Dec Retained earnings $95,206 Rent Expense Supplies expense Interest Expense Insurance Expense Bad Debt Expense Depreciation Expense 31-Dec Rent Income $2,000 Retained Earning 31-Dec Retained Earnings $46,121 Income Tax Expense 31-Dec Retained Earnings $26,800 Cash $500 $1,150 $12,2001 $3,075 $899 $77,382 Balance Sheet Current Assets Cash Accounts Receivable Less: allowance for bad debts Inventory supplies prepaid Insurance Total Current Assets Non Current assets Land Building Less accumulated Depreciation Building Equipment Less accumulated Depreciation Equipment Total non current asset Total assists Current Liabilities accounts Payable income tax payable Interest payable unearned rent notes payable total Equity Common Stock Less treasury stock Capital paid Preferred Stocks Retained earning total Total liabilities and owners equity $ 155,000 $ 320,000 $ (18,615) $ 280,000 $ (96,334) $ 640,051 $ 965,169 $2,000 $46,1211 $ 42,350 $ 46,121 $ 8,308 $ 2,800 $ 220,000 $319,579 $26,800 $ 110,000 $ (12,000) $ 315,000 $ 50,000 $ 182,590 $ 645,590 $ 965,169 Credit Financial Ratios For BSG Inc Gross Profit Margin Net Profit Margin Earning Per Share Return in Common Stockholders Equity Return on Assets Debt To Equity Ratio Current Ratio Inventory Turnover Days in Inventories Average Receivable Turnover 40.20% 15.41% 78.78% 14.31% 8.98% 0.50 $1,143 1.02 4.18 87.32 14.13 $18,615 Post Trail Balance BSG Inc Account Debit Cash $192,196 Accounts Receivable $38,100 Allowance for Doubtful Accounts Inventory $68,740 Supplies on Hand $150 Prepaid Insurance $275 Land $155,000 Building $320,000 Accumulated Depreciation on Building Equipment $280,000 Accumulated Depreciation on Equipment Accounts Payable Income Tax Payable Interest Payable Unearned Rent Notes Payable Common Stocks Apic Common Stock Treasury Stocks $12,000 Preferred Stock APIC Preferred Stocks Retained Earrings . $96,334 $42,350 $46,121 $8,308 $2,800 $220,000 $110,000 $290,000 $50,000 $25,000 $155,790 Total $1,066,461 $1,066,461 Hotizonal Analysis For BSG Inc 2022 2023 Inc/Dec in Value Assets $56,254 $218,996 $40,231 $36,957 $92,000 $68,740 $400 $150 $50 $275 $188,935 $325,118 $162,742 -$3,274 -$23,260 -$250 $225 $136,183 $75,000 $155,000 $195,300 $301,385 $197,133 $183,666 $467,433 $640,051 $656,368 $965,169 $80,000 $106,085 $13,467 $172,618 $308,801 Current Assets Cash Accounts Receivble Inventory Supplies On Hand Prepaid Insurance Total Current Assets Non Current Assets Land Building Equipment Total Current Assets Total Assets Liabilities and Stockholders Equilty Current Liabilities Account Payable Income Taxes Payable Interest Payable Unearned Rent Dividend Payable Notes Payable Total Liablilties Stockholders Equity Common Stocks Treasuty Stock Apic-Common Stocks Capital paid Preferred Stocks Retained Earnings Total Equity Total Liablilties and Stocholder Equilty $23,200 $42,350 $23,023 $46,121 $6,808 $8,308 $600 $2,800 $10,000 $170,000 $220,000 $233,631 $319,579 $19,150 $23,098 $1,500 $2,200 -$10,000 $50,000 $85,948 $10,000 $12,000 $100,000 $110,000 $12,000 $200,000 $315,000 $50,000 $122,737 $182,590 $422,737 $645,590 $656,368 $965,169 $59,8531 $422,853 $508,801 Northern bank - 120,000, 6% interest rate, Interest is paid on June 30th of each year, principal to be repaid on June 30, 2024 Stock 0 Common Stock has a $1 par value, 500,000 shares authorized, 100,000 shares issued and outstanding at 12/31/2022. Preferred Stock has a $10 par value, 10%, 100,000 shares authorized, there were no shares issued or outstanding at 12/31/2022. o The following transactions and events occurred in 2023. Date Transaction 1/1 Issued 10,000 share of $1 par common stock to investors at $10 per share 1/1 Paid monthly rent on computer equipment, $500 1/1 Issued 5,000 share of $10 par, 10% preferred stock to investors at $15 per share 1/1 The estimated useful life and salvage value for the building that was purchased in 2022 was changed. It is now estimated that the building has a remaining life (as of 1/1/2023) of 20 years and a salvage value of $5,000. 1/1 Purchased a building and land for $200,000. The building has a 25-year expected useful life and a $10,000 expected salvage value. The land is valued at $80,000. 1/10 Purchased $250 of supplies for cash 1/15 Purchased inventory on account - 500 Running Sneakers for $121 each and 600 Aerobic for $82 each 1/15 Made a payment of $20,000 to pay off several Accounts Payable accounts 1/15 Paid the cash dividend declared in November 2022 1/31 Paid $3,300 for a 1-year insurance policy (effective 2/1/2023-1/31/2024) 2/1 BSG repurchased 1,000 shares of its own common stock to be held as treasury stock. The price paid was $12 per share 2/1 Paid the interest on the loan from Foley Bank (Remember some of the interest was accrued at 12/31/2022- your entry should include three accounts) 2/2 Paid for inventory purchased on 1/15 2/20 Sold Inventory on account (sold 100 Running Sneakers for $200 and 120 Aerobic Sneakers for $150) terms 2/10, net 30 3/2 Received notice that a customer from 2022 declared bankruptcy and will not be able to pay the remaining balance owed on their bill, $1,000 3/5 Sold Inventory on account (sold 200 Running Sneakers for $200 and 70 Aerobic Sneakers for $150) terms 2/10, net 30 3/10 Received payment for the 2/20 transaction 3/12 Received payment for merchandise sold on 3/5 3/15 Paid income taxes owed from the 2022 fiscal year. 4/2 Sold Inventory on account (sold 250 Running Sneakers for $200 and 200 Aerobic Sneakers for $150) terms 2/10, net 30 4/10 Received payment for merchandise sold on 4/2 4/30 Purchased inventory on account - 700 Running Sneakers for $123 each and 500 Aerobic for $84 each 5/1 Sold Inventory on account (sold 350 Running Sneakers for $200 and 250 Aerobic Sneakers for $150) terms 2/10, net 30 5/20 Customer from the 5/1 transaction returned inventory (50 Running Sneakers) all inventory was still in good working order 5/20 Customer paid their remaining balance from the 5/1 transaction 6/10 Paid for half of the inventory purchase from 4/30 Date 7/1 7/1 7/15 8/2 8/10 9/10 Transaction Made interest payment on equipment note to Northern Bank Purchased $50,000 of equipment using a bank loan at 6% interest to be paid in 2 years. Interest is due on June 30 of each year. The equipment has a life of 7 years and a 5,000- salvage value. Sold Inventory on account (sold 275 Running Sneakers for $200 and 315 Aerobic Sneakers for $150) terms 2/10, net 30 Purchased $300 of supplies for cash Received 7 of payment from the 7/15 transaction Purchased inventory on account - 400 Running Sneakers for $124 each and 300 Aerobic for $85 each Made a payment of $100,000 towards our accounts payable balance, Purchased $350 of supplies for cash Received $4,200 from a tenant for 6 months' rent (11/1/2023 to 4/30/2024) Paid a cash dividend of $.20 per share on outstanding shares and paid dividends to preferred shareholders Sold Inventory on account (sold 600 Running Sneakers for $200 and 510 Aerobic Sneakers for $150) terms 2/10, net 30 Received payments totaling $250,000 from customers for past due invoices 10/1 10/15 11/1 11/17 12/1 12/31 . 0 . . . . Other Information: At year end $150 worth of supplies are on hand The company uses the % of Receivables method in estimating bad debts; 3% of the ending receivables balance is deemed to be uncollectible Required: Prepare all journal entries to record the information for 2023. Prepare all adjusting journal entries as necessary Prepare an adjusted Trial Balance as of December 31, 2023 Prepare an income statement, statement of retained earnings and a balance sheet as of December 31, 2023 Prepare a cash flow statement, using the indirect method, for the year ended December 31, 2023 Close all accounts as necessary and prepare a post-closing Trial Balance Please include a sheet on how you calculated your adjusting Journal entries and inventory Prepare a horizontal analysis of the balance sheet o When preparing this analysis only analyze the sum of the main categories (total current assets, total long-term assets, total assets, total current liabilities, total long-term liabilities, total liabilities, total equity, total liabilities and equity) Prepare a vertical analysis for 2023 income statement When preparing this analysis use the following categories: Net Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, Income from Operations, Other Expenses and losses, Income before income taxes, Income Tax Expense and Net Income Compute the following ratios for the company (use 365 days per year and be sure to show all calculations) o Gross Profit Margin o Debt to assets ratio o Net Profit Margin Current ratio o Earnings per Share Inventory Turnover Return on Comm Stockholder's Days in Inventory equity 0 Average receivable turnover Return on Assets Average collection period . 0 0 0 o 0 Based on the following industry standards, comment on the profitability, solvency and liquidity of the company. o Gross Profit Margin 40.00% o Net Profit Margin 15.20% o Earnings per Share .80 Return on Comm Stockholder's equity 17.00% Return on Assets 11.00% Debt to assets ratio .50 Current ratio 1.50 o Inventory Turnover 4.00 Days in Inventory 91.25 0 Average receivable turnover 15.00 o Average collection period 24.33 0 o O 0 NOTE: It is up to you to use the skills you learned in Spreadsheets to complete a report using Excel. Please be sure all cells are referenced and using formulas where applicable. Getting or using a template from another source is considered plagiarism and will result in automatically failing this assignment. . BSG is a Corporation that sells 2 styles of Sneakers (Running and Aerobic) The company uses the perpetual FIFO method in accounting for its inventory. BSG makes its adjustments at the end of each year All sales and inventory are purchased on account Be sure to round all numbers to the nearest dollar (Do Not Use Cents). The company had the following Post-Closing Trial Balance at 12/31/2022 Credit Debit 56,254 41,475 1,244 92,000 400 50 75,000 200,000 4,700 Account Name Cash Accounts Receivable Allowance for Bad Debt Inventory Supplies on Hand Prepaid Insurance Land Building A/D- Building Equipment A/D- Equipment Accounts Payable Income Tax Payble Interest Payable Unearned Rent Dividend Payable Notes Payable Common Stock APIC - Common Stock Retained Earnings 230,000 32,867 23,200 23,023 6,808 600 10,000 170,000 100,000 200,000 122,737 . BSG uses, the 200% double declining balance, Half Year, method to depreciate all 5, 7 & 10-year property BSG uses, the SL, mid-month basis to depreciate all real property Income tax rate is 35% The $230,000 of equipment has an expected life of 7 years and no salvage value The $200,000 building has an expected life of 39 years and no salvage value Inventory at 1/1/23 consists of: o Running Sneakers - 500 units at $120 each o Aerobic Sneakers - 400 units at $80 each Notes Payable at December 31, 2022 consisted of: o Foley Bank - 50,000, 7% interest rate. Interest is paid on Feb 1st of each year, principal to be repaid on 2/1/2026 adjusted trail balance adjusting entries credit S $ Debit 218,996 38,100 $ 1,143 $ S S 68,740 150 275 155,000 320,000 S $ $ 18,615 $ 280.000 $ $ $ $ $ Account Cash accounts receivables allowance for bad debits inventory supplies on hand prepaid insurance land building A/D Building Equipment | A/D Equipment accounts payable income tax payable interest payable unearned rent notes payable common stock APIC common stocks Treasury stocks common preferred stock Apic preferred stocks Retained Earrings sales sales discount sales returns cost of goods sold rent expense supplies expense Interest expense insurance expense bad debts expense depreciation expense rent income income tax expense 96,334 42,350 46,121 8,308 2,800 220,000 110,000 290,000 $ $ $ Date Account Debit Credit 31-Dec depreciation expense $ 13,915 accumulated depreciation building $ 13,915 to record depreciation expense for building 31-Dec depreciation expense $ 56,324 accumulated depreciation Equipment $ 56,324 to record depreciation expense for equipment 31-Dec depreciation expense $ 7,143 accumulated depreciation Equipment $ 7,143 to record depreciation expense for equipment purchased on 7/1 31-Dec supplies expense $ 1,150 supplies $ 1,150 to record supplies expense 31-Dec bad debts expense $ 899 allowance for bad debts $ 899 to bring the allowance for bad debts to should be accounts 31-Dec interest expense $ 6,808 interest payable $ 6,808 to accrue interest on foley and northern bank loans 31-Dec interest expense $ 1,500 interest payable $ 1,500 to accrue interest on bank loan for equipment purchased on 7/1 31-Dec insurance expense $ 3,075 prepaid insurance $ 3,075 to record amortization of prepaid insurance 31-Dec unearned rent S 2,000 rent income $ 2,000 to recognize rent income 31-Dec income tax expense $ 46,121 income tax payable $ 46,121 to record income tax expense $ 12,000 $ 50.000 25,000 95,937 574,750 $ $ S $ $ S $ 2,610 10,000 336,160 500 1,150 12,200 3,075 899 77,382 $ S $ S $ 2,000 $ 46,121 totals $ 1,583,358 $ 1,583,358 + to 538 686px 538 x 686px B C D E G H Multi step income statement Statement of retained Earnings $ 574,750 $ Retained Earning Add net income Total Less Dividends Retained Earning $ 95,937 $ 86,653 $ 182,590 $ 26,800 $ 155,790 sales Less: sales Discount Sales Return Net sales Cost of Good Sold Gross Profit $ 2,610 $10,000 $ 12,610 $ 562,140 $ 336,160 $ 225,980 $ 500 $ 1,150 $ 12,200 $ 3,075 $ 899 $ 77,382 Operating Expenses: Rent Expenses Supplies Expense Interest Expense Insurance Expense Bad Debts Expense Departing Expense Total Operating Expenses Operating Income Other Income: Rent Income Net income before tax income tax expense net income after tax $ 95,206 $ 130,774 $ 2,000 $ 132,774 $ 46,121 $ 86,653 B D E F F G Credit $ 218,996 $ 38,100 $ (1,143) $ 68,740 $ 150 $ 275 $ 325,118 $2,610 $10,000 $562,140 Closing Entries BSG inc Date Account Debit 31-Dec Sales $574,750 sales discount sales return retained earning 31-Dec Retained earnings $95,206 Rent Expense Supplies expense Interest Expense Insurance Expense Bad Debt Expense Depreciation Expense 31-Dec Rent Income $2,000 Retained Earning 31-Dec Retained Earnings $46,121 Income Tax Expense 31-Dec Retained Earnings $26,800 Cash $500 $1,150 $12,2001 $3,075 $899 $77,382 Balance Sheet Current Assets Cash Accounts Receivable Less: allowance for bad debts Inventory supplies prepaid Insurance Total Current Assets Non Current assets Land Building Less accumulated Depreciation Building Equipment Less accumulated Depreciation Equipment Total non current asset Total assists Current Liabilities accounts Payable income tax payable Interest payable unearned rent notes payable total Equity Common Stock Less treasury stock Capital paid Preferred Stocks Retained earning total Total liabilities and owners equity $ 155,000 $ 320,000 $ (18,615) $ 280,000 $ (96,334) $ 640,051 $ 965,169 $2,000 $46,1211 $ 42,350 $ 46,121 $ 8,308 $ 2,800 $ 220,000 $319,579 $26,800 $ 110,000 $ (12,000) $ 315,000 $ 50,000 $ 182,590 $ 645,590 $ 965,169 Credit Financial Ratios For BSG Inc Gross Profit Margin Net Profit Margin Earning Per Share Return in Common Stockholders Equity Return on Assets Debt To Equity Ratio Current Ratio Inventory Turnover Days in Inventories Average Receivable Turnover 40.20% 15.41% 78.78% 14.31% 8.98% 0.50 $1,143 1.02 4.18 87.32 14.13 $18,615 Post Trail Balance BSG Inc Account Debit Cash $192,196 Accounts Receivable $38,100 Allowance for Doubtful Accounts Inventory $68,740 Supplies on Hand $150 Prepaid Insurance $275 Land $155,000 Building $320,000 Accumulated Depreciation on Building Equipment $280,000 Accumulated Depreciation on Equipment Accounts Payable Income Tax Payable Interest Payable Unearned Rent Notes Payable Common Stocks Apic Common Stock Treasury Stocks $12,000 Preferred Stock APIC Preferred Stocks Retained Earrings . $96,334 $42,350 $46,121 $8,308 $2,800 $220,000 $110,000 $290,000 $50,000 $25,000 $155,790 Total $1,066,461 $1,066,461 Hotizonal Analysis For BSG Inc 2022 2023 Inc/Dec in Value Assets $56,254 $218,996 $40,231 $36,957 $92,000 $68,740 $400 $150 $50 $275 $188,935 $325,118 $162,742 -$3,274 -$23,260 -$250 $225 $136,183 $75,000 $155,000 $195,300 $301,385 $197,133 $183,666 $467,433 $640,051 $656,368 $965,169 $80,000 $106,085 $13,467 $172,618 $308,801 Current Assets Cash Accounts Receivble Inventory Supplies On Hand Prepaid Insurance Total Current Assets Non Current Assets Land Building Equipment Total Current Assets Total Assets Liabilities and Stockholders Equilty Current Liabilities Account Payable Income Taxes Payable Interest Payable Unearned Rent Dividend Payable Notes Payable Total Liablilties Stockholders Equity Common Stocks Treasuty Stock Apic-Common Stocks Capital paid Preferred Stocks Retained Earnings Total Equity Total Liablilties and Stocholder Equilty $23,200 $42,350 $23,023 $46,121 $6,808 $8,308 $600 $2,800 $10,000 $170,000 $220,000 $233,631 $319,579 $19,150 $23,098 $1,500 $2,200 -$10,000 $50,000 $85,948 $10,000 $12,000 $100,000 $110,000 $12,000 $200,000 $315,000 $50,000 $122,737 $182,590 $422,737 $645,590 $656,368 $965,169 $59,8531 $422,853 $508,801