Category: Accounting

Project 1- Regression Analysis 1. Develop scattergraphs, simple regression output tables, and multiple output table. 2. Develop cost estimation based on your regression analysis. 3. Analyze results and recommend the best approach for the cost estimation.   

This assignment is an INDIVIDUAL assignment and due by the final day of the Module.  Submissions should be uploaded to the dropbox in the course. Research assignments should be in proper format of a Client Letter AND Memo.  Citations needed should only be IRS PRIMARY SOURCES.  Submissions that reference non primary sources cannot earn a passing score.
Harold recently was notified by the IRS that he was being assessed a penalty for failure to file a tax return.  Harold was upset that he has to pay this penalty, but has come to you, a CPA for assistance to ensure he is tax compliant moving forward.  Harold believes that the penalty paid for failure to file the tax return is tax deductible.
REQUIRED:
As a staff accountant in the firm hired by Harold, use an official tax research service to research primary source material to determine if this penalty can be deducted.  Communicate your findings in both a work paper memo and client letter as to whether or not Harold can deduct the penalties.

Complete this template by replacing the bracketed text with the relevant information.
Accounting System Questions
1. How does an accounting system provide accurate calculations to prevent errors?
[Insert text.]
2. What are potential concerns related to data security?
[Insert text.]
3. How does an accounting system save time?
[Insert text.]
4. How does using an accounting system enable separation of duties?
[Insert text.]
5. What are the benefits of an ERP system?
[Insert text.]
6. What are the benefits of QuickBooks?
[Insert text.]
Variance and Anomalies Questions
7. How can an accounting system help you find anomalies or variances in financial data?
[Insert text.]
8. Assume you calculated a financial ratio variance of 2x the usual balance for accounts receivable. Why did you calculate a financial ratio variance of 2x the usual balance?
[Insert text.]
9. You are a small company that calculates a normal current ratio at 1.95. This period the current ratio is only 1.45. Why has the ratio decreased?
[Insert text.]
References
Include at least one reference used to complete this chart. This section is for the full citation. Sources should be cited using APA style.

If you were to open a small business with the knowledge and skills you have acquired to this point, would you prefer to keep your accounting records on the cash basis or the accrual basis? Reflect on the differences between cash basis and accrual basis accounting, and explain why you selected one option over the other.

Please complete the case Excel and Analysis Case – Parker and Suffolk PLC, page 534, in good form, using Excel. The case includes Part I a-d, and Parts II – IV. Students are to complete Part I a-d only. The case will be submitted as one workbook; enter part I a-d on separate worksheet tabs.
I’ve attached photos of the case.

