Posts

Calculate relevant summary statistics including the mean, standard deviation, minimum, maximum, median.

/in /by

ACTL2111/5102 2020 Term 2 Excel Assignment
Deadline: 3 August 2020 (Monday of Week 10) at 5pm sharp
Jackson is a fresh actuarial graduate who just started his rst full time job in a reputable insurance
company in Sydney on 3 January 2020. Upon the start of his job, Jackson also decided to make an
investment to accumulate a deposit to purchase his rst home in 10 years time. As a junior actuary who
passed Part I and Part II exams, Jackson has a personal preference of passive investment strategies,
that is, investments consisting of fund tracking well-diversied portfolios and government bonds only.
To make such important investment decision, he consulted a bank regarding his investment strategy.
You, a junior analyst in the bank, have received the case from your supervisor, with the following
information.
a. Salary:
(i) Jackson’s annual starting salary is $55,000 (after income tax) and it will increase by 4.5%
every year at the beginning of each year.
(ii) There are three actuarial exams Jackson will take. His salary will increase by 20% (i.e. 15.5%
extra compared to the regular increase described in part (i) above) at the beginning of the
year after he passes an exam. Since he is working full time, he will take only one exam every
year and his chance of passing each exam is 35%, independent of his performance in previous
exams (if there is any).
(iii) He receives his salary at the end of every fortnight on Friday, i.e. the rst payment will be
on 17 January 2020.
b. Savings: Jackson is very keen on saving as much as possible for his deposit, so he has decided that
each fortnight when he receives his salary, he will put 30% of it to his investment portfolio.
c. Investment options: After a meeting with Jackson, your supervisor has shortlisted the following
two investments for Jackson:
 Option 1: 75% Vanguard Australian Shares Index Fund; 25% government (zero-coupon) bonds
maturing on 31 December 2029,
 Option 2: 50% Vanguard Australian Shares Index Fund; 50% government (zero-coupon) bonds
maturing on 31 December 2029.
For example, in Option 2, Jackson will invest 15% of his total salary in government bonds and the
other 15% in the index fund every fortnight. The index fund does not pay dividends.
d. Bond return: Your colleague in the interest rate modelling team has given you the current spot
yield curve using the dynamic Nelson-Siegel model, where the (annual eective)  -year spot yield
at time t is it;% with it; given by
it; = 1;t + 2;t
1 􀀀 e􀀀


+ 3;t
1 􀀀 e􀀀

􀀀 e􀀀

