Category: Accounting

Safeparts
Corporation is Jon Johnson’s audit and tax client. The short story:
The Cast of Characters
Safeparts
Corporation’s three directors are the officers and only stockholders of the
company. Each holds 1/3 of the shares. President Raul Rambo founded the company
and is now retired. As an individual, he is also Johnson’s tax client. Vice
President Jana Smith manages the day-to-day operations. She has been
instrumental in increasing the business and its profits. Smith’s individual tax
work is done by CPA Corin Ware. Treasurer Chris Fletch has been a long-term,
loyal employee responsible for many innovative financial transactions of great
benefit to the business. He is Johnson’s close, personal friend and an
individual tax client.
The Conflict
President
Rambo discussed with CPA Johnson the tax consequences to him as an individual
of selling his one-third interest in the Safeparts Corporation to Vice
President Smith. Later, meeting with Fletch to discuss his individual tax
problems, Johnson learns that Fletch fears that Rambo and Smith will make a
deal, put him in a minority position, and force him out of the company. Fletch
says, “Jon, we’ve been friends a long time. Please keep me informed about
Rambo’s plans, even rumors. My interest in Safeparts Corporation represents my
life savings and my resources for the kid’s college. Remember, you’re little
Otto’s godfather.” Thinking back, Johnson realized that Vice President Smith
has always been rather hostile. Chances are that Johnson will lose the Safeparts
engagement (to CPA Ware) if Smith acquires Rambo’s shares and controls the
corporation. Nevertheless, Fletch will probably suffer a great deal if he
cannot learn about Rambo’s plan, and Johnson’s unwillingness to keep him
informed will probably permanently ruin their friendship.
Later, Johnson’s Dilemma 
Johnson
ponders the problem. “Safeparts Corporation is my client, but a corporation is
a fiction-only form. The stockholders personify the real entity, so they are
collectively my clients, and I can transmit information among them as though
they were one person. Right? On the other hand, Rambo and Fletch engage me for
individual tax work, and information about one’s personal affairs is really no
business of the other. What to do? I could be sued and lose my CPA license if I
get this wrong, so whatever should I do?
Required:
Prepare a paper discussion on the advice you would give to Johnson about
his professional ethics issue(s) with complete details. 
Include the appropriate
constraints that you believe are governing factors that Johnson must consider
per the AICPA Code of Professional Conduct as highlighted in Module B. 
Your paper should include a letter to each stockholder informing them about your decision concerning your ongoing ability to provide services as a CPA to the Safeparts Corporation and to each of them individually. 
Use proper business terms and refer to the AICPA Code of Professional Ethics as required.
Please see the PDF Textbook – Module B. 
If you are using outside source, please ensure its easly acesss (.gov, or .com)
Please do not use AI as it can be easly detected. 

Financial Analysis of Oman Oil Marketing Co. (OOMS): Ratio analysis, Vertical and horizontal analysis, Cash flow analysis, all details provided in the document attached, please focus on the font size and reference method. NOTE: Just do the report the report only, and use more than 10 references.

Project Overview & Instructions
OBJECTIVE
This project gives students the opportunity to apply the AMPS Framework to address a relevant
business question. In doing so, this assignment will contribute towards the development of an
“analytics mindset”, which is the ability to:
► Ask the right questions,
► Extract, transform and load relevant data,
► Apply appropriate data analytics techniques, and
► Interpret and share the results with stakeholders.
You have the choice to complete the semester project individually or in pairs. If you wish to
work with a partner, you must inform your instructor as soon as you begin working on the
project and no later than May 3, 2023. If you do not declare a partner by the deadline, you
must complete the project on your own.
BACKGROUND
This project is based on the Capstone Project 1 of the textbook used in this course (Richardson,
V. J., Teeter, R., & Terrell, K. (2023). Data Analytics for Accounting. New York, NY: McGraw-Hill
Education). You will be using real-world data from Lending Club – a US based peer-to-peer
lending company (www.lendingclub.com) – to analyze loan approvals and repayments.
REQUIREMENTS
You work for Lending Club as an accounting data analyst and you have been tasked with
developing a diagnostic model of loan repayment. Your task is to use appropriate software
tools, including Microsoft Office Excel and Tableau, to analyze data provided by the company.
Your ultimate goal is to understand the link between loan characteristics, initial loan approval,
and future loan repayment.
a. Part 1 – Written Report: The report should cover all five deliverables as described on p. 280
of the textbook (link available on Blackboard) and follow the guidelines outlined on the next
page.
a. Deliverable 1: Create and start working on your reportb. Deliverable 2: Prepare a Desсrіptive Statistics of the Independent and Dependent
Variables
c. Deliverable 3: Transform Data and Prepare another Set of Desсrіptive Statistics
d. Deliverable 4: Perform the Analysis
e. Deliverable 5: Create the Final Report
IMPORTANT: You must follow all instructions and formatting requirements, carefully and
exactly. If in doubt, reach out to your instructor.
b. Part 2 – Presentation: Prepare a professional presentation to the Chief Loan Officer of
Lending Club discussing your analysis. This presentation should be about 10 minutes in
length and summarize the main findings and recommendations from your written report. It
should be professional-looking, informative, and must include outputs, charts, and
visualizations from Microsoft Office Excel and/or Tableau.
c. You can use either PowerPoint or Tableau to prepare the presentation. You will need to
record your presentation and submit it before the deadline. Please note that you must turn
on the camera when you record your presentation! In other words, your recording should
include your slides and your face. Failure to comply will result in a significant reduction of
points.
d. Part 3 – Work Papers (Files): Prepare all your analysis, including visualizations, in Microsoft
Office Excel and/or Tableau. All your work papers must be submitted with your report and
should be organized in a professional, easy-to-follow way. Add explanations to your
visualizations where necessary
I certify that I am the author of this work and that any assistance I have received in its
preparation is fully acknowledged and disclosed. I have also cited any sources from which I used
data, ideas or words, directly quoted or paraphrased. This work was prepared by me specifically
for this course.
 Include a Table of Content with relevant section headings to organize your report
 Create at least four (4) visualizations (bar graphs, line charts, etc.) and discuss them in your
report
 Font: Times New Roman; Font size: 12; Line Spacing: 1.5; Normal Margins (1’’ on each side)
 Appendix: include a bibliography (https://www.plagiarism.org/article/whats-a-bibliography)
in APA style (http://www.easybib.com/guides/citation-guides/apa-format/) and additional
information, charts, sources, etc. as necessary
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

ACCT 102
Financial Statement Analysis
Term Paper Project
This term project requires you to analyze trends in corporate performance and to perform a financial statement analysis on a company of your choosing.
(I choose SEPHORA)
Choose a publicly held company, who reports their financial data in US dollars.  They should be traded on either the New York Stock Exchange or the NASDAQ.  
The title page of your paper should include the name of your company, and any logo that     the company uses and your name.
A table of contents is encouraged but not mandatory. Charts or graphs are encouraged but not mandatory.
Based on the most recent financial report available (only Annual 10K reports filed with the SEC should be used ), perform the following:
A horizontal analysis of the  complete Income Statement and Balance Sheet comparing the data from the two most recent years.**
A vertical analysis of the complete  Income Statement and Balance Sheet utilizing the data for the two most recent years. **
Compute the following ratios for the two most recent years AND COMMENT ON THE RESULTS.  (List the formula in words, then amounts, and then comment on the results. What do they mean, were the changes favorable or unfavorable. I highly recommend Excel for all numerical computations. )
Current Ratio
Acid Test Ratio
Accounts Receivable Ratio
Number of Day’s sales in receivables
Inventory Turnover
Number of Day’s sales in inventory
Return on Total Assets
Basic Earnings per share (This is computed at bottom of the income statement. Just disclose the amounts.)
Price Earnings ratio
Dividend Yield
Debt Ratio
Equity Ratio
Before presenting the financial data, prepare a narrative on your company.  You should consider not only using the formal 10K, but other sites as well to gather the data needed. (ALL OF THE FINANCIAL DATA ABOVE SHOULD BE TAKEN ONLY OUT OF THE AUDITED 10K REPORT.) Within the body of your narrative, make sure you include the following:
The nature of the operations. (How did the company get started, what products or services they sell, what companies are consolidated into the financial statements, how they distribute products, and whether they experience seasonal business.  Also include the state of incorporation within your narrative.)
The ticker symbol the company uses and what stock exchange they are sold on
Significant changes that have taken place
Significant future plans
What “Risk Factors”
Accounting methods related to costing inventory and recording depreciation
Any business combinations
How has technology changed their business
High and low stock prices for the years reported on. (Please also include what the current stock price is.
Any recent news after the date of your balance sheet.
COMMENT ON RESULTS of the financial analyses above in your paper.
You can include any other data as you see fit.
I STRONGLY SUGGEST that you have someone proofread your paper before submitting it.  You may want to exchange papers with a classmate and have each other proof your work (and learn about another company in the process.)
Your project should be typed (in Word)  and should include all of the above.  (Excel attachments are ok but I prefer you export data into Word if you know how. Otherwise, you can attach excel files and refer to them in the Word document.  No handwritten data will be accepted. All work must be uploaded in Canvas prior to the due date.  Try your best to include all data In ONE FILE.
** This can be done using ONE line of FORMULAS in Excel. Just copy the formula down.  
I prefer WORD better.

No plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions. All answers must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism.
Assignment Question(s): (Marks 15)
Q1. What is the process of identifying activities in an organisation and assigning costs under the Activity Based Costing (ABC) system? Elucidate. You will need to include the right numerical examples to support your answer. (2 Marks) (Chapter 7, Week 7)
Answer:
Q2. PPLC Company has two support departments, SD1 and SD2, and two operating departments, OD1 and OD2. The company decided to use the direct method and allocate variable SD1 dept. costs based on the number of transactions and fixed SD1 dept. costs based on the number of employees. SD2 dept. variable costs will be allocated based on the number of service requests, and fixed costs will be allocated based on the number of computers. The following information is provided: (4 Marks) (Chapter 8, Week 10)
Support Departments
Operating Departments
SD1
SD2
OD1
OD2
Total Department variable costs
18,000
19,000
51,000
35,000
Total department fixed costs
20,000
24,000
56,000
30,000
Number of transactions
30
40
200
100
Number of employees
14
18
35
30
Number of service requests
28
18
35
25
Number of computers
15
20
24
28
You are required to allocate variable and fixed costs using direct method. Answer:
Q3. What are an organization’s “outsourcing decisions” and “constrained resource decisions?” Provide a suitable numerical example of these decisions and explain how quantitative and qualitative considerations support a company’s decision-making process.
(2 Marks) (Chapter 4, Week 9)
Note: Your answer must include suitable numerical examples. You are required to assume values of your own, and they should not be copied from any sources. Answer:
Q4. VBN plastic industry makes three plastic toys: T1, T2, and T3. The joint costs of the three products in 2017 were SAR 120,000. The total number of units for each product and the selling price per unit is given below:(3 Marks) (Chapter 9, Week 11)
Product
Units
Selling Price per unit
T1
45,000
SAR 15
T2
26,000
SAR 14
T3
18,000
SAR 10
You are required to allocate the joint costs to each product using the physical volume method and sales value at the split-off method.
Answer:
Q5. MN&M Corporation is preparing a budget for 2018. The company provides you with the following details which will help you to prepare the budget: (4 Marks) (Chapter 10, Week 12)
Budgeted selling price per unit = SAR 500 per unit
Total fixed costs = SAR 150,000
Variable costs = SAR 100 per unit
Required:
You are required to prepare a flexible budget for 1,000, 1,100, 1,200 and 1,300 units. Answer:

Read Instructions VERY Carefully, for the 2 organizations I want to select Pfizer as the profit organization and Mayo Clinic as the Non-Profit.

Situations and financial projections in companies are constantly changing. The effects of global events can impact valuations on companies over time. For example, in some cases, the pandemic has caused substantial issues in financial projections, either in a positive or negative manner. 
Analyze each post and what did you learn from each post? Post a cohesive response.
Post 1:
One of the companies that were highly affected by consumer demand due to the pandemic was Hilton. Hilton went from being the number 1 best company to work for to in the U.S. to weeks later, having to furlough thousands of its employees. This is because of the pandemic lockdown, people were not traveling and staying away from home. This negatively affected Hilton in its financials. Hilton not only lost from people not renting rooms but they also lost from their restaurant and bar departments. As a result, Hilton stopped operations in 275 properties across the United States and Europe. Other companies such as pharmaceutical companies were favored by the pandemic and consumer demand. 
Post 2:
After considering the positive impact of pandemic and public demand for transportation industry, I selected FedEx because the high demand for deliveries increased FedEx’s revenues during pandemic. FedEx does not only deliver residential packages but business packages for retail companies such as Walmart, Costco, and Shoprite. Furthermore, the average daily package volume increased for FedEx Ground, which handles e-commerce deliveries for retailers like Walmart. The volume for residential and business deliveries increased as clients placed a lot of online orders such as office furniture, food, clothing, and equipment to keep their social distance. These higher profits attracted more investors as EPS was higher and investors were willing to pay more for the company’s shares. FedEx was able to minimize its costs and invest in things like automated sorting centers and route optimization. Route optimization saved fuel because residential deliveries were higher and delivery drivers were not spread out. FedEx also spent $565 million in 2020 on fuel which is 35% less than a year earlier in 2019. However, as of 2024, the demand for FedEx packages had decreased because there are other competitors such as UPS and Amazon. Additionally, many customers now prefer to buy in person. In my opinion, Fedex is a good example of how the pandemic affected positively its higher revenue, investment and cost minimization. 
Post 3: As we all know, there were millions of companies that were impacted by the pandemic and experienced changes in consumer demand. But a known, and a popular one is Delta Air Lines.
The airline industry was heavily impacted by the pandemic, and Delta Air Lines was no exception. Due to travel restrictions, lockdowns, and reduced consumer confidence, Delta and other airlines faced a significant decline in passenger demand. The company had to cancel flights, ground aircraft, and implement cost-cutting measures to mitigate the financial impact. Delta also had to adapt its operations to ensure passenger safety and comply with health protocols, such as implementing enhanced cleaning procedures and requiring masks. The ability of companies to adapt and respond to these changes in consumer behavior played a crucial role in their performance and resilience during these challenging times. 
Post 4: The COVID-19 pandemic taught Bed Bath & Beyond and other retailers important lessons about how to deal with changes in customer behavior and the economy. Even while demand for home goods increased, the pandemic made the company’s challenges from online merchants and the customer’s move toward digital purchasing even stronger. Regretfully, this change was not beneficial to Bed Bath & Beyond because of its restricted online capabilities.
The restructuring and capital-raising attempts of the corporation were inadequate due to declining finances, as shown by significant operational losses. By April 2023, Bed Bath & Beyond was in serious financial trouble, resulting in bankruptcy. Its association with stock dealers made matters more difficult by instabilizing the price of its shares while ignoring the more serious business problems. Later, as the shares of the company approached zero after bankruptcy, it was eliminated.
—-
You can begin the post, by saying “after anayzlzing each post….”
No sources are require since the posts are being analyze. 

I need the excel worksheet done and the questions answered in the case study story.  We use Pearson MYLAB and Mastering, but only students can access this.  

Using the T accounts (from the answer key), prepare the following financial statements for the year ending 12/31/2021:
Income Statement
Statement of Changes in Net Assets
Balance Sheet

Accounting case study filling out a spreadsheet with calculations based on other information in spreadsheet.