OverviewThe Governmental Accounting Standards Board (GASB) has established accountability as the cornerstone of financial reporting for governments. Accountability, as defined by GASB, includes budgetary and fiscal compliance. In this assignment, you will explore a local government’s Annual Comprehensive Financial Report (ACFR) for the elements of the ACFR and how those elements are incorporated by a local government.
Your professor will assign a local government ACFR for use in this assignment.
InstructionsWrite a 3-5 page paper in which you address the following:
Analyze the local government ACFR for the types of budgets the local government maintains. Provide at least three different budget types maintained by the local government and an example of what each controls.
Analyze the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provide an example of each of the three assertions you analyzed.
Analyze the Budget-to-Actual reports in the local government ACFR for at least three indications of budgetary and fiscal compliance, such as significant or non-significant variances. Provide the implication for the local government of each of the three indications.
Analyze the local government ACFR for at least three local government finance-related legal or contractual requirements. Provide an example of each of the three requirements.
Use at least three quality sources to support your writing. Choose sources that are credible, relevant, and appropriate. Cite each source listed on your source page at least one time within your assignment. For help with research, writing, and citation, access the library or review library guides.
This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support. Check with your professor for any additional instructions.
The specific course learning outcome associated with this assignment:
Analyze the financial reporting of a local government for specific indications of budgetary and fiscal compliance.
View Rubric
Week 4 Assignment – Week 4 – Assignment: Financial Reporting Review of Local Government
Week 4 Assignment – Week 4 – Assignment: Financial Reporting Review of Local Government
CriteriaRatingsPts
Analyze the local government ACFR for the types of budgets the local government maintains. Provide at least three different budget types maintained by the local government and an example of what each controls.26 to >23.4 pts
Exemplary
Analyzed the local government ACFR for the types of budgets they maintain. Identified three different budget types maintained and provided an example of what each control.23.4 to >20.8 pts
Competent
Analyzed the local government ACFR for the types of budgets they maintain. Identified three different budget types they maintained and provided an example of what two of the identified types control.20.8 to >18.2 pts
Satisfactory
Analyzed the local government ACFR for the types of budgets they maintain. Identified three different budget types they maintained. Response contains at least one example of what a budget type controls.18.2 to >15.6 pts
Needs Improvement
Analyzed the local government ACFR for the types of budgets they maintain. Identified two different budget types they maintained and an example of at least one of the budgets identified controls.15.6 to >0 pts
Unacceptable
Did not submit or submission contains no evidence or identification of the type of budgets maintained or identification of examples of what they control./ 26 pts
Analyze the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provide an example of each of the three assertions you analyzed.
26 to >23.4 pts
Exemplary
Analyzed the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provided an example of each of the three analyzed assertions.23.4 to >20.8 pts
Competent
Analyzed the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provided an example of two of the analyzed assertions.20.8 to >18.2 pts
Satisfactory
Analyzed the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provided an example of one of the analyzed assertions.18.2 to >15.6 pts
Needs Improvement
Analyzed the Management Discussion and Analysis for at least three assertions made by management as to their budgetary and fiscal compliance. Provided an incomplete example of one management assertion.15.6 to >0 pts
Unacceptable
Did not submit or submission contains no evidence of analysis of management assertions or examples of any assertions./ 26 pts
Analyze the Budget-to-Actual reports in the local government ACFR for at least three indications of budgetary and fiscal compliance, such as significant or non-significant variances. Provide the implication for the local government of each of the three indications. 26 to >23.4 pts
Exemplary
Analyzed the local government methods used in preparation of the Budget-to-Actual reports in the ACFR, including the basis of accounting used, significant variances, and other local government finance-related legal or contractual requirements.23.4 to >20.8 pts
Competent
Analyzed the local government methods used in preparation of the Budget-to-Actual reports in the ACFR, including at least two analysis factors – the basis of accounting used, significant variances, or other local government finance-related legal or contractual requirements.20.8 to >18.2 pts
Satisfactory
Analyzed the local government methods used in preparation of the Budget-to-Actual reports in the ACFR, including at least one analysis factor – the basis of accounting used, significant variances, or other local government finance-related legal or contractual requirements.18.2 to >15.6 pts
Needs Improvement
Analyzed the local government methods used in preparation of the Budget-to-Actual reports in the ACFR, but submission includes only partial inclusion of analysis factors – basis or accounting used, significant variances, or other local government finance-related legal or contractual requirements.15.6 to >0 pts
u
Did not submit or submission contains no evidence of analysis of local government methods used in preparation of the Budget-to-Actual reports in the ACFR and did not include any analysis factors – basis of accounting used, significant variances, or other local government finance-related legal or contractual requirements./ 26 pts
Analyze the local government ACFR for three local government finance-related legal or contractual requirements. Provide an example of each of the three requirements.
26 to >23.4 pts
Exemplary
Analyzed the local government ACFR for three local government finance-related legal or contractual requirements. Provided an example of each of the three requirements.23.4 to >20.8 pts
Competent
Analyzed the local government ACFR for three local government finance-related legal or contractual requirements. Provided an example of two of the three requirements.20.8 to >18.2 pts
Satisfactory
Analyzed the local government ACFR for three local government finance-related legal or contractual requirements. Provided at least one example of such a contractual requirement, however, the remainder of the submission does not contain suitable examples.18.2 to >15.6 pts
Needs Improvement
Analyzed the local government ACFR for three local government finance-related legal or contractual requirements. Provided a partial example of only one of the identified requirements.15.6 to >0 pts
Unacceptable
Did not submit or submission contains no evidence of analysis of the local government ACFR, with no identification of primary revenue sources from both governmental and enterprise funds or any analysis of the following factors – revenue rates, revenue trends, or whether there was any delay in the recognition of revenue./ 26 pts
Use at least three quality sources to support your writing. Choose sources that are credible, relevant, and appropriate. Cite each source listed on your source page at least one time within your assignment.
13 to >11.7 pts
Exemplary
Cited at least three credible, relevant and appropriate sources; each source was cited within the assignment.11.7 to >10.4 pts
Competent
Cited required number of sources but not all sources were credible, relevant or appropriate; or sources were not cited within the assignment.10.4 to >9.1 pts
Satisfactory
Cited required number of sources but sources were not credible, relevant or appropriate.9.1 to >7.8 pts
Needs Improvement
Did not cite the required number of sources and one or more sources were not credible, relevant or appropriate.7.8 to >0 pts
Unacceptable
Did not cite any sources./ 13 pts
Produce writing that contains accurate grammar, mechanics, and spelling in accordance with SWS style.
13 to >11.7 pts
Exemplary
Produced writing that is clear and well organized and applies appropriate SWS style. Writing contains accurate grammar, mechanics, and spelling with no errors.11.7 to >10.4 pts
Competent
Produced writing that attempts to be clear and well organized and to apply appropriate SWS style. Writing contains some errors in grammar, mechanics, and spelling. There may be occasional errors (1–2), but they do not impact the ability of the reader to understand the writing.10.4 to >9.1 pts
Satisfactory
Produced writing that attempts to be clear and well organized and to apply appropriate SWS style. Writing contains some errors in grammar, mechanics, and spelling. There are multiple errors (3–4) that distract from the reader’s ability to understand the writing.9.1 to >7.8 pts
Needs Improvement
Produced writing that has noticeable issues with clarity, organization, and the application of SWS style. Errors in grammar, mechanics, and spelling detract from readability. Overall, there were frequent errors (5–6) and have a definite impact on the ability of the reader to understand the writing.7.8 to >0 pts
Unacceptable
Produced writing that lacks clarity, organization, or does not apply SWS style. There are significant issues with grammar, mechanics, and spelling. Overall, errors are significant in number (7 or more), and the reader will have difficulty understanding the writing.

