Description Course is Principles of Accounting Assignment is as follows: 2 parts must be completed in the attached excel files. Part 3 is a 3 page word file formatted in APA please. The Accounting Cycle and Stockholders’ Equity Analysis Portfolio Project is for accounting students who are sensing learners and learn best from concrete materials and examples. If this is your learning style preference, you are practical and careful with detail. For this assignment, you are required to complete Part 1, Part 2, and Part 3. You will present Parts 1 and 2 in Excel, and Part 3 of the Portfolio Project in a Word document, following the exact instructions that accompany each part. Use the assignment templates are attached below. Part 1: Katy McCall opens a tax consulting business called Horizon Consultants Inc. and completes the following transactions in March: March 1: As a sole shareholder, McCall invested $125,000 cash along with $45,000 of office equipment in the company. March 2: Horizon Consultants Inc. completed services for a client and immediately received $4,000 cash. March 3: Horizon made credit purchases for office equipment for $1,500 and office supplies for $2,100. Payment is due within 10 days. March 6: Horizon Consultants Inc. pre-paid $6,000 cash for six months’ rent for their office. March 10: Horizon completed a $4,250 project for a client who must pay within 45 days. March 12: Horizon paid $3,600 cash to settle the account payable created on March 3. March 19: Horizon paid a $6,000 cash premium on a 12-month insurance policy. March 22: Horizon received $3,250 cash as a partial payment for the work completed on March 10. March 25: Horizon completed work for another client for $4,250 on credit. March 29: McCall paid herself a dividend of $3,000 cash. March 30: Horizon purchased $750 of additional office supplies on credit. March 31: Horizon paid $350 cash for this month’s utility bill. Instructions: Using the following chart of accounts and template, prepare journal entries for the above economic transactions. Include the effect that each transaction has on the accounting equation. Enter your journals to the general ledger using the same file name. Chart of accounts: cash, office equipment, capital stock, prepaid rent, prepaid insurance, office supplies, accounts payable, consulting revenue, accounts receivable, dividend, utility expense. Part 2: (I’ve attached a word file so that is formatted better for your understanding) The following unadjusted trial balance is for Groenke Construction Company as of year-end for the December 31, 20×7 fiscal year. The December 31, 20×6 credit balance of the stockholders’ equity account is $50,500, and the stockholders invested $45,000 cash in the company during 20×7. Account Title Debit Credit 101 Cash $15,000 126 Supplies $8,500 128 Pre-paid insurance $11,200 167 Equipment $175,000 168 Accumulated depreciation – equipment $19,000 201 Accounts payable $9,250 251 Long-term notes payable $45,000 301 Shareholders’ equity $106,900 302 Dividends $15,750 401 Construction Revenue $153,000 623 Wage expense $61,800 633 Interest expense $6,250 640 Rent expense $15,750 683 Property tax expense $12,500 684 Repairs expense $6,100 690 Utilities expense $5,300 TOTALS $333,150 $333,150 Instructions: Use the template provided to: a. Journalize the following adjusting entries as of fiscal year-end December 31, 20×7. b. Post the adjusting entries to an unadjusted trial balance and prepare the adjusted trial balance. c. Create financial statements, namely: i) the income statement, ii) statement of stockholders’ equity, and iii) the balance sheet for 20×7. Adjustments needed: 1. The supplies available at the end of the fiscal year 20×7 are at a cost of $5,700. 2. The company’s employees have earned $3.500 in accrued wages for the fiscal year. 3. The cost of expired insurance for the fiscal year is $8,600. 4. The rent expense not yet paid or recorded in the fiscal year is $2,250. 5. Annual depreciation on equipment is $8,000; no other depreciation adjustment was made in 20×7. 6. The $450 accrued interest for December has not yet been paid and reported. 7. Additional property taxes of $625 have been assessed for the fiscal year but have not yet been paid or recorded in the accounts. 8. The December utilities expense of $425 is not included in the adjusted trial balance, because the bill arrived after the trial balance was prepared. The $425 amount owed needs to be recorded. Part 3 Assume you are the chief accountant making a presentation during the stockholders’ annual meeting for your corporation. Provide a brief explanation to stockholders on each of the following questions: Shares a. In what ways can shares be “preferred”? In which ways are they similar and different from common shares? Give real-world examples. b. How does the book value of shares of stock differ from the market value of shares of stock? Use a real-world example in your answer. Dividends a. Discuss at least three main issues a board of directors considers when making a dividend declaration decision. b. How does a share dividend differ from a share split? Retained Earnings e) Explain why companies place restrictions on some of their retained earnings. Reminder: Your Part 3 paper should be three pages in length total.