; (1)
where  = 0:6150 is a parameter. Here both t and  are measured in years, where t is the amount
of time from 3 January 2020 (17th of Jan is t = 1=26, and 31st of Jan is t = 2=26 etc.) and  is
the remaining time (counting from time t) until maturity. It is assumed that each year has exactly
52 weeks. (Note that it; will not be known before time t, and therefore from time 0’s perspective
it is modelled as a random variable.) The starting values of the ’s are given by
1;0 = 3:0
2;0 = 􀀀 1:5;
3;0 = 􀀀 2;
1
and then for subsequent values of t = 1
26 ; 2
26 ; :::; 925
26 ; 10 they satisfy the recursive relationship
1;t = 0:3 + 0:85 1;t􀀀 1
26
+ “1;t:
2;t = 􀀀 0:25 + 0:65 2;t􀀀 1
26
􀀀 “1;t;
3;t = 􀀀 0:8 + 0:6 3;t􀀀 1
26
+ “2;t;
with
“1;t  N(0; 0:10);
“2;t  N(0; 0:19):
Here all “j;t’s are assumed to be independent (j = 1; 2 and t = 1
26 ; 2
26 ; :::; 925
26 ; 10).
*Note that negative interest rates are possible but rare, due to the dynamics of the ’s.
e. Return for the fund: the eective return rate for period [t; t + 1
26 ] is rt% with rt given by
it;1 + 5:5
26
+ Xt (2)
with
Xt  N(0; 9);
where t is the beginning of a fortnight and the random variables Xt’s are independent.
f. Costs and fees and others: At this stage, your supervisor is going to present the two products
(described in c.) in preliminary form to Jackson so you do not need to consider the details such as
costs, fees, taxes on investment and reinvestment of the bond coupons.
You need to perform the following analysis for your supervisor to present to Jackson:
1. Project Jackson’s salary payments over the next 10 years (from the rst payment on 17 January
2020 to the last payment in 2029), under the following scenarios:
(i) He passes the three exams in 2022, 2025 and 2028 (average scenario);
(ii) He passes the three exams in 2020, 2021 and 2022 (best scenario);
(iii) He passes the three exams in 2024, 2028 and does not pass the last exam before 2030 (bad
scenario).
Also calculate the probability of each of the scenarios (i)-(iii).
2. Interpret the terms in (1). Via simulation, plot the spot yield curves at 1 January 2027 and 1
January 2029 respectively, for 0    10, i.e. the yield curve for the next 10 years starting at
1 January 2027 and another yield curve for the next 10 years starting at 1 January 2029. (Hint:
You only need to simulate one trajectory when plotting the two yield curves, and the yield
curves are dependent.) Explain the shape of the curves. Also interpret the formula (2).
3. For each of the options in the average scenario, run 100 simulations on the terminal value of
Jackson’s investments and calculate relevant summary statistics including the mean, standard
deviation, minimum, maximum, median. Plot the histograms for the terminal values of the two
options in the same graph.
*Hint: You may want to create a new worksheet and use VBA to copy your answer in each
simulation to the new worksheet.
2
4. Provide a brief recommendation to Jackson based on your analysis (max. 250 words). This
should be placed in a separate sheet within the same EXCEL le.
Please note all workings used to arrive at any conclusions must be presented in your
workbook in a logical and coherent manner. This includes any macros you write
and excel formulas you have used. Any macros and formulas used must work when
the marker runs them. You will be marked on your presentation and readability.
Assignment submission procedure
Your assignment must be uploaded as a unique EXCEL document. As long as the due date is still
future, you can resubmit your work; the previous version of your assignment will be replaced by the
new version.
Assignments must be submitted via the Turnitin submission box that is available on the course Moodle
website. Turnitin reports on any similarities between their own cohort’s assignments, and also with
regard to other sources (such as the internet or all assignments submitted all around the world via
Turnitin). More information is available at: [click]. Please read this page, as we will assume that you
are familiar with its content.
Once you have submitted your document via Turnitin, you may not be able to view it on screen
within the submission system as the system may not support viewing Excel le. This will not be
a problem because the grader will download your Excel le for grading purposes. After submission,
please download the le from the system to make sure that (1) it is the right le (as students usually
have saved multiple versions of the le in their own computer); and (2) you can view the downloaded
le in your computer (in case the le is corrupted possibly due to e.g. internet disruption during le
upload).
Please note that the School of Risk and Actuarial Studies will apply the following policy on late
assignments. A penalty of 25% of the mark the student would otherwise have obtained, for each
full (or part) day of lateness (e.g., 0 day 1 minute = 25% penalty, 2 days 21 hours = 75% penalty).
Students who are late must submit their assessment item to the LIC via e-mail. The LIC will then
upload documents to the relevant submission boxes. The date and time of reception of the e-mail
determines the submission time for the purposes of calculating the penalty.
Students are reminded of the risk that technical issues may delay or even prevent their submission
(such as internet connection and/or computer breakdowns). Students should allow enough time
(at least 24 hours is recommended) between their submission and the due time. The
Turnitin module will not let you submit a late report. No paper copy will be either accepted or
graded.
In case of a technical problem, the full document must be submitted to the LIC before the due time
by e-mail, with explanations about why the student was not able to submit on time. In principle,
this assignment will not be marked. It is only in exceptional circumstances where the assignment was
submitted before the due time by e-mail that it may be markedand this only if a valid reason is
established (and the LIC has the discretion in deciding whether a given reason is valid).
Plagiarism awareness
Students are reminded that the work they submit must be their own. While we have no problem with
students discussing assignment problems if they wish, the material students submit for assessment
must be their own. In particular, this means that any code you present are from your own computer,
which you yourself developed, without any reference to any other student’s work.
While some small elements of code are likely to be similar, big patches of identical code (even with
dierent variable names, layout, or commentsTurnitin picks this up) will be considered as plagiarism.
3
The best strategy to avoid any problem is not to share bits and pieces of code with other student
outside your group.
Note however that you are allowed to use any EXCEL les that were made available during the course
(either from the lectures or developed in the lab tutorials). You don’t need to reference them formally,
and this will not be considered as plagiarism.
Students should make sure they understand what plagiarism iscases of plagiarism have a very high
probability of being discovered. For issues of collective work, having dierent persons marking the
assignment does not decrease this probability. For more information on plagiarism, see [click].
Students may consult the Write well; Learn deeply” website [click] and consult the resources provided
there. In particular, all students should do the quiz about plagiarism to make sure they know how to
avoid any issue. For instance, did you know that sharing any part of your work with other students
(outside your group) before the deadline is already considered as plagiarism? 1
Assessment criteria
Please see the le Rubric”.
1Yes, that’s right, just sending it, even if the third party promises not to copy, is already plagiarism in the UNSW
policy!
4

Explain why you think Vladek is suffering from PTSD?

/in /by

Discuss the theme of PTSD (or traumatic memory) in Maus. Explain why you think Vladek is suffering from PTSD?
write a formal literary essay (including a unique title, an introductory paragraph with a thesis statement, body paragraphs with quotations/evidence, conclusion, & Works Cited page in MLA style). A minimum of 2 research sources should be used in this essay.

Identifying the areas where you do not accept their proposed terms and your counter-proposal.

/in /by

MSc Entrepreneurship and Innovation Management

BEMM386 Business Law and Mitigating Risk

Assessment: Summative assessment, Risk Audit and Commercial Scenario

% of Credit: 100%

Word Count:  3,500 words ± 10% (The word count is excluding the cover page, table of contents, appendices*, reference section, and signed plagiarism declaration)

*(Appendices must be appropriate and utilised within the main body of text or will not be considered for marking purposes).

The word count should be split between the 2 Parts, approximately equally.

Individual Risk audit and commercial scenario

During the module you will hear about a range of legal and commercial risk factors you will need to navigate when setting up, growing and maturing a business.

Your task in this assessment is to respond to a scenario based on what you have learned.

We expect you to explore literature to identify important factors that may determine risk and outcomes.

This should be supported predominantly by your review of literature (see the suggested reading on ELE).

Assignment Brief and Structure

Part 1 Risk Audit. Setting up your own business. You have a product or service past development stage and are ready to go to market.

  • What legal and commercial risk factors have you already considered and taken up to this point and what will you need to consider now to set up the business formally?
  • Consider the legal vehicle you will use and why.
  • What legal agreements will you need in place?
  • What Intellectual Property sits within the business and how have you protected it?

Part 2 Commercial Scenario. Based upon the Commercial Scenario on the next page prepare the following:

  • An informal set of Heads of Agreement/ Memorandum of Understanding. In bullet point format write:
    1. the key commercial and legal terms (the concepts) you want to include;
    2. any changes you want to negotiate to their proposed terms.

You do not need to observe any legal formalities for the agreement, this is to test your commercial awareness of how legal issues affect business transactions and your ability to identify risks and mitigate them.

  • Include a covering email to the other party identifying the areas where you do not accept their proposed terms and your counter-proposal. Remember, this is a negotiation, you want the contract but you also want to protect your business from major risks and financial failure.
  • Finally, briefly explain your reasoning for including the terms chosen in Part 2 (a) i. above and other major risks that this contract could pose to your business and how you might mitigate them.

