Question: I need the exact excel formulas Discounted Economics Present Average Bachelors- Age Interest B.S. Salary Value earnings for HS Degree Rate HS graduate IRR 18

I need the exact excel formulas

I need the exact excel formulas Discounted Economics Present Average Bachelors- AgeInterest B.S. Salary Value earnings for HS Degree Rate HS graduate IRR

Discounted Economics Present Average Bachelors- Age Interest B.S. Salary Value earnings for HS Degree Rate HS graduate IRR 18 $18,750.00 0.99009901 -$18,564.36 $38,674.00 $57,424.00 19 $18,750.00 0.987654321 -$18,518.52 $38,674.00 $57,424.00 20 $32,650.00 0.980392157 -$32,009.80 $38,674.00 $71,324.00 21 $21,450.00 0.970873786 -$20,825.24 $38,674.00 $60,124.00 22 $7,800.00 0.997506234 -$7,780.55 $38,674.00 $46,474.00 23 $32,500.00 0.997506234 $32,418.95 $38,674.00 $6,174.00 24 $42,500.00 0.997506234 $42,394.01 $38,674.00 $3,826.00 25 $43,350.00 0.997506234 $43,241.90 $38,674.00 $4,676.00 26 $72,100.00 0.997506234 $71,920.20 $38,674.00 $33,426.00 27 $73,542.00 0.996015936 $73,249.00 $38,674.00 $34,868.00 28 $75,012.84 0.996015936 $74,713.98 $38,674.00 $36,338.84This report should include the following components: . A description of your projected career path and the assumptions you have made about your salary progression. 0 An estimate of the net present value {NPV} of expected lifetime earnings for someone in the major you selected and an estimate of the intemal rate of return {IRR} to an investment in a degree in the major you selected. . An explanation of your data sources and a discussion of any assumptions you had to make. . An interpretation and contextualization of your results

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 Economics Questions!