FIN 320 Module Six Journal Guidelines and Rubric
Overview
Risk and return go together. You must understand this relationship to make informed financial decisions. This applies when you make personal investment decisions or when you’re investing excess cash for a business. In this journal assignment, you will explore the risk-return relationship when investing in stocks in both of these roles.
Directions
Write a journal discussing risk and return as it relates to investing in stocks.
Specifically, you must address the following rubric criteria:
Investment Risk: Explain key risks associated with investing in stocks.
Investment Return: Discuss events that can cause the price of a stock to increase or decrease.
Risk-Return Relationship: Explain the relationship between risk and return and how this relationship affects stock-investment decisions. Use examples to support your claims.
Reflection: Describe how you would make stock-investment decisions in your:
Personal life: Investing for yourself
Professional life: Investing in a business
What to Submit
Your submission should be a 4- to 5-paragraph Microsoft Word document (not including title and resource pages) with 12-point Times New Roman font, double spacing, and one-inch margins. Sources should be cited using APA style.

Instructions 
Please be sure to answer all questions as unanswered problems will receive no credit.  Effort is most important — wrong answers will still receive partial credit.
All weekly homework assignments are to be completed using word documents or Microsoft Excel formula function entry. Some homework assignments contain numeric questions which can be completed using formula and function (fx) entries or financial calculator formula and solution entry in Excel.  A provided template each week  includes input data which can assist you in  completing excel solutions.  Again, this is not required but may help you in completing the numeric problems.   Or, complete the numeric problems independently in a word document.  If you use exel and word, please combine on one submission document.
Assigned Problems
Time Value of Money Questions and problems:   3 points
#4-9   page 122
#4-10 
#4-11
#4-12 
Discounted Cash Flow Questions and problem:  3 points
#5-2 – page 158
#5-12 – page 159
#5-16 – page160
#5-18 – page 160
Bond Valuation:  4 points
Critical thinking:
6.1 and 6.2 – page 202
Questions and problems:
#6-4 – page 203
#6-6 – page 204
#6-8 – page 204
#6-22 – page 205
Book Access
https://www.vitalsource.com
username:   **************************************************   Mibbys77!