Commercial Scenario:

You own the Good Bake with your co-founder Jo, it has become a well known artisan baked goods retailer which you have built up a strong and loyal following for over 3 years.

Having trained as a pastry chef in Paris you have developed your own secret recipes and processes in the production of some of the more innovative business products.

All ingredients are sourced at a premium locally, are organic and with high ethical standards so goods are sold at premium prices which your retail customers are happy to pay.

The business has expanded in to 3 city centre retail premises in the region, one of which contains the kitchen space for production. The business has 12 employees which are a mixture of part-time, full-time and casual.

Approximately 80% of revenue comes from retail sales in-store, 20% is derived from wholesale deliveries to restaurants, cafes and hotels in the local area but you and Jo have identified this as a huge growth market.

The business spends most of its gross income on supplies (ingredients, packaging, food labelling etc.), rent, payroll, and utilities. Gross income is around £900 per day. Costs are around £600 per day leaving a pre-tax profit of £300 per day.

You are approached by a luxury boutique hotel chain White Noise, who want The Good Bake to supply baked products fresh each morning to their hotels within a radius of 100km of your kitchen.

If things go well there is potential to expand nationally and subsequently internationally to the chain by exporting frozen part-baked goods for finishing locally within White Noise hotels using The Good Bake branding and logo.

In order to fulfil the contract, The Good Bake will need to expand production capacity by taking on new commercial kitchens and an additional 4 employees as well as a regulatory expert on food labelling, packaging and health & safety for the 4 sites. You will also need to lease a new delivery vehicle or find a distribution company to deliver for you.

White Noise have e-mailed you their proposed commercial terms below and have asked you to produce a heads of agreement which if approved will form the basis for a formal Supply of Goods contract.

  • The Good Bake shall produce and make available a minimum of 30 units per day to White Noise exclusively.
  • No minimum order quantity from White Noise.
  • Delivery to 5 x White Noise premises each day by 6.30am. Timing to be of the essence.
  • The Good Bake will be subject to a minimum contract term of 12 months.
  • White Noise reserve the right to terminate the contract at any time upon 3 months notice or immediately if The Good Bake breaches any of the terms.
  • Unit prices to be fixed at 50% of The Good Bakes current retail shop prices for the initial term of the agreement with no ability to increase.
  • Upon termination The Good Bake must deliver to White Noise their secret recipe and processes.

Conclude the case study with a statement of how personal traits, skills, motivations, and experiences that you possess might be helpful in pursuing a career as an addiction

/in , /by

COURSE OF TREATMENT
• Current level of treatment (as defined in Week 4 by the American Society of Addiction
Medicine’s Patient Placement Criteria [PPC])
• Projected PPC level(s) of treatment after discharge from residential treatment over the
next 12 months and an explanation of why this level(s) would be effective
• Projected levels of treatment over next 12 months
• Response to treatment
• Prognosis for response to treatment over next 12 months
DISCHARGE PLAN
• Summary of treatment recommendations over next 12 months (as reflected in treatment
plan)
REFLECTION ON PERSONAL MISSION STATEMENT
• Conclude the case study with a statement of how personal traits, skills, motivations, and
experiences that you possess might be helpful in pursuing a career as an addiction
counselor. How will these factors contribute to your ability to maintain self-awareness
and a healthy work/life balance?

What are the main differences between Beccaia’s and Lombroso’s explanations of the reasons people commit crimes?

/in /by

The study of modern European and  American ideas about crime and justice begins with the radical new ideas of the Age of Enlightenment.  How do these  new ideas differ from the views of crime and punishment held by the previous generations?

What are the main differences between Beccaia’s and Lombroso’s explanations of the reasons people commit crimes? How do these explanations compare and contrast with everything that you have learned during your undergraduate studies? Provide at least two examples to illustrate your point of view.

The end of 19th century brought about a new interest in juvenile delinquency. Summarize the most important findings introduced by Shaw ad McKay while focusing on the following question: can we apply their findings to explain the crime situation in the city of Chicago in the 21st century? Provide some specific examples, utilizing statistics about crime spikes in Chicago in the last decade.

The sociology of law views the law as a product of social forces. Identify at least 3 different theories about how societies develop and create their legal standards, while addressing the following question: is our current legal system, in the United States, a product of any of the theories that you  have identified?

What were the extraordinary changes in the nature of the law that took place during Holme’s time on the bench? Do you see any similarities to our times?  If yes, provide some examples, if not explain why not.

 

Highlight common points and differences between the two examples and if these adverts can be considered successful based on the post-feminist theories.

/in /by

(More details and citations in the attachment)
Through the two main examples I would like them to be critically analysed with related theories of post-feminist advertising. The first example is on the Dior fall 2017 campaign and its big statement, the “we should all be feminist” T-shirt. The Artistic Director shifted Dior from being feminine to feminist. It is possible to see this change from Jennifer Lawrence’s photoshoot (see image) analysing the posing and the way she is dressed, very different from the classic Dior style. Fashion has been highly influenced after this feminist campaign from the French brand. With this first example, at least the theory from Ros Gill (chapter 3 of Gender and the media) has to be used to critically analyse it.
The second example is about Always #LikeAGirl 2014 video campaign. In here as well, analyse the video in its content and message, pointing out at the meaning of doing something “like a girl” another statement, a bit more subtle than Dior’s one. In the second example, use at least Ros Gill theories for critically analyse it.
In general try to use at least 2/3 of the references in bold, but feel free to add others if more relevant. There is no limit to online sources, just do not abuse it.
To conclude, highlight common points and differences between the two examples and if these adverts can be considered successful based on the post-feminist theories.

Describe some of the rights of the accused found in the Bill of Rights

/in /by

Answer either of the following questions:
Describe some of the rights of the accused found in the Bill of Rights. Specifically, discuss the exclusionary rule, Miranda rights, and double jeopardy. In your answer, be sure to define each term, identify its support in the Constitution and in Supreme Court cases, and discuss why the rights of the accused are so essential to due process of law.
Many advances in civil rights have been accomplished through federal legislation. Describe the different parts of the Civil Rights Act of 1964 and the Voting Rights Act of 1965. What have these two laws accomplished?
Instructions:
Critical thought is important! You should aim for about a page, single-spaced. You shouldn’t need to do outside research, but if you do cite your sources according to Chicago citation format

Examine ideas in terms of the history of stigma of mental illness. How it does present a barrier to care?

/in /by

The essay is in relation to the stigma associated with mental health and illness often being called a barrier to care. This assessment is asking to examine ideas in terms of the history of stigma of mental illness. How it does present a barrier to care? How it is this being overcome in the Australian perspectives? Is the work around stigma reduction effective?

References must be the current edition.

Provide your friend with six key branding strategies to ensure your friend’s local business can maintain market share while competing with Domino’s Pizza, the global brand.

/in /by

Instructions:

You are required to answer BOTH questions.  The word limit[1] for each question is 1,000 words.

Question 1

Using B2B (business-to-business) brand equity theories and concepts, evaluate the extent to which you agree or disagree with the following quote:

“Industrial firms that are able to create a trustworthy brand identity for their product or service can achieve the degree of differentiation and reputation that can be the difference between success and failure when serving their B2B (business-to-business) customers”.

 (McQuiston, 2003, p 345)

Question 2

A friend who manages a family owned local pizza parlour is seeking your advice. Apparently, a Domino’s Pizza has moved into the neighbourhood. Provide your friend with six key branding strategies to ensure your friend’s local business can maintain market share while competing with Domino’s Pizza, the global brand.

 

 

 

 

 

 

 

Compare and contrast the different forms of EU law and their operation

/in /by

1. Compare and contrast the different forms of EU law and their operation. Discuss the constitutional issues EU law creates for the UK’s political and legal systems.