+1-617-874-1011 (US)
+61-7-5641-0117 (AU)
+44-117-230-1145 (UK)
Live Chat

Finance assignment question 5

You will be required to create a spreadsheet in Microsoft Office (or iWork Numbers).

The spreadsheet will need to take certain input values; in particular a life table and

Financial assumptions and it will output the Expected Present Value of the function

required. The life table input should be able to be entered either as lx values, or qx values. Acceptable ranges for x should be 0-100. The spreadsheet should be able to handle being given a life table that starts at any age between and including 0 and 99.

The spreadsheet should be well constructed and properly documented. Guidelines for good spreadsheet construction are available in this document (note that this document goes far beyond what is needed for this project):

The spreadsheet should be able to calculate expected present values as well as variances for:

They should also be able to increase/decrease by a constant compound rate or a fixed monetary amount.

  • A whole life assurance
  • A temporary assurance
  • An endowment assurance
  • A pure endowment

All assurances should be able to be calculated as payable in arrears or death.

The sum assured should be able to increase/decrease by a constant compound rate

or a fixed monetary amount.

The spreadsheet should also calculate; for all the policies given above, the net premium; allowing for premiums either payable annually in advance or mthly in advance, for life or for a certain fixed term (if shorter) or as a single premium.

Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.