Assume that your medical expenses in a year are normally distributed with mean $2000 and standard deviation $500. Build an @RISK model in which the output is the amount of money left to you after...

1 answer below »
Assume that your medical expenses in a year are normally distributed with mean $2000 and standard deviation $500. Build an @RISK model in which the output is the amount of money left to you after paying taxes, putting money in an FSA, and paying any extra medical expenses. Experiment with the amount of money put in the FSA, using a RISKSIMTABLE function. b. Rework part a, but this time assume a gamma distribution for your annual medical expenses. Use 16 and 125 as the two parameters of this distribution. These imply the same mean and standard deviation as in part a, but the distribution of medical expenses is now skewed to the right, which is probably more realistic. Using simulation, see whether you should now put more or less money in an FSA than in the symmetric case in part a.
Answered Same DayFeb 05, 2021

Answer To: Assume that your medical expenses in a year are normally distributed with mean $2000 and standard...

Aishwarya answered on Feb 06 2021
141 Votes
Management Report
Financial Analysis
Name | Course Title | Date
Introduction
The purpose of this ana
lysis is to understand how much savings an individual can make after paying for Taxes and medical expenses. These savings then can be used by the individual to make other expenses as well as investments.
For this analysis the medical expenses were assumed to follow normal and gamma distribution with common mean and standard deviation $2000 and $500 respectively. The income of the individual was assumed to be $80,000 which remained fixed. Also the taxes remained fixed at 30% p.a.
There was a proposal to setup a Flexible Savings Account (FSA) in the beginning of the calender year which would support the medical expenses as and when they occurred. So in case the amount of medical expenses exceeded the FSA, the additional amount went form the individuals pockets. However, if the medical expenses were less than FSA then the individual would not get the remaining amount back.
For the purpose of the analysis one simulated various...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here