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...
-
(Computation of Net Income) Presented below are changes in all the account balances of Fritz Reiner Furniture Co. during the current year, except for retained earnings. Increase Increase (Decrease)...
-
Again, consider the daily simple returns of GM stock in the file d-gmsp9908.txt. (a) Find an adequate GARCH-M model for the series. Write down the fitted model. (b) Find an adequate EGARCH model for...
-
Management of Last Call Inc. is considering the following capital projects Assume that all projects have no salvage value and that the company uses a discount rate of 10 percent. Management has...
-
Therapeutic Systems sells its products for $13 per unit. It has the following costs: Rent.............................................$145,000 Factory labor ....................................$4.00...
-
An investor has $50,000 to divide among several instruments. Municipal bonds have an 8% return,, treasury -bills a 10% return, and growth stock 14%. The following guidelines have been established: 1....
-
MidSouth Tool Company produces an aircraft part. The company can produce the part entirely at a flexible work center with computerized machines. The company has four work centers, all of which have...
-
A company issues 1 , 0 0 0 , 0 0 0 of 7 % , 5 - year bonds with detachable stock warrants. The issuance price is $ 1 , 0 6 5 , 0 0 0 . Each $ 1 , 0 0 0 bond has 2 0 warrants attached. The warrants...
-
1.S&A budget including cash disbursements for S&A Outdoor Chef Grill Company budgeted the following costs for anticipated production in October. The list below includes fixed MOH expenses and Fixed...
-
Find a suitable integrating factor o(a) or o(y), and use it to find the general solution of the differential equation. (a) 3yda + dy=0 (b) ydx + xln z dy = 0 (c) y ln y dr + (x + y)dy = 0 (d) dx +...
-
What annual interest rate, r, is required to return $670 from $300 over 10 years? Give your answer as a percentage to two decimal places and assume growth compounds quarterly.
-
Write a java program to perform swapping of two numbers without using third variable?
-
Determine KLPC's federal Income tax payable for the 20X9 fiscal year. Determine KLPC's eligible and non-eligible refundable dividend tax on hand balance at the end of 20X9. Determine KLPC's dividend...
-
Case: That's Her Responsibility, Not Mine Susan Wilson is the administrative supervisor of Diagnostic Imaging at Central Hospital. Supervising in an expanding department and coping with steadily...
-
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...
-
Do you feel that there are any ethical issues involved when management decides to extend the depreciable life of its long-lived assets in order to increase the firms current net income to a level...
-
Omar Corporation paid \($200,000\) for a tract of land that had an old gas station on it. The gas station was demolished at a cost of \($20,000\) and a new warehouse was constructed on the site at a...
-
During 2016, The Alberta Oil & Gas Company began an exploration project in Montana. The company had paid \($500,000\) for the drilling rights on a tract of 500 acres of land. The company then spent...
Study smarter with the SolutionInn App