Assignment 1: The Course Project consists of 10 Requirements for you to complete. The Course Project is due at the end of Module 9. See Course Project for details and due date information. All of the information you need to complete the Course Project is located in the workbook provided on the Course Project page.
Do not download the workbook again. You will continue to build on the content in the same workbook in which you worked in Milestone 1.
There are eight worksheets in the workbook you will need to complete.
A list of March transactions.
A Chart of Accounts reference sheet.
A Grading Rubric to help explain what is expected.
Each worksheet has the Check Figures embedded as a comment.
In this module, you will submit Milestone 2 and include project requirements 4-7.
The Course Project consists of 12 Requirements for you to complete. The Course Project is due at the end of Module 9. See the Due Dates section for more information. All of the information you need to complete the Course Project is located in an Excel Workbook. Be sure to read all the sheets in the workbook. This workbook includes:
Eight worksheets in the workbook you will need to complete
A list of March transactions
A Chart of Accounts reference sheet
A Grading Rubric to help explain what is expected
Each worksheet has the Check Figures embedded as a comment
MGMT 210 Course Project Excel Workbook (XLSX)Preview the document
You will continue to use the same workbook for all 3 milestones. You do not need to download a new copy for Milestones 2 or 3. When you submit Milestone 3, all sheets in your workbook will be complete.
Please proceed to the Scenario section.
Youve just secured a new client in your accounting practice, Howard’s Flight Radio Management Corporation (HFRM), a brand 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 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 doesnt know where to begin. Its your job to go through the complete accounting cycle to prepare the financial statements for the HFRM.
Please proceed to the Requirements section.
Use this table to help ensure you use the correct worksheet for each requirement.
Requirement Requirement Description Worksheet Name
1 Prepare the Journal Entries in the General Journal 1 – Journal Entries
2 Post Journal Entries to the General Ledger 2 – General Ledger
3 Prepare a Trial Balance 3 – Trial Balance
4 Prepare the Adjusting Entries 4 – Adjusting Entries
5 Post Adjusting Entries to the General Ledger 2 – General Ledger
6 Prepare an Adjusted Trial Balance 5 – Adjusted TB
7 Prepare the Financial Statements 6 – Financial Statements
8 Prepare the Closing Entries 7 – Closing Entries
9 Post Closing Entries to the General Ledger 2 – General Ledger
10 Prepare the Post Closing Trial Balance 8 – Post Closing Trial Balance
11 Compute Ratios 11 – Ratios
12 Interpret the Ratios 12 – Interpretation of Ratios
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 instructor.
Please proceed to the Due Dates section.
Assignment 2: The Course Project consists of 12 Requirements for you to complete. The Course Project is due at the end of Module 9. See the Due Dates section for more information. All of the information you need to complete the Course Project is located in an Excel Workbook. Be sure to read all the sheets in the workbook. This workbook includes:
Eight worksheets in the workbook you will need to complete
A list of March transactions
A Chart of Accounts reference sheet
A Grading Rubric to help explain what is expected
Each worksheet has the Check Figures embedded as a comment
MGMT 210 Course Project Excel Workbook (XLSX)Preview the document
You will continue to use the same workbook for all 3 milestones. You do not need to download a new copy for Milestones 2 or 3. When you submit Milestone 3, all sheets in your workbook will be complete.
Please proceed to the Scenario section.
Youve just secured a new client in your accounting practice, Howard’s Flight Radio Management Corporation (HFRM), a brand 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 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 doesnt know where to begin. Its your job to go through the complete accounting cycle to prepare the financial statements for the HFRM.
Please proceed to the Requirements section.
Use this table to help ensure you use the correct worksheet for each requirement.
Requirement Requirement Description Worksheet Name
1 Prepare the Journal Entries in the General Journal 1 – Journal Entries
2 Post Journal Entries to the General Ledger 2 – General Ledger
3 Prepare a Trial Balance 3 – Trial Balance
4 Prepare the Adjusting Entries 4 – Adjusting Entries
5 Post Adjusting Entries to the General Ledger 2 – General Ledger
6 Prepare an Adjusted Trial Balance 5 – Adjusted TB
7 Prepare the Financial Statements 6 – Financial Statements
8 Prepare the Closing Entries 7 – Closing Entries
9 Post Closing Entries to the General Ledger 2 – General Ledger
10 Prepare the Post Closing Trial Balance 8 – Post Closing Trial Balance
11 Compute Ratios 11 – Ratios
12 Interpret the Ratios 12 – Interpretation of Ratios
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 instructor.
Please proceed to the Due Dates section.
There are three milestones in this project.
