New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

5 Pages
ISY00243 Systems Analysis and Design

Task: Task Description   Your task is to give a five (5) minute video presentation to present your solution for 100% Organic Co. to Richard, Ardell and Joe. For the first three (3) minutes ...

Course

ISY00243

Type

Assignment

Subject

Management

University

Southern Cross University

0 Page
Expatriates and Employment Relations in the Context of Global HRM

...

Course

HI5013

Subject

Management

University

Holmes Institute

Season

Spring

55 Pages
MGMT8003 Organisational Behaviour

Answers: The world is facing an issue regarding the survival while competing against each other. This is important enough for managing changes in an effective way.  It is difficult for the man ...

Course

MGMT8003

Type

Assignment

Subject

Management

University

Australian National University

Season

Fall

98 Pages
Comparing of two Models

BSBLDR803 - DEVELOP AND CULTIVAT E COLLABORATIVE PARTNE RSHIPS AND RELATIONSHIPS ASSESSMENT GUIDE ASSESSMENT INFORMATI ON FOR STUDENTS Throughout your training w ...

Course

BSBLDR803

Subject

Management

University

Mentor Education

Season

Spring

ACCT3610 Business Analysis and Valuation

Question

Answered

Question:

The Problem

A TSB (Tax Saver Benefit plan) allows you to put money (to a maximum of euro) into an account at the beginning of the calendar year. The money in this account may only be used for paying medical expenses. The amount that you put into the account is tax deductible. As you pay medical expenses during the year, you are reimbursed by the administrator of the TSB, until the TSB account is exhausted. The catch is, however, that any amount left in the TSB at the end of the year is lost to you and will be transferred to the government.

You estimate that your medical expenses for the next year will be any amount between euro and  euro and all amounts are equally likely. The federal income tax rate is. Assume your annual salary is euro before tax. You would like to decide how much money to put into your TSB account at the start of the next year. You want to look at your disposable income (after paying taxes and medical expenses).

The Task

The assignment requires you to model the situation regarding a tax saver benefit plan in Excel and implement the risk analysis methods such as sensitivity analysis and simulation. Please hand in a report that answers questions (a) through (g) below. You can discuss the task with members of your team, and even help each other with the technical analysis, but you should write the individual report on your own. A small part of the overall grade is allocated to presentation and adherence to submission guidelines. 
 
(a) You start your analysis by assuming that the average case for your medical expenses will happen. In this case, what is the optimal amount to put into the TBS? Explain why this is optimal. What is your disposable income?

Tip: Do not take uncertainty into account as of yet (do not start @Risk). Just assume medical expenses = average medical expenses and assume that this is known to you when you decide how much to put into the TSB. Note that the medical expenses to pay after TSB exist only when the total medical expenses are more than what you have put into the TSB.

(b) You recognize, however, that there is some uncertainty involved in the problem. Perform a scenario analysis (i.e., finding the best- and worst-case disposable incomes) and sensitivity analysis (with steps euro), given your plan to put the optimal amount from Question (a) in the TSB account. Discuss your results.

Tip: Do not start @Risk yet. Use a one-way data table for the sensitivity analysis and interpret your results.

(c) Set up a simulation model and analyze the results (given your plan to put the optimal amount from Question (a) in the account). Analyze the results and compare them to the outcome from Questions (a) and (b). What is the probability that your disposable income will be lower than euro? What is the probability that it will be higher than euro?

(d) Given your decision to put the optimal amount from Question (a) in the account, analyse what the average cost or benefit is for the government of introducing this TSB account (compared to not having the account).

Tip: The government’s cost or benefit is your benefit or cost, respectively.

(e) You wonder whether it would be better to put in a different amount. You want to do the risk analysis for amounts between, with increments of. (do this in one spreadsheet). Assume that your risk measure is the  percentile. Analyse and discuss the results (Hint: (i) prepare a mean-risk graph in which the expected disposable income is presented on the X-axis and the risk measure on the Y-axis, (ii) consider the distribution of the disposable income for each setting and explain the form). Is the optimal TSB amount different from what you originally thought (see Question (a)) and why (not)?

Tip: You can use the RiskMean() and RiskPercentile() functions.

(f) You are wondering about your assumption that all values for the medical costs are equally likely between. You now think that a better assumption is to say that the most likely value is €5,000, and the further you go to the extremes, the less likely these values are. Are the results from the previous scenario and sensitivity analysis still valid? Discuss why (not). Repeat your simulation analysis (for TSB levels between and with this new assumption. Discuss the differences that you observe compared to the results in Question (e). If you put euro in your TSB account, is the average disposable income in this case higher or lower than under the previous assumption (all outcomes equally likely) and explain why. 

(g) Go back to your assumption that expenses between and are equally likely. If the tax rate will go up, will your optimum TSB level go up or down? Analyze the situation with a tax rate of 65% and explain the influence of the tax rate.

ACCT3610 Business Analysis and Valuation

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

22 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com is committed to offer reliable thesis writing help in more than 100 subjects. Being a reputable thesis writing service provider, we always think about our customers. Thus, we provide cheap thesis writing services by maintaining the quality of help solutions. With an efficient team of PhD qualified thesis writers, we provide highest quality thesis paper help but at reasonable prices. This is why students from all over USA prefer our services over other service providers.

More ACCT3610 ACCT3610 Business Analysis and Valuation: Questions & Answers

Q
icon

We aren't endorsed by this University

ISY00243 Systems Analysis and Design

Task: Task Description   Your task is to give a five (5) minute video presentation to present your solution for 100% Organic Co. to Richard, Ardell and Joe. For the first three (3) minutes, you will “pitch” your recommended solution to 100% Organic Co. using the WHAC method.& ...

View Answer
Q
icon

We aren't endorsed by this University

Expatriates and Employment Relations in the Context of Global HRM

...

View Answer
Q
icon

We aren't endorsed by this University

MGMT8003 Organisational Behaviour

Answers: The world is facing an issue regarding the survival while competing against each other. This is important enough for managing changes in an effective way.  It is difficult for the managers to implement the change and to focus on customer satisfaction. Companies need to take care of ...

View Answer
Q
icon

We aren't endorsed by this University

Comparing of two Models

BSBLDR803 - DEVELOP AND CULTIVAT E COLLABORATIVE PARTNE RSHIPS AND RELATIONSHIPS ASSESSMENT GUIDE ASSESSMENT INFORMATI ON FOR STUDENTS Throughout your training we are committed to your learning by providing a training and assessment framework that ensures the ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?