Marcus is 25 years old. He has a new job and intends to save $10,000 today and
Question:
Marcus is 25 years old. He has a new job and intends to save $10,000 today and in each of the next 34 years (35 deposits altogether). He has decided on an investment policy in which he invests 30% of his assets in a risk-free bond with 3% continuously compounded annual interest and the remainder in the market portfolio that has lognormal returns ? = 12% and ? = 35%. Write a spreadsheet showing Marcus?s accumulation by the time he is 60. A sample output is given below:
Transcribed Image Text:
B MARCUS'S INVESTMENT/SAVINGS DECISION A D E 1 2 Annual deposit 3 Risk-free rate 4 Market portfolio mean 5 Market portfolio sigma 6 Proportion in market portfolio 7 Accumulation at age 60 10,000 3% 12% 35% 70% 12,048,869 <- =B45 8 Total investment at Total beginning of New investment at 9 Age 25 investment end of period period 13,065.44 27,795.31 =(B10+C10)*($B$6*EXP($B$4+ 52,906.64 $B$5*NORM.S.INV(RAND()))+(1- 58,590.40 99,352.45 10 10,000 <-- 10,000 13,065.44 27,795.31 52,906.64 58,590.40 11 26 12 27 10,000 13 28 10,000 $B$6)*EXP($B$3)) 14 29 10,000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
calculate Marcuss accumulation by the time he is 60 Heres what you can do Open a new spreadsheet in ...View the full answer
Answered By
Rupak soni
I love sharing my knowledge with others and watching them grow. I think tutoring is a great way to get started. My mentor was my mathematics teacher in high school. He was always willing to help me after school and even gave me extra assignments to help me improve. I like to do cooking and crafting . I also like to read and write. I think these activities can help me connect with students .I am engineering student also, so I know how to manage my time effectively. I will make sure I have enough time to do both. I have a lot of experience working with students in a variety of subjects. I know how to help students learn and succeed.
0.00
0 Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
In each of the following pairs, determine whether the two represent resonance forms of a single species or depict different substances. If two structures are not resonance forms, explain why. All the...
-
In each of the following reactions, an amine or a lithium amide derivative reacts with an aryl halide. Give the structure of the expected product, and specify the mechanism by which it is formed.
-
The truss shown consists of 18 members and is supported by a ball and socket at A, two short links at B, and one short link at G. (a) Check that this truss is a simple truss, that it is completely...
-
Why must Microsoft report this charge of over $1billion entirelyin one quarter, the last quarter of the company's physicalyear? From an accounting point of view, what willMicrosoft do in the futur?
-
Investment markets are highly competitive and professional investors now dominate the marketplace. What should the average performance of all investors be, compared with market indexes? If...
-
LALA Corp has just started its operations in 2020. After 6 months, the company has the following data: Cost of goods sold is 540,000; 30% of Manufacturing cost were distributed to Direct labor cost....
-
The test statistic F is never greater than 1. In Exercises 7 and 8, determine whether the statement is true or false. If the statement is false, rewrite it as a true statement.
-
The demand for product S is 100 units. Each unit of S requires 1 unit of T and 1/2 unit of U. Each unit of T requires 1 unit of V, 2 units of W, and 1 unit of X. Finally, each unit of U requires 1/2...
-
The ABC Corporation manufactures and sells two products: T1 and T2. 20XX budget for the company is given below: Projected Sales Units Price T1 60,000 $165 T2 40,000 $250 Inventories in Units January...
-
Propose skeletal structures for compounds that satisfy the following molecular formulas. There is more than one possibility in each case. (a) C5H12 (b) C2H7N (c) C3H6O (d) C4H9Cl
-
Stock price simulation: A stock?s price is lognormally distributed with mean ? = 15%. The current stock price is S 0 = 35. Following the template on the spreadsheet, create 60 static standard normal...
-
Use Monte Carlo to calculate the integral of the function Exp(x) for 0 Graph of Exp(x), 0
-
You are a manufacturer of precision components for the automotive industry. Your supplier reviews stock every 4 weeks and replenishes it instantaneously. The standard deviation of demand during the...
-
At t=1.0 s, a person walking with constant velocity is located at x=3.0 m. At t = 6.0 s the person is located at x=5.0 m. (a) Draw a position vs. time graph for the person, and find their velocity...
-
As a demonstration of uniform circular motion in class, I often swung my keys from a 52.0 cm string in a horizontal circle over my head. Suppose my keys have a mass of 240. g, and during their motion...
-
You will write a Java program using do-while loop. The program asks users to guess the license plate of a car between 1-and 81. (You will assume that the number picked by the program is 42.) Program...
-
A truck tractor pulls two trailers, one behind the other, at a constant speed of 1 0 0 km / h . It takes 0 . 6 2 5 s for the big rig to completely pass onto a bridge 3 6 0 m long. For what duration...
-
Q 1. A 0.645 kg toy train engine is travelling around a horizontal circular track. The track has a radius of 0.790 m. The track can provide a maximum horizontal force of 3.50 N resulting in circular...
-
In the online article "Comparing the Effects of Fluoxetine and Imipramine on Total Cholesterol, Triglyceride, and Weight in Patients with Major Depression" (Journal of Pharmaceutical Sciences, Vol....
-
The following table shows the rates of total return in successive years from 2004 to 2008 for the Sprott Canadian Equity Fund and for the benchmark Toronto Stock Exchange S&P/TSX Composite Index. By...
-
What is the relationship between national culture and a global organizations organizational culture?
-
Describe forces that act as stimulants to change.
-
Describe the sources of resistance to change.
-
During Year 1, Chung Corporation earned $6,900 of cash revenue and accrued $3,800 of salaries expense. Required: (Hint. Record the events in general ledger accounts under an accounting equation...
-
Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $89,000 on May 1, 2019. The following budgeted...
-
The monthly salaries for December and the year-to-date earnings of the employees of Bush Consulting Company as of November 30 follow. Determine the amount of Medicare tax to be withheld from each...
Study smarter with the SolutionInn App