ONLY NEED HELP WITH THE STATEMENT OF CASH FLOWS PORTION> Computer Depot was incorporated on January 1st. The business maintains a retail personal computer replacement parts store, and also provides a full range of services, including computer diagnostic services, virus removal, hardware replacement, software installation and upgrades, and optimization services. The following transactions occurred during the first twelve months of operations: January 1st Common stock is issued in exchange for cash in the amount of ………….………….……………………… 350,000 February 8th The company purchases and pays for 300 units of computer replacement parts at a price of $25 per unit ………….. 7,500 March 1st The company pays cash for a one-year insurance policy in the amount of ……………….………………………..….. 10,752 March 31st Rent on a retail space for 12 months is paid in the amount of …..……….……………………………………… 10,512 April 1st Diagnostic tools and testing equipment with a useful life of 2 years is purchased for cash in the amount of …… 23,460 April 10th PC tuning supplies purchased on account in the amount of …………..…………………………………………… 4,250 May 15th The company purchases and pays for another 300 units of computer replacement parts at a price of $38 per unit ….. 11,400 May 30th PC repair services are performed on account in the amount of …………………………………………………………..………… 10,538 June 1st The company pays for advertisements to be run for the next 12 months in the amount of ………………………. 1,540 June 30th The company issues a 5-year bond with a face value of $100,000 and a stated annual rate of 8%. Interest is due on June 30th each year. The market rate is 6% on the date of issuance ……………………………. 100,000 July 25th Software installation & upgrade services are performed on account in the amount of …...……………………………..………… 10,759 July 31st 120 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of (see note c for cost flow assumptions) ……………………………………………………………………………………. 9,000 August 2nd Hardware replacement services are provided on account in the amount of ………………………………………………………………. 9,820 August 6th The company receives full payment from the customer for the July 31st sale ……………………………………… 7,350 September 15th Virus removal services are performed on account in the amount of ……………………..…………………………….………….. 6,295 September 29th Customer payments are received for services previously provided in the amount of ……………………………….. 1,520 October 13th 136 units of computer replacement parts are sold for $75 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of ………………………………………………………………………………………. 10,200 October 29th The company receives payment for half of the October 13th sale ……………………………………………………… 5,100 November 1st Equipment originally purchased on April 1st for $3,000 is sold for $1,500 cash November 15th A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation December 15th The bookkeeper is paid $4,500 for the previous month's services 4,500 Additional information: a. PC tuning supplies on hand at the end of the month are as follows: ……………………………………. 2,550 b. The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts is estimated as 2.5% of outstanding receivables at the end of the year c. The Company uses a perpetual inventory system and accounts for costs using the Last-In-First-Out cost flow assumption. On December 31st, a count of ending inventory reveals that there are 344 units of computer replacement parts on hand. d. All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statement. e. The effective interest method is used to amortize bond premiums and discounts f. Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. g. The bookkeeper is paid a salary of $4,500 on the 15th of every month. h. The company declared dividends of $700 for the year i. Assume selling expenses include advertising and supplies expense. All other expenses, other than depreciation and interest expense, are considered general & administrative. REQUIRED: 1. Prepare journal entries for each transaction listed above (with descriptions). 2. Post journal entries to the general ledger accounts. 3. Prepare an unadjusted trial balance. 4. Prepare all necessary adjusting journal entries (with descriptions) and post to the general ledger. 5. Prepare an adjusted trial balance on December 31st. 6. Prepare closing entries, post to the general ledger, and carryforward balances to January 1st of the next year. 7. Prepare the following financial statements on December 31st (ignore income taxes): a. Income Statement (multi-step, see Example 5.2 in textbook) b. Statement of Stockholders' Equity c. Balance Sheet (classified) d. Statement of Cash Flows (indirect method)
Ans.
Cash Flow Statement | ||
Date | Particular | Amt |
Cash From Operating Activity | ||
Net Income (as per income statement) | 8940.2 | |
Less | ||
Debtor | ||
Debtor of 13st oct | -5100 | |
Remaining debtors (from 30 may to 15 sep income) | -46412 | |
Add: | ||
31-Dec | Depreciation | 11730 |
31-Dec | Interest in bond for 6 month (4% on 100000 ) | 4,000 |
Cash from operating activity | -26841.8 | |
Cash From Investing Activity | ||
08-Feb | Purchase of computer replecement part | -7500 |
01-Apr | Purchase of Diagnostic tools and testing equipment | -23460 |
15-May | Purchase of computer replecement part | -11400 |
01-Nov | equipment sold | 1500 |
Total | -40860 | |
Cash From Financing Activity | ||
01-Jan | Common stock issued | 3,50,000 |
31-Dec | Dividend paid | -700 |
31-Dec | Interest on bond for 6 month (4% on 100000 ) | (4,000) |
30-Jun | 5-year bond | 1,00,000 |
Total | 4,45,300 | |
Total cash inflow from all activity | 3,77,598 | |
Income Statement | ||
Date | Particular | Amt |
Income | ||
30-May | Repair service | 10538 |
25-Jul | computer upgread service | 10759 |
31-Jul | sales replecement part | 9000 |
02-Aug | hardware replecement part | 9820 |
15-Sep | Virus removal services | 6295 |
13-Oct | sales computer replacement parts | 10200 |
31-Dec | PC tuning supplies inventory | 2550 |
Total Income | 59162 | |
Expenses | ||
01-Mar | Insurance premium | 10752 |
31-Mar | Rent Expenses | 10512 |
31-Dec | Depreciation (23460/2) | 11730 |
Apr-10 | PC tuning supplies purchased | 4250 |
01-Jun | Adverisement exp | 1540 |
06-Aug | Discount to july 31st customer | 1650 |
15-Dec | bookkeeping exp | 4500 |
31-Dec | Allowance for Doubtful Accounts 51512*2.5/100 | 1,288 |
31-Dec | Interest in bond for 6 month (4% on 100000 ) | 4,000 |
Total Exp | 50221.8 | |
Net Profit | 8940.2 |
ONLY NEED HELP WITH THE STATEMENT OF CASH FLOWS PORTION> Computer Depot was incorporated on January...
The following transactions occurred during the first twelve months of operations: January 1st Common stock is issued in exchange for cash in the amount of ………….………….……………………… 395,000 February 8th The company purchases and pays for 170 units of gourmet dog food at a price of $25 per unit ………….. 4,250 March 1st The company pays cash for a one-year insurance policy in the amount of ……………….………………………..….. 3,900 March 31st Rent on a retail space for 12 months is paid in...
YOUR COMPANY
Income Statement
For the year ended January 31, 2019
Sales revenue (net)
55,432
Cost of goods sold
-9,778
Gross profit
45,704
Operating expenses:
Selling expenses
2,598
General & administrative expenses
25,869
Depreciation expense
8,548
Total operating expenses
38,015
Operating Income
9,089
Other items:
Interest expense
-3,253
Loss on sale of equipment
625
3,878
Net Income
4,811
YOUR COMPANY
Statement of Cash Flows
For the year ended January 31st, 2019
Cash Flows from Operating Activities
Net Income
Adjustments for...
Part A) Prepare a chart of accounts as required and journalize the following transactions and post to the general ledger. (note: general ledger here can be expressed as a T account) TRANSACTIONS 1) On March 1st Fancy Pants sold 1,000 common shares for $12,000 start the business.2) On March 2nd Fancy Pants took out a $3,000 loan from “TD Bank”. Fancy Pants agreed to repay the loan in one year plus 8% interest.3) On March 3rd Fancy Pants purchased some computer equipment to help run the business for $4,500...
Part A) Prepare a chart of accounts as required and journalize the following transactions and post to the general ledger. (note: general ledger here can be expressed as a T account) TRANSACTIONS On March 1st Fancy Pants sold 1,000 common shares for $12,000 start the business. On March 2nd Fancy Pants took out a $3,000 loan from “TD Bank”. Fancy Pants agreed to repay the loan in one year plus 8% interest. On March 3rd Fancy Pants purchased some computer...
Based on the following information, prepare only the operating portion of a Statement of Cash Flows for Burgess Company. Burgess Company’s Income Statement for Year 2 (dollars in Millions) is as follows: Sales $3,600 Cost of Goods Sold 2,550 Gross Margin 1,050 Selling & Admin 875 Net Operating Income 175 Nonoperating Items Gain on Sale of Equipment 3 Income Before Taxes 178 Income Taxes 63 Net Income 115 It’s Balance Sheet for the end of Year 1 and...
Prepare journal entries for the transactions below. A company entered into the following transactions during April. This is the first month of their operation. April 1st: Signed a lease and made a payment of $4,500 to the landlord comprised of three month’s rent covering April, May, and June. April 3rd: Purchased equipment on account for $35,000. April 4th: Purchased supplies for $2,000, paid with cash. April 10th: Performed services and sent a bill of $57,000 to a customer. April 15th:...
I need help with 9-12
Use the following to answer questions 9 - 10 On October 1st, the company received a $20,000 payment from a customer for services to be rendered evenly over the next four months. Deferred Revenue was credited on October 1st and no other entries regarding this transaction were made until December 31st. 9. $ After the adjusting entry has been recorded on December 31st, determine the ending balance in the deferred revenue account that should be...
I need to prepare a statement of cash flows using the indirect method using this information Assets: Dec. 31st, 2020 Dec. 1st, 2019 Cash 680,000 360,000 Investments 110,000 290,000 Accounts receivable 115,000 130,000 Inventory 230,000 195,000 Prepaid advertising 40,000 25,000 Property & Equipment, net 435,000 500,000 Patents, net 180,000 50,000 Total Assets 1,790,000 1,550,000 Liabilities & Stockholders’ Equity Accounts Payable 265,000 284,000 Wages Payable 30,000 21,000 Notes Payable 650,000 350,000 Common Stock & APIC 600,000 600,000 Treasury Stock (250,000) (50,000)...
On January 1, 2020 the company paid $3,600 for an annual (12 month) flood insurance policy covering their headquarter building. Assume the company has a monthly accounting period, prepare the adjusting entry needed at the end of January. Assume the company has a quarterly accounting period (report once every 3 months). Prepare the entry needed at the end of the first quarter. A business pays its employees $1,500 per day and payday is each Friday. Prepare the adjusting entry needed...