This project will be submitted in 3 parts. The submission dates and required parts to be...
YOU MUST USE FORMULAS AND CELL REFERENCES FOR INPUTS IN THE WORKSHEETS AND FINANCIAL STATEMENTS FOR YOUR PROJECT TO BE CONSIDERED FOR FULL CREDIT Submission 1 - due Friday January 17 before 5pm - You must submit your completed Journal entries, the Worksheet complete through the Trial Balance (with totals for all columns), and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure...
I need submission 2 and submission 3 completed please, thank you!!! Submission 1 - due Friday January 17 before 5pm - You must submit your completed Journal entries, the Worksheet complete through the Trial Balance (with totals for all columns), and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure to name your file correctly will result in a 1 point deduction Submission...
Submission 1 - due Monday January 21 before 5pm - You must submit your completed January Journal entries, the Worksheet complete through the Trial Balance, and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure to name your file correctly will result in a 1 point deduction. You have been hired as an accountant for FigMint Consulting Inc. This business was created when...
Fill out the pink part of the journal entry and then fill out the worksheet entry Date Amount During January, the first mouth of operations, the following transactions occurred: Event 2-Jan Paid for 12 months rent on office space 5-Jan Purchased office furniture Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be paid back in 5 Amount 9,000 8.950 5-m years 0.02 interest rate 11500 on account 30,000 loan am 12,500 paid...
Looking for a solution to Submission 2 & 3. For "formulas tab" - means excel formulas by copy & pasting work with "paste + ~" PURCHASE AND SALES INFO BANK REC INFO AGING OF ACCOUNTS RECEIVABLE INFO BLANK BANK REC Submission 2 - due Monday March 25 before 5pm - You must submit your completed Bank Reconciliation, the journal entries to bring the cash balance to the correct balance, and the Bank Reconciliation formulas tab completed. Your file must be...
$ . % Merge & Center - .000 Formatting Table SIU. . . A. Number Styles Alignment Font Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for...
i need help with the financial statement, balance sheet, statement of retained earnings. here are the numbers used. formulas displayed. Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY...
You have been given the unadjusted trial balance for your company as of 12/31/19. Each company prepares financial statements annually. Required Tasks: 1. Using the information in the Worksheet (1) tab, Aging Analysis (2) tab, and Adjustments (3) tab, prepare the adjusting journal entries for the period. Record the entries in the Adjusting Journal Entries (4) tab. (Round all numbers to the nearest dollar.) SHOW YOUR WORK FOR THE ADJUSTMENT IN THE CELL OR YOU WILL NOT RECEIVE CREDIT FOR...
Using the information on the 12/31/18 adjusted trial balance (page 2) complete the following two parts. Note: An accompanying EXCEL file is provided see "Trial Balance for Homework 2" Note: The owner cannot afford an accountant so she hires an accountant (you) to come in once a month during the year to make the necessary accounting. Part 1 - For the 2018 Year-End A. Prepare closing entries B. Prepare post-closing trial balance C. Prepare the balance sheet as of 12/31/18...
Part 4: Big Problem - 50 PTS TOTAL *** SHOW YOUR WORK ***Journal entries must be prepared in proper format. Your Excel file should be similar to the one we used to complete Ex 14-5. On January 1, 2020, Albany Company issued 8% bonds dated January 1, 2020, with a face amount of $10 million. The bonds mature January 1, 2030 (10 years). For bonds of similar risk and maturity, the market yield is 10%. Interest is paid semiannually on...