For each question below, copy your LC model to a new worksheet (tab) within your file,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For each question below, copy your LC model to a new worksheet (tab) within your file, and change the numbers within that sheet as needed. Use an income of $65,000 per year for age 26 through age 65. You should have 5 sheets (tabs) in your file when done: Part A, and the 4 questions bellow. 1. Using of C = HC / years (as we did previously), and setting r = 1% (per year), how much do you achieve in final assets (at the end of age 100)? 2. Guess / plug in values for consumption until you arrive at a level of consumption (to the nearest whole dollar) that leaves approximately zero remaining assets at age 100. 3. Add another column off to the right of your LC model, in which to calculate the present value (at age 26) of each future year's income. See example below in cells 19, 110, etc. Recall that the PV of the amount to be received in year n, is: amount PV₂ = amount x PVF = (1+r)n Real Rate of Return Total HC (not PV) 3 Years in Plan 1 2 23456789 4 Smooth Consumption Final Assets 10 Year 1 2 Age 26 27 D 1% $2,000,000.00 75 $26,666.67 $ 504,952.65 references value of assets at age 100. G W Al с Income Asset Income Consumption $ 50,000.00 $ S=W+Al-C An = An-1+ Sn Savings Assets $ 23,333.33 $ 23,333.33 $ 26,666.67 $ 50,000.00 $ 233.33 $26,666.67 $23,566.67 $ 46,900.00 H с PV(HO $31,219.36 $1,641,734.31 PV(W) $ 49,504.95 $ 49,014.80 a. At the top of the worksheet (cell 14), calculate the total PV of human capital, by summing up the PVs of each year' human capital. b. In cell 13, use the Excel PMT function to convert the PV of human capital to an amount of smooth annual consumption. Adjust your model to reference this cell for each year's consumption, and verify that it results in $0 of final assets. 4. Now, set r = 2% per year. a. Using the PMT function (from question 3), find the level of smooth consumption, and verify that this amount results in zero final assets at age 100. b. Write an explanation (in one or two sentences) about what happens to C and Sas r increases. For each question below, copy your LC model to a new worksheet (tab) within your file, and change the numbers within that sheet as needed. Use an income of $65,000 per year for age 26 through age 65. You should have 5 sheets (tabs) in your file when done: Part A, and the 4 questions bellow. 1. Using of C = HC / years (as we did previously), and setting r = 1% (per year), how much do you achieve in final assets (at the end of age 100)? 2. Guess / plug in values for consumption until you arrive at a level of consumption (to the nearest whole dollar) that leaves approximately zero remaining assets at age 100. 3. Add another column off to the right of your LC model, in which to calculate the present value (at age 26) of each future year's income. See example below in cells 19, 110, etc. Recall that the PV of the amount to be received in year n, is: amount PV₂ = amount x PVF = (1+r)n Real Rate of Return Total HC (not PV) 3 Years in Plan 1 2 23456789 4 Smooth Consumption Final Assets 10 Year 1 2 Age 26 27 D 1% $2,000,000.00 75 $26,666.67 $ 504,952.65 references value of assets at age 100. G W Al с Income Asset Income Consumption $ 50,000.00 $ S=W+Al-C An = An-1+ Sn Savings Assets $ 23,333.33 $ 23,333.33 $ 26,666.67 $ 50,000.00 $ 233.33 $26,666.67 $23,566.67 $ 46,900.00 H с PV(HO $31,219.36 $1,641,734.31 PV(W) $ 49,504.95 $ 49,014.80 a. At the top of the worksheet (cell 14), calculate the total PV of human capital, by summing up the PVs of each year' human capital. b. In cell 13, use the Excel PMT function to convert the PV of human capital to an amount of smooth annual consumption. Adjust your model to reference this cell for each year's consumption, and verify that it results in $0 of final assets. 4. Now, set r = 2% per year. a. Using the PMT function (from question 3), find the level of smooth consumption, and verify that this amount results in zero final assets at age 100. b. Write an explanation (in one or two sentences) about what happens to C and Sas r increases.
Expert Answer:
Answer rating: 100% (QA)
Question 1 To calculate the final assets at the end of age 100 you can use the formula for the prese... View the full 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
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A group of fraud examiners is coordinating an investigation at a local law firm. Several lawyers at the firm are suspected of overbilling clients, possibly creating fake client accounts, and then...
-
If density of ice is 920 kg/m3, find the pressure at the bottom of a 1000 m thick ice cap on the North Pole. What is the melting temperature at that pressure?
-
Which markets clear in the New Keynesian model, and which do not?
-
Flo Choi owns a small business and manages its accounting. Her company just fin ished a year in which a large amount of borrowed funds was invested in a new building addition as well as in equipment...
-
North Slope Realty Co. pays weekly salaries of $7,900 on Friday for a five-day week ending on that day. What is the adjustment at the end of the accounting period, assuming that the period ends (a)...
-
Consider two vectors: = (-3,2, -1) and = (1, -3, 2), evaluate the following: A. (A:1) - v B. (A:1) Angle between u and C. (A:2) x v D. (A:2)Proj E. (A:1) Area of parallelogram produced by u and . F....
-
Given a database of the results of an election, find the number of seats won by each party. There are some rules to going about this: There are many constituencies in a state and many candidates who...
-
Explain the roles played by boards, commissions, and regulatory agencies Important questions about the ability to regulate the production and transportation of oil and natural gas have been raised...
-
Problem 5. You need to simulate a draw for a random variable X with the cumu- lative distribution function Fx defined by Fx(x) = = { x < 0 0 x using the inverse-transform method. You have generated a...
-
1.What does the term Premises Liability mean? 2.What does the term Products Liability mean ? 3.What does the term Completed Operations Liability mean ? 4.What does the term Contractual Liability mean...
-
The Platinum Monthly Stock-Picker Chronicle ('Platinum') has been the best performed stock tipping service over the last 3 years, with Platinum subscribers being able to consistently (over the last 3...
-
Good day. Kindly show workings. Thank you E Example 1- Calculate the expected return and risk of Stocks A and B. State of Economy Probability (p) Return (k) A B Recession Normal .20 .50 4% -10% 10%...
-
Problem 6 (10%: Consider portfolio manager with a $20,500,000 equity portfolio under management. The manager wishes to hedge against a decline in share values using stock index futures. Currently a...
-
For very short periods of stay, like 5 years or less, the Effective Equity will be negative. Discuss how this value could be negative; what is the cause of actually losing money on the investment,...
-
A 2500-lbm car moving at 15 mi/h is accelerated at a constant rate of 15 ft/s 2 up to a speed of 50 mi/h. Calculate force and total time required?
-
Brian and Kim have a 12-year-old child, Stan. For 2012, Brian and Kim have taxable income of $52,000, and Stan has nonqualifying dividend income of $4,500 and investment expenses of $250. No election...
-
Sally and Charles Heck received the following dividends and interest during 2012: Assuming the Hecks file a joint tax return, complete Schedule B of Form 1040 (on page 2-33) for them for the 2012 tax...
-
Jim is fired from his job as a waiter and decides to take an extended trip to Europe. After touring Europe for 3 months, Jim returns to look for a new job as a waiter. Are his job-hunting expenses...
-
What common practice is the principal of value dates based on?
-
What sort of cash organisation is generally in place for highly decentralised groups?
-
Is the risk of bankruptcy of a subsidiary an obstacle to cash pooling for a group which balances its accounts daily?
Study smarter with the SolutionInn App