100000+

Students can't be Wrong!

767452

Orders

4.9/5

Ratings

4981

PhD Experts

# Spreadsheet: Function Of The Spreadsheet Click this icon and make it bookmark in your library to refer it later.GOT IT

## Question:

Give the solution on a separate sheet (labelled ‘Part a’, ‘Part b’, and Part c—‘Part d’ will appear on the ‘Part a’ tab).

spreadsheet should be clearly labelled and easy to understand. Include a description of the function of the spreadsheet. Remember to make sure you clearly identify the ‘inputs’ and ‘outputs’.

### Part A

The following are the steps and inferences from the assignment given.

Probability of S alive is 50% and hence his death probability is 1-50%=50%

Probability that S is alive in year 2 is the probability that he is alive in year 1 and he is alive in year 2. Hence the joint probability is 50%*50% or 0.5^2=25%. Hence the probability of his death in year 2 is 1-25% or 75%. Similarly till year 30

S does not receive any coupon. Hence 0 will year 30. In year 35 assuming he is alive, he gets the principal of 1000,000. The expected value of this is P(alive)*1000,000+P(dead)*0. Take the NPV which is 1000,000/(1+7%)^30 or 93663.

M bond person receives coupons irrespective of S dead or alive. But principal will be received only if S dead. So multiply P(S dead)*expected value of receipt. The coupon paid semi annually @ rate 9.8% is equivalent to an effective annual rate of 10% calculated as (1+9.8%/2)^2-1. Hence every year, M receives 1000,000*10%. Calculate the PV for 35 years comes to 1,388,441

Since SM bond –S bond+M bond the total value is c+d or 1,482,104

Part B is  same as Part A except face value is \$ 1 and hence the investor needs \$ 659 as retirement amount at the end of 35 years. Hence he has to buy 659 bonds

Part B is same as Part A except that face value of the bond is 100 instead of 100,000

OR

### Professional Developers Comprehend Software

Question:Discuss about the professional developers comprehend software? Answer:I have been working in the USA Technologies for nine months now, and it ...

### Rethinking Oil Nationalism

Question:Describe about the Rethinking Oil Nationalism? Answer:1. The engineering discipline that I have chosen is Mechanical Engineering and I have se...

### Advertising: An Integrated Marketing Communication Perspective

Question:Explain about the Advertising for An integrated marketing communication perspective? Answer:Introduction:Social media has become the part of...

### Comprehensive Model Of Interpersonal

Question:Discuss about the Comprehensive Model of Interpersonal.   Answer:Introduction:The meteorological analogy given by Mr. Andy Grove, Cha...

### Critical Review Assignment

In the article, Kohn (2006) has argued that homework is not only needless but also counterproductive for children. The author adopts a contextual review method to pro...

Tourism AustraliaTourism Australia has established 13 offices all around the globe to target 22 of its most advantageous markets. The key strategy behind the adve...

### A Boon For TodayĂ¢â‚¬â„¢s Competent World

THE ERA OF GLOBALIZATIONToday’s world is by and far moving at a jet set speed and an exponential rate towards the horizon of collaborating the whole world i...

### Pain Under Power Or Kindness Under Conscience!

Feelings or No feelingsMilgram’s experiment was a fascinating thing done to a group of people resulting into more fascinating insight into the behaviors, fe...

### Need For The Code Of Ethics For Construction Professionals & Engineers

AbstractEngineers are the pioneer for global development and professionals are catalysts for problem solving but void of any rules, regulations, code of conduct o...

### Motivational Skills In Project Management

QuestionDiscuss about the Motivational Skills in Project Management.  Answer:Introduction:In the present time, the main focus of the project man...

### Singapore Productivity Growth Sluggish

Question:Discuss about the Singapore Productivity Growth Sluggish.  Answer:IntroductionThis essay outlines the different macroeconomic events ...

### Integration And Adoption Of Digital Innovation

The economic conditions are dynamic in nature therefore it is important to keep the track of the digitization and innovation that is happening across ...

### Planning Is Guessing Possible Outcomes

IntroductionPlanning process means to prepare for the future. The future outcomes are determined by the organizational plans of the present (Zwikael & Globers...

### The Logistics Challenges In Transporting The Dragline Excavators

INTRODUCTION  The logistics management is an act of managing the supply chain which involves the transfer of goods as well as services from the poin...

### Essay On Indigenous And Aboriginal Health

IntroductionThe norms of culture have been misunderstood for emotional abuse within the indigenous population. This time it had been the Yorganop group, the agenc...

### Using Levels Of Analysis To Understand The Influence Of Violent Media On Aggression

Introduction  The media has been in a changing and dynamic form ever since the newer technologies have changed the paradigm of thinking (Anderson &a...

### STRIVING FOR EXCELLENCE

"(Name)" is the current principal of my school (School name) with a leadership term of above 30 years. The journey of *--- as a leader was full of tribulations, cha...