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


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
Get step-by-step solutions from verified subject matter experts
