职业发展的迷茫时期，跪求建议~

qqyang

911110000 发表于 2013-10-9 11:43
I cannot type Chinese at the moment, sorry

Relax, check what I am replying,

Just an academic discussion, don't be too serious.

You can question whether MA had provided the right figure, but regarding to the "right" analysis, there is no "right" or "wrong".  The analysis is about estimation, is about forecasting.  Did you learn about Audit module in CA, all engagement relating to estimation or forecasting is "no assurance"; "Review of estimation or forecasting" is "limited assurance"; which means all those "analysis" would be based on certain modelling built on top of a lot of assumptions and info provided by the other parties.  

很明显

足迹问前程， 唯有水电工！

Aries2012

jacey 发表于 2013-10-9 11:29
楼主，建议文章要切合题目。清晰说明你的问题，大家好给你解答。。。

52楼有发问啊~~

等我去改改字体，弄大点，醒目点~~

911110000

qqyang 发表于 2013-10-9 12:03
Just an academic discussion, don't be too serious.

You can question whether MA had provided the r ...

yes, not like black/white

CA AAA changed this year, I am not quite good at AAA, but rules are changed re assuance about Prospective FS,

refer to textbook

In Australia, ASAE 3450 Assurance Engagements involving Corporate Fundraisings and/or Prospective Financial
Information (ASAE 3450), which is effective for engagements commencing on or after 1 July 2013, deals with
engagements that involve corporate fundraisings and/or prospective financial information.
Despite apparent similarities in the topic titles in ASAE 3450 and ISAE 3400, ASAE 3450 has a much broader
scope than ISAE 3400. It also contains mandatory requirements for the assurance practitioner that ISAE 3400
does not. Accordingly, ASAE 3450 states that there is no equivalent ISAE issued by the IAASB.
Level of assurance – under ASAE 3450 para. 8, an assurance practitioner can provide the following types
of assurance on the different types of financial information:
–– Historical financial information – limited or reasonable assurance
–– Pro forma historical financial information – limited or reasonable assurance
–– Prospective financial information assumptions – limited assurance
–– Prospective financial information basis of preparation – limited or reasonable assurance
–– Prospective financial information (overall) – limited assurance

I am very confused about this parts...according to ISAE, cannot provide assuance on PROJECTION, only provide assuance for FORECAST, but according to ASAE, what is "Prospective"?

qqyang

911110000 发表于 2013-10-9 12:20
yes, not like black/white

CA AAA changed this year, I am not quite good at AAA, but rules are cha ...

I seriously doubt Big4 would stamp on prospective financial information without putting a lengthy disclaim before the actual opinion.  The fee can't even cover the increase insurance.

911110000

qqyang 发表于 2013-10-9 12:26
I seriously doubt Big4 would stamp on prospective financial information without putting a lengthy  ...

seriously, what is different between forecase,projection and prospective?

qqyang

911110000 发表于 2013-10-9 12:30
seriously, what is different between forecase,projection and prospective?

Just googled it:
http://www.cpanet.com/cpa_forum/forum_posts.asp?TID=27997

911110000

qqyang 发表于 2013-10-9 12:34
Just googled it:
http://www.cpanet.com/cpa_forum/forum_posts.asp?TID=27997

thanks anyway, i understand f and projection, mainly about time different, and can be find in text book.

what is different between "f and projection" an "prospetive"...anyway, WAI LOU LE...sorry LZ

qqyang

911110000 发表于 2013-10-9 12:39
thanks anyway, i understand f and projection, mainly about time different, and can be find in text ...

Prospective always comes with Projection as its attribute,

Aries2012

有没有哪位足友有类似的经历可以指点迷津啊~~分分送上！！

枫林

天道酬勤，楼主的成功是必然的。

请问Excel要怎么学啊？

zliybyc1

911110000 发表于 2013-10-9 12:43
I cannot type Chinese at the moment, sorry

Relax, check what I am replying,

I didn't say LZ is totally wrong. Actually I planned to answer your question after I finish my CPA exam this semester.
But seems others provided some very good points to you.

911110000

