Question: Finally, somewhere on your sheet (i.e. columns H, I) include the sum total of the present value of noncollege and the present value of college.

Finally, somewhere on your sheet (i.e. columns H, I) include the sum total of the present value of noncollege and the present value of college. If you did all steps correctly, you should get Present Value of NonCollege to be 450,984.46 and the Present Value of College 505,667.91.

Copy your sheet and make a new excel sheet labeled "Sheet A".

Repeat the exercise in Sheet A with the following changes:

Each year of college still costs $15,000 and each year of post-college work still pays $60,000, but each year of non-college work now pays $40,000.

Finally, somewhere on your sheet (i.e. columns H, I) include the

how do i calculate the period's present value?

sum total of the present value of noncollege and the present value

This exercise has you uploading an excel file. A high school graduate has to decide between working and going to college. If he works, he will work for the next 50 years of his life. If he goes to college, he will be in college for 5 years, and then work for 45 years. In this model, the rate of discount that equates the lifetime present value of not going to college and going to college is 8.24% when the cost of each year of college is $15,000, each year of non-college work pays $35,000, and each year of post-college work pays $60,000. Set up an excel Sheet 1" with the following information in Column A: age Column B: noncollege work Column C: college work Column D: Present Value of Noncollege (Each Period) Column E: Present Value of College (Each Period) In column A. have the ages span from ages 18-67. (Alternatively, you can have ages be 0 to 49). in column B, the salary is $35,000 In column C, the cost for college is -$15,000 for ages 18-21. Beginning at age 22, the worker makes $60,000. In column D and E. calculate the period's present value. If ke the following This exercise has you uploading an excel file. A high school graduate has to decide between working and going to college. If he works, he will work for the next 50 years of his life. If he goes to college, he will be in college for 5 years, and then work for 45 years. In this model the rate of discount that equates the lifetime present value of not going to college and going to college is 8.24% when the cost of each year of college is $15,000, each year of non-college work pays $35,000, and each year of post-college work pays $60,000. Set up an excel Sheet 1" with the following information in Calumn Aage Column B: noncollege work Column C: college work Column D: Present Value of Noncollege (Each Period) Column E: Present Value of College (Each Period) In column A, have the ages span from ages 18-67. (Alternatively, you can have ages be 0 to 49). In column B, the salary is $35,000 In column C, the cost for college is -$15,000 for ages 18-21. Beginning at age 22, the worker makes $60,000. In column D and E, calculate the period's present value. If you did everything correctly, your excel file should look like the following AutoSavon exical worksheet O Search

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Question 6. Jeff Douglas believes strongly that they should help fully fund the equivalent of a state university education (4 years) for Paul and Marcy. Both sets of grandparents have volunteered to...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

this is all the information required to do assignment Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The...

Hello, I need help with this Excel assignment. It involves the use of what if analysis. Capital Budgeting - Cott Corpo Suppose that the Cott Corporation (COT) is considering adding a new product...

this is all the information given Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have...

Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet...

Evidence indicates that fathers are more likely to take family leave when it is offered as a "father's quota" rather than when it is available as part of a more standard leave policy where the leave...

Explain Fiedlers contingency model of leadership.

The type of exposure that arises from the need, for purposes of reporting and consolidating, to convert the financial statements of foreign operations from the local currencies involved to the home...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

1 Learning from some of the measures taken by Eskom, AECI and Germiston City Council, what could a foreign company like Colgate Palmolive do to contribute to the development of human potential within...

Achievementascription. Quite often more traditional societies accord status according to ascription. Again, this may influence recruitment and promotion policies that may be at variance with...

Indian managers at both middle and senior levels in organizations profess a belief in group-based, participative decision making, but have little faith in the capacity of workers for taking...