你知道ACCA机考中常用的Excel公式吗?

发布时间:2020-02-21


最近有很多小伙伴都在问51题库考试学习网ACCA机考中常用的Excel公式有哪些?今天51题库考试学习网就为各位小伙伴说说吧!

常用公式

1.求和

=SUM(number 1,number 2,…)

2.减项

=number 1-number 2

3.乘法

=number 1*number 2

4.除法

=number 1/number 2

分为两类:

①直接乘除

②带入数据乘除

5.平均数

=AVERAGE(number 1,number 2,…)

6.平均增长率,有两种方法

方法1

=POWER(b/a,1/n)-1

方法2

=(b/a)^1/n)-1

7.复利求终值(通胀,增长等)

=Number*(1+r%^n

8.折现

=Number/(1+r%^n

9.NPV

=NPV(rate,number 1,number 2…)

10.年金折现

=PV(rate,nper,pmt,fv,type

其中:

参数rate为各期利率;

参数nper为投资期(或付款期)数;

参数pmt为各期支付的金额。省略pmt参数就不能省略fv参数;

fv参数为未来值,省略fv参数即假设其值为0,也就是一笔贷款的未来值为零,此时不能省略pmt参数;

type参数值为10,用以指定付款时间是在期初还是在期末,如果省略type则假设值为0,即默认付款时间在期末。

有以下分类

10.1普通复利年金

=PV(rate,nper,pmt,fv,type

10.2先付年金

=PV(rate,nper,pmt,fv,type

11.IRR

=IRR(number 1,number 2,…)

常用操作

1设置单元格格式

2设置数字格式

3从working中选数值

以上就是51题库考试学习网为大家带来的关于“ACCA机考中常用的Excel公式有哪些?”相关内容,希望能给各位小伙伴带来帮助。


下面小编为大家准备了 ACCA考试 的相关考题,供大家学习参考。

(iii) Can internal audit services be undertaken for an audit client? (4 marks)

Required:

For each of the three questions, explain the threats to objectivity that may arise and the safeguards that

should be available to manage them to an acceptable level.

NOTE: The mark allocation is shown against each of the three questions above.

正确答案:

(iii) Internal audit services
A self-review threat may be created when a firm, or network firm, provides internal audit services to a financial statement
audit client. Internal audit services may comprise:
■ an extension of the firm’s audit service beyond requirements of International Standards on Auditing (ISAs);
■ assistance in the performance of a client’s internal audit activities; or
■ outsourcing of the activities.
The nature of the service must be considered in evaluating any threats to independence. (For this purpose, internal audit
services do not include operational internal audit services unrelated to the internal accounting controls, financial systems
or financial statements.)
Services involving an extension of the procedures required to conduct a financial statement audit in accordance with
ISAs would not be considered to impair independence with respect to the audit client provided that the firm’s or network
firm’s personnel do not act or appear to act in a capacity equivalent to a member of audit client management.

When the firm, or a network firm, provides an audit client with assistance in the performance of internal audit activities
or undertakes the outsourcing, any self-review threat created may be reduced to an acceptable level by a clear separation
of:
■ the management and control of the internal audit by client management;
■ the internal audit activities.
Performing a significant portion of an audit client’s internal audit activities may create a self-review threat. Appropriate
safeguards should include the audit client’s acknowledgement of its responsibilities for establishing, maintaining and
monitoring the system of internal controls.
Other safeguards include:
■ the audit client designating a competent employee, preferably within senior management, to be responsible for
internal audit activities;
■ the audit client, audit committee or supervisory body approving the scope, risk and frequency of internal audit
work;
■ the audit client being responsible for evaluating and determining which recommendations of the firm should be
implemented;
■ the audit client evaluating the adequacy of the internal audit procedures performed and the resultant findings by
obtaining and acting on reports from the firm; and
■ appropriate reporting of findings and recommendations resulting from the internal audit activities to the audit
committee or supervisory body.
Consideration should also be given to whether such non-assurance services should be provided only by personnel not
involved in the financial statement audit engagement and with different reporting lines within the firm.


(ii) The shares held in Date Inc and the dividend income received from that company. (7 marks)

正确答案:
(ii) Shares held in Date Inc and the related dividend income
Degrouping charge
There will be a degrouping charge in Nikau Ltd in the year ending 31 March 2008 in respect of the shares in Date Inc.
This is because Nikau Ltd has left the Facet Group within six years of the no gain, no loss transfer of the shares whilst
still owning them.
Nikau Ltd is treated as if it has sold the shares in Date Inc for their market value as at the time of the no gain, no loss
transfer. This will give rise to a gain, ignoring indexation allowance, of £201,000 (£338,000 – £137,000).
This gain will give rise to additional corporation tax of £60,300 (£201,000 x 30%).
Controlled foreign company
Date Inc is a controlled foreign company. The profits of such a company are normally attributed to its UK resident
shareholders such that they are subject to UK corporation tax.
However, none of the profits of Date Inc will be attributed to Nikau Ltd because Date Inc distributes more than 90%
(£115,000/£120,000 = 95·8%) of its chargeable profits to its shareholders.
Dividend income
Nikau Ltd is a UK resident company and is therefore subject to corporation tax on its worldwide income.
The dividend income will be grossed up in respect of the withholding tax giving rise to taxable income of £39,792
(£38,200 x 100/96). There is no underlying tax as there are no taxes on income or capital profits in Palladia.
The corporation tax of £11,938 (£39,792 x 30%) will be reduced by unilateral double tax relief equal to the withholding
tax suffered of £1,592 (£39,792 x 4%) resulting in corporation tax due of £10,346 (£11,938 – £1,592).

(d) Comment on THREE factors other than NPV that the directors of ITL should consider when deciding whether

to manufacture the Snowballer. (3 marks)

正确答案:
(d) Factors that should be considered by the directors of ITL include:
(i) The cash flows are estimated. How accurate they are requires detailed consideration.
(ii) The cost of capital used by the finance director might be inappropriate. For example if the Snowballer proposal is less
risky than other projects undertaken by ITL then a lower cost of capital should be used.
(iii) The rate of inflation may vary from the anticipated rate of 4% per annum.
(iv) How strong is the Olympic brand name? The directors are proposing to pay royalties equivalent to 6% of sales revenue
during the six years of the anticipated life of the project. Should they market the Snowballer themselves?
(v) Would competitors enter the market and what would be the likely effect on sales volumes and selling prices?
N.B: Only three factors were required.

(b) A sale of industrial equipment to Deakin Co in May 2005 resulted in a loss on disposal of $0·3 million that has

been separately disclosed on the face of the income statement. The equipment cost $1·2 million when it was

purchased in April 1996 and was being depreciated on a straight-line basis over 20 years. (6 marks)

Required:

For each of the above issues:

(i) comment on the matters that you should consider; and

(ii) state the audit evidence that you should expect to find,

in undertaking your review of the audit working papers and financial statements of Keffler Co for the year ended

31 March 2006.

NOTE: The mark allocation is shown against each of the three issues.

正确答案:
(b) Sale of industrial equipment
(i) Matters
■ The industrial equipment was in use for nine years (from April 1996) and would have had a carrying value of
$660,000 at 31 March 2005 (11/20 × $1·2m – assuming nil residual value and a full year’s depreciation charge
in the year of acquisition and none in the year of disposal). Disposal proceeds were therefore only $360,000.
■ The $0·3m loss represents 15% of PBT (for the year to 31 March 2006) and is therefore material. The equipment
was material to the balance sheet at 31 March 2005 representing 2·6% of total assets ($0·66/$25·7 × 100).
■ Separate disclosure, of a material loss on disposal, on the face of the income statement is in accordance with
IAS 16 ‘Property, Plant and Equipment’. However, in accordance with IAS 1 ‘Presentation of Financial Statements’,
it should not be captioned in any way that might suggest that it is not part of normal operating activities (i.e. not
‘extraordinary’, ‘exceptional’, etc).
Tutorial note: However, note that if there is a prior period error to be accounted for (see later), there would be
no impact on the current period income statement requiring consideration of any disclosure.
■ The reason for the sale. For example, whether the equipment was:
– surplus to operating requirements (i.e. not being replaced); or
– being replaced with newer equipment (thereby contributing to the $8·1m increase (33·8 – 25·7) in total
assets).
■ The reason for the loss on sale. For example, whether:
– the sale was at an under-value (e.g. to a related party);
– the equipment had a bad maintenance history (or was otherwise impaired);
– the useful life of the equipment is less than 20 years;
– there is any deferred consideration not yet recorded;
– any non-cash disposal proceeds have been overlooked (e.g. if another asset was acquired in a part-exchange).
■ If the useful life was less than 20 years, tangible non-current assets may be materially overstated in respect of other
items of equipment that are still in use and being depreciated on the same basis.
■ If the sale was to a related party then additional disclosure should be required in a note to the financial statements
for the year to 31 March 2006 (IAS 24 ‘Related Party Disclosures’).
Tutorial note: Since there are no specific pointers to a related party transaction (RPT), this point is not expanded
on.
■ Whether the sale was identified in the prior year audit’s post balance sheet event review. If so:
– the disclosure made in the prior year’s financial statements (IAS 10 ‘Events After the Balance Sheet Date’);
– whether an impairment loss was recognised at 31 March 2005.
■ If not, and the equipment was impaired at 31 March 2005, a prior period error should be accounted for (IAS 8
‘Accounting Policies, Changes in Accounting Estimates and Errors’). An impairment loss of $0·3m would have
been material to prior year profit (12·5%).
Tutorial note: Unless this was a RPT or the impairment arose after 31 March 2005 a prior period adjustment
should be made.
■ Failure to account for a prior period error (if any) would result in modification of the audit opinion ‘except for’ noncompliance
with IAS 8 (in the current year) and IAS 36 (in the prior period).
(ii) Audit evidence
■ Carrying amount ($0·66m as above) agreed to the non-current asset register balances at 31 March 2005 and
recalculation of the loss on disposal.
■ Cost and accumulated depreciation removed from the asset register in the year to 31 March 2006.
■ Receipt of proceeds per cash book agreed to bank statement.
■ Sales invoice transferring title to Deakin.
■ A review of maintenance expenses and records (e.g. to confirm reason for loss on sale).
■ Post balance sheet event review on prior year audit working papers file.
■ Management representation confirming that Deakin is not a related party (provided that there is no evidence to
suggest otherwise).

声明:本文内容由互联网用户自发贡献自行上传,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任。如果您发现有涉嫌版权的内容,欢迎发送邮件至:contact@51tk.com 进行举报,并提供相关证据,工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。