Show all work and formulas in excel for this problem.

1. (40 points4 points for each transactions) For each of the following transactions, analyze the transaction with the spreadsheet (in the cash column indicate whether the item is from operations, investing, or financing. [Use the perpetual system for inventory.) This is a single month's (February 2020) financial data. a b c d d a Accepted credit cards as payment for S158,000 of services (no cost of goods sold) rendered to its customers. The credit card fee is 4.5%. Paid $9,750 in rent expense for the current period. Sold for immediate cash payment $145,000 of merchandise that cost $82,000. Purchased $140,000 of equipment $5,000 cash downpayment and the rest with a note. The equipemnt has a eight-year useful life and a salvage value of $20,000. All principal and interest on the note is due in three years. Sold on account for $150,000 of merchandise that cost $95,000 (no discounts for early payment). Collected $95,000 of its Accounts Receivables. Recorded $8,000 for salaries for this period that will be paid next month. Recorded the month's entry for depreciation using the straight line method. Wrote off a customer's 56,825 account receivable that was deemed to be uncollectible. e f 8 h i Recorded the month's entry for bad debt. They estimated that 2.5% of the credit sales will not be collected j OANA I FA Cash Inv. AR ADA Common Stock Revenue Expense Net Incor Retained Earnings 238.500 BB 295,500 365,000 85,000 (7,000) 500,000 IT C-1 EB 2 highlight correct answer (2.5 points) Transaction f above is a/an A. Cash entry B. Deferral entry C. Adjusting entry D. Accrual entry E. Paid bill 3 3 (2.5 points) Transaction h above is a/an A. Cash entry B. Deferral entry C. Adjusting entry D. Accrual entry E. Paid bill 4 (2.5 points)Transaction i above is a/an A. asset source B.asset use C. asset exchange D. claims exchange 5 (2.5 points)Transaction jabove is aan A. asset source B.asset use C. asset exchange D. claims exchange 1. (40 points4 points for each transactions) For each of the following transactions, analyze the transaction with the spreadsheet (in the cash column indicate whether the item is from operations, investing, or financing. [Use the perpetual system for inventory.) This is a single month's (February 2020) financial data. a b c d d a Accepted credit cards as payment for S158,000 of services (no cost of goods sold) rendered to its customers. The credit card fee is 4.5%. Paid $9,750 in rent expense for the current period. Sold for immediate cash payment $145,000 of merchandise that cost $82,000. Purchased $140,000 of equipment $5,000 cash downpayment and the rest with a note. The equipemnt has a eight-year useful life and a salvage value of $20,000. All principal and interest on the note is due in three years. Sold on account for $150,000 of merchandise that cost $95,000 (no discounts for early payment). Collected $95,000 of its Accounts Receivables. Recorded $8,000 for salaries for this period that will be paid next month. Recorded the month's entry for depreciation using the straight line method. Wrote off a customer's 56,825 account receivable that was deemed to be uncollectible. e f 8 h i Recorded the month's entry for bad debt. They estimated that 2.5% of the credit sales will not be collected j OANA I FA Cash Inv. AR ADA Common Stock Revenue Expense Net Incor Retained Earnings 238.500 BB 295,500 365,000 85,000 (7,000) 500,000 IT C-1 EB 2 highlight correct answer (2.5 points) Transaction f above is a/an A. Cash entry B. Deferral entry C. Adjusting entry D. Accrual entry E. Paid bill 3 3 (2.5 points) Transaction h above is a/an A. Cash entry B. Deferral entry C. Adjusting entry D. Accrual entry E. Paid bill 4 (2.5 points)Transaction i above is a/an A. asset source B.asset use C. asset exchange D. claims exchange 5 (2.5 points)Transaction jabove is aan A. asset source B.asset use C. asset exchange D. claims exchange