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

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows

Thread Tools Search this Thread Display Modes
Old 11-12-2018, 02:59 PM
actuary94 actuary94 is offline
Join Date: Sep 2017
Posts: 7
Question EOM1 - Budget Valuation Detail

Do we need to edit the formulas at all on the "Budget Valuation Detail" sheet?

I cannot figure out why they subtract an extra half year in the "value at 1/1/06" calculation.

It looks like inflation is already being accounted for, but they said MMCL wasn't accounting for inflation... I think they just say that because it was set equal to 0%. Right? I've been staring at this spreadsheet for so long I'm starting to second guess myself.
Reply With Quote
Old 11-27-2018, 05:05 PM
mushibug mushibug is offline
Join Date: Nov 2018
Favorite beer: Anything from Cascade Brewing
Posts: 17

I didn't edit any of the formulas since they all seemed right to me. They subtract the extra half year because they assume that costs are incurred at the midpoint of the year.

So if a cost was incurred in 2006, they assume it happened July 2006, so you need to discount half a year to get to 1/1/2006.
Reply With Quote

budget valuation, eom1, inflation

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 05:40 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, 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.13621 seconds with 11 queries