Reference no: EM131216136
Managerial Report with 5 steps in Excel
Tyler is 37 years old and would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist Tyler with retirement planning.
Your model should include the following input parameters:
Tyler's current age = 37 years
Tyler's current total retirement savings = $259,000
Annual rate of return on retirement savings = 4 percent
Tyler's current annual salary = $145,000
Tyler's expected annual percentage increase in salary = 2 percent
Tyler's percentage of annual salary contributed to retirement = 6 percent
Tyler's expected age of retirement = 65
Tyler's expected annual expenses after retirement (current dollars) = $90,000
Rate of return on retirement savings after retirement = 3 percent
Income tax rate postretirement = 15 percent
Assume that Tyler's employer contributes 6% of Tyler's salary to his retirement fund. Tyler can make an additional annual contribution to his retirement fund before taxes (tax-free) up to a contribution of $16,000. Assume he contributes $6,000 per year. Also, assume an inflation rate of 2%.
Managerial Report
Your spreadsheet model should provide the accumulated savings at the onset of retirement as well as the age at which funds will be depleted (given assumptions on the input parameters). As a feature of your spreadsheet model, build a data table to demonstrate the sensitivity of the age at which funds will be depleted to the retirement age and additional pre-tax contributions. Similarly, consider other factors you think might be important.
Develop a report for Tyler outlining the factors that will have the greatest impact on his retirement.
|
Find the two dimensional joint pmf
: Find the two-dimensional joint PMF.- Find the three-dimensional joint PDF. - Find the marginal PDF. - What are the chances that none of the three random variables are equal to 1?
|
|
Find the joint pdf of x and y
: Suppose a point in three-dimensional Cartesian space, (X, Y, Z) is equally likely to fall anywhere on the surface of the hemisphere - Find the PDF Of Z. - Find the joint PDF of X and Y.
|
|
Demodulate an fm signal on the edge of a lowpass filter
: Try to replicate the experiment carried out in Illustration 180. (f) On your own design a PLL as in Illustration 181 and try to set the control voltage for the VCO in such a way that the PLL works.
|
|
Prepare a balance sheet as of december
: Lamp Light Company maintains and repairs warning lights, such as those found on radio towers and lighthouses. Prepare a balance sheet as of December 31, 2016. Fixed assets must be entered in order according to account number
|
|
Develop a report for tyler outlining the factors
: Tyler is 37 years old and would like to establish a retirement plan. Develop a report for Tyler outlining the factors that will have the greatest impact on his retirement.
|
|
Examine the composition and the influence in the frequency
: Examine the composition and the influence in the frequency domain of the frequency swing, the frequency of the source signal and the FM mid-frequency on the width of the FM spectrum.
|
|
Explain the main features of the fund
: Pick a Mutual Fund of your choice. Visit the web site and learn about your chosen fund whatever you want to learn. Write a report, a page or so, explaining the main features of the fund.
|
|
Find the pdf of y
: Suppose a point in two-dimensional Cartesian space, , is equally likely to fall anywhere on the semicircle. - Find the PDF of Y.
|
|
Explain how options would achieve that goal
: Explain how options would achieve that goal. Describe the concepts of options. Be sure to develop a strategy using options to mitigate risk.
|