Actuarial Outpost
Go Back   Actuarial Outpost > Exams - Please Limit Discussion to Exam-Related Topics > SoA > Modules 6-8
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Thread Tools Search this Thread Display Modes
Old 08-25-2014, 09:47 PM
ezzy ezzy is offline
Join Date: Jun 2013
Studying for MLC
Posts: 10
Default BBA Task 2

Hi All -

I'm not sure I'm doing the CTE() portion of Task 2 right...wanted to hear your ideas.

To assess what the price would be at a given profit level, and a given CTE level, say profit of 10% and CTE(95), I was doing a Goal-Seek on cell H11 of the Summary Statistics section. H11 is calculating the % of scenarios below the target profit threshold (10%), so to calculate CTE(95), I'd do a goal seek, where I'm setting H11 to 5% (because CTE(95) indicates that 5% of scenarios would be below the target level), by changing the Price cell...

Is that overcomplicating things? Should we simply be setting the goal-seek on the profit column, in column I, setting equal to the profit level we want to achieve, next to the related CTE options?

Any help is appreciated!
Reply With Quote

bba, fa bba task 2

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT -4. The time now is 04:29 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.12378 seconds with 9 queries