zliybyc1 发表于 2013-10-9 21:23
I didn't say LZ is totally wrong. Actually I planned to answer your question after I finish my CPA ...

"I didn't say LZ is totally wrong" really??


"企业也是成王败寇 破产了什么理由都来扣啊

我们还年轻 不管什么事情都不要轻易下结论哈"


first of all, is it really "破产"?

second, the answer, well, not black or write, not a big deal, I even dont care...anyway, good luck for your CPA

zliybyc1

911110000 发表于 2013-10-10 08:27
"I didn't say LZ is totally wrong" really??

"企业也是成王败寇 破产了什么理由都来扣啊
这句是我自己对这类讨论的感受，没有道理么？
不想玩关于“破产”这个词的文字游戏
考完试后还是会给你回复的 不管你care不care
谢谢～ 我会好运的

zliybyc1

Aries2012 发表于 2013-10-9 22:02
有没有哪位足友有类似的经历可以指点迷津啊~~分分送上！！

放平常心
很多老板尤其是oz有时候不大喜欢太进取的员工

Aries2012

枫林 发表于 2013-10-9 22:14
天道酬勤，楼主的成功是必然的。

请问Excel要怎么学啊？

我看书，论坛还有youtube~

www.excelhome.net, 里面有个叫做佛山小老鼠的老师写的东西很不错~

Aries2012

zliybyc1 发表于 2013-10-10 09:50
放平常心
很多老板尤其是oz有时候不大喜欢太进取的员工

我其实也就是想上班有趣点，工资高点嘛~(paopaobing(81))

枫林

Aries2012 发表于 2013-10-10 10:05
我看书，论坛还有youtube~

www.excelhome.net, 里面有个叫做佛山小老鼠的老师写的东西很不错~ ...

太感谢了

zliybyc1

Aries2012 发表于 2013-10-10 10:14
我其实也就是想上班有趣点，工资高点嘛~

Review的时候都写上
下次找工作 找个好老板!

Aries2012

枫林 发表于 2013-10-10 11:09
太感谢了

不客气~你如果有任何EXCEL的需要用公式解决的问题，可以发消息给我~ 不过LZ不能保证一定可以解决问题

LZ过往帮朋友解决了疑难杂症的记录还是不错的~

zliybyc1

Aries2012 发表于 2013-10-10 11:41
不客气~你如果有任何EXCEL的需要用公式解决的问题，可以发消息给我~ 不过LZ不能保证一定可以 ...

我从系统里dump了一份 inventory record 到excel里
各种乱七八糟 但我只需要前两栏的信息和最靠右一栏的数字
前两栏好办，
但是最右边的数字，不知道因为什么原因，处在不同的column，
column Q,T,V,O 等等都有
但都确定是在最右边一栏。。。
有没有什么公式可以自动把所有最右边的数字都fit到指定的一个column？
还是要macro才能解决？
现行谢过。

Aries2012

zliybyc1 发表于 2013-10-10 14:09
我从系统里dump了一份 inventory record 到excel里
各种乱七八糟 但我只需要前两栏的信息和最靠右一栏的 ...

=LOOKUP(1,0/(A1:AA1<>""),A1:AA1)

有帮助的话赏点分哈

zliybyc1

Aries2012 发表于 2013-10-10 14:14
=LOOKUP(1,0/(A1:AA1""),A1:AA1)

有帮助的话赏点分哈

不行哦 都是0

douya625

看得出楼主是个努力的好孩子

sorga

楼主牛人，能吃苦执行力强。找工作运气差了点。加油哈

Brucehome

Aries2012 发表于 2013-10-10 10:05
我看书，论坛还有youtube~

www.excelhome.net, 里面有个叫做佛山小老鼠的老师写的东西很不错~ ...

嗯，

佛山小老鼠的那个VBA其实写的不好，是文章的思路不好。有机会你回国或者叫家里人帮你买本就是excelhome的牛人斑竹出的“别怕，excel VBA其实很简单”，做入门到中级的进阶石挺不错的。

VBA还是要实战，因为我们都不是写程序的，是工作中遇到问题去解决，所以google和宏录制是必然的左右护法