Model a bond manually in Excel. Do not use any premade Excel functions. Assume annual payments....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Model a bond manually in Excel. Do not use any premade Excel functions. Assume annual payments. Face ytm coupon maturity $ 2,000,000 3% 4% 10 Rule of 72 Surf the web for The Rule of 72. Display the calculations that motivate the rule of 72. Make a chart displaying the time to double that corresponds to different rates. Where is the rule of 72 most accurate? Is there a rule of thumb to enhance the rule of 72? A trader boasts that he's earned at least a 25% return each year for the last 8 years. If he started with $100,000, using the rule of 72, estimate how much principle he currently has. 2 B 5 7 Log Scale Make a scatter plot of the data vectors below. What's wrong with it? Take the log of the y values and plot again. X 1 1.073 2.433 2 1.901 22.19 3 3.33 28.53 4 3.494 14.11 5 4.038 2E+07 6 4.734 5E+05 7 8.021 2E+06 8 9.239 8E+10 9 12.51 5E+31 10 20.35 1E+52 11 27.06 1E+62 Introdution A life annuity is a financial product that you buy from a life insurance company. It pays a you a fixed amount of money for as long as you live. This protects you from outliving your money. Of course, the insurance company needs to make money, so they will price this financial product accordingly. To find the value of the annuity, the insurance company considers your probability of survival. Excel Practice Questions E1. What is the impact of raising the discount rate by 1%? E2. What is the impact if the probabilty of death increases by 2% each year instead of 1% each year? E3. What is the value for an annuity with the same specification but it begins at age 70? (You'll need to make a larger version) Tip: Note that the probability of death is linked to the actual age. Model a bond manually in Excel. Do not use any premade Excel functions. Assume annual payments. Face ytm coupon maturity $ 2,000,000 3% 4% 10 Rule of 72 Surf the web for The Rule of 72. Display the calculations that motivate the rule of 72. Make a chart displaying the time to double that corresponds to different rates. Where is the rule of 72 most accurate? Is there a rule of thumb to enhance the rule of 72? A trader boasts that he's earned at least a 25% return each year for the last 8 years. If he started with $100,000, using the rule of 72, estimate how much principle he currently has. 2 B 5 7 Log Scale Make a scatter plot of the data vectors below. What's wrong with it? Take the log of the y values and plot again. X 1 1.073 2.433 2 1.901 22.19 3 3.33 28.53 4 3.494 14.11 5 4.038 2E+07 6 4.734 5E+05 7 8.021 2E+06 8 9.239 8E+10 9 12.51 5E+31 10 20.35 1E+52 11 27.06 1E+62 Introdution A life annuity is a financial product that you buy from a life insurance company. It pays a you a fixed amount of money for as long as you live. This protects you from outliving your money. Of course, the insurance company needs to make money, so they will price this financial product accordingly. To find the value of the annuity, the insurance company considers your probability of survival. Excel Practice Questions E1. What is the impact of raising the discount rate by 1%? E2. What is the impact if the probabilty of death increases by 2% each year instead of 1% each year? E3. What is the value for an annuity with the same specification but it begins at age 70? (You'll need to make a larger version) Tip: Note that the probability of death is linked to the actual age.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Write the following functions according to their order of growth from the lowest to the highest. Prove the accuracy of your ordering g1(n) = 5n g2(n) = Vn g3(n) = n3(n) g4(n) = (n2)! g5(n) = (n!)n
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Allison is paid $1,520 per week. What is the amount of federal income tax withheld from Allisons paycheck under the following conditions? Use the percentage method table in the Appendix to this...
-
Define the following terms: (a) Degrees of freedom between persons (b) Sum of squares between persons (c) Mean square between persons
-
Herron Company operates its business solely in Jurisdiction H, which levies a 5.0% sales and use tax. This year, Herron paid $1,270,000 to purchase tangible property from a dealer located in...
-
How does humidity affect aircraft performance? Do performance charts account for humidity?
-
Wright Cola Corporation produces a new soft drink brand, Sweet Spring, using two production departments: mixing and bottling. Wright's beginning balances and data pertinent to the mixing department's...
-
(1) What was the background of Mr Wang Gang? What was his character? How did these two elements help him in his career development? (2) What was the benefits for Mr Wang Gang to have a partner? What...
-
Shauna Coleman is single. She is employed as an architectural designer for Streamline Design (SD). Shauna wanted to determine her taxable income. She correctly calculated her AGI. However, she wasnt...
-
If the speed of a boat in still water is 7 km/hr and its speed against the stream is 2.5 km/hr, then what is its speed in the direction of the current? 1. 14.5 km/hr 2. 13 km/hr 3. 14 km/hr 4. 11.5...
-
In 2016, Toni taught music and earned $20,000. She also earned $4,000 by renting out her basement. On January 1, 2017, she quit teaching, stopped renting out her basement, and began to use it as the...
-
How Much Does an American Wedding Cost? A survey by The Knot reports the national aver age cost of a wedding, excluding the honeymoon, was $35,329 in 2016, up from $32,641 in 2015 and $31,213 in...
-
Write down six rules for effective web copywriting.
-
As the price of oil fell from $99 a barrel in September 2014 to $53 a barrel by September 2015, Saudi Arabias oil revenues fell by 23 percent, compared with its 2014 oil revenues of 444.5 billion...
-
Two out of three Americans own a petalmost half own a dog and a third a catand pet ownership is projected to grow. Households have spent more on pets every year through recessions and booms, growing...
-
After drilling for 24 hours, a footage of 384 ft has been achieved. The bit used has a cost of USD 4,000. The bit will be replaced with a new one. Two different bit candidates are available, which...
-
Identify the Critical Infrastructure Physical Protection System Plan.
-
Sophie is a single taxpayer. For the first payroll period in October 2012, she is paid wages of $3,250 monthly. Sophie claims three allowances on her Form W-4. a. Use the percentage method to...
-
Leslie and Leon Lazo are married and file a joint return for 2012. Leslie's Social Security number is 466-47-3311 and Leon's is 467-74-4451. They live at 143 Snapdragon Drive, Reno, NV 82102. For...
-
Amy is a calendar-year taxpayer reporting on the cash basis. Please indicate how she should treat the following items for 2012: a. She makes a deductible contribution to an IRA on April 15,...
-
(a) Among 880 smart phones sold by a retailer, 72 required repairs under the warranty. Estimate the probability that a new phone, which has just been sold, will require repairs under the warranty....
-
A car rental agency has 19 compact cars and 12 intermediate-size cars. If four of the cars are randomly selected for a safety check, what is the probability of getting two of each kind?
-
With reference to Exercise 3.34, suppose that the questionnaire filled in by one of the 150 persons is to be double-checked. If it is chosen in such a way that each questionnaire has a probability of...
Study smarter with the SolutionInn App