Solve every point Listed in the description pls And thank you, that covers the part B of the assignemnt (which Is in blue) i Will attach the part one with the journal And T accounts (pls only answer this question if you can cover all the points)

Either the Google Sheet can be shared with me or the Excel worksheet can be placed in the Assignment/Dropbox folder in D2L. Jan PROJECT H1 - PART B 31 A \$1,200 invoice/bill arrives for utility services used in January. Payment is due Feb 15. 31 Supplies on hand on Jan 31 are counted and determined to have cost $250. 31 As of Jan 31, FDI had completed 60% of the deliveries for the customer who paid in advance on Jan 20. 31 As of Jan 31, FDI owed one month of interest on the loan from Jan 3. 31 The delivery van purchased on Jan 4 has been in use for one month. The life of the van is 4 years and method used is based on life. 31 Salaries earned by employees for the second half of the month are 1,100 per employee and will be paid Feb 3. 31 Prepaid rent and insurance were both used for January. REQUIRED FOR POINTS: This uses your Part A file to continue the process. Using the balances in the T-accounts (update as needed from Part A submission) and the information given, calculate and record the adjusting journal entries for January 431 on the enclosed joumal entry form (same tab). 5 Post each of the adjusting entries to the same T-accounts on the enclosed T-account form. This posting should be below the previous totals submitted for Part A. Using the addition/sum and subtract functions in Excel/Sheets, calculate the correct final balance for each T-account on the correct side. The T-account should have the unadjusted total, the adjusting journal entries, then a new separate final total. "A suggestion to check the work is to create an adjusted trial balance using the 6 totals*ute 7 Prepare the 3 Financial statements in good form using the final ending T-account balances as of January 31 , current year Use the reference or linking function in Excel/Sheets to link the financial statements accounts and amounts to the T-accounts. Referencing 'answer' cells back to 'input' cells creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. A blank sheet/tab is included, but the statements should be created by the student. Financial statements must follow outline shown in the textbook and homework with titles and totals and must be classified Chapter \& Course Outcomes: (demonstrated in this project) A Apply revenue and matching principles of accounting, transaction analysis and double entry accounting to business activities. B Record financing, investing operating and adjusting transactions in the general journal C Post transactions and calculate normal account balances using T-accounts. D. Prepare a classified Balance Sheet, Statement of Retained earnings and Income Statement in good form. Use Microsoft Excel proficiently to record and summarize information used in business analysis and decision making. (When a business decides to complete a transaction, and records it in the journal, the impact is apparent on the financial statements. Setting up this worksheet to link/reference between the T-accounts and the financial statements, E allows for 'what if' questions). Fast Deliveries, Inc. (FDI) was organized in December last year and had limited activity last year. The resulting balance sheet at the beginning of the current year is provided below: Additional Information: Two employees have been hired, at a monthly salary of $2,200 each, starting on January 1. The following transactions occurred during January of thistrent year. Jan #1 - PART A 1 Paid 12 months insurance starting January 1,$5,700. 2 Paid 12 months rent starting January 1,$4,200. 3 FDI borrows $30,000 cash from First State Bank at 6% annual interest; this note is payable in two years. 4 A delivery van is purchased using cash. The total cost was $24,000. 5 Stockholders contribute $6,000 of additional cash to FDI for its common stock. 6 Additional supplies costing $1,000 are purchased on account and received. 7 Accounts receivable of $600 is collected from December sales. 8 Accounts payable of $400 is paid from December purchases. 9 Performed services for customers on account, sending invoices totaling $10,400. 10 Performed services for customers totaling $7,600 who paid in cash. 16 Salaries totaling $2,200 were recorded and paid for the first half of the month. 20 FDI receive $3,500 cash from a customer for an advance order for services to be provided later in January and Fe 25 Accounts receivable of $4,500 is collected from customer on account from January 9. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Cash } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Beg Bal & $10,900 & $5,700 & Jan1 \\ \hline Jan3 & $30,000 & $4,200 & Jan2 \\ \hline Jan5 & $6,000 & $24,000 & Jan4 \\ \hline Jan 7 & $600 & $400 & Jan8 \\ \hline Jan 10 & $7,600 & $2,200 & Jan 16 \\ \hline Jan 20 & $3,500 & & \\ \hline Jan 25 & $4,500 & & \\ \hline & & & \\ \hline End Bal & $26,600 & & \\ \hline \end{tabular} \begin{tabular}{|c|l|l|l|} \hline \multicolumn{3}{|c|}{ Notes Payable } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline & & $30,000 & Jan 3 \\ \hline & & & \\ \hline End Bal & $30,000 & & \\ \hline \multicolumn{4}{|c|}{ Common Stock } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{|c|}{ Credit } \\ \hline Beg Bal & & $11,000 & \\ \hline & & $6,000 & Jan5 \\ \hline & & & \\ \hline End Bal & $17,000 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Accounts Receivable } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Beg Bal & $800 & $600 & Jan 7 \\ \hline Jan 9 & $10,400 & $4,500 & Jan 25 \\ \hline & & & \\ \hline End Bal & $6,100 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Retained Earnings } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Beg Bal & & $600 & \\ \hline & & & \\ \hline End Bal & $600 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Prepaid Insurance } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Jan 1 & $5,700 & & \\ \hline & & & \\ \hline End Bal & $5,700 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Service Revenue } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline & & $10,400 & Jan9 \\ \hline & & $7,600 & Jan10 \\ \hline & & & \\ \hline End Bal & $18,000 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Prepaid Rent } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{|c|}{ Credit } \\ \hline Jan 2 & $4,200 & & \\ \hline & & & \\ \hline End Bal & $4,200 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|l|l|} \hline \multicolumn{3}{|c|}{ Supplies } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Beg Bal & $400 & & \\ \hline Jan6 & $1,000 & & \\ \hline & & & \\ \hline End Bal & $1,400 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Salaries Expense } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Jan 16 & $2,200 & & \\ \hline & & & \\ \hline End Bal & $2,200 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Unearned Service Revenue } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline & & $3,500 & Jan 20 \\ \hline & & & \\ \hline End Bal & $3,500 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|l|l|} \hline \multicolumn{4}{|c|}{ Prepaid Rent } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{|c|}{ Credit } \\ \hline Jan2 & $4,200 & & \\ \hline & & & \\ \hline End Bal & $4,200 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Salaries Expense } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Jan 16 & $2,200 & & \\ \hline & & & \\ \hline End Bal & $2,200 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|l|l|} \hline \multicolumn{3}{|c|}{ Supplies } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Beg Bal & $400 & & \\ \hline Jan 6 & $1,000 & & \\ \hline & & & \\ \hline End Bal & $1,400 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Unearned Service Revenue } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline & & $3,500 & Jan 20 \\ \hline & & & \\ \hline End Bal & $3,500 & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Delivery Van } \\ \hline \multicolumn{2}{|c|}{ Debit } & \multicolumn{2}{c|}{ Credit } \\ \hline Jan 4 & $24,000 & & \\ \hline & & & \\ \hline End Bal & $24,000. & & \\ \hline \end{tabular} Be sure to check the Info \& Directions tab for additional information. 2 Create a T-account for every account used to date by FDI on the T-account tab. Correctly post any beginning balances. Post each of the entries to the correct T-accounts on the enclosed T-account form (separate tab) using linking/referencing functionality. 3 Using the addition/sum and subtract functions in Excel/Sheets, calculate the correct subtotal balance for each T-account on the enclosed form. Use of the basic reference/linking function and addition/sum/subtraction function in Excel/Sheets must be included to the fullest extent possible to earn full project points. Referencing 'answer' cells back to 'input' cells creates a functioning, effective worksheet. 5 Post each of the adjusting entries to the same T-accounts on the enclosed T-account form. This posting should be below the previous totals submitted for Part A. Using the addition/sum and subtract functions in Excel/Sheets, calculate the correct final balance for each T-account on the correct side. The T-account should have the unadjusted total, the adjusting journal entries, then a new separate final total. *A suggestion to check the work is to create an adjusted trial balance 6 using the totals** Use the reference or linking function in Excel/Sheets to link the financial statements accounts and amounts to the T-accounts. Referencing 'answer' cells back to 'Input' cells creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. Be sure to check the Info \& Directions tab for additional information. Prepare the 3 Financial statements in good form using the final ending T-account balances as of January 31, current year Use the reference or linking function in Excel/sheets to link the financlal statements accounts and amounts to the T-accounts. Referencing 'answer' cells back to 'input' cells creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential Financial statements must follow outline shown in the textbook and homework with titles and totals and be classifled. An example of the process can be found in the demonstration case starting on page 177 through page 179. You may change the width of a column, or format a number, or insert lines as needed. You may create a Trial Balance. Make changes as needed. The goal of a functioning worksheet is that an amount can be changed in the journal and the T-accounts and the financial statements update automatically. Try that before you submit. If you are typing numbers on this sheet, you are not meeting the requirements of the project