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...
-
What is the advantage of using a perpetual budget instead of the traditional annual budget?
-
What is the operating income using variable costing if 450 units are sold for $100 each? a. $2,750 b. $5,000 c. $500 d. $2,500 Donovan Company incurred the following costs while producing 500 units:...
-
An international corporation needed several millions of words, from thousands of documents and manuals, translated. The work was contracted to a company that used computer-assisted translation, along...
-
Patten Corporation acquired an 85% interest in Savage Company for $3,100,000 on January 1, 2011. On this date, the balances in Savage Companys capital stock and retained earnings accounts were...
-
In your new role as Chief Human Resources Officer (CHRO) for a major retail organization, you have been tasked within the first 30 days by the CEO to conduct a presentation to the management team on...
-
Sofia Lofts case, but under a new set of assumptions on page 11 of the case. First re-read the Sofia Lofts case, then click here to download the new page 11. Specifically, you are to write up a brief...
-
Practice Question 1 Some longer quotes are included in the practice questions to help you to develop your skills in critically evaluating arguments. Required: Critically evaluate the following quote....
-
lila needs help with this question, macowski company is considering a special order that it received for 95 overhead light. The controller has gathered the following data: Direct materials costs per...
-
China's giant property developer Country Garden has been declared in default on its debt after failing to make a bond repayment by a final deadline of October 18. A panel of global banks and...
-
Evaluate the function f(x)=-8(x-2)+x and find f(2).
-
Find the x, y and z intercepts of the plane tangent to the sphere of radius 14, with center at the origin, at the point (1, 2, 3).
-
Using a relative valuation approach what do you believe is the relevant valuation of Ferrari?
-
Solve each equation by using the square-root property. 21. (- 2) = 7 23. (4x1) = 20 22. (b + 4) = 27 24. (3x + 5) = 11
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Why do you think Google was adamant about not wanting to supply information requested by the government concerning the Child...
-
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...
-
Make an energy diagram for gas B in Figure 20.4. Figure 20.4 When gases of different temperatures are placed in thermal contact, energy is transferred thermally from the hotter to the cooler gas...
-
Suppose you were to play the two film clips shown in Figure 20.7 backward. Would the resulting processes be possible? Figure 20.7 Quasistatic versus non-quasistatic expansion of a cylin- der...
-
(a) What are the SI units of \(Q\) ? (b) For the process depicted in Figure 20.2a, make an energy diagram for each of these systems: (i) water, pot, and flame; (ii) pot and flame; (iii) pot. Figure...
Study smarter with the SolutionInn App