Calculate the annual demand for each component of Model A and Model C
Calculate the EOQ for each component of Model A and Model C
Different from last week, use the cost for the Legos … 1 x 1 piece = $0.12
Adjust inventory levels as compared to current on-hand quantities of each component
Calculate inventory costs saving based on your EOQ calculation
Deliverable for this Section:
Summary demand for Model A and Model C of annual demand
Table showing your EOQ calculations for each Lego component of Model A and Model C
Table showing savings … comparing current inventory with proposed (EOQ calculated inventory). Note there are at least three areas of savings: material savings, holding savings, and ordering savings.

Overview
In Milestone One, you completed the first part of your course project to demonstrate your ability to accurately record financial data. In Milestone Two, you will use your trial balance results from Milestone One to create financial statements. These financial statements will be part of the Summary Report that you will present to your employer in Module Seven.
Scenario
You were recently hired as an entry-level bookkeeper for a service business that recently opened. This is the first month in operation for the business and your first task is to record business transactions for their first month using the source documents and transaction data the owner will provide to you. Because this is a small business that does not use computerized accounting, you will apply the accounting cycle in Excel to record transactions and generate financial reporting results for the owner.
Directions
Report Financial Results: Use the account balances from the Trial Balance generated through the recording process in Milestone One to prepare the income statement, statement of owner’s equity, and balance sheet for the company. Then close temporary account balances using closing entries in the final step. Be sure to revisit any feedback received from Milestone One and make necessary corrections to ensure that statements are completed with accurate balance information. (You may refer to the blank Company Accounting Workbook Template if necessary, but keep in mind that your work for this milestone should be added to the work that was completed in your workbook for the previous milestone. You should also implement any feedback that was given during Milestone One.)
Specifically, you must address the following rubric criteria:
Income Statement: Prepare the income statement using the adjusted trial balance
Statement of Owner’s Equity: Prepare the statement of owner’s equity using the adjusted trial balance.
Balance Sheet Assets: Prepare the balance sheet asset entries using the adjusted trial balance.
Balance Sheet Liabilities: Prepare the balance sheet liabilities entries using the adjusted trial balance.
Closing Entries: Complete the “Closing Entries” tab of the company accounting workbook by closing all temporary income statement amounts to create closing entries.
What to Submit
Build on your work from Milestone One to complete the “Income Statement,” “Statement of Owner’s Equity,” “Balance Sheet,” and “Closing Entries” tabs in your company accounting workbook. This should be completed and submitted using Microsoft Excel. Please refer to the video walkthrough linked below if you need more assistance with your submission.
Supporting Materials
The following resources support your work on the project:
Video: Milestone Two Walkthrough (13:28) ( https://youtu.be/4NGA6ZpsMRE?si=xAZUHS5B-XHNkTCk )
This video walkthrough is available if you need additional assistance completing this milestone. The video uses a sample data set for illustrative purposes.
A video transcript is available: Transcript for ACC 201 Milestone Two Walkthrough