Category: Accounting

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

In the accounting field, you may one day be put in a compromising situation in which you question the morality or integrity of the actions taken and future actions that need to be taken. For this discussion, you will discuss possible actions to take when an authority figure/company puts you in a compromising situation. As you read the scenario and answer the questions, consider GAAP principles, continual updates and nuances to methods and GAAP, and GAAP ethics.
First, read from Chapter One in your textbook in the Review and Practice section: Critical-Thinking Cases CT1.13 Ethics (Rule Making Issues). Then, address the following questions in your initial post:
From your point of view, is there an ethical issued involved in this case? In your own words, explain why there is or is not an ethical issued involved and what the issue is.
Is the financial vice president acting improperly or immorally? Why?
What does Weller have to gain by advocacy of early implementation?
How might stakeholders be affected by the decision against early implementation?
Should we hold financial decision makers and companies responsible and why?
In your responses to two peers, respond to their initial post and add to the conversation about possible actions to take when an authority figure/company puts you in a compromising situation. Provide examples from personal experience or recent events.
To complete this assignment, review the Discussion Guidelines and Rubric.
To complete this assignment, review the Discussion Rubric.
https://wileyplus.vitalsource.com/reader/books/9781119744429/epubcfi/6/22[%3Bvnd.vst.idref%3Dc01]!/4[c01-body-0001]/2[id1]/16[idd2]/16[c01-sec-0004]/16/2%4050:92 
login info  website  book
password edulik88@
Peer 1)After reading through the case it seems that when the FASB creates new rules they have a 12 month implementation period from their date of issuance. Within this policy it states that early implementation is encouraged. While Weller was pushing for the early implementation because “it would cause a fairer presentation of the company’s financial condition and earnings”. The vice president she spoke with decided to not implements the rule early because the vice president deemed it would adversely affect their reports. This seems to me like an ethical issue is involved. Weller may only gain the good feeling of properly presenting the financial health of the company. Stakeholders may not be able to gain the better representation of the financials of the company or may also be adversely affected by the lower projected numbers the company may have. Yes we should definitely hold financial decision makers and companies responsible because if they act unethically or immorally they can adversely affect many clients along with their employees.
References:
Global leader in publishing, Education and research. Wiley. (n.d.). https://www.wiley.com/en-us
peer 2) There is a clear ethical issue when the financial vice president discourages early implementation of a new accounting rule because it would lower the reported net income. This action prioritizes the company’s short-term financial appearance over the long-term goal of providing transparent and accurate financial information. The role of financial reporting is to present a true picture of the company’s financial health. By delaying the implementation of a rule that ensures fairer presentation, the financial vice president is potentially misleading stakeholders, including investors, creditors, and regulators. This decision compromises ethical principles like honesty and transparency, which are crucial for maintaining trust and integrity in financial reporting.
Advocating for early implementation of the new rule, as Karen Weller suggests, has significant benefits. It demonstrates a commitment to ethical standards and ensures that the company’s financial reports are accurate and transparent. This approach not only enhances Weller’s professional reputation but also builds trust with stakeholders who rely on truthful financial information for their decisions. On the other hand, delaying the implementation can lead to stakeholders making decisions based on incomplete or misleading information, potentially causing financial losses and damaging trust in the company’s management. Holding financial decision-makers accountable for their actions is essential to maintain the integrity of financial reporting and protect stakeholders’ interests.

The following short homework essay due this week is worth 40 points:
In a very concise essay (one page), explain the concept of cardinality within the context of database relationships, and describe at least one relevant example in your answer.
Submit your assignment in a Word file upload.

Primary Task Response: Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Understanding cost behavior is important for analysis and decision making. Cost can be broadly categorized as fixed, variable, or mixed. The way costs behave in relation to production drives pricing and cost estimation.
Evaluate the behavior of fixed, variable, and mixed costs in a manufacturing environment. Elaborate on an example of each type of cost as applied in a manufacturing environment. Communicate why understanding the costs you have chosen are essential in pricing and cost estimation. Responses to Other Students: Respond to at least 2 of your fellow classmates with at least a 200-word reply about their Primary Task Response regarding items you found to be compelling and enlightening. To help you with your discussion, please consider the following questions:
What did you learn from your classmate’s posting? What additional questions do you have after reading the posting? What clarification do you need regarding the posting? What differences or similarities do you see between your posting and other classmates’ postings?

The following multiple-part problem due this week is worth 40 points:
Problem 14.2 (pages 455-456) – Answer questions a through l.
Submit your assignment in a Word file upload