Please help me with completing 10 different pages and assignment is attached in the pictures.

AutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share Cut 2 AutoSum Century Got... . 10 A- A Wrap Text General Copy Fill Paste A E + Merge & Center $ ~ % 2 00 $.0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B16 + X V fx B C D E F G H K M MGMT210: Course Project 2 Requirement Requirement Description Worksheet Name Prepare the Journal Entries in the General Journal 1 - Journal Entries 3 2 Post Journal Entries to the General Ledger 2 - General Ledger 3 Prepare a Trial Balance ial Balance Prepare the Adjusting Entries 4 - Adjusting Entries 5 Post Adjusting Entries to the General Ledger 2 - General Ledger Prepare an Adjusted Trial Balance 5- Adjusted TB Prepare the Financial Statements 6 - Financial Statements a 8 Prepare the Closing Entries 7 - Closing Entries 9 Post Closing Entries to the General Ledger 2 - General Ledger 11 10 Prepare the Post Closing Trial Balance 8 - Post Closing Trial Balance 12 11 Compute Ratios 11-Ratios 13 12 Interpret the Ratios 12-Interpretation of Ratios 14 15 16 17 Menu Project Instructions March Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB 7 - Financial S + Ready + 100%AutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share Cut Century Got... * 11 A- A General 2 AutoSum Wrap Text AP Copy Fill Paste Conditional Format Cell Insert Delete Format Sort & Format B I US A E + Merge & Center $ ~ % 2 00 $.0 Formatting as Table Styles Clear Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D17 B C D E F G H J K L Course Project Overview The Course Project consists of 12 Requirements for you to complete. The Course Project is due at the end of Week 9. See the Modules section for due date information. All of the information you need to complete the Course Project is located in this Workbook. . There are eight worksheets in the workbook you will need to complete. . A list of March transactions . A Chart of Accounts reference sheet Before You Begin: A Grading Rubric to help explain what is expected. Review the Week 2 Lecture prior to starting Each worksheet has the Check Figures embedded as a comment. work on this project. Print the Chart of Accounts and October A W N Transactions worksheets for your reference. Scenario You will need to refer to both throughout You've just secured a new client in your accounting practice, Howard's Flight Radio Management Corporation (HFRM), a brand the project. new small business specializing in flight management systems (FMS). The owner, Howard Allan, is a former Air Force pilot and Review the Grading Criteria. retired Colonel, but definitely not an accountant. Your job is to help Howard put his affairs in order. Luckily Howard has only been in operation for a month and things have not gotten too out of hand yet! Howard has to submit his financial statements to his investors and doesn't know where to begin. It's your job to go through the complete Accounting cycle to prepare the financial statements for the HFRM. Requirements MGMT210: Course Project Requirement Requirement Description Worksheet Name repare the Journal Entries in the General Journal - Journal Entries Post Journal Entries to the General Ledger 2 - General Ledger Prepare a Trial Balance - Trial Balance Prepare the Adjusting Entries - Adjusting Entries Post Adjusting Entries to the General Ledger 2 - General Ledger Prepare on Adjusted Trial Balance - Adjusted TB Prepare the Financial Statements - Financial Statements Prepare the Closing Entries 7- Closing Entries Post Closing Entries to the General Ledger 2 - General Ledger 10 Prepare the Post Closing Trial Balance 8 - Post Closing Trial Balance 11 Compute Rofios 1-Ratios 12 Interpret the Ratios 2-Interpretation of Ratios Guidelines Use the embedded assistance in the template, guidance in your textbook, and examples in the weekly assignments to 31 complete this project. Should you have any questions contact your professor. Menu Project Instructions March Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB 7 - Financial + Ready + 100%AutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share Cut Century Got... * 11 A- A 2 AutoSum Wrap Text General AP Copy Fill Paste B I U A Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D17 X V fx B C D E F G H J K L . A LIST OF MGICTT TITISUCTIONIS . A Chart of Accounts reference sheet Before You Begin: A Grading Rubric to help explain what is expected. Review the Week 2 Lecture prior to starting Each worksheet has the Check Figures embedded as a comment. work on this project Print the Chart of Accounts and October * W N Transactions worksheets for your reference. Scenario You will need to refer to both throughout You've just secured a new client in your accounting practice, Howard's Flight Radio Management Corporation (HFRM), a brand the project. new small business specializing in flight management systems (FMS). The owner, Howard Allan, is a former Air Force pilot and retired Colonel, but definitely not an accountant. Your job is to help Howard put his affairs in order. Luckily Howard has only Review the Grading Criteria. been in operation for a month and things have not gotten too out of hand yet! Howard has to submit his financial statements to his investors and doesn't know where to begin. It's your job to go through the complete Accounting cycle to prepare the financial statements for the HFRM. Requirements MGMT210: Course Project Requirement Requirement Description Worksheet Name repare the Journal Entries in the General Journal - Journal Entries Post Journal Entries to the General Ledger 2 - General Ledger Prepare a Trial Balance 3 - Trial Balance Prepare the Adjusting Entries - Adjusting Entries Post Adjusting Entries to the General Ledger 2 - General Ledger Prepare on Adjusted Trial Balance 5 - Adjusted TB Prepare the Financial Statements - Financial Statements Prepare the Closing Entries 7 - Closing Entries Post Closing Entries to the General Ledger 2 - General Ledger 10 Prepare the Post Closing Trial Balance 8 - Post Closing Trial Balance 11 Compute Rafios 1-Ratios 12 Interpret the Ratios 2-Interpretation of Ratios Guidelines Use the embedded assistance in the template, guidance in your textbook, and examples in the weekly assignments to complete this project. Should you have any questions contact your professor. Milestone 1 is due in Week 3 - This includes project requirements 1-3 Milestone 2 is due in Week 6 - This includes project requirements 4-7 Milestone 3 is due in Week 9 - This includes project requirements 8-12 37 Menu Project Instructions March Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB Ready TUU 70\fAutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share 1 Cut Arial 10 A- A Wrap Text General 2 AutoSum Copy Fill Paste Format A + Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates E51 X V fx A C D E F G H K M N O P Q R S REQUIREMENT #3: Prepare a trial balance for March in the space below. Howard's Flight Radio Management Corporation Trial Balance Only enter March 31 accounts that Account Account Balance have a balance. Number Title Debit Credit HH Menu Project Instructions March Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB Ready TUU 70AutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Table Share Cut Century Got... . 10 A- A Wrap Text Date 2 AutoSum Copy Fill Paste A + Merge & Center $ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A5 X V J A C D E F G H K L M N O P Q R S Requirement #4: Prepare adjusting entries using the following information in the General Journal below. Show your calculations! a) One month's insurance has expired 6) The remaining inventory of repair supplies is $200. c) The estimated depreciation on repair equipment is $120. d) The estimated income taxes are $65. Requirement #5: Post the adjusting entries on March 31 below to the General Ledger T-accounts and compute adjusted balances. Just add to the balances that are already listed. 2 General Journal Account Number from Chart of Date Accounts tab Account Title from Chart of Accounts tab Debit Credit Menu Project Instructions March Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB ReadyAutoSave OFF T MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Table Share Cut Arial 10 A- A Wrap Text General 2 AutoSum Copy Fill Paste + Merge & Center $ ~ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B12 B C D E F G H K M N O P Q R S Howard's Flight Radio Management Corporation Adjusted Trial Balance Only enter March 31 accounts that Account Balance have a balance. Account Number Title Debit Credit Cash 18,060 Repair Insurance 2,200 Repair Supplies 200 Repair Equipment 5,800 Accum Dep-Repair Equipment 120 Account Payable 5,050 11 Income Tax Payable 65 12 13 14 15 16 17 18 5.235 Menu Project Instructions March Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB ReadyAutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share Cut Arial 10 A- A Wrap Text General 2 AutoSum Copy Fill Paste A E + Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates G31 X V fx D E G H K M N P Q R S Requirement #7: Prepare the financial statements for Howard's Flight Radio Management Corporation as of March 31 in the space below. You will only be preparing the Income Statement, Statement of Retained Earning, and the Balance Sheet. The Statement of Cash Flows is a required Financial Statement, but is not required for this project Howard's Flight Radio Management Corporation Howard's Flight Radio Management Corporation Howard's Flight Radio Management Corporation Income Statement Statement of Retained Earnings Balance Sheet For the Month Ending March 31 or the Month Ending March 31 March 31 Revenues: Retained Earnings, March Assets: FMS Repair Revenue Add: Net Income Cash Total Revenue Subtotal Prepaid Insurance 11 Less : Dividends Repair Supplies 12 Expenses: Retained Earnings, March 31 Repair Equipment 13 Store Rent Expense Less: Accum. Depr. 14 Telephone Expense Total Assets 15 Insurance Expense Repair Supplies Exp Liabilities and Stockholders Equity 17 Depreciation Exp. Liabilities: B Income Taxes Expense Accounts Payable 19 Electric Expense Income Taxes Payable 20 Total Expenses Total Liabilities 21 22 Net Income Stockholders' Equity: 23 Common Stock 24 Retained Earnings 25 Total Stockholders' Equity 26 Total Liabilities & Stockholders' 27 Equity 28 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB 7 - Financial Statements 8 & 9- - Closing Entries 10 - Post Closing Trial Balance 11- Ratios 12- Interpretaion of Ratio Grading + Ready + 100%AutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share Cut Arial 10 A- A Wrap Text General 2 AutoSum Copy Fill Paste A + Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates G45 fx A D E F G H K M N O P Q R S Requirement #8: Prepare the closing entries at March 31 in the General Journal below. Hint: Use the balances for each account which appear on the Adjusted Trial Balance for your closing entries. Requirement #9: Post the closing entries to the T-Accounts on the General Ledger worksheet and compute ending balances. Just add to the adjusted balances already listed. General Journal Account Number from Chart of Date Accounts tab Account Title from Chart of Accounts tab Debit Credit 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB 7 - Financial Statements 8 & 9- - Closing Entries 10 - Post Closing Trial Balance 11- Ratios 12- Interpretaion of Rat ReadyAutoSave OFF MGMT210_Course Project _ Template (1) - Saved to my Mac Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share Cut Arial 10 A- A Wrap Text General 2 AutoSum Copy Fill Paste + Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates E24 B C D E F G H K M N O P Q R S Requirement #10: Prepare a post-closing trial balance as of March 31 in the space below. Howard's Flight Radio Management Corporation Post-Closing Trial Balance March 31 Account Account Balance Number Title Debit Credit 3 - Trial Balance 4 & 5 Adjusting Entries 6 - Adjusted TB 7 - Financial Statements 8 & 9- - Closing Entries 10 - Post Closing Trial Balance 11- Ratios 12- Interpretaion of Ratio Grading + Ready + 100%