Computation of significant ratios, Auditing

Assignment Help:

Plz assist me with these questions

The auditors for Weston University are conducting their audit for the fiscal year ended December 31, 2011. Specifically, the audit firm is now focusing on the audit of revenue from this season's home football games. While planning the audit of sales of football tickets; one of their newer staff people observed that in prior years, many hours were spent auditing revenue. This staff associate pointed out that perhaps the firm could apply analytical procedures to evaluate whether it appears that revenue account is properly stated.
The staff associate noted that information for a typical home game could be used to estimate revenues for the entire season. The home football season consisted of seven home games - one against a nationally ranked powerhouse, Bloomington University, and six games against conference opponents. One of these conference games is Weston's in-state archrival, Norwalk University. All these were day games except for the games against a conference opponent, Westport University.
The auditor will base their estimate on game played against Kramer College, a conference opponent, Weston University. The following concerning that game is available:
Total attendance 24,000 (stadium capacity 40,000)
The attendance figure includes the 500 free seats described below, and the 24,000 figure should be used as a basis for all further calculations.
Ticket prices
Box seats $12 per ticket
End zone seats 8 per ticket
Upper - deck seats 5 per ticket
At the game against Kramer College, a total attendance was allocated among the different seats as follow:
Box seats 70%
End zone seats 20%
Upper - deck seats 10%
• Based on the information obtained in prior year audits, the following assumptions are made to assist in the estimation of revenue for all the games;
• Attendance for the Bloomington University game was expected to be 30% higher than total attendance for an average game, with the mix of seats purchase expected to be the same as for regular game; however, tickets are priced 20% higher than a normal game
• The game against Norwalk University was expected to draw 20% more fans than normal game, with 75% of these extra fans buying box sets and the other 25% purchasing upper - deck seats.
NORALK UNIVERSITY 23,500 X 20% = 470,000, 12.00 X 23,500. = 282,000
.75 X 12.00 = 900
.25 X 12.00 = 300
• To make up for the extra costs associated with the night game, ticket prices were increased by 10% each; however, attendance was also expected to be 5- percent lower than for normal game, with each type of seating suffering a 5 percent decline.
12.00 X 10% $ 12X .10 = $ 120.00
$8.00 X 10% $ 8.00 X .10 =$80.00
$5.00 X .10 $50.00 LOWER
• At every game, 500 box seats are given away free to players' family and friends. This number is expected to be the same for all home games.
REQUIRED:
1. Based on information above develop an expectation for the ticket revenue for seven home football games.
TOTAL Attendance; 24,000 - 500 = 23,500.
130% x 23,500 = 3,055
Attendance for Bloomington University game higher by 30%
24,000- 500 = 23,500 23, 500X 12.00 282,000
23,500 X .30 = 7,050 7,050X 12.00 84,200
2. Reported ticket Revenue was $2, 200,000. Is the difference between your estimate and reported ticket revenue large enough to prompt further consideration? Why or why not? If further consideration is warranted, provide possible explanations for the difference between estimated and actual football ticket revenue. What evidence could you gather to verify each of your expectations?
$2,200,000 - 2,000,000 = $200,000 DIFFERENCE OF THE ESTIMATE
3. Under what conditions is substantive analytical procedure likely to be effective in a situation such as that described in this problem?
The use of analytically procedures is one method of increasing auditor efficiency. Analytically procedures consist of evaluations of financial information made by an auditor of plausible and expected relationships among both financial and non-financial data. They range from simple comparisons (e.g., the current year with the preceding year) to the use of complex models involving many relationships and elements of data (e.g., regression
Analytically procedures used in planning the audit might include the following:
• Account balance comparison. Compare unadjusted trial balance amounts with adjusted tried balance amounts of the prior year.
• Computation of significant ratios. Compare current year ratios to current industry ratios and prior year computing ratios.
• Computation of ratios using non financial and financial data. E.g., sales per square foot of sales space.
• Regression analysis. This procedure is discussed in a separate section below.

 


Related Discussions:- Computation of significant ratios

Conformity and conservatism - external auditor report, Conformity and Conse...

Conformity and Conservatism - External Auditor Report Conformity Although the user of the accounts expects the accounts to conform to general accepted accounting princi

Internal control systems, Internal Control Systems ISA 400: “Internal c...

Internal Control Systems ISA 400: “Internal control system” means all the policies and processes (i.e., internal controls) accepted by the management of an entity to assist in

Explain what further evidence you would seek in relation, 1. On 5 August 20...

1. On 5 August 2012, the financial controller informed you that the board has recently received a letter from the assistant general manager, Mr. Tan. The letter contains a confessi

Records kept by auditor, Records kept by AUDITOR of procedures applied, tes...

Records kept by AUDITOR of procedures applied, tests performed, the information obtained and pertinent conclusions reached in the course of the AUDIT. (2) Any records developed by

Audit report, impact on audit report of going concern

impact on audit report of going concern

Relevance, Relevance The auditor obtains evidence either through compli...

Relevance The auditor obtains evidence either through compliance testing of the internal controls or through substantive tests of the information contained in the financial sta

Non-adjusting events - audit process, Non-Adjusting Events - Audit Process ...

Non-Adjusting Events - Audit Process Non-adjusting events are those that are indicative of conditions such arose than the balance sheet date as a decline in the market price o

ACL PROGRAME, I have some questions in ACL PROGRAME . IF YOU CAN HELP ME

I have some questions in ACL PROGRAME . IF YOU CAN HELP ME

Reliance on the work of other auditors, Reliance on the Work of Other Audit...

Reliance on the Work of Other Auditors The principal auditor or the primary auditor is solely responsible for the holding company's accounts. So here it is inevitable but that

COBIT, Analyse the ratios in conjunction with the additional information an...

Analyse the ratios in conjunction with the additional information and identify from your analysis, implications for the audit and any particular audit steps that need to be underta

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd