Assignment_2 Individual
.docx
keyboard_arrow_up
School
Sheridan College *
*We aren’t endorsed by this school
Course
4200D
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
10
Uploaded by AgentSwan4092
There are 2 parts to this individual assignment.
Part 1 – read the Maple Leaf Airport (MLA) case provided. Answer the 5 requireds using the information and appendices provided. Answer in a new word document (use the following naming convention LastName_FirstName_Assignment2_Part1). Your response for Part 1 should be no more than 2,500 words. Part 2 – read the scenario provided. Address the specific requireds. Answer in a second new word document (using the following naming convention LastName_FirstName_Assignment2_Part2). Your response for Part 2 should be no more than 2,500 words.
Part 1: (60%) Maple Leaf Airport (MLA) Case
You, CPA, are an internal auditor with Maple Leaf Airport (MLA). MLA, located in
Maple Leaf City, has undergone significant expansion during fiscal 2023, including
the construction of a new terminal building to allow it to start servicing international
routes. Given it operates on land leased from the Canadian government, MLA is
subject to regulation related to both environmental issues and which airlines it is
permitted to do business with. Details on the Land Use Rules are provided in
Appendix I.
It is February 13, 2024, and you are beginning to prepare for the December 31,
2023, annual external audit of the financial statements in accordance with
International Financial Reporting Standards. “
We need to address the key
accounting issues before the audit firm arrives,” the director
of
internal
audit,
Carol
LeBlanc,
explains.
“Therefore,
I would
like
you
to
prepare
a
memo on the treatment
of the accounting matters I have identified in Appendix II
. Required 1: There are
three accounting issues which are to be discussed in the case. You should use the
following approach to discussing an accounting issue: Issue = should include the
accounting treatment the company is currently following and what you will be
analyzing. GAAP = identify the key GAAP criteria which will be used to support your
discussion. Analysis = your interpretation of the GAAP criteria and using case facts
to analyze. Recommendation = your recommended accounting treatment – what
they should be doing, as well as the impact on user objectives if any. “The chief financial officer (CFO), Zach Mostar, also mentioned that during his
review of earnings, he became concerned with the revenue figures from our parking
lot,” Carol continues. “He did not notice a decrease in car traffic, but revenue has
significantly declined. Upon further investigation, he discovered that fraud had
occurred. I have provided the background on our parking revenue process and an
analysis of the current-year revenue figures in Appendix III. Please provide the CFO
with some insight into what may have happened and how we can improve our
controls over
parking revenue to prevent
something similar from happening in the
future
. Please also explain what analytical procedures MLA staff can perform as
detective controls to help them identify, on a more timely basis, any anomalies in
parking revenue
. Required 2: Address the control weaknesses (discuss three) in the
parking revenue process. Use the WIR framework (weakness = clearly explain the
issue/control design flaw using case facts; implication = the financial or other
impact/why the company should care; and recommendation = what control should
be implemented to prevent an issue in the future/be specific. Required 3: Discuss
three analytical procedures which could be performed to address the objective of
the user (to perform as detective controls to help them identify any anomalies in
parking revenue. “
Further, our external auditors have asked for our assistance in completing audit
procedures over additions to capital assets related to our new international
terminal, and procedures over our landing fee revenue.
Please design procedures
over the additions to capital assets, keeping in
mind
the
relevant
risks
. For
landing
fee
revenue, given
the
high
volume
of flights
on
an
annual basis, an analytical
procedure is likely the most appropriate. Please perform that analysis
. Required 4:
provide the audit procedures (4 good ones) for the new terminal building. When
developing substantive procedures use the RAP framework: Risk – what the risk of
an overstatement or understatement is and why. Assertion – the key assertion(s).
Procedure: a complete procedure which includes what the starting point is, what
evidence we need, how we will review it, and how it connects back to the GL.
Required 5: Prepare the substantive analytics (2 good ones) over the landing fee
revenue. Show your calculations, support your assumptions/inputs, and interpret
your results.
APPENDIX I
LAND USE RULES
The Canadian government requires Maple Leaf Airport (MLA) to be in compliance
with the following regulatory rules as a condition for using the land leased for
airport operations. MLA complied with all of these regulations in 2023.
1.
Environmental Impacts
The impact of carbon dioxide emissions on the Maple Leaf City region from
departing and arriving flights must be limited to 1,000 metric tonnes per annum.
Each additional metric tonne is subject to a $10,000 fine. When a jet airplane
lands and then takes off, it generates a total of 100 kilograms of carbon dioxide
impact, on average, on the local surrounding area (1,000 kilograms equals 1 metric
tonne).
2.
Canadian Airline Facilitation
M L A must not engage a foreign airline to service more than 5% of the volume
of a given route, calculated based on number of passengers travelling the route.
For example, if total passenger demand for a route from Maple Leaf City to
Singapore is 100,000 passengers per year, foreign-based airlines may not service
more than 5,000 passengers. Each percentage in excess of 5% is subject to a
$15,000 fine per route.
3.
Noise Pollution
Given proximity to residential communities, MLA must cease airport operations at
11:00 p.m. local time on a daily basis and refrain from beginning airport operations
until the following morning at 6:00 a.m. Each flight that takes off or lands during
the hours of limitation will be subject to a $2,500 fine.
Non-compliance with these rules will result in fines to the airport, as specified
above. M L A is expected to commit to the highest standards of ethical business
conduct and service to its stakeholders, including customers, employees, tenants,
suppliers, neighbours, and the city.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Answer the following questions in a separate document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link.
This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
Please respond to the following:
You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in 26 equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. What is the present value of the payments you will receive?
In your own words and using various bond websites, locate one of each of the following bond ratings: AAA, BBB, CCC, and D. Describe the differences between the bond ratings. Identify the…
arrow_forward
urgent this please help me in 1 hour
arrow_forward
Explain the following entities: (about ten lines each). Use any Internet resources, and please give reference to those resources.
(a) HMO (Health Maintenance Organization.
(b) PPO (Preferred Provider Organization.
(C) CMS (Centers for Medicare and Medicaid Services.
(d) PPS (Prospective Payment System.
(e) DRG (Diagnosis Related Groups.
arrow_forward
Info in image "ACC PT1" can be used for image "ACC PT2"
arrow_forward
Use the template attached below to complete this activity: (Videos are available in the C4 module on using the ebook + copying worksheets).
Chapter_7_Applying_Excel_template-1.xlsx
Use the data found in the template + use the additional data found in the ebook section, "Applying Excel" (p. 330 print text). All calculations should be performed within the cell using cell referencing/formulas so that I can see how you arrived at your answers! Do not use your calculator and just type in numbers!
You will submit four worksheets within your assignment file:
sheet 1 = original
sheet 2 = requirement 1 quantitative + question responses
sheet 3 = requirement 2 quantitative + question responses
sheet 4 = requirement 3 quantitative + question responses
In scenario 1, 2, and 3.... copy the original worksheet after inputting your cell formulas and change the values as indicated for each requirement. Name each tab by the question #.
Chapter 7: Applying Excel
Data…
arrow_forward
I need help with a and b
arrow_forward
I need the answer as soon as possible
arrow_forward
Hello,
I need help with this assigment.
You can take your time. The first 3 questions were answered already by someone else, but they told me that I needed to ask aomeone else for other parts of the assigment. Please help me. I also have attached the images of the answer of the first questions so you can undertand what the first person helping me was doing.
The instrudtions of the assigments are as follows:
Go to Yahoo.com’s financial website and enter Apple, Inc.’s stock symbol, AAPL. Answer the following questions concerning Apple, Inc.
What is the annual dividend of Apple’s stock?
How many current broker recommendations are strong buy, buy, hold, sell, or strong sell?
What is the average of the broker recommendations?
What is the price-earnings ratio?
arrow_forward
Hello,
I need help with this assigment.
You can take your time. The first 3 questions were answered already by someone else, but they told me that I needed to ask aomeone else for other parts of the assigment. Please help me. I also have attached the images of the answer of the first questions so you can undertand what the first person helping me was doing.
The instrudtions of the assigments are as follows:
Go to Yahoo.com’s financial website and enter Apple, Inc.’s stock symbol, AAPL. Answer the following questions concerning Apple, Inc.
At what price did Apple’s stock last trade?
What is the 52-week range of Apple’s stock?
When was the last time Apple’s stock hit a 52-week high?
What is the annual dividend of Apple’s stock?
How many current broker recommendations are strong buy, buy, hold, sell, or strong sell?
What is the average of the broker recommendations?
What is the price-earnings ratio?
arrow_forward
Attach is a copy of the question . I really need help. Please
arrow_forward
Academic access to the FASB Codification is available through university subscriptions, obtained from the American Accounting Association. This subscription covers an unlimited number of students within a single institution. Once this access has been obtained by your school, you should log in to prepare responses to the following exercises.
CE1.1 Describe the main elements of the link labeled “Help, FAQ, Learning Guide, and About the Codification.”
CE1.2 Describe the procedures for providing feedback.
CE1.3 Briefly describe the purpose and content of the “What’s New” link.
arrow_forward
Match the two lists, below, by placing the capital letter from List 1 in each of the cells
preceding the five descriptions in List 2 to which they best relate.
One description in List 2 can be answered with 2 matches from List 1. Therefore, you should
have 2 letters left over from List 1.
List 1: Concepts
A. Application (i.e., automated) control.
B. Corrective control.
C. Control environment.
D. Input validity.
E. Input completeness.
F. Input accuracy
G. Update completeness.
H. Efficient use of resources.
List 1: Capital letter
List 2: Definitions/Descriptions
1. Insurance policy reimburses a company for losses due to
a fire in a warehouse.
2. Shipping notices have a serial number that is tracked to
ensure that they are all input.
3.
Computer reviews each input to ensure that all the
required data are included.
4. Inventory movements are tracked with a scanner to
reduce manual counting.
5. Purchase orders are signed to approve the purchase.
arrow_forward
Kk.252.
arrow_forward
I asked two questions (Problem 10-36 & 10-38) from separate messages, but both ansewers were incorrect.
Then, I sent below message again.
However, I only received problem 10-36 answer for the following the message.
“Since you have asked multiple questions, we will solve the first question for you. If you want any specific question to be solved then please specify the question number or post only that question.”
Please review Problem 10-38 again and send me the correct answer for proble10-38.
Problem 10-38 (LO. 2, 3, 4, 5, 6, 7)
Evan is single and has AGI of $277,300 in 2020. His potential itemized deductions before any limitations for the year total $52,300 and consist of the following:
Medical expenses (before the AGI limitation)
$29,000
Interest on home mortgage
8,700
State income taxes
9,500
Real estate taxes
3,600
Charitable contributions
2,500
After all necessary adjustments are made, what is the amount of itemized deductions Evan may claim? Do not…
arrow_forward
Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items as listed in the feedback portion of the pictures. Note that the pictures are for the same problem, I have just included the separate feedback parts for specification purposes.
arrow_forward
since due to Q&A guidelines, you must answer the first three sub-parts, could you please answer to questions 4, 5 and 6, please? thank you
arrow_forward
Since i have posted a question with multiple sub-parts, you will solve the first three sub-parts for me. To get remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.” In the first part and I do not have the step 3 ,I have only the steps 2 and steps 4. The second picture I will send you is the sub-parts and the # you need to resolved is the #4 and #5. Thank you! I'm looking forward to wait for the rest of my homework. Have a nice day!
arrow_forward
1.
arrow_forward
Can you help me with this problem please
arrow_forward
Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items.
arrow_forward
I need all blanks filled with the blue arrow pleaee and thank you.
arrow_forward
Reports can be directly exported from QBO to __________________.Select all that apply.
Select one or more:
A. a PDF file
B. a new workbook in Excel
C. an existing workbook in Excel
D. another company file in QBO
arrow_forward
Please don't give image format
arrow_forward
Answer the following questions by writing down the correct
letter next to the relevant number:
arrow_forward
Hello i have attached two pictures. They are both used together to answer the question. The first picture is the information to use too answer the question. The second attachment is the for the answer. I hope it is understandable and whoever answer this can please explain how they got the answers. I need the help. I have marked a yellow x on what i have done already. I DO NOT NEED HELP WITH WHAT IS CROSSED IN YELLOW (PARTS 1-3) I NEED PARTS 4-6. THIS IS IS IS THE ANSWER TO PARTS 1-3
Analysis and Calculation:
1)
Gold Medal Athletic Co.,
Sales Budget:
For the month ended March:
Product
Sales Volume
Sale Price per unit
Sales, $
Batting helmet
1,200 units
$40
$ 48,000
Football helmet
6,500 units
$160
$1,040,000
Total revenue from sales
$ 1,088,000
2)
Production Budget:
Batting
Football
Helmet
Helmet
Expected units to be sold
1,200
6,500
Add: desired Ending inventory
50
220
Total
1,250
6,720
Less: Beginning estimated inventory
40
240
Total…
arrow_forward
How would I calculate this problem? I just guessed on which answer made sense to me. Please help. thank you in advance.
arrow_forward
Can you please expand on how you got the answer for: Think-Local Inc
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardAnswer the following questions in a separate document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. Please respond to the following: You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in 26 equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. What is the present value of the payments you will receive? In your own words and using various bond websites, locate one of each of the following bond ratings: AAA, BBB, CCC, and D. Describe the differences between the bond ratings. Identify the…arrow_forwardurgent this please help me in 1 hourarrow_forward
- Explain the following entities: (about ten lines each). Use any Internet resources, and please give reference to those resources. (a) HMO (Health Maintenance Organization. (b) PPO (Preferred Provider Organization. (C) CMS (Centers for Medicare and Medicaid Services. (d) PPS (Prospective Payment System. (e) DRG (Diagnosis Related Groups.arrow_forwardInfo in image "ACC PT1" can be used for image "ACC PT2"arrow_forwardUse the template attached below to complete this activity: (Videos are available in the C4 module on using the ebook + copying worksheets). Chapter_7_Applying_Excel_template-1.xlsx Use the data found in the template + use the additional data found in the ebook section, "Applying Excel" (p. 330 print text). All calculations should be performed within the cell using cell referencing/formulas so that I can see how you arrived at your answers! Do not use your calculator and just type in numbers! You will submit four worksheets within your assignment file: sheet 1 = original sheet 2 = requirement 1 quantitative + question responses sheet 3 = requirement 2 quantitative + question responses sheet 4 = requirement 3 quantitative + question responses In scenario 1, 2, and 3.... copy the original worksheet after inputting your cell formulas and change the values as indicated for each requirement. Name each tab by the question #. Chapter 7: Applying Excel Data…arrow_forward
- I need help with a and barrow_forwardI need the answer as soon as possiblearrow_forwardHello, I need help with this assigment. You can take your time. The first 3 questions were answered already by someone else, but they told me that I needed to ask aomeone else for other parts of the assigment. Please help me. I also have attached the images of the answer of the first questions so you can undertand what the first person helping me was doing. The instrudtions of the assigments are as follows: Go to Yahoo.com’s financial website and enter Apple, Inc.’s stock symbol, AAPL. Answer the following questions concerning Apple, Inc. What is the annual dividend of Apple’s stock? How many current broker recommendations are strong buy, buy, hold, sell, or strong sell? What is the average of the broker recommendations? What is the price-earnings ratio?arrow_forward
- Hello, I need help with this assigment. You can take your time. The first 3 questions were answered already by someone else, but they told me that I needed to ask aomeone else for other parts of the assigment. Please help me. I also have attached the images of the answer of the first questions so you can undertand what the first person helping me was doing. The instrudtions of the assigments are as follows: Go to Yahoo.com’s financial website and enter Apple, Inc.’s stock symbol, AAPL. Answer the following questions concerning Apple, Inc. At what price did Apple’s stock last trade? What is the 52-week range of Apple’s stock? When was the last time Apple’s stock hit a 52-week high? What is the annual dividend of Apple’s stock? How many current broker recommendations are strong buy, buy, hold, sell, or strong sell? What is the average of the broker recommendations? What is the price-earnings ratio?arrow_forwardAttach is a copy of the question . I really need help. Pleasearrow_forwardAcademic access to the FASB Codification is available through university subscriptions, obtained from the American Accounting Association. This subscription covers an unlimited number of students within a single institution. Once this access has been obtained by your school, you should log in to prepare responses to the following exercises. CE1.1 Describe the main elements of the link labeled “Help, FAQ, Learning Guide, and About the Codification.” CE1.2 Describe the procedures for providing feedback. CE1.3 Briefly describe the purpose and content of the “What’s New